Explain linear programming model for bicycle manufacturer

Assignment Help Marketing Management

Reference no: EM1334601

Explain Linear programming model for bicycle manufacturer

A bicycle manufacturer is determining its production schedule for the next 6 months. Assume that it costs this company $150 to manufacture each bicycle. At the end of each month, a holding cost of $35 per bicycle left in inventory is incurred. No more than 40 bicycles can be stored in inventory at any point in time. Monthly demands for bicycles are projected to be as follows: 150 in month 1; 175 in month 2; 165 in month 3; 156 in month 4; 169 in month 5; and 178 in month 6. Assume that at the beginning of month 1, 10 completed bicycles are in inventory. Finally, this company can produce up to 170 bicycles per month. Formulate and solve a linear programming model to find a cost-minimizing production schedule that meets all demands on time.

Answer the following questions-

1) Write down the decision variables.

2) Write down the optimization statement for the objective function.

3) Write down the constaints.

4) With Excel Solver, what is the optimal production schedule? (Please hand in a printed copy of the report)

5) By Excel Solver, what is the sensitivity report? (Please hand in a printed copy of the report)

Reference no: EM1334601

Questions Cloud

Develop a case analysis : Developing a Case Study Instructions of approximately 1000 words." While answering the specific questions below, please develop a case analysis.

Different patterns of futures price quotes : Compare and discuss the different patterns of futures price quotes amongst the selected commodities using some specific examples?

High priority on paid time off : Why do employees today place such a high priority on paid time off and Do you feel that companies are fair in their offerings for vacation/personl/sick time? Why or why not?

Illustrate what economic policy should be adopted : Illustrate what economic policy should be adopted by regions with persistent economic problems.

Explain linear programming model for bicycle manufacturer : Explain Linear programming model for bicycle manufacturer and Write down the optimization statement for the objective function

About rule 1.6 : What does Rule 1.6 prohibit or require, exactly?

Structural consideration strategy to realize growth : Evaluate alternatives your organization must consider to realize growth. Recommend a single strategy that the organization might implement. Explain key success factors for monitoring strategy implementation.

Problem formulation and identification styles : Compare and constrast problem formulation and identification styles - How can I investigate and observe the decision making processes in a telecom vendor such as Motorola and Cisco?

My scenario is where i am going to open restaurants in china : My scenario is where I am going to open restaurants in China. One in Shanghai & one Beijing.

User Account

All Pages