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!


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
Get step-by-step solutions from verified subject matter experts
