Please answer #15. I provided the answers for Exercises 10-14.

15. Use the information determined in Exercises 10-14 to prepare the cost of goods sold budget for Cards by Shannon for 2016. The company expects the beginning and ending inventories shown. Direct materials (Card stock) Work in process Finished goods Beginning Inventory $ 200 8,850 10,200 Ending Inventory $ 200 20,000 25,200 Answer 10 Revenue budget for the year 2016 Description Expected units to be sold Sales price p.u Total Revenue in S) B C Total 2,040 5.100 1.530 8,670 10128 20,400 61,200 12,240 93,840 Answer 11 Production budget for the year 2016 C Description Expected Units to be sold Add: Desired Finished inventory Total Required Units Less: Opening Inventory Required Production B 2,040 2,1525 4,192 2,102 2,090 5,100 ,381 10,481 5.255 5.226 1,530 1,614 3.144 1,577 1.568 Total 8,670 9,147 17.817 8,934 8.884 Ending Inventory is total of current year sales+ 5% of year 2017 sales 2017 Sales 110%of 2016 sales Opening Inventory is total of year 2015 sale+5%of year 2016 sales Answer 12 Total 8.884 2,090 1.50 3,135 5.226 3.00 15,678 1.568 0.50 784 Direct material budget Description Units to be produced Direct Material required per unit Total material required in units) Add: Desired ending direct materials in unit) Total material required Less: opening inventory Total Material to be purchased Cost per unit Total Cost of Material purchased 19.597 2,000 21,597 2,000 23.597 0.10 2,359.70 Answer 13 Direct labour budget Description ABC Total Units to be produced 2090 5226 1568 8884 Direct labour time per unit (in hours) Production 1.65 Finishing 0. 51 Total labour required (in hours) per unit of production 0.75 1 2.65 Total labour required (in hr) 1567.5 5226,0 14112 8204.7 Cost per hour Total cost in S) 14107.50 47034.00 12700,80 73842.30 14 Factory overhead cost budget of the company for the year 2015 Variable factory overhead costs : Utilities $8.000 Indirect materials $500 Indirect factory wages $2,500 Total variable factory overhead costs $11,000 Fixed factory overhead costs : Factory Depreciation $7,500 Total fixed factory overhead costs $7,500 Total factory overhead costs $18,500