A manufacturing Co. submits the following figures for the first quarter of 1980:
Product X Product Y Product Z
Sales in (Units)-Jan. 25,000 30,000 10,000
Feb. 20,000 25,000 10,000
Mar. 30,000 35,000 10,000
Selling price per unit (Rs.) 10 20 40
Targets for 1st Quarter 1981:
Sales quantity increase 20% 10% 10%
Sales price increase Nil 10% 25%
Stock position 1st Jan. 81:
Percentage of Jan. 81 sales 50% 50% 50%
Stock position 31st Mar. 81 20,000 25,000 5,000
Percentage of subsequent months sales 50% 50% 50%
You are required to prepare the Sales and Production budget for the 1st Quarter of 1981.