Question: please solve this on the excel. thank you! Solve the following optimal product pricing problem. (Attach your Excel solver solution in a separate file.) A

please solve this on the excel. thank you!

Solve the following optimal product pricing problem. (Attach your Excel solver solution in a separate file.) A bike manufacturer makes 2 types of bikes - premium and regular. A premium bike costs $225 to manufacture, and a regular bike costs $200 per unit to manufacture. Demand for premium bikes is given by demand =20,00010 price, and demand for regular bikes is characterized by demand =4000030 price. Answer the following: a. Suppose there are no capacity constraints. What price should be charged for premium bikes? Price for regular bikes? What is the total profit? b. Now suppose the manufacturer has a capacity constraint of 15,000 bikes (i.e, only a total of 15,000 can be made). Determine the total profit. c. Suppose that in addition to the capacity constraint of 15,000 bikes, it was found that retailers insist on at least two premium bikes for each regular bike. Determine the product mix and the total profits

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 General Management Questions!

Figure 20.30 shows the B-versus-H curve for a steel alloy. (a) What is the saturation flux density? (b) What is the saturation magnetization? (c) What is the remanence? (d) What is the coercivity?...

Solve the following optimal product pricing problem. (Attach your Excel solver solution in a separate file.) A bike manufacturer makes 2 types of bikes premium and regular. A premium bike costs $225...

*Please solve this problem in EXCEL and also use EXCEL SOLVER* Thank you! :) For each Linear Programming question, you must submit the following. 1) What are the decisions to be made? 2) What is the...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

MAT540 Homework Week 6 Page 1 of 2 MAT540 Week 6 Homework Chapter 2 1. A Cereal Company makes a cereal from several ingredients. Two of the ingredients, oats and rice, provide vitamins A and B. The...

HEY CAN ANYONE SOLVE ME THIS QUESTIONS IN THE WORD. THANK YOU. (NOTE: There is an Excel Spreadsheet available for these problems but for the ones asking for "Standard Form" hardcopy/manual layout and...

Is there a way you can do the work on solver and then send it as an attachment? Or Excel? Thank you! Update: Ok that's fine. Could you possibly do the work that requires solver and then send those as...

Thank you so much in advance. I have trouble with these questions. Exercise 2-13: Solve the following LP problem by using the graphical procedure and by using excel: For all problems use Excel Solver...

I am looking for the solution or guidance with the following case study. The case study has been asked about by other students but I cannot find the solution. can you direct me to it or provide some...

You are to use the information in problem 15 at the end of Chapter 4 in your textbook. You will be very familiar with this problem from the PowerPoint file blend. Please follow these directions like...

CASE its lose in ROSE TREE REGIONAL AIRLINE or ad- ying Decision Support Using Microsoft Excel Solver PREVIEW onse Tree Regional Airline provides passenger transportation services and small-parcel...

Q3) If P(2,-2,1) Q (3, -1,2) and R( 3,-1,1) a) find the area of the triangle determined by the P,Q, R Pointr P, Q, b) find the unit vector Per pendicalar to plane PQR

The term virus is derived from Latin which means poison A virus is a tiny infectious agent that reproduces inside the cells of living hosts When infected, the host cell rapidly reproduce thousands of...

5 Nanptec Manutacturing reports net income of \ 8 6 0 0 0 0 Depricintion Expemse is $ 6 7 , 0 0 0 Accourts Recelvable increased $ 3 3 , 0 0 0 and Accounts Peysble decreased $ 2 6 . 0 0 0 Requared...

Premise: Using a dictionary and list, create a set of key / value pairs that consists of a musical database. The key / value pairs should consist of Artist Name: Song Names pattern. For example, EACH...