Fred Gerald Macapinlac Email and Phone Number

Managerial skills performed were mainly as follows:• Demand Forecasting – managed monthly purchase forecasts that ensured category profitability by balancing current inventories, sales plans, stock plans, purchase orders and aging percentages. Assured that the right stock arrived at the right store by analyzing stores’ past performance and customer demographic. • Sales Controllership – optimized sales levels by confirming vendor deliveries, monitoring item performances down to the SKU level, and implementing promotions to aid slow-moving stocks.• Product Development – conceptualized monthly and seasonal offerings based on customer needs and international trends. Developed prototypes and packaging specs relayed to suppliers for production. • Basic Visual Merchandising – provided support to store personnel in creating compelling and visually attractive displays.

Performed substantive and analytical procedures to assess appropriateness of clients’ financial statements. Majority of these procedures included:• Sales and Overall Trend Analysis – consolidated quantitative and qualitative insights to estimate expected monthly figures, compared estimates with actual data, analyzed root causes for observed variances, adjusted expectations in response to current information. • Process Reviews and Walkthroughs – understood and confirmed the overall and detailed flow of a process, identified risks and the controls that mitigate such risks, suggested controls and alternative measures for unaddressed risks.• Substantive Procedures in Order-to-Cash Process – performed sales cutoff procedures to assure appropriateness of revenue recognition, confirmed accounts receivables to assure existence of claims, corroborated abrupt fluctuations of balances through vouching of support documents.

COMME ESTER CUSTOM JEWELRY – BA 129 FEASIBILITY STUDYConducted a feasibility study of a mid-priced mass customizable authentic jewelry business. Successfully got a rating of 1.00 for the study and was marked best paper and presentation. Applied techniques in finance, marketing and operations such as:• Sales and Net Profit Forecasting – projected short- and long-term revenue and net income based on logical assumptions, tested the volatility of projections by subjecting assumptions to sensitivity analysis.• Marketing Plan – conceptualized the brand identity by considering consumer insights, industry data and the quality of products and service the team envisioned, created a marketing plan to execute the brand introduction and maintenance, prepared draft publicity materials such as print ads, taglines and other related imagery.• Vendor Sourcing – inquired and canvased for possible suppliers of raw materials and manufacturers of the final products, interviewed industry experts such as established mid-priced jewelers and gemologists.

• Conceptualized, created and executed publicity materials for the organization’s programs and events such as the Interview Simulation and Accessorial Events among others• Assisted Assistant Directors in accomplishing their tasks

• Conceptualized and executed themes and content to be included in the school’s yearbook• Collated, edited and formatted the text components of the individual graduate’s pages• Managed and aided graduates in their photo shoots • Solicited messages from the university’s top management

• Conceptualized the theme and overall aesthetic of the organization’s monthly magazine• Created covers for every issue. Styled the layout the magazine pages

• Led and headed projects such as the Alternative Classroom Learning Experience, the Bulletin Board Workshop, the Literary Folio, and the Reaffirmation and Recruitment Workshop• Managed and motivated the committee members to participate in UPJPIA’s events

Co-created the Global Advice Tool/EUDA, an MS Excel tool that automatically transforms input data into SAP (Accounting Program) format which ultimately saves labor hours for the company and promotes formalization and uniformity of financial data.