What will be the optimal profit contribution

Assignment Help Operation Management
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.

Reference no: EM131367310

Questions Cloud

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.

Reviews

Write a Review

Operation Management Questions & Answers

  Strengths of various organizational structures

Compare and contrast the strengths of the various organizational structures and explain which organizational structure you would work best in and why. Which organizational structure would be difficult for you to work in? Do you have a work experience..

  Company business model and company strategy

Explain the difference between a company's business model and a company's strategy. What is the connection between a company's strategy and its quest for sustainable competitive advantage? List five things to look for in identifying the components of..

  What are organizations longterm objectives

What are organizations longterm objectives. What are the best strategies to achieve those objectives. What are organizations shorterm objectives.

  The local office of tourism sells souvenir calendars

The local Office of Tourism sells souvenir calendars. The head of the office, Lucy, needs to order these calendars in advance of the main tourist season. Based on past seasons, Lucy has determined the probability of selling different quantities of th..

  Which one of the 5 generic competitive strategies

Which one of the 5 generic competitive strategies is most likely to be best suited for an industry whose product is a commodity? Explain.

  Operate small wooden toy company making two products

You operate a small wooden toy company making two products: alphabet blocks and wooden trucks. Your profit is $30 per box of blocks and $ 40 per box of trucks. Producing a box of blocks requires one hour of woodworking and two hours of painting; prod..

  Which organization structure of five types is most suitable

Before one can begin writing a charter, one must consider the most appropriate organization for the project. You are the project manager for an organization that builds doors and windows for homes. Which organization structure of the five types is mo..

  Obtain increased embeddedness amomgst mangement

In what ways can you crowdsource your strategy and feel included in the workplace without being disrespectful to your position and your management and obtain increased embeddedness amomgst mangement at the same time.

  Case study on coleen colombo

The case study (Coleen Colombo and Colleagues Resist Mortgage Fraud) will include a Synopsis and three Findings of Fact. Each Finding of Fact will require a justified recommended solution. Students should support their recommended solutions with ra..

  Define the term categorical imperative

Define the term categorical imperative and give at least three examples of categorical imperatives that you believe in. Why is it important for you and others to adhere to those categorical imperatives you listed?

  How many chips can intel make with five machines

A machine at Intel can produce 120 chips per hour and runs 16 hours per day, six days per week. How many chips can Intel make with five machines running at maximum capacity for a year?

  Considering the purchase of two alternative cars

A student is considering the purchase of two alternative cars. Car A initial costs $1,500 more than Car B, but uses 0.05 gallons per mile, versus 0.07 gallons per mile for Car B

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd