Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel or show excel commands and give detailed solution. The following table contains pricedemand and total cost data for the production of regular

Please use excel or show excel commands and give detailed solution.

The following table contains pricedemand and total cost data for the production of regular sleeping blankets, where the wholesale price (in dollars) of a sleeping blankets is for an annual demand of sleeping blankets and is the total cost (in dollars) of producing sleeping blankets:

image text in transcribed

b. Find a linear best fit equation for the cost data, using as the independent variable. (Use Excel) a. Find a quadratic best fit equation for the pricedemand data, using as the independent variable. (Use Excel) (Hint: Express the price as a function of the demand )

c. By using the pricedemand equation found in part (a), and cost function found in part (b), find a best fit equation for profit function (), using as the independent variable. Then plot its graph using given values in the table. (Use Excel)

d. What is the maximum profit? How many sleeping blankets must be produced (demanded) to have the maximum profit? What is the wholesale price per regular sleeping blanket that should be charged to realize the maximum profit? Use the profit function, (), you obtained in part (c), and find the requested values algebraically.

e 1 X C[x] 135000 2250 3100 1850.00 72 195000 5 5150 000SZZ 6 5650 250000 7 6100 291520

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_2

Step: 3

blur-text-image_3

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

Hotel And Restaurant Accounting

Authors: Cole Raymond

8th Edition

0866125531, 9780866125536

More Books

Students also viewed these Accounting questions