Generate the range sensitivity analysis

Assignment Help Operation Management

Reference no: EM132871471

Comfort Plus Inc. (CPI) manufactures a standard dining chair used in restaurants. The demand forecasts for quarter 1 (January - March) and quarter 2 (April - June) are 3700 and 4200 chairs, respectively. CPI has a policy of satisfying demand in the quarter in which it occurs.

The chair contains an upholstered seat that can be produced by CPI or purchased from DAP, a subcontractor. DAP currently charges $12.50 per seat, but has announced a new price of $13.75 effective April 1. CPI can produced 3800 seats per quarter at a cost of $10.25 per seat.

Seats that are produced or purchased in quarter 1 and used to satisfy demand in quarter 2 cost CPI $1.50 each to hold in inventory, but the maximum inventory cannot exceed 300 seats.

Formulate a linear program to help minimize cost while satisfying demand. Solve the LP using Solver or LINDO and generate the range sensitivity analysis as part of the output.

Reference no: EM132871471

Questions Cloud

Explain introduction of interest-based bargaining : Why might an employer be opposed to the introduction of interest-based bargaining?

Delivery of the prototype from the vendor : One of the risks you anticipated for the project was the late delivery of the prototype from the vendor.

What are the helmet laws in new york : What are the helmet laws in New York? Are these laws to attempt to legislate ethics? Why or why not? And should governments legislate ethics?

Resources that might be required in hospitality operation : What are some of the resources that might be required in a hospitality operation? List different resources that might be allocated via budget.

Generate the range sensitivity analysis : Formulate a linear program to help minimize cost while satisfying demand. Solve the LP using Solver or LINDO and generate the range sensitivity analysis

Understanding of human capital change : How should HRs understanding of human capital change or enhance HR strategy

Assume project sponsor within major corporation : Assume the project sponsor within a major corporation has championed a project for the past year, and the concept was finally approved.

Establishing an effective working relationship : Explain how you might be able to go about establishing an effective working relationship with human resources in the prevailing environment.

Single most important lesson any entrepreneur : Discuss the single most important lesson any entrepreneur should apply in order to be successful. Explain your rationale.

User Account

All Pages