SALES COMPARATIVE ANALYSIS: refer to the data in the tables and compare the projected sales report with the current sales report. Explain how they differ and the ways we can improve/change things.
I. Projected Sales and Production Projections/Forecasts Sales Forecasts For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit Price Total Sales Month Qty. Unit Price Total Sales Month Qty. Mar For the period of March 2022 to June 2022 Product Name: Diffusers Unit Price 80 Total Sales PHP 250 PHP 20,000 Mar Dulcet: Sales and Production Report 40 PHP 380 PHP 15,200 Sales (Fragrance Oils) Apr 135 Mar For the period of March 2022 to June 2022 Product Name: Essential Oils & Diffusers 120 PHP 250 PHP 250 PHP 35,000 PHP 33,750 Table 1.1 Sales Forecast (Fragrance Oils) May 140 Sales (Diffusers) Apr 45 PHP 380 May 45 PHP 380 PHP 17,100 PHP 17,100 Table 1.2 Sales Forecast (Diffusers) Jun 140 PHP 250 PHP 35,000 Jun 45 Consolidated Sales (Fragrance Oils and Diffusers) Apr May 180 185 PHP 380 PHP 17,100 Jun 185 35,200 50,850 52,100 52,100 Table 1.3 Sales Forecast (Fragrance Oils and Diffusers Consolidated) Total 495 123,750 Total 175 66,500 Total 670 190,250 II. Current Sales and Production Report Current Sales For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit Price Qty. (Bundles) Disc. Price Total Sales Month Qty. (Individual) Unit Price Mar Qty. (Bundles) PHP 250 6 For the period of March 2022 to June 2022 Product Name: Diffusers PHP 226.4 PHP 226.4 PHP 226.4 PHP 1,358.40 PHP 2,037.60 PHP 500 Mar Sales (Fragrance Oils) Apr May 2 PHP 250 PHP 380 2 PHP 250 9 Disc. Price PHP 320 Total Sales PHP 640 Sales (Diffusers) Table 2.1 Current Sales (Fragrance Oils) Apr 1 PHP 380 2 PHP 320 May PHP 380 PHP 320 Jun 3 PHP 250 15 PHP 226.4 PHP 4,146 PHP 1,020 Table 2.2 Current Sales (Diffusers) Jun 1 PHP 380 1 PHP 320 PHP 700 Total 5 30 PHP 8,042 Total 2 5 PHP 2,360 For the period of March 2022 to June 2022 Product Name: Essential Oils & Diffusers Month Qty. Unit Price Consolidated Sales (Fragrance Oils and Diffusers) Apr May Jun 1 2 4 Qty. (Bundles) Disc. Price Total Sales PHP 1,998.40 PHP 2,357.60 PHP 500 Essential Oils Mar Diffuser 8 11 *Computation for Discounted Price Per Unit (Bundles) Original Price - Discount P250 - P23.6 16 PHP 4,846 Table 2.3 Current Sales (Fragrance Oils & Diffusers) Discounted Price P226.4 P380-P60 P320 Table 2.4 Price Change for Bundles (Fragrance Oils & Diffusers) Total 7 35 PHP 9,702 I. Projected Sales and Production Projections/Forecasts Sales Forecasts For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit Price Total Sales Month Qty. Unit Price Total Sales Month Qty. Mar For the period of March 2022 to June 2022 Product Name: Diffusers Unit Price 80 Total Sales PHP 250 PHP 20,000 Mar Dulcet: Sales and Production Report 40 PHP 380 PHP 15,200 Sales (Fragrance Oils) Apr 135 Mar For the period of March 2022 to June 2022 Product Name: Essential Oils & Diffusers 120 PHP 250 PHP 250 PHP 35,000 PHP 33,750 Table 1.1 Sales Forecast (Fragrance Oils) May 140 Sales (Diffusers) Apr 45 PHP 380 May 45 PHP 380 PHP 17,100 PHP 17,100 Table 1.2 Sales Forecast (Diffusers) Jun 140 PHP 250 PHP 35,000 Jun 45 Consolidated Sales (Fragrance Oils and Diffusers) Apr May 180 185 PHP 380 PHP 17,100 Jun 185 35,200 50,850 52,100 52,100 Table 1.3 Sales Forecast (Fragrance Oils and Diffusers Consolidated) Total 495 123,750 Total 175 66,500 Total 670 190,250 II. Current Sales and Production Report Current Sales For the period of March 2022 to June 2022 Product Name: Essential Oils Month Qty. Unit Price Qty. (Bundles) Disc. Price Total Sales Month Qty. (Individual) Unit Price Mar Qty. (Bundles) PHP 250 6 For the period of March 2022 to June 2022 Product Name: Diffusers PHP 226.4 PHP 226.4 PHP 226.4 PHP 1,358.40 PHP 2,037.60 PHP 500 Mar Sales (Fragrance Oils) Apr May 2 PHP 250 PHP 380 2 PHP 250 9 Disc. Price PHP 320 Total Sales PHP 640 Sales (Diffusers) Table 2.1 Current Sales (Fragrance Oils) Apr 1 PHP 380 2 PHP 320 May PHP 380 PHP 320 Jun 3 PHP 250 15 PHP 226.4 PHP 4,146 PHP 1,020 Table 2.2 Current Sales (Diffusers) Jun 1 PHP 380 1 PHP 320 PHP 700 Total 5 30 PHP 8,042 Total 2 5 PHP 2,360 For the period of March 2022 to June 2022 Product Name: Essential Oils & Diffusers Month Qty. Unit Price Consolidated Sales (Fragrance Oils and Diffusers) Apr May Jun 1 2 4 Qty. (Bundles) Disc. Price Total Sales PHP 1,998.40 PHP 2,357.60 PHP 500 Essential Oils Mar Diffuser 8 11 *Computation for Discounted Price Per Unit (Bundles) Original Price - Discount P250 - P23.6 16 PHP 4,846 Table 2.3 Current Sales (Fragrance Oils & Diffusers) Discounted Price P226.4 P380-P60 P320 Table 2.4 Price Change for Bundles (Fragrance Oils & Diffusers) Total 7 35 PHP 9,702
