Copy and paste, or type, the following into cells A1 D5 of an Excel spreadsheet Input data fixed cost 17,500 Units 1,050 variable cost per unit 7 35 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 Assuming that demand is fixed at 1,050 units, what is the sell price per unit that results in break even Enter only the numerical solution Do not include a $ sign Your Answer

The Answer is in the image, click to view ...

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

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

Input data
fixed cost	17,500	Units	1,050
variable cost per unit	7.35	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. Assuming that demand is fixed at 1,050 units, what is the sell price per unit that results in break even?

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

Your Answer:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please complete the following exercises from the end of Chapter 4 (page 110-114) where E = Exercise, P = Problem, and C = Case: E 34 E 42 P 50 Problem 50 requirement C states: ?Using the data shown...

Hope you are well. I have an assignment that has a time limit of 4 hours with 23 questions. Nonetheless, these questions are not long and hard, all I need is direct answer. It?s due tonight, so there...

Please provide a solution for each item 30-60. 30. The following information relates to the break-even point at Pezzo Corporation: $120,000 Total fixed expenses......... $30,000 If Pezzo wants to...

Hello I've attached an Excel file (NZ1832) and I got these questions wrong: 6.01, 6.02, 6.03, 6.04, 9.01, 9.04, 9.05, 9.06, 9.09, 9.12, 9.13, 10.01, 10.03, 10.04, 10.05, 10.07, 13.01, 15.01, 15.02,...

Attached is a project I'm working on and I'm stuck at a crucial point. I need help figuring out what the Planned sales, Desired ending inventory of finished goods as well as the Beginning inventory...

I need help solving my accounting project. i did 4-7 workbook which i have attached below. but 7-10 are incorrect. could someone help me correct from 7-10 quickly please. MI5965 I SEE THE LIGHT...

Hello, I am doing my project and I am stuck on number 4.08 which is the following Fixed Administrative expenses are expected to increase by $4,000. The total administrative expenses for 20x0 were...

Hello I've attached an Excel file and I got these questions wrong: 6.01, 6.02, 6.03, 6.04, 9.01, 9.04, 9.05, 9.06, 9.09, 9.12, 9.13, 10.01, 10.03, 10.04, 10.05, 10.07, 13.01, 15.01, 15.02, and 17.03...

Hi! I need help with my assignment, where I have to do tabs 7,8,9,10,11,& 22. I've solved most of it but there are a few mistakes and I hit a dead end in tab 11 Mistakes are on: Q10.06, 10.07, 11.03,...

3x1 - x2 + x3 = 4 - x1 + 7x2 - 2x3 = 1 2x1 + 6x2 - x3 = 5 Solve by Cramer's rule, where it applies.

Calculate the work done (kJ) when 100g of Cu reacts completely with excess HCI at 800 mmHg in an open beaker at 45 C. Indicate if your answer is -ve or +ve and to two decimal places.

14. LO.3 Use the following chart to indicate whether each of the indicated items is included in distributable net income (DNI) Fiduciary Entity Item Included in DNI? Taxable interest income...

Fill in the table below with the activity times after crashing to show the resulting schedule. (Enter your responses as whole numbers.) The cost of shortening of project is (Enter your response as a...

Should civil service employees be allowed to unionize? Why?

Is testing the best way to identify the best candidate for a job? Why or why not?

Describe the principal hazards in espousing a policy of development from within an organization while aggressively recruiting from the outside.