Question: I need the excel portion completed anything else will be a downvote A company manufactures two products. If it charges price p for product i,
I need the excel portion completed anything else will be a downvote
A company manufactures two products. If it charges price p for product i, it can sell qe units of product i, where 91 80 - 2p + P2 and 2 100 - 3p2 + p. It costs $8 to produce a unit of product 1 and $15 to produce a unit of product 2. How many units of each product should the company produce, and what prices should it charge, to maximize its profit? B E F G H D 1 Producing and pricing two products 2 3 Demand for each product is of form a+b*p1+cp2, where 4 Product 1 Product 2 5a 80 100 6b -2 1 7c 1 -3 8 Range names used: Demand =Model!$B$15:$C$15 Prices =Model!$B$11:$C$11 Produced =Model!$B$13:$C$13 Profit =Model!$B$19 000 $8 $15 2 9 Unit cost 10 11 Prices 12 13 Production quantities 14 15 Demand 16 17 Total cost 18 Total revenue 19 Total profit 20 21 22 23 24 Question 1 Question 2 Question 3 Extra Credit

Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
