Question: PLease try to answer in QM for windows if possible. Thank you! Metro Food Services Company delivers fresh sandwiches each morning to vending machines throughout
PLease try to answer in QM for windows if possible. Thank you!
Metro Food Services Company delivers fresh sandwiches each morning to vending machines throughout the city. The company makes three kinds of sandwichesham and cheese, bologna, and chicken salad. A ham and cheese sandwich requires a worker minutes to assemble, a bologna sandwich requires minutes, and a chicken salad sandwich requires minutes to make. The company has available minutes each night for sandwich assembly. Vending machine capacity is available for sandwiches each day. The profit for a ham and cheese sandwich is $ the profit for a bologna sandwich is $ and the profit for a chicken salad sandwich is $ The company knows from past sales records that its customers buy as many ham and cheese sandwiches as the other two sandwiches combined, if not more so but customers need a variety of sandwiches available, so Metro stocks at least of each. Metro management wants to know how many of each sandwich it should stock to maximize profit.
Formulate a linear programming model for this problem.
Solve the linear programming model using Excel
If Metro Food Services could hire another worker and increase its available assembly time by minutes or increase its vending machine capacity by sandwiches, which should it do Why? How much additional profit would your decision result in
What would the effect be on the optimal solution if the requirement that at least sandwiches of each kind be stocked was eliminated? Compare the profit between the optimal solution and this solution. Which solution would you recommend?
What would the effect be on the optimal solution if the profit for a ham and cheese sandwich was increased to $ to $
Step 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
