Question

Jessica’s Catering Service bakes and delivers lasagnas to parties and group meetings. In a typical week, Jessica has around 40 orders. Each order involves a specific amount of the required lasagna in pounds. A small group would need about 20 pounds, whereas a large group would need almost triple that amount. The following table shows the different customer orders that have come in this week, grouped into eight categories by weight.

Job type	1	2	3	4	5	6	7	8
Weight (pounds)	20	25	30	35	40	45	50	55
Number	10	5	4	7	3	9	2	1

15 points: Jessica has an inventory of 100 six-pound trays and 80 ten-pound trays. Although she appears to have enough capacity in her trays, she would like to plan her orders so that the amount of excess lasagna is kept to a minimum.

5 points: How many six-pound trays and ten-pound trays should Jessica use for each of the orders?

**solve it using solver in excel

Answer 1

****Please please please LIKE THIS ANSWER, so that I can get a small benefit, Please****

Jessica has an inventory of 100 six-pound trays and 80 ten-pound trays. Although she appears to have enough capacity in her trays, she would like to plan her orders so that the amount of excess lasagna is kept to a minimum.

Formulae:

How many six-pound trays and ten-pound trays should Jessica use for each of the orders?