Question

In: Statistics and Probability

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

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

Input data
fixed cost	16,000	Units	1,050
variable cost per unit	4.75	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

Expert Solution

Thank you for providing the data in this format! Very considerate!

The answer is:

sell price per unit

19.988

The data in excel(Actual)

The data in excel(Formulas)

Go to DATA - WHAT IF ANALYSIS - Goal Seek

The input for goal seek:

The output for goal seek:

Let me know in the comments if anything is not clear. I will reply ASAP! Please do upvote if satisfied!

orchestra answered 11 months ago

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50...

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50 4513 $195.30 4655 $191.10 4696 $182.70 4949 $172.20 5142 $163.80 5313 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What...

2. Copy and paste the following data into Excel: P Q $140.25 5375 $137.45 5616 $136.05...

2. Copy and paste the following data into Excel: P Q $140.25 5375 $137.45 5616 $136.05 5641 $133.25 5744 $130.45 5806 $123.44 6055 $122.04 6368 $119.24 6382 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What...

Copy and paste the following data into Excel: P Q $140.25 5375 $137.45 5616 $136.05 5641...

Copy and paste the following data into Excel: P Q $140.25 5375 $137.45 5616 $136.05 5641 $133.25 5744 $130.45 5806 $123.44 6055 $122.04 6368 $119.24 6382 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is...

2. Copy and paste the following data into Excel: P Q $15.25 125 $14.79 133 $14.33...

2. Copy and paste the following data into Excel: P Q $15.25 125 $14.79 133 $14.33 140 $13.57 141 $12.96 147 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is the point price elasticity of...

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50 4513...

Copy and paste the following data into Excel: P Q $210.00 4280 $201.60 4335 $199.50 4513 $195.30 4655 $191.10 4696 $182.70 4949 $172.20 5142 $163.80 5313 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is...

Copy and paste the following data into Excel: P Q $87.50 370 $82.25 399 $81.38 410...

Copy and paste the following data into Excel: P Q $87.50 370 $82.25 399 $81.38 410 $76.13 438 $70.88 444 a. Run OLS to determine the demand function as P = f(Q); how much confidence do you have in this estimated equation? Use algebra to invert the demand function to Q = f(P). b. Using calculus to determine dQ/dP, construct a column which calculates the point-price elasticity for each (P,Q) combination. c. What is the point price elasticity of demand...

Please use excel and colored cells for input data and a different colored cell for the...

Please use excel and colored cells for input data and a different colored cell for the answer. No hidden numbers in the formulas! If a number is used, it should be visible if we print out the spreadsheet. Put each answer in a sheet labeled with the problem number, like “Problem 1” Suppose natural gas experiences a 1.8% increase per year in real terms over the foreseeable future. The cost of 1,000 cubic feet of natural gas is now $7.50....

The following data are related to Copy, Paste, and Attach (CPA) Corp’s Ending Inventory (Inventory is...

The following data are related to Copy, Paste, and Attach (CPA) Corp’s Ending Inventory (Inventory is valued as of December 31 of each year provided, which is CPA Corp’s year-end): Year Price Index Inventory at End-of-Year Prices 2015 100 $159196 2016 125 $263594 2017 150 $304976 Using the dollar-value LIFO method, what is the value of CPA Corp’s ending inventory on December 31, 2017?

This for my Managerial Accounting Course kindly Type in order for me to Copy and Paste...

This for my Managerial Accounting Course kindly Type in order for me to Copy and Paste 1 McGloire Construction is analyzing its capital expenditure proposals for the purchase of equipment in the coming year. The capital budget is limited to $5,000,000 for the year. Lori Alleyne, staff analyst at McGloire’s, is preparing an analysis of the three projects under consideration by Joyanne McGloire, the company’s owner. A B C D 01 Project A Project B Project C 02 Projected Cash...

Type or paste question here Fill in the empty cells and the values required in the...

Type or paste question here Fill in the empty cells and the values required in the last row of the table. These values will help you answer subsequent questions and calculate the Pearson’s r and the linear regression equation. (2 decimals) X Y ()( 3 3 -2.00 -4.00 4.00 16.00 8.00 6 9 1.00 2.00 1.00 4.00 2.00 5 8 0.00 1.00 0.00 1.00 0.00 4 3 -1.00 -4.00 1.00 16.00 4.00 7 10 2.00 3.00 4.00 9.00 6.00 5...