(Solved): Objectives - To develop two-variable Linear Programming (LP) model. - To solve the LP model ...

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 $$260\mathrm{kg}$$ of meat and $$300\mathrm{kg}$$ 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 company. 1. Read the problem carefully and identify the decision variables. 2. Write the objective function for the quantity to be optimized. 3. Identify the constraints that the problem must satisfy, show your steps, and provide the complete LP model. 4. Solve the problem with graphical method, show your steps and interpret the solution. 5. Solve the problem with EXCEL Solver, show your steps with screenshots and interpret the solution. Please provide the screenshots of Excel. DO NOT submit the Excel file. 6. Determine the unused amount of meat and grain. 7. If the company had to lay-off one worker without disrupting the current optimal production rate, from which department/s would you suggest to lay-off the worker? Explain your answer.