Excel McGraw Hill Excel Question - Saved Search (Option + Q) File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 B General A1 2 1234 Xx Accessibility tab summary: Tempo Company's fixed budget is presented in cells A4 to 817 and A B C Tempo Company's fixed budget (based on sales of 7,000 units) follows. D E Budgeted units Budgeted selling Fixed Budget 5 Sales (7,000 units x $400 per unit) $2,800,000 6 Costs 7 Direct materials 280,000 8 Direct labor 490,000 9 Indirect materials 175,000 10 Supervisor salary 65,000 11 Sales commissions 140,000 12 Shipping 154,000 13 Administrative salaries 210,000 14 Depreciation-Office equipment 35,000 15 Insurance 20,000 16 Office rent 36,000 17 Income $1,195,000 18 19 Required: 20 1. Compute total variable cost per unit. 21 22 (Use cells A2 to D17 from the given information to complete this question.) 23 24 Total variable cost per unit 25 26 2. Compute total fixed costs. 27 28 (Use cells A2 to D17 from the given information to complete this question.) 29 30 Total fixed costs 31 Graded Worksheet + Calculation Mode: Automatic Workbook Statistics 7,000 price per unit $400 Unit Sales in anal MacBook Pro A1 1 2 3 Excel McGraw Hill Excel Question Saved Search (Option + Q) File Home Insert Draw Formulas Data Review View Help Editing Calibri 11 B B&A General A fx Accessibility tab summary: Tempo Company's fixed budget is presented in cells A4 to 817 anc B C Tempo Company's fixed budget (based on sales of 7,000 units) follows. 4 Fixed Budget 5 Sales (7,000 units x $400 per unit) $2,800,000 6 Costs 7 Direct materials 280,000 8 Direct labor 490,000 9 Indirect materials 175,000 10 Supervisor salary 65,000 11 Sales commissions 140,000 12 Shipping 154,000 13 Administrative salaries 210,000 14 Depreciation-Office equipment 35,000 15 Insurance 20,000 16 Office rent 36,000 17 Income $1,195,000 18. 19 Required: 20 1. Compute total variable cost per unit. 21 22 (Use cells A2 to D17 from the given information to complete this question.) 23 24 Total variable cost per unit 25 26 2. Compute total fixed costs. 27 28 (Use cells A2 to D17 from the given information to complete this question.) 29 30 Total fixed costs 31 33 = Graded Worksheet + Calculation Mode: Automatic Workbook Statistics D E Budgeted units Budgeted selling price per unit 7,000 $400 Unit Sales F