Question: please need help its urgent this problem, also use the template file Ch3 test problem cost benefit tradeoff.xlsx found on Canvas Test 1. For 1.

please need help its urgent this problem, also

please need help its urgent this problem, also

please need help its urgent this problem, also

please need help its urgent

this problem, also use the template file Ch3 test problem cost benefit tradeoff.xlsx found on Canvas Test 1. For 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). You will need to enter this data into cells B2, C2 and D2. Sandwich 1 Sandwich 2 $1.55 Sandwich 3 $1.75 $1.25 Profit per sandwich 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 Processing Time Processing Time 1.1 minutes sandwich 1 1.5 Sandwich Preparer 1 Sandwich Preparer 2 Question: Use Solver to find an optimal solution and report the total profit that is expected Report on the dollars and cents, and DO NOT use the "$" sign. The correct answer will correspond on the template spreadsheet provided cell G10. Round up or down to enter a WHOLE number. 1.5 minutes sandwich 2 1.1 minutes sandwich 3 1.6 2.0 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 $1.25 Per sandwich profit Sandwich Preparer 1 Sandwich Sandwich 2 $1.55 2. Each employee takes a different amount of time to make each sandwich type (table 2 below). Notice that Preparer 1 has discovered a better and faster way to prepare Sandwich type 3, and has reduced the time required to prepare that sandwich type - it is NOW 1.2 minutes (in red 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) 1.5 Processing Time Processing Time Processing Time Sandwich 1 Sandwich 2 Sandwich 3 1.1 Sandwich 3 $1.75 1.5 1.1 1.2 2.0 Preparer 2 Question: Use Solver to find an optimal solution and report the number of Sandwich 3 that should be made. You will need to change the prior value in cell D6. Then re-run Solver. If not a whole number then round up the number that is returned by Excel. The correct answer will correspond on the template spreadsheet provided cell D10. A Per sandwich profit Sandwich Preparer 1 Sandwich Preparer 2 How many to make? B Sandwich 1 $1.25 Processing Time Sandwich 1 1.1 1.5 Sandwich 1 0.0 Sandwich 2 $1.55 Processing Time Sandwich 2 1.5 1.1 Sandwich 2 0.0 D Sandwich 3 $1.75 Processing Time Sandwich 3 1.6 2 Sandwich 3 0.0 E Minutes Used 0 0 LL F

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!