Tempo Company's fixed budget (based on sales of 7,000 Budgeted units Bucke 9 price per unit Fixed Budget 5 Sales (7,000 units x 5400 per unit) $2,800,000 7,000 $400 6 Costs 17 Direct materials 280,000 B Direct labor 490,000 9 Indirect materials 175,000 10 Supervisor salary 65,000 35 Sales commissions 140,000 12 Shipping 154,000 13 Administrative salaries 210,000 34 Depreciation-Office equipment 35,000 15 Insurance 20,000 16 Office rent 36,000 17 Income $1,195,000 18 9 Required: 201 Compute total variable cost per unit 21 22 (Use cells A2 to D17 from the given Information to complete this question.) 24 Total variable cost per unit 26 2 Compute total fixed costs 27 28 (Use cells A2 to D17 from the given information to complete this question.) 29 30 Total nxed 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 33 34 (Use cells A2 to E32 from the given information to complete this question. Negative amounts or amounts to be 35 deducted should be input and displayed as negative values.) 36 37 38 39 40 Sales 41 Variable costs 42 43 44 45 46 47 Total variable costs 48 Contribution margin 49 Fixed costs 50 51 52 53 55 Total faed costs 56 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