cessity tab summary: Tempo Company's fixed budget is presented in cells A4 to 17 and an additional table in presented in cells D3 to ES. A statement of requir B C Tempo Company's fixed budget (based on sales of 7,000 units) follows 2 3 4 Fixed Budget 5 Sales (7,000 units x $400 per unit) 6 Costs 7 Direct materials Direct labor 9 Indirect materials 10 Supervisor salary 11 Sales commissions 12 Shipping 13 Administrative salaries 24 Depreciation-Office equipment 15 Insurance 16 Office rent 17 Income 18 $2,800,000 280,000 490,000 175,000 65,000 140,000 154,000 210,000 35,000 20,000 36,000 $1,195,000 Budgeted units Budgeted selling 7,000 price per unit $400 H McGraw Hill Check Answer Check My Wow Legend Graded cell needed. Scratchood workspace 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 foxed costs. 27 28 (Use cells A2 to D17 from the given information to complete this question.) Graded Worksheet + Calculation Mode Automatic Workbook Statistics Save a A1 EX Accessibility tab summary: Tempo Company's fixed budget is presented in celts A4 to 617 and an additional table is presented in cells 03 to 15. A statement of rem McGraw Hill Check Answe 27 28 (Use cells A2 to 017 from the given information to complete this question.) 29 30 Total fixed costs 35 323 Prepare a flexible budget at activity levels of 6,000 units and 8,000 units 33 34 question.) 35 29 40 Sales 41 Variable costs 42 43 44 45 46 47 Total variable costs 48 Contribution margin 49 Fixed costs 50 52 Graded Worksheet Calculation Mode Automatic Workbook Statistics Unit Sales 6,000 8,000 TEMPO COMPANY Flexible Budget Flexible Budget for: Variable Amount Total Fixed per Unit Cest Units Sales of Unit Sales of 6,000 8,000 Check My We Legend Graded cel needed Scratchoom workspace Su