The production manager for the ice cold soft drink company


The production manager for the ICE COLD soft drink company is considering the production of 2 kinds of soft drinks: regular and diet. Two of the resources used are production time and syrup. To produce a regular case requires 4 minutes and 8 gallons of syrup, while a diet case needs 8 minutes and 6 gallons of syrup. The available production time is 450 minutes per day. The syrup is limited to 675 gallons per day. Profits for regular soft drink are $3.00 per case and profits for diet soft drink are $2.00 per case. Using EXCEL, find the optimal INTEGER mix of soft drinks that will maximize the company’s profit.

Steps please

Request for Solution File

Ask an Expert for Answer!!
Operation Management: The production manager for the ice cold soft drink company
Reference No:- TGS01136145

Expected delivery within 24 Hours