Question: Solve the following problems using Excel (QM can be used for graphs): 1. The Himalayan Patties Company makes beef patties and Argentinian empanadas in large
Solve the following problems using Excel (QM can be used for graphs): 1. The Himalayan Patties Company makes beef patties and Argentinian empanadas in large baking trays. The main ingredients are flour and ground beef. There are 25 pounds of flour and 16 pounds of ground beef available, and the demand for beef patties is 5. Five pounds of flour and 2 pounds of ground beef are required to make a pan of beef patties, and 5 pounds of flour and 4 pounds of ground beef are required to make a pan of Argentinian empanadas. A tray of beef patties has a profit of $1, and a tray of Argentinian empanadas has a profit of $5. Determine the number of trays of patties and empanadas to produce each day so that profit will be maximized. a. Formulate a linear programming model for this problem. b. Solve this model by using graphical analysis.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
