A1 File Home Insert Draw Formulas Data Review View Help Editing Calibri B General Comments fr Accessibility tab summary: Tempo Company's fixed budget is presented in cells A4 to 817 and an additional table is presented in cells D3 to 5. A statement of requirement 1 is G L M N H 3 K 2 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 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 $1,195,000 Budgeted units Budgeted selling 7,000 price per unit $400 17 Income 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. 28 (Use cells A2 to D17 from the given information to complete this question.) 30 Total fixed costs 31 32 3. Prepare a flexible budget at activity levels of 6,000 units and 8,000 units. Unit Sales 6,000 8,000 34 (Use cells A2 to E32 from the given information to complete this question. Negative amounts or 35 amounts to be deducted should be input and displayed as negative values.) TEMPO COMPANY Flexible Budget 40 Sales 41 Variable costs 44 45 46 47 Total variable costs 45 Contribution margin 49 Fixed costs 50 51 52 53 54 55 Total fixed costs 56 Income Flexible Budget for: Variable Amount Total Fixed per Unit Cost Units Sales of Unit Sales of 6,000 8,000