Kim's Kitchen Supply wants to extend its business and makes oil supply contracts with fried chicken...

Transcribed Image Text:

Kim's Kitchen Supply wants to extend its business and makes oil supply contracts with fried chicken restaurants in Newark. Kim's premium oil bottle has 4 gallon of olive oil and 4 gallon of canola oil while regular oil bottle has 2/3 of olive oil and 1/3 of canola oil. The shop has 80 gallons of olive oil and 90 gallons of canola oil. Olive oil costs $24 per gallon and canola oil costs $12 per gallon. The Premium oil will sell for $35 per gallon and the Regular oil will sell for $24 per gallon. The firm estimates that no more than 100 bottles of each type can be sold. a. Define decision variables. Your definition must include unit size & time frame. b. Develop the Objective Function. (Hints: Profit = Revenue - Cost) You may calculate the profit per productor for both products together. c. Find the constraints. d. Use 'Excel Solver' and find the optimal solution. Kim's Kitchen Supply wants to extend its business and makes oil supply contracts with fried chicken restaurants in Newark. Kim's premium oil bottle has 4 gallon of olive oil and 4 gallon of canola oil while regular oil bottle has 2/3 of olive oil and 1/3 of canola oil. The shop has 80 gallons of olive oil and 90 gallons of canola oil. Olive oil costs $24 per gallon and canola oil costs $12 per gallon. The Premium oil will sell for $35 per gallon and the Regular oil will sell for $24 per gallon. The firm estimates that no more than 100 bottles of each type can be sold. a. Define decision variables. Your definition must include unit size & time frame. b. Develop the Objective Function. (Hints: Profit = Revenue - Cost) You may calculate the profit per productor for both products together. c. Find the constraints. d. Use 'Excel Solver' and find the optimal solution.