Question: please help me fill out the excel spreadsheet correctly with the given information. please include formulas. thank you! Tempo Company's fixed budget (based on sales

please help me fill out the excel spreadsheet correctly with the given information. please include formulas. thank you!

 please help me fill out the excel spreadsheet correctly with the
given information. please include formulas. thank you! Tempo Company's fixed budget (based
on sales of 7,000 units) follows. 18. Required: 19. 1. Compute total

Tempo Company's fixed budget (based on sales of 7,000 units) follows. 18. Required: 19. 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 3. Prepare a flexible budget at activity levels of 6,000 units and 8,000 units. \begin{tabular}{|l|l|} \hline \multicolumn{2}{|l|}{ Unit Sales } \\ \hline 6,000 & 8,000 \\ \hline \end{tabular} question.) TEMPO COMPANY Flexible Budget Flexible Budget for: Variable Amount Total Fixed Units Sales of Unit Sales of per Unit Cost 8,000 42 43 44 45 Total variable costs Contribution margin Fixed costs Total fixed costs Income Tempo Company's fixed budget (based on sales of 7,000 units) follows. 18. Required: 19. 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 3. Prepare a flexible budget at activity levels of 6,000 units and 8,000 units. \begin{tabular}{|l|l|} \hline \multicolumn{2}{|l|}{ Unit Sales } \\ \hline 6,000 & 8,000 \\ \hline \end{tabular} question.) TEMPO COMPANY Flexible Budget Flexible Budget for: Variable Amount Total Fixed Units Sales of Unit Sales of per Unit Cost 8,000 42 43 44 45 Total variable costs Contribution margin Fixed costs Total fixed costs Income

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!