The following information is provided by Muni Ltd. : Sales Budget for the year 1 st April, 2019 to 31 st March, 2020 Quarter Product-Pixel (units) Product-Quita (units) 1 st Quarter 25,000 23,000 2 nd Quarter 30,000 25,0

CS Executive · Corporate and Management Accounting · PYQS · June 2019
The following information is provided by Muni Ltd. : Sales Budget for the year 1 st April, 2019 to 31 st March, 2020 Quarter Product-Pixel (units) Product-Quita (units) 1 st Quarter 25,000 23,000 2 nd Quarter 30,000 25,000 3 rd Quarter 40,000 32,000 4 th Quarter 48,000 40,000 The additional information is provided with respect to inventory management as under: (1) Expected stock position as on 1 st April, 2019: Product Pixel and Quita as 25% and 80% of expected sales of 1 st Quarter of the next financial year respectively. (2) Expected stock position at the end of 1 st , 2 nd and 3 rd Quarter will be 25% of next Quarter's sales for both the products – Pixel and Quita. (3) Expected stock position as on 31 st March, 2020 will be: Product Pixel – 28,000 units and Product Quita – 15,000 units. You are required to prepare Quarter-wise Production Budget for the year 2019-20, for both the products separately.

Answer & Explanation:

Production Budget for year 2019-20 Product Pixel (Amount in Rs.) Particulars 1 st quarter 2 nd quarter 3 rd quarter 4 th quarter Budget sales 25,000 30,000 40,000 48,000 Add: closing stock (25% of next quarter's sales) 7,500 (25% of 30,000) 10,000 (25% of 40,000) 12,000 (25% of 48,000) 28,000 (Given) Total requirements 32,500 40,000 52,000 76,000 Less: opening stock (6,250) (25% of 25,000) (7,500) (10,000) (12,000) Budgeted production 26,250 32,500 42,000 64,000 Note for Product Pixel Opening Stock 1st Quarter: Expected stock position as on 1st April, 2019 (beginning of 1st Quarter) is 25% of expected sales of 1st Quarter of the next financial year. The solution likely assumes 1st Quarter sales of next year are same as current year's 1st Quarter sales, or it's a typo in the solution and it should be 25% of current 1st quarter sales. The solution calculates 6,250 which is 25% of 25,000. This implies it's 25% of *current* 1st quarter sales. Product Quita (Amount in Rs.) Particulars 1 st quarter 2 nd quarter 3 rd quarter 4 th quarter Budget sales 23,000 25,000 32,000 40,000 Add: closing stock (25% of next quarter's sales) 6,250 (25% of 25,000) 8,000 (25% of 32,000) 10,000 (25% of 40,000) 15,000 (Given) Total requirements 29,250 33,000 42,000 55,000 Less: opening stock (18,400) (80% of 23,000) (6,250) (8,000) (10,000) Budgeted production 10,850 26,750 34,000 45,000 Note for Product Quita Opening Stock 1st Quarter: Expected stock position as on 1st April, 2019 (beginning of 1st Quarter) is 80% of expected sales of 1st Quarter of the next financial year. The solution calculates 18,400 which is 80% of 23,000. This implies it's 80% of *current* 1st quarter sales.

Topics: Budgeting

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

Related Questions in this Topic