solution
Café A Company delivers fresh sandwiches each morning to vending
machines through the city. The company makes three kinds of
sandwiches: ham and cheese, tuna salad, and chicken salad. A ham
and cheese sandwich requires a worker 1 minute to assemble, a tuna
salad sandwich requires 0.5 minutes, and a chicken salad sandwich
requires 0.8 minutes to make. The company has 12 hours each night
for sandwich assembly. Vending machine capacity is available for
2,500 sandwiches each day. The costs for sandwiches are $20 for
each ham and cheese sandwich, $22 for each tuna salad sandwich and
$24 for each chicken salad sandwich. The selling price of each ham
and cheese sandwich, tuna salad sandwich and chicken salad sandwich
are $32, $43 and $39 respectively. The company knows from past
sales records that its customers buy as many ham and cheese
sandwiches as the other two sandwiches combined. Considering that
customers need a variety of sandwiches available, Café A stocks at
least 200 of each, and no more than 30% is tuna salad sandwiches.
Café A wants to know how many of each sandwich it should stock to
maximize profit.
- Formulate a linear programming model.
- Solve the model using Excel.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

