Reference no: EM133134018

Yummy Creamy is a New York based company that manufactures and distributes ice-cream across tri-state area. The product line includes 2 main flavors - Purple Delight (PD) and Choco-Chips (CC). On selling 1 unit of each flavor, profit earned is:

Flavor	Profit per Unit ($)
Purple Delight (PD)	$5.00
Choco-Chips (CC)	$5.30

Given the fact that Yummy Creamy is a newly introduced establishing brand in the area and the nature of the product, they want to limit the stock in the market maximum to: PD - 250 and CC - 400

Ingredients required to manufacture each unit of the ice cream is as follows:

Flavor	Milk	Sugar	Cream
PD	0.1	0.05	0.03
CC	0.3	.1	0.02

Total available resources are:

Ingredients	Availability
Milk	150
Sugar	130
Cream	15

Yummy Creamy needs to determine how many units of each flavor to manufacture to maximize its weekly profit.

Submit your response in form of MS Excel file ONLY.