Reference no: EM131367310
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.
|
Operations management goals of efficiency and effectiveness
: Explain the relationship between the operations management goals of “efficiency” and “effectiveness.” Discuss the Healthcare Supply Chain. What are the advantages and disadvantages of offshoring? How does offshoring differ from outsourcing? Can human..
|
|
Statements above with the results of poor customer service
: Part one: Describe THREE reasons why organizations should provide good customer service. Part two: Defend your statements above with the results of poor customer service. In your description, use a real example of a company that did not provide go..
|
|
Explain the equity theory of motivation
: Explain the equity theory of motivation. Describe the measures managers take to address the various equity issues.
|
|
Define what is meant by the term downsizing
: Define what is meant by the term downsizing, and explain its purpose. Identify and explain the matters that require careful consideration when executing a downsizing.
|
|
What will be the optimal profit contribution
: 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. Formulate a mathemati..
|
|
What is the hcup program
: HI300-3 :Access the provided website and find out if your state (New- York) participates in the HCUP program.If your state does participate in this program, who is the contact person? Give the name and contact information.What is the HCUP program?
|
|
Information system management
: In this writing assignment, you will explore how organizations use business process management (BPM). Write a one-page (250-word) paper explaining how organizations use business process management (BPM). Be sure to use at least one specific exampl..
|
|
Explanation of connections between privilege and religion
: An explanation of the connections between privilege and religion. Describe a situation in which members of a religion experience privilege. Describe a situation in which members of a religion experience religious oppression
|
|
Deduce the formulae of accumulative probability
: Outline the simplified supposition conditions of the optimal adjustment model for power output of generator units during reliability evaluation of electrical power systems.
|