Reference no: EM131372996
A motorcycle shop sells two models of motorcycles: Type A and Type B. The shop is limited by a quota of 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 $8000 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
c) Formulate a mathematical model to maximize profit. Clearly define your decision variables, constraints and objective
d) Implement your model in Excel and utilize Solver to answer the following questions (include organized snapshots of your Excel answers in the report):
How many of each motorcycle type should the shop optimally order? · ·
What prices should the shop set for the two types?
What will be the optimal profit contribution?
Which constraints are binding?
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.
Pipeline encounters political resistance
: The XL pipeline encounters political resistance, and is forced to shut down for one month.Would this affect your profits more if the outage occurred in the winter, when demand tends to be fairly low, or in the summer when demand is higher?
|
Compute bresenhamsline drawing algorithm
: COIS 4480H Assignment - Write a program to properly compute Bresenham'sline drawing algorithm for a 3D line projected onto any of the 4 possible parts of a grid. Format for this question - Write a program in any language of your choosing that will..
|
Rationales for women empowerment
: In the state of Georgia. what are the rationales for women empowerment in terms of development impact? For example, according to the World Bank there is a positive effect of reduction in the gender gap in education on economic growth, immunization..
|
Consider the statement with the global economy
: Consider the statement, "With the global economy, people around the world are becoming more and more alike, so why be concerned about diversity? Do you agree? Should organizations conduct diversity training?
|
Formulate mathematical model to maximize profit
: A motorcycle shop sells two models of motorcycles: Type A and Type B. The shop is limited by a quota of 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 ..
|
Explain the four components of the earth-sun relationship
: ECET 402- Briefly identify and explain the four components of the Earth-sun relationship that gives us seasons, or in other words, the changing distribution of insolation throughout the year (in three to four paragraphs).
|
Knowledge of the price elasticity of demand
: Based on your knowledge of the price elasticity of demand, do you think the deadweight loss of a soda/junk-food tax would be relatively large or relatively small? Why? Do you think taxing junk food would be a good idea? Based on your analysis, wou..
|
Write a short essay on the linguistic relativity
: Do you think Whorf is, broadly, right about the relationship between language and thought? Give one example or piece of evidence that supports your position or seemed most clear or convincing to you? The example can come from Whorf, Lakoff& Johnso..
|
Kind of disequilibrium situation results
: (a) What is the equilibrium price? $ (b) If a minimum price (price floor) of $8 is set, (i) What kind of disequilibrium situation results? (Click to select) shortage surplus
|