Question: Triangle Food Services Company (TFSC) delivers fresh sandwiches each morning to restaurants throughout Raleigh. The company makes three kinds of sandwiches- ham and cheese, bologna, and chicken salad. A ham and cheese sandwich requires a worker 0.4 minutes to assemble, a bologna sandwich requires 0.6 minutes, and a chicken salad sandwich requires 0.5 minutes to make. The company has 960 available minutes (16 hours) each night for sandwich assembly. The profit for a ham and cheese sandwich is $0.3, the profit for a bologna sandwich is $0.5, and the profit for a chicken salad sandwich is $0.4. To ensure that a variety of sandwiches are available, the company produces at least 200 sandwiches of each kind. Further, the restaurants demand as many or more of the ham and cheese sandwiches than the other two sandwiches combined. The restaurants need a total of at least 1,500 sandwiches per day, and TSFC is able to sell all sandwiches to the restaurants. TFSC wants to know how many of each sandwich it should produce each day to maximize its profit.

a. Formulate a linear programming model to maximize Triangle Food Services Company’s daily profit. [13%]

b. Solve the model using Excel Solver. [5%]