90.2K

Verified Solution

Link Copied!

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

See Answer