Candy Kane Cosmetics (CKC) produces Leslie Perfume, which requires chemicals and labor. Two production processes are available. Process 1 transforms 0.3 units of labor and 0.4 unit of chemicals into an ounce of perfume. process two transforms 0.2 units of labor and 0.5 units of chemicals into an ounce of perfume. it costs CKC $12 to purchase a unit of labor and $10 to purchase a unit of chemicals. Each year up to 5.000 units of labor and 10.000 units of chemicals can be purchased. In the absence of advertising, CKC believes it can sell 15,000 ounces of perfume. to stimulate demand for Leslie, CKC can hire the beautiful model Jenny Nelson. Jenny is paid $400 per hour for up to 150 hours. each hour jenny works for the company is estimated to increase the demand for Leslie Perfume by 50 ounces. Each ounce of Leslie perfume sells for $50. Determine how CKC can maximize its profit.

Utilizing an excel Linear Programming Mode be sure to include:

1. Three Constraints:

"Inputs used <= Inputs Available" (i.e., Labor and Chemical).

"Jenny hours <= Max_Jenny hours"

"perfume produced <= total demand"

2. Two Changing Variable cells

"level of processes to use (process1 and process2)"

"Jenny's hour"