Question: Please solve all the tasks. Objectives - To develop two-variable Linear Programming (LP) model. - To solve the LP model using the graphical method. -

Please solve all the tasks.
Objectives - To develop two-variable Linear Programming (LP) model. - To solve the LP model using the graphical method. - To solve the LP model using EXCEL solver. Background Ebara Co. produces two types of dog food - wet and dry. The production process includes mixing, inspection, and packaging. The company employs 8 workers in mixing, 3 in inspection and 7 in packaging. The factory works 8-hrs shift, 5 days a week. The following table provides the production time requirements and profit per product. The company has unlimited supply of all ingredients, except for meat and grain that are the only source of protein and carbohydrates in the mixture. Only 260kg of meat and 300kg of grain are available daily. The content of protein and carbohydrates in meat and grain are given in the table below. Wet food should have 20% protein and 55% carbohydrates and dry food should have 27% protein and 65% carbohydrates. Develop an LP model to determine the optimal weekly production for the companyStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
