(CMA, adapteo) (appendix) Completion of budget schedules: manufacturer School Days Furniture Ltd manufactures a variety of desks, chairs, tables and book shelves w 5 .39 sold to public schools in Western Australia. The Financial Accountant of the Desk Division is curr preparing the budget for the third quarter of this year. The following sales have been forecast for the third quarter 5000 desks 6000 desks requires 3 metres of wooden planks and 1.5 hours of direct labour nlanks costs $1s per metre,and at Each desk sells for enough 7500 desks the next month's production requirements. The divisood of the the end of each month there is ends each month with remaining to cover tO per cost of $25 per hour for direct labout including on costs. The division ends each months On an Exce/ spreadsheet construct the following budget schedules (a) Sales budget finished goods to satisty 20 perc frished goods to satisty 20 percent of the following months sales Juty August 5000 200 Sales unts Selling prioe per unit Sales revenue $1 00000 August September D) Production budget (units) July 5000 Sales units 1200 1 500 Add ending inventory 6200 Total units required Less opening inventory Planned production 5200 Raw materials purchases July AugustSeptember Planned production 5200 Raw material per unit Raw material required for production 15600 Add ending inventory of raw materials Total requirements Less ending inventory of raw materials Planned purchases of raw material in metres Cost per metre Planned purchases of raw material in dollars $286 740 1890 2700 17490 1560 15930 $2 86740 (d) Direct labour budget Sales units July Direct labour per unit August September Direct labour hours required 5000 Cost per hour Planned drect labour cost 7500 $187500