A small shop sells only two models of motorcycles type a, Ask an Expert

Management Studies

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.

View complete question

Operation Management, Management Studies

Category:- Operation Management
Reference No.:- M92177161

Have any Question?Write your Review or question?

Related Questions in Operation Management

You are the buyer for your university bookstore one of the

You are the buyer for your university bookstore. One of the textbooks has a cost to you of $205 and you sell it to students for $410. In this case, however, you cannot salvage any value from copies that do not sell becau ...

1 in a paragraph using your own words describe what a

1. In a paragraph using your own words, describe what a quality culture is and how you will know when one exists in an organization? 2. Discuss the value of social data for marketers. 3. Name two attributes of a democrat ...

1 evaluate twitter and instagram as tools for branding a

1. Evaluate Twitter and Instagram as tools for branding a not for profit charity organisation. With reference to marketing/branding theory, what are the positives and negatives of their use in this case? (International s ...

Question 1 prepare an individual report demonstrating that

Question : 1. Prepare an individual report demonstrating that you a) understand the key ideas presented in the assigned and recommended readings for Week 1 and b) can analyze critically the extent to which they are appli ...

When installing new technology the result often is a

When installing new technology, the result often is a reduction in staff or the reassignment of staff. What responsibility (if any) does the company have for displaced workers? Does the company have an obligation to retr ...

1 pick one amendment from the bill of rights and explain

1. Pick one amendment from the Bill of Rights and explain the historical context and importance of this amendment. Then, explain how this amendment is still relevant today. How has this transformed over time? 2. Describe ...

1 attitudes are evaluative statementsmdashfavorable or

1. Attitudes are evaluative statements—favorable or unfavorable—concerning objects, people, or events. They reflect how an individual feels about something. When a person says, “I like my job,” he or she is expressing an ...

1 if pricelinecom increases its advertising expenses by 30

1. If Priceline.com increases its advertising expenses by 30 percent while keeping its price and variable costs the same, does that mean the company’s breakeven point will increase 30 percent? Show this calculation for a ...

1 evaluate the performance of the ceo of kroger from the

1. Evaluate the performance of the CEO of Kroger from the perspective of (a) stockholders, (b) employees, (c) customers and (d) suppliers. what does this evaluation tell you about the ability of the CEO and the prioritie ...

1 aim stores a national retailer does not permit its

1. Aim Stores, a national retailer, does not permit its employees to wear hats, caps, scarves, hoodies, or anything else on their heads. Aaleyah, a Muslim who wears a traditional hijab, scored very well on interviews but ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Operation Management Expert