I NEED TO INSETRT A WHAT IIF ANAYLYSIS IN EXCEL FOR THIS PROBLEM BUT WHEN...

90.2K

Verified Solution

Question

Accounting

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students