Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet: Input data fixed cost 18,000 Units 1,000 variable cost per unit

Copy and paste, or type, the following into cells A1:D5 of an Excel spreadsheet:

Input data
fixed cost 18,000 Units 1,000
variable cost per unit 3.00 revenue =D2*B4
sell price per unit 6.5 expenses =B2+(B3*D2)
profit =D3-D4

Use Excel's Goal Seek to answer the following question. With a demand of 1,000 units, what is the sell price per unit that results in break even?

Enter only the numerical solution. Do not include a $ sign.

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

Chatgpt And Future Of Blockchain

Authors: Richard Thumser

1st Edition

979-8370852664

More Books

Students also viewed these Finance questions

Question

How do amplifiers differ from repeaters?

Answered: 1 week ago