Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I NEED TO INSETRT A WHAT IIF ANAYLYSIS IN EXCEL FOR THIS PROBLEM BUT WHEN I DO IT I GET 0 FOR EVRYTHING. Roadmaster Equipment
I NEED TO INSETRT A WHAT IIF ANAYLYSIS IN EXCEL FOR THIS PROBLEM BUT WHEN I DO IT I GET 0 FOR EVRYTHING.
Roadmaster Equipment is an up-scale, higher-priced, specialty road construction equipment maker based in Irvine, California. The management accountant for Roadmaster compiled information for various levels of output in units. | |||||||||||||
Required: | |||||||||||||
Complete the yellow cells with the appropriate algebra. | |||||||||||||
Complete the one variable data table | |||||||||||||
Basic Model | Output | ||||||||||||
Per Unit | Total | ||||||||||||
Units | 3,100 | 3,100 | 6,500 | 8,800 | |||||||||
Variable production costs | $56,967.74 | $176,600,000.00 | $176,600,000 | 370290322.6 | 501316129 | ||||||||
Fixed production costs | $245,400,000 | $245,400,000 | $245,400,000 | $245,400,000 | |||||||||
Variable selling costs | $12,645.16 | $39,200,000.00 | $39,200,000 | 82193548.39 | 111277419.4 | ||||||||
Fixed selling costs | $15,000,000 | $15,000,000 | $15,000,000 | $15,000,000 | |||||||||
Total costs | 191,600,000 | $476,200,000 | $712,883,871 | $872,993,548 | |||||||||
Selling price per unit | $155,300 | $155,300 | $155,300 | $155,300 | $155,300 | ||||||||
Unit cost | $ 61,806.45 | $153,612.90 | $109,674.44 | $99,203.81 | |||||||||
Profit per unit | $93,494 | $1,687.10 | $45,625.56 | $56,096.19 | |||||||||
Data table | Profit per Unit | ||||||||||||
$93,494 | |||||||||||||
Increments of 500, starting at 500 | 500 | 0 | |||||||||||
1000 | 0 | ||||||||||||
1500 | 0 | ||||||||||||
2000 | 0 | ||||||||||||
2500 | 0 | ||||||||||||
3000 | 0 | ||||||||||||
3500 | 0 | ||||||||||||
4000 | 0 | ||||||||||||
4500 | 0 | ||||||||||||
5000 | 0 | ||||||||||||
5500 | 0 | ||||||||||||
6000 | 0 | ||||||||||||
6500 | 0 | ||||||||||||
7000 | 0 | ||||||||||||
7500 | 0 | ||||||||||||
8000 | 0 | ||||||||||||
8500 | 0 | ||||||||||||
9000 | 0 | ||||||||||||
9500 | 0 | ||||||||||||
10000 | 0 | ||||||||||||
10500 | 0 | ||||||||||||
11000 | 0 | ||||||||||||
11500 | 0 | ||||||||||||
12000 | 0 |
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