Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem. The following table contains pricedemand and total cost data for the production of regular sleeping blankets, where p the wholesale price (in dollarsl of

image text in transcribed

image text in transcribed
Problem. The following table contains pricedemand and total cost data for the production of regular sleeping blankets, where p the wholesale price (in dollarsl of a sleeping blankets is for an annual demand ofx sleeping blankets and C is the total cost (in dollars] of producing x sleeping blankets: A . a c 1 , n p cm 2 i 2250 100 135000 3 3100 55 155000 4 . 4750 72 195000 5 I 5150 51 225000 a 5550 as 250000 I 3 6100 41 251510 3) Find a quadratic best fit equation for the pricedemand data, using x as the independent variable. (Use Excel] b] Find a linear best fit equation for the cost data, using 3: as the independent variable. (Use Excen c] By using the quadratic pricedemand equation found in part {a}, and the linear cost function found in part (bl, nd a best fit equation for profit function P(x}, using x as the independent variable. Then plot its graph using given x 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 prot? Use the profit function, P(x), you constructed in part {c}, and find the requested values algebraically. 2] Verify your answer for the maximum profit and the number of sleeping blankets that leads to maximum profit you found in part (d) by using Excel Solver. (Hint: Apply "C: Steps to set up the problem in Excel\" and the following related steps given in \"Module 5-Excel Applications\") f) Find P'(3000) and P'C4UOO), and then interpret the result- Here, use the profit function, P(x), you constructed in part (cl, and find the requested values algebraically

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

The Structure Of Functions

Authors: Hans Triebel

1st Edition

3034805691, 9783034805698

More Books

Students also viewed these Mathematics questions

Question

distinguish between job costing and process costing; LO1

Answered: 1 week ago