Question: solve the model in excel The production manager for the Coory soft drink company is considering the production of two kinds of soft Arinks regular

solve the model in excel
The production manager for the Coory soft drink company is considering the production of two kinds of soft Arinks regular (R) and diet (D). Two of her limited resources are productim time (8 hours =490 minutes per day) and syrup (1 of the ingredierits). imited to 675 galloes per day. To preduce a regular case requires 2 mimutos and 5 gallans of syrup, while a diet case needs 4 minutes and 3 gallons of syrup. Profits for regular soft drink are $300 per case and protits for diet soft drink are $2.00 per case-
The manager wants to know how many cases of each type of soft drink to produce in order to maximize profits.
 solve the model in excel The production manager for the Coory

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!