5 Paste Cut s Copy Format Painter Clipboard d BID A $ . % 98 IM Conditional format Formatting - Tables Tables Font Undo Number Alignment 1 August F1 B D F H 12 13 14 Requirement 1: 15 Perfect Pots, Inc. makes large, outdoor decorative flower pots that have the look of clay but are made from a polyresin 16 material that is much more durable. The controller for the company is working on the budget for the coming fiscal year, which 17 begins April 1. 18 19 Sales are expected to increase each month by: 20% 20 21 Complete the Sales Budget for April - June and the quarter in total 22 23 Sales Budget April May June 1st Quarter July 24 Sales in units 6,100 25 Price per unit $ 90 $ 90 $ 90 S 90 26 Total sales 27 28 29 Requirement 2: 30 Desired ending Inventory: 10% of next months expected sales 31 32 Complete the Production Budget for April - June and the quarter in total 33 34 Production Budget April May June 1st Quarter July 35 Sales in units 36 Desired ending Inventory 37 Total required 38 Beginning inventory 39 Total units to produce 40 41 42 Hint: The next three budgets are all manufacturing cost budgets, and use units to be produced, ne 43 Aug Hint: You will in units in ord inventory for July Aug 42 Hint: The next three budgets are all manufacturing cost budgets, and use units to be produced, no 43 Requirement 3: 44 The standard cost for polyresin: $ 8 per pound 45 The standard quantity of polyresin: 5 pounds per pot 46 Desired direct materials ending inventory: 15% of next months production 47 48 Complete the direct materials purchases budget for April - June and the quarter in total 49 50 Direct Materials Purchases Budget April May June 1st Quarter 51 Units to be produced 52 Pounds of direct material per unit produced 53 Total pounds needed for production 54 Desired ending inventory 55 Total material requirement 56 Beginning inventory 57 Total pounds to purchase 58 Cost per pound 59 Total cost of direct materials 60 Hint: Ya produce material Requirement 4: Standard labor rate: Standard labor hours required: $ 16 per hour 1 per pot Complete the Direct Labor Budget below: April May June 1st Quarter Direct Labor Budget Units to be produced Direct labor hours per unit Total direct labor hours Direct labor rate per hour Total cost of direct labor > G 5 6 Requirement 5: 7 Indirect materials cost per pot: $ 20 8 Fixed manufacturing overhead costs per month: *9 Depreciation $ 2,410 50 Utilities 1,890 31 Supervisor's salary 9,640 B2 Other 2,910 33 34 Complete the Manufacturing Overhead Budget below: 35 B6 Manufacturing Overhead Budget April 87 Variable Overhead 88 Units to be produced 89 Variable overhead per unit 90 Total variable overhead 91 Fixed Overhead Depreciation 93 Supervisor's salary 94 Factory utilities 95 Other 96 Total fixed overhead 97 Total manufacturing overhead 98 May June 1st Quarter 92 us $ 2 per pot $ 603 4,820 728 100 Requirement 6: 101 Selling costs: 102 Fixed administrative costs per month: 103 Depreciation 104 Billing and accounting 105 Other 106 107 Complete the Operating Expense Budget below: 108 109 Operating Expense Budget 110 Variable Selling Expenses 111 Units to be sold 112 Selling cost per unit sold 113 Total variable selling expenses 114 Fixed Administrative Expenses 115 Depreciation 116 Billing and accounting 117 Other administrative costs 118 Total fixed administrative 119 Total operating expenses 120 April May June 1st Quarter 1 GO B D E 21 22 Requirement 7: 23 Calculate manufacturing cost per unit at your projected volume of production: 24 -25 DM cost per unit -26 DL cost per unit -27 Variable MOH per unit 28 Total fixed MOH -29 Units to be produced 30 Fixed MOH per unit 31 Total manufacturing cost per unit Used to determine COGS bek 32 133 134 Requirement 8: 135 Prepare the budgeted income statement for the quarter ending June 30 below: 136 137 Perfect Pots, Inc. 138 Budgeted Income Statement 139 Quarter Ending June 30 140 141 Sales 142 Cost of goods sold 143 Gross profit 144 145 Operating expenses 146 Selling 147 Administrative 148 Total operating expenses 149 150 Operating income 151 152 Hint: COGS is based on units sold, not produc Use the manufacturing cost per unit calcula above and the units to be so P3 +