A company manufactures two products, Bubble and Squeak. The products are made from three materials A, B, and C; the following table shows quantities and prices of each material used in the products:
Product A B C
Bubble 1kg 0.5kg 1.5kg
Squeak 0.5kg 2kg 0.5kg
Price per kilo £1.50 £1.00 £2.50
The product schedule for Year 3 is as follows:
Month No 1 2 3 4-6 7-9 10-12
Bubble 3000 3500 3800 10000 11000 12000
Squeak 5000 5500 6000 17000 18000 18000
Stock positions Akg Bkg Ckg
Opening 6000 14000 8000
Closing 10 per cent higher than in the final month of the year's consumption, the production of that month being one third of the quarter's production.
Require to prepare materials cost budget and purchasing budget for Year 3.