..Il mobile 8:26 AM 88% X Individual Assignment I - Case - (E... E Appendix 1 White Chocolate Dark Chocloate Pure Chocolate Sales Mix 50.00% 30.00% 20.00% Contribution Margin Ratio 40.00% 60.00% 70.00% Total Driver per Volume Activity Cost Pool Issuing Purchase Orders Delivery Orders Estimated Overhead SI50,000 S160,000 50,000 20,000 Packaging S450,000 100.000 Cost Driver No. of Purchase Orders No. of Reams No. of Orders Delivered Activity Cost Pool Issuing Purchase Orders Delivery Orders Packaging Dark Chocolate 125 150 160 White Chocolate 180 400 350 Pure Chocolate 160 325 300 Raw Materials Data Beginning Ending $1,250,000 S24.500 Work in Process Beginning Ending Manufacturing Overhead $89,000 S16,000 $215,000 Direct Labour 824,000.00 Old Machine New Machine Production Cost per unit Sales Cost per unit Production in units (Old Machine) s 80,000.00 s 55.000.00 s s 6.50 8.50 Sale in Units (Old Machine) 50.00 50.00 ...Il mobile 8:27 AM 88% X Individual Assignment - Case - (E... Appendix II Expected Lnie Sale November December 474,667 712,000 January's sales increases by 50% incrementally cach month 10% following month's production Desired Ending Finished Goods: requirements January's Beginning finished goods: 10% of Estimated first quarter sales Desired Ending Direct Materials (lbs): 5% next month's production January's Beginning Direct Materials Lbs): 10% Estimated first quarter's production Direct Materials per unit. Direct Materials cost per lb. 2 lbs $0.75 Collection Contract Schedule 60% in the same month of sale 30% in the next month of sale 10% two months after sale Scheduled Payments 50% in the month of purchase 50% in the next month of purchase s 1.40 Selling & Administrative Variable Expenses per Unit Fixed Expenses Advertising Insurance Salaries Depreciation Other 15,000.00 1,400.00 12,000.00 2,200.00 3,000.00 Total Direct Labour Cost January February March $ 4,037,040.00 6,055,560.00 9,788,400.00 Total Indirect Labour Hours January February March 224 280 336,420 435,040 8. For each department a budget has to be prepared. Prepare budgets for the following: (59 Marks) (a) Sales (b) Production (c) Direct Materials (d) Manufacturing Overhead (e) Selling and Administrative (f) Collections (9) Payments (h) Cash ..Il mobile 8:26 AM 88% X Individual Assignment I - Case - (E... E Appendix 1 White Chocolate Dark Chocloate Pure Chocolate Sales Mix 50.00% 30.00% 20.00% Contribution Margin Ratio 40.00% 60.00% 70.00% Total Driver per Volume Activity Cost Pool Issuing Purchase Orders Delivery Orders Estimated Overhead SI50,000 S160,000 50,000 20,000 Packaging S450,000 100.000 Cost Driver No. of Purchase Orders No. of Reams No. of Orders Delivered Activity Cost Pool Issuing Purchase Orders Delivery Orders Packaging Dark Chocolate 125 150 160 White Chocolate 180 400 350 Pure Chocolate 160 325 300 Raw Materials Data Beginning Ending $1,250,000 S24.500 Work in Process Beginning Ending Manufacturing Overhead $89,000 S16,000 $215,000 Direct Labour 824,000.00 Old Machine New Machine Production Cost per unit Sales Cost per unit Production in units (Old Machine) s 80,000.00 s 55.000.00 s s 6.50 8.50 Sale in Units (Old Machine) 50.00 50.00 ...Il mobile 8:27 AM 88% X Individual Assignment - Case - (E... Appendix II Expected Lnie Sale November December 474,667 712,000 January's sales increases by 50% incrementally cach month 10% following month's production Desired Ending Finished Goods: requirements January's Beginning finished goods: 10% of Estimated first quarter sales Desired Ending Direct Materials (lbs): 5% next month's production January's Beginning Direct Materials Lbs): 10% Estimated first quarter's production Direct Materials per unit. Direct Materials cost per lb. 2 lbs $0.75 Collection Contract Schedule 60% in the same month of sale 30% in the next month of sale 10% two months after sale Scheduled Payments 50% in the month of purchase 50% in the next month of purchase s 1.40 Selling & Administrative Variable Expenses per Unit Fixed Expenses Advertising Insurance Salaries Depreciation Other 15,000.00 1,400.00 12,000.00 2,200.00 3,000.00 Total Direct Labour Cost January February March $ 4,037,040.00 6,055,560.00 9,788,400.00 Total Indirect Labour Hours January February March 224 280 336,420 435,040 8. For each department a budget has to be prepared. Prepare budgets for the following: (59 Marks) (a) Sales (b) Production (c) Direct Materials (d) Manufacturing Overhead (e) Selling and Administrative (f) Collections (9) Payments (h) Cash