Reference no: EM132596582

You are a start-up caterer that delivers food directly to customers in a neighborhood where there are a lot of businesses.

You have limited variation at this stage and you can offer four kinds of food: Kebab, Iskender, Beyti, and Baklava. Each meal needs to through the following steps: Cooking, Packaging, and Delivery. You hired 4 workers, and have 32 man-hours in a day for these 3 tasks. Total available time (man-hours) for cooking is 16 hrs., for packaging is 8 hrs., and for delivery is 8 hrs. in a day.

Kebab: 10 portions of Kebab require 1 hour of time for cooking, packaging is done at the rate of 30 portions per hour, and delivery at the rate of 40 per hour; Ingredients including labor for 1 portion cost $2, and each packaged portion can be sold for $12.

Iskender: 5 portions of Iskender require 1 hour 20 minutes for cooking, packaging is done at the rate of 20 portions of Iskender in 1 hour, and 30 portions can be delivered in 1 hour; Ingredients including labor for 1 portion cost $5, and it can be sold for $20.

Beyti: 6 portions of Beyti require 1 hour for cooking, packaging is done at the rate of 20 per hour, and 24 portions can be delivered in 1 hour; Ingredients including labor for 1 portion cost $6, and it can be sold for $15.

Baklava: 20 portions of baklava require 3 hours for cooking, packaging is done at the rate of 40 portions in 1 hour, and 60 portions can be delivered in 1 hour; Ingredients including labor for 1 portion cost $1, and it can be sold for $5.

You believe you do not have a problem on the demand side due to survey you did in neighborhood. Customers expressed interest in having the following products delivered every day: 30 kebab meals, 20 Iskender meals, and 20 Beyti meals, and 10 baklava portions. They need to meet or exceed this minimum demand at this stage.

Question 1: Use Excel Solver to find the number of dishes from each type to maximize your profit.