For this problem, also use the template file Ch3 test problem cost benefit tradeoff.xlsx found on Canvas Test 1.

1. Jose owns three bodegas in Philadelphia, where he makes three different types of his own bodega sandwiches. He has two employees preparing all the bodega sandwiches, each of which yields a different profit per sandwich. (table 1 below). These employees must make the sandwiches in the early morning hours from 4-6am, so there are only two hours available.

(Table 1; profit per sandwich type).

	Sandwich 1	Sandwich 2	Sandwich 3
Profit per sandwich	$1.25	$1.55	$1.75

2. Each employee takes a different amount of time to make each sandwich type (table 2 below). Jose wants to maximize his profit and has to decide, how many of each sandwich should be made?

(Table 2; processing time, minutes per sandwich)

	Processing Time minutes sandwich 1	Processing Time minutes sandwich 2	Processing Time minutes sandwich 3
Sandwich Preparer 1	1.1	1.5	1.6
Sandwich Preparer 2	1.5	1.1	2.0

Question: Use Solver to find an optimal solution and report the total profit that is expected in dollars and cents, but DO NOT use the "$" sign.

Numeric Response

Numeric Response