ZED Ltd. manufactures two categories of products, Omega and Theta. These products are sold through two primary distribution channels, Online Portals…

CA Intermediate · Cost and Management Accounting · PYQS · May 2026
ZED Ltd. manufactures two categories of products, Omega and Theta. These products are sold through two primary distribution channels, Online Portals and Retail Stores. In the current financial year, Omega performed exceptionally well online due to a viral trend, while Theta saw a surge in retail stores. The following information is available for the year 2025-26: Product Channel Budgeted Sales Actual Sales Selling Price per unit (For Budgeted and Actual Sales) Omega Online 1000 units 1200 units 15,000 Retail 800 units 700 units 18,000 Theta Online 500 units 450 units 40,000 Retail 400 units 500 units 45,000 Market research indicates that Omega series is facing stiff competition offline, therefore, management has decided to reduce the price by 10% across both channels. Theta series has gained luxury status, so the management has decided to increase the price by - 5,000 per unit for both Online and Retail sales. Based on these price changes, the Sales Manager has submitted the following estimates of increase in sales for the year 2026-27 over the original budgeted sales: Product Online Channel Retail Channel Omega + 15% +5% Theta + 10% +20% Furthermore, the company has signed a contract for an Influencer Marketing Campaign. It is estimated that for the year 2026-27 this campaign will generate the following additional sales: Product Online channel Retail Channel Omega 200 units Nil Theta 100 units 50 Units You are required to prepare: (i) Sales Budget for 2026-27 after incorporating the above estimates. (ii) Statement showing Budgeted and Actual Sales for 2025-26.

Suggested Answer and Working Notes:

Answer (a) (i) Statement Showing Sales Budget for 2026-27 Channel Omega Theta Total Qty. Rate (₹) Amt. (₹) Qty. Rate (₹) Amt. (₹) Amt. (₹) Online 1,350 13,500 1,82,25,000 650 45,000 2,92,50,000 4,74,75,000 Retail 840 16,200 1,36,08,000 530 50,000 2,65,00,000 4,01,08,000 Total 2,190 3,18,33,000 1,180 5,57,50,000 8,75,83,000 Workings 1,000 × 115% + 200 = 1,350 units800 × 105% + Nil = 840 units500 × 110% + 100 = 650 units400 × 120% + 50 = 530 units (ii) Statement Showing Budgeted Sales for 2025-26 Channel Omega Theta Total Qty. Rate (₹) Amt. (₹) Qty. Rate (₹) Amt. (₹) Amt. (₹) Online 1,000 15,000 1,50,00,000 500 40,000 2,00,00,000 3,50,00,000 Retail 800 18,000 1,44,00,000 400 45,000 1,80,00,000 3,24,00,000 Total 1,800 2,94,00,000 900 3,80,00,000 6,74,00,000 Statement Showing Actual Sales for 2025-26 Channel Omega Theta Total Qty. Rate (₹) Amt. (₹) Qty. Rate (₹) Amt. (₹) Amt. (₹) Online 1,200 15,000 1,80,00,000 450 40,000 1,80,00,000 3,60,00,000 Retail 700 18,000 1,26,00,000 500 45,000 2,25,00,000 3,51,00,000 Total 1,900 3,06,00,000 950 4,05,00,000 7,11,00,000

Topics: Budgets and Budgetary Control

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic