Tempo Company's fixed budget (based on sales of 7,000 units) follows.

Thank you for the help!

B D E G M R Tempo Company's fixed budget (based on sales of 7,000 units) follows. Budgeted units Budgeted selling price per unit 7,000 $400 $2,800,000 Fixed Budget Sales (7,000 units x $400 per unit) Costs Direct materials Direct labor Indirect materials Supervisor salary Sales commissions Shipping Administrative salaries Depreciation-Office equipment Insurance Office rent Income 280,000 490,000 175,000 65,000 140,000 154,000 210,000 35,000 20,000 36,000 $1,195,000 Required: 1. Compute total variable cost per unit. (Use cells A2 to 017 from the given information to complete this question.) Total variable cost per unit 2. Compute total fixed costs. (Use cells A2 to 017 from the given information to complete this question.) Total fixed costs Unit Sales 6,000 3. Prepare a flexible budget at activity levels of 6,000 units and 8,000 units. 8,000 (Use cells A2 to E32 from the given information to complete this question. Negative amounts or amounts to be 8 (Use cells A2 to 017 from the given information to complete this question.) -9 CO Total fixed costs Unit Sales 6,000 2 3. Prepare a flexible budget at activity levels of 6,000 units and 8,000 units. 8,000 4 (Use cells A2 to E32 from the given information to complete this question. Negative amounts or amounts to be 5 deducted should be input and displayed as negative values.) -6 -7 TEMPO COMPANY -8 Flexible Budget Flexible Budget for: Variable Amount per Unit Units Sales of 6,000 Unit Sales of 8,000 Total Fixed Cost 9 -0 Sales -1 Variable costs -3 4 -5 -6 -7 Total variable costs -8 Contribution margin -9 Fixed costs -0 .1 -2 3 -4 5 Total fixed costs -6 Income -7 8 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 TEMPO COMPANY 38 Flexible Budget Flexible Budget for: Variable Amount per Unit Units Sales of 6,000 Unit Sales of 8,000 Total Fixed Cost 39 40 Sales 41 Variable costs 42 Administration salaries 43 44 45 46 Depreciation Office equipment Direct labor 47 Direct materials 48 Indirect materials 49 Insurance 50 Office rent 51 Sales 52 53 54 55 Total fixed costs 56 Income 57 K 5 7 3 TEMPO COMPANY Flexible Budget Flexible Budget for: Variable Amount Units Sales of 6,000 Unit Sales of 8,000 per Unit Total Fixed Cost Sales 1 Variable costs 2 B Direct materials 4 Indirect materials 5 Insurance 5 7 Office rent 3 Sales 2 Sales commissions Shipping Supervisor salary 3 4. 5 Total fixed costs 3 Income 3