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

Subject:AccountingPrice:4.89 Bought3

Share With

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.

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