3 Prepare the following schedules in good form. All formats should be followed including dollar signs, decimal places, underscores*, column alignment, bold etc. (*the borders function should be used for underscores). Not following the correct formatting will result in penalty. 4 5 1. Revenue Budget 6 2. Production Budget 7 8 4. Direct Labor Budget 9 3. Direct Materials Budget 5. Manufacturing Overhead Budget 10 6. Ending Finished Goods Inventory Budget 11 7. Selling, General, and Administrative Expense Budget 12 8. Cash Budget 13 9. Budgeted Income Statement 14 10. Budgeted Balance Sheet 15 16 Grading The assignment contains 100 possible points. Each schedule is worth 8 points for a total of 80 points. The remaining 20 points will be allocated to the 17 development and formating of the spreadsheet (10 points) and the use of Excel formulas (10 points). Do not hardcode numbers in your schedules (other than the assumptions tab). 18 19 Completion of the Assignment and Formatting 20 21 Change the name of your file to "Section # - Your Name - Part 1" and submit the file via Blackboard to your professor by the class due date./n6 7 8 Sales Budget Budgeted sales in units 9 Selling price per unit 10 Percentage of total sales collected in quarter of sale 11 Percentage of total sales collected in quarter after sale 12 Percentage of total sales collected in second quarter after sale 13 Sales in 4th quarter of prior year 14 15 Production Budget 16 Percentage of next quarter's sales units in ending finished goods inventory 17 Units in beginning finished goods inventory 18 Inventory valuation method used is FIFO 19 20 Direct Materials Budget 21 Feet of heart of pine wood per unit (cabinet) 22 Cost per foot of heart of pine wood 23 Percentage of next quarter's production needs in ending inventory 24 Board feet of heart of pine wood in beginning raw materials inventory 25 Board feet of heart of pine wood needed to meet production for quarter 1 in 2022 26 Percentage of purchases paid in the quarter purchased 27 Percentage of purchases paid in the quarter after the purchase 28 29 Direct Labor Budget 30 Direct labor hour required per unit (cabinet) 31 Direct labor cost per hour 32 33 Manufacturing Overhead Budget 34 Variable manufacturing overhead per direct labor hour 35 Fixed manufacturing overhead per quarter 36 Depreciation per quarter (included in the fixed manufacturing overhead) 37 38 Selling and Adminsitrative Expense Budget 39 Variable selling and adminsitrative expense per unit Fixed selling and administrative expense per quarter 40 41 42 Executive salaries Advertising All 4 Quarters 2021 Quarters 1 2 3 Quarter 1

Fig: 1

Fig: 2