Tempo Company's fixed budget (based on sales of 7,000 units) follows. Budgeted units Budgeted selling price per unit Fixed Budget Sales (7,000 units x $400 per unit) Costs Direct materials Direct labor $2,800,000 280,000 490,000 Indirect materials 175,000 Supervisor salary 65,000 Sales commissions 140,000 Shipping 154,000 Administrative salaries 210,000 Depreciation-Office equipment 35,000 Insurance 20,000 Office rent 36,000 Income $1,195,000 Required: 1. Compute total variable cost per unit. (Use cells A2 to D17 from the given information to complete this question.) Total variable cost per unit 2. Compute total fixed costs. (Use cells A2 to D17 from the given information to complete this question.) Total fixed costs 7,000 $400 Unit Sales 6,000 8,000 3. Prepare a flexible budget at activity levels of 6,000 units and 8,000 units. (Use cells A2 to E32, as well as cells A40 to E56 from the Flexible Budget, to complete this question.) Sales Variable costs Total variable costs Contribution margin Fixed costs Total fixed costs Income TEMPO COMPANY Flexible Budget Flexible Budget for: Variable Amount Units Sales of Unit Sales of per Unit Total Fixed Cost 6,000 8,000