P9.39 (appendix) Completion of budget schedules: manufacturer School Days Furniture Lid manufactures a variety of desks, chairs, tables and book shelves that are sold to LO9.9 public schools in Western Australia. The financial accountant of the desk division is currently preparing the 9.11 budget for the third quarter of this year. The following sales have been forecast for the third quarter. July 5000 desks August 6000 desks September 7500 desks Each desk requires 3 metres of wooden planks and 1.5 hours of direct labour. Each desk sells for $200. Wooden planks costs $18 per metre, and at the end of each month there is enough wood remaining to cover 10 per cent of the next month's production requirements. The division incurs a cost of $25 per hour for direct labour, including on-costs. The division ends each month with enough finished goods to satisfy 20 per cent of the following month's sales. 68 PART THREE INFORMATION FOR MANAGING RESOURCES B 193 / 1132 61.296 - Required: 1. In an Excel spreadsheet construct and complete the following budget schedules. (a) Sales budget July August September Sales units 5 000 Selling price per unit 200 Sales revenue $1 000 000 (b) Production budget (units) July August September Sales units 5 000 Add ending inventory 1 200 1 500 Total units required 6 200 Less opening inventory 1 000 Planned production 5 200