Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Costing

Authors: Lucey

7th Edition

1844809439, 978-1844809431

More Books

Students also viewed these Accounting questions