The demand for ice cream during the summer months(June, July, and August) at a parlor is estimated at 500, 600, and 400 20-gallon cartons. Two wholesalers, 1 and 2, supply the parlor with its ice cream. Although the flavors from the two suppliers are different, they are interchangeable. The maximum number of cartons either supplier can provide is 400 per month. Also, the price the two suppliers charge change from one month to the next according to the following schedule: Price per carton: June, July, August 

Supplier 1: $100, $110, $120 

Supplier 2: $115, $108, $125 

to take advantage of price fluctuation, the parlor can purchase more than is needed for a month and store the surplus to satisfy the demand in a later month. The cost of refrigerating an ice-cream carton is $5 per month. It is realistic to assume that the refrigeration cost is a function of the average number of cartons on hand during the month.

Solve this on excel? 

  

Transcribed Image Text:

A C D E F G H I J K M 1 Multiple Period Production-Inventory Model 2 Input Data 3 х1 x2 x3 y1 y2 y3 i1 12 13 4 Totals Limits 5 Objective 6 C1 100 110 120 115 108 125 5 5 0.00 1 1 -1 0.00 400 %3D 7 C2 1 1 1 -1 0.00 600 8 C3 1 1 1 -1 0.00 400 %3D 9. >=0 >=0 >=0 >=0 >=0 >=0 >=0 >=0 >=0 10 Output results: 11 х1 x2 x3 y1 y2 y3 i1 12 13 12 Solution 0.00 13 A C D E F G H I J K M 1 Multiple Period Production-Inventory Model 2 Input Data 3 х1 x2 x3 y1 y2 y3 i1 12 13 4 Totals Limits 5 Objective 6 C1 100 110 120 115 108 125 5 5 0.00 1 1 -1 0.00 400 %3D 7 C2 1 1 1 -1 0.00 600 8 C3 1 1 1 -1 0.00 400 %3D 9. >=0 >=0 >=0 >=0 >=0 >=0 >=0 >=0 >=0 10 Output results: 11 х1 x2 x3 y1 y2 y3 i1 12 13 12 Solution 0.00 13

Answer rating: 100% (QA)

Below are the variables being explained X1 supplier p... View the full answer