Tempo Company's fixed budget (based on sales of 7,000 units) follows. Fixed Budget Sales (7,000 units x $400 per unit) Costs Direct materials $2,800,000 280,000 Direct labor Indirect materials Supervisor salary 490,000 175,000 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 Budgeted units Budgeted selling price per unit 7,000 $400 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 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 from the given information to complete this question. Negative amounts or amounts to be deducted should be input and displayed as negative values.) 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