PRODUCTION COMPARATIVE ANALYSIS: refer to the data in the tables and compare the projected production report with the current production report. Explain how they differ and the ways we can improve/change things.
Production Forecasts For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit cost Total cost For the period of March 2022 to June 2022 Product Name: Diffusers Month Qty. Unit cost Production (Fragrance Oils) Mar Apr 80 135 PHP 85 PHP 85 6,800 11,475 11,900 Table 1.4 Production Forecast (Fragrance Oils) Total cost Mar 40 PHP 200 8,000 May 140 PHP 85 11,900 Production (Diffusers) Apr May 45 45 PHP 200 PHP 200 Jun 140 PHP 85 Jun 45 PHP 200 9,000 9,000 Table 1.5 Production Forecast (Diffusers) 9,000 Total 495 42,075 Total 175 35,000 Current Production For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit cost Total cost Pure Essential Oil Amber Bottles Sticker Total Month *Computation for the Unit Cost (Essential Oils) Qty. Unit cost Total cost For the period of March 2022 to June 2022 Product Name: Diffusers Mar 20 Month Qty. PHP 97.84 Unit cost PHP 1,956 Total cost Mar For the period of March 2022 to June 2022 Product Name: Stamps Mar Production (Fragrance Oils) Apr 1 643 PHP 643 9 PHP 97.84 PHP 880.56 PHP 880.56 Table 2.5 Current Production (Fragrance Oils) PHP 97.84 Apr Quantity 1 1 1 Apr May Production (Diffusers) May 9 Table 2.6 Current Production (Fragrance Oils) *Last purchase of diffusers was on December 24, 2021 for 40 units at a unit cost of P185.06 Production May Jun Table 2.7 Current Production (Dulcet Stamps) 9 PHP 97.84 PHP 880.56 Jun Jun Total Unit Cost 64.42 PHP 4,597.68 32.58 0.84 Total PHP 97.84 47 Total Total 1 PHP 643 Production Forecasts For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit cost Total cost For the period of March 2022 to June 2022 Product Name: Diffusers Month Qty. Unit cost Production (Fragrance Oils) Mar Apr 80 135 PHP 85 PHP 85 6,800 11,475 11,900 Table 1.4 Production Forecast (Fragrance Oils) Total cost Mar 40 PHP 200 8,000 May 140 PHP 85 11,900 Production (Diffusers) Apr May 45 45 PHP 200 PHP 200 Jun 140 PHP 85 Jun 45 PHP 200 9,000 9,000 Table 1.5 Production Forecast (Diffusers) 9,000 Total 495 42,075 Total 175 35,000 Current Production For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit cost Total cost Pure Essential Oil Amber Bottles Sticker Total Month *Computation for the Unit Cost (Essential Oils) Qty. Unit cost Total cost For the period of March 2022 to June 2022 Product Name: Diffusers Mar 20 Month Qty. PHP 97.84 Unit cost PHP 1,956 Total cost Mar For the period of March 2022 to June 2022 Product Name: Stamps Mar Production (Fragrance Oils) Apr 1 643 PHP 643 9 PHP 97.84 PHP 880.56 PHP 880.56 Table 2.5 Current Production (Fragrance Oils) PHP 97.84 Apr Quantity 1 1 1 Apr May Production (Diffusers) May 9 Table 2.6 Current Production (Fragrance Oils) *Last purchase of diffusers was on December 24, 2021 for 40 units at a unit cost of P185.06 Production May Jun Table 2.7 Current Production (Dulcet Stamps) 9 PHP 97.84 PHP 880.56 Jun Jun Total Unit Cost 64.42 PHP 4,597.68 32.58 0.84 Total PHP 97.84 47 Total Total 1 PHP 643
