Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A manufacturing company produces four types of products: Product A , Product B , Product C , and Product D . Each product contributes differently

A manufacturing company produces four types of products: Product A, Product B, Product C, and Product D. Each product contributes differently to the company's profit margin. However, the production process for each product requires labor and materials, both of which are limited resources for the company.The company has a total of 600 hours of labor available and 700 units of material available for production. Here are the details of each product:Product A: Profit $15 per unit, labor requirement 2 hours per unit, material requirement 3 units per unit.Product B: Profit $20 per unit, labor requirement 3 hours per unit, material requirement 2 units per unit. However, due to market demand, the company can sell at most 200 units of Product B.Product C: Profit $25 per unit, labor requirement 4 hours per unit, material requirement 3 units per unit. However, due to market demand, the company must make at least 10 units of Product C.Product D: Profit $30 per unit, labor requirement 5 hours per unit, material requirement 2 units per unit. However, due to market demand, the company must make at least 15 units of Product D.a)Formulate this production planning problem as a linear programming Model. In the report, you must clearly identify and mention the decision varaibles, objective function and objective function coeffients in the formulated LP Model.b)Solve the model with Solver.c)Conduct sensitivity analysis for this problem
I want the LP model using excel MS
and part c is important too

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of strategic management

Authors: Charles w. l. hill, Gareth r. Jones

3rd Edition

1111525196, 978-1111525194

More Books

Students also viewed these General Management questions