Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve in Excel formulas Required: 1. Compute total variable cost per unit. 2. Compute total fixed costs. ='Question Data'!.A26 Tempo Company's fixed budget (based
Please solve in Excel formulas
Required: 1. Compute total variable cost per unit. 2. Compute total fixed costs. ='Question Data'!.A26 Tempo Company's fixed budget (based on sales of 33,000 units) follows. \begin{tabular}{|l|r|r|} \hline & Fixed Budget & Flexible Budget \\ \hline Budgeted units & 33,000 & 32,500 \\ \hline Selling price per unit & $590 & \\ \hline & & \\ \hline Fixed Budget (based on 33,000 units) & \\ \hline Sales & $19,470,000 & \\ \hline Costs & & \\ \hline Direct materials & 1,947,000 & \\ \hline Direct labor & 2,937,000 & \\ \hline Indirect materials & 1,452,000 & \\ \hline Supervisor salary & 1,946,000 \\ \hline Sales commissions & 973,500 & \\ \hline Shipping & 1,039,500 & \\ \hline Administrative salaries & 4,282,000 & \\ \hline Depreciation-Office equipment & 779,000 & \\ \hline Insurance & 623,000 & \\ \hline Office rent & 155,000 \\ \hline Income & $3,336,000 \\ \hline & & \\ \hline Required: & & \\ \hline 1. Compute total variable cost per unit. & \\ \hline 2. Compute total fixed costs. & \\ \hline 3. Prepare a flexible budget at activity levels of 32,500 units and 33,500 units. \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started