linear programming., Operation Research

Assignment Help:
The demand of ice cream during the three summer months (June, July, and August) at All-Flavors Parlor is estimated at 500,600, and 400 20-gallon cartons, respectively. Two wholesalers, 1 and 2, supply All-Flavors 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:

Q2_table.PNG

To take advantage of price fluctuation, All-Flavors 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 in the present situation to assume that the refrigeration cost is a function of the average number of cartons on hand during the month. Develop a model to determine the optimum schedule for buying ice cream from the two suppliers. Solve the LP using Excel solver and attach your answer report.

Related Discussions:- linear programming.

Scope and concept, Explian scope and concept of Operations research?

Explian scope and concept of Operations research?

Mathematical Model, What is meant by a mathematical model of a real situati...

What is meant by a mathematical model of a real situation? Discuss the importance of models in the solution of Operations research problems

Metholodolgy, metholodolgy of operational research

metholodolgy of operational research

#methode, #what are the methods of OR ?

#what are the methods of OR ?

Report writing - report writing presentation, REPORT WRITING The final...

REPORT WRITING The final step in research is to report the study  findings to those  who authorized the investigation. The American marketing association is  of the opinion  t

one tailed test diagrams - hypothesis testing, Normal 0 false ...

Normal 0 false false false EN-IN X-NONE X-NONE

Sampling techniques, discuss and explain both probability and non probabili...

discuss and explain both probability and non probability sampling techniques.

Linear programming problem, Solve the following Linear Programming Problem ...

Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0

Reference books - classification of documents, Reference Books: Defini...

Reference Books: Definition According to William  Katz (1969) a Reference book generally has the following qualities:  It is a miscellany of information organised for quick

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd