Which constraints are binding

Assignment Help Operation Management

Reference no: EM131371336

A small shop sells only two models of motorcycles. Type A and Type B. The shop is limited to 100 of Type A and 150 of Type B. Dealer preparation requires 2 hours for a motorcycle of Type A and 3 hours for a motorcycle of Type B. Next quarter, the shop has 400 labor-hours available for this work and wants to know how many of each type should be ordered so that profit is maximized. The cost for Type A is $8,000 per motorcycle and $12,000 for Type B. The sales of a motorcycle will depend on the selling price, such that: PA = 0.009A2 – 8A+9000 PB = -7.5B+13200 Where A = quarterly sales of Type A PA = selling price of Type A B = quarterly sales of Type B PB = selling price of Type B a) Formulate a mathematical model to maximize profit. Clearly define your decision variables, constraints and objective b) Implement your model in Excel and utilize Solver to answer the following questions 1. How many of each motorcycle type should the shop optimally order? 2. What prices should the shop set for the two types? 3. What will be the optimal profit contribution? 4. Which constraints are binding? 5. How does the percentage of Type B motorcycles vary compared to the total as the number of labor hours available varies from 100 to 400 in steps of 50

Reference no: EM131371336

Questions Cloud

Using the van der waals equation : 1. What is the ratio of the average kinetic energy of SO2 molecule to that of an O2 molecule in a mixture of two gases? What is the ratio of the root mean square speeds, urms, of the two gases?

Develop histogram : Develop histogram. The function consumes a list of grades between 0 and 100; it produces a vector of size 101 where each slot contains the number of grades at that level.

Calculate the amount of copper : Calculate the amount of copper (in moles) in a 33.9-g pure copper sheet.

Approximate mass of a single piece of shot : Question: What is approximate mass of a single piece of shot, assuming all the pieces have same dimensions?

Which constraints are binding : A small shop sells only two models of motorcycles. Type A and Type B. The shop is limited to 100 of Type A and 150 of Type B. Dealer preparation requires 2 hours for a motorcycle of Type A and 3 hours for a motorcycle of Type B. Which constraints ar..

Research the various elements of the marketing plan : This week you will continue your comprehensive marketing plan researching the SAME company that you researched in previous units. Again, utilizing the Library, you will research the various elements of the marketing plan as it relates to this comp..

Develop a program that keeps track of feeding of zoo animals : Develop the function all-fed. It consumes a list of animals, as defined in exercise 41.2.8, and modifies them so that their field for morning feedings is switched to true.

Examine the re-measurement and translation process : Examine the re-measurement and translation process. Compare and contrast the international capital asset pricing model to the domestic capital asset pricing model.

Difference between soil porosity and permeability : 1. What is the difference between soil porosity and permeability? 2. What is cation exchange capacity and how does it relate to soil fertility?

User Account

All Pages