Formulate the linear programming model

Assignment Help Operation Management

Reference no: EM131122393

Publisher Dilemma

a – formulate the linear programming model.

b – solve the linear programming model on Excel.

c – print out the sensitivity report.

A publisher has orders for 600 copies of a certain text from San Francisco, 300 copies from San Jose, and 400 copies from Sacramento. The company has 700 copies in a warehouse in Novato and 800 copies in a warehouse in Lodi. It costs $5 to ship a text from Novato to San Francisco, costs $7 to ship it to San Jose, and costs $10 to ship it to Sacramento. It costs $15 to ship a text from Lodi to San Francisco, costs $8 to ship it from Lodi to San Jose, and costs $4 to ship it from Lodi to Sacramento.

There is a limit of 300 copies be send for each route. What if there are only 600 copies of the text from both Novato and Lodi. How would the model be changed? Will there be unhappy customers (why would they be unhappy)?

Reference no: EM131122393

Questions Cloud

Assumptions or results is the confidence interval : From the data of parts (a) and (b) of Exercise 1 of Chapter 2, construct approximate 95% confidence intervals for the population total. Also construct approximate 95% confidence intervals for the population mean per unit.

What means do they use to hedge against exchange rate risk : What means do they use to hedge against exchange rate risk? Using this information, what do you think would be the effect of increases or decreases in the dollar's exchange value on the firm's profitability?

Use the squeeze theorem to find equation : Use the Squeeze Theorem to find limx→0 x sin (1/x) Is f(x) = x2 - 7/x - 3 continuous on the interval (3, ∞)

What is the best estimate of the price in chf you can reco : what is the best estimate of the price (in CHF) you can recommend that management charge if it wants to just cover its costs and profit objectives?

Formulate the linear programming model : formulate the linear programming model. solve the linear programming model on Excel. A publisher has orders for 600 copies of a certain text from San Francisco, 300 copies from San Jose, and 400 copies from Sacramento. The company has 700 copies in a..

What factors led to redefinition of the patient as consumer : What has most influenced the way you view yourself as a consumer of healthcare? What factors led to the redefinition of the patient as a consumer in the late twentieth century?

Survey to estimate the population variance : Using the sample variance from the data of your own survey to estimate the population variance, specify a desired precision and calculate the sample size necessary to achieve it with 95% confidence in a future survey of the same population.

About the importance of being very good at the strategy : Zappo’s has become very successful by positioning themselves as a company with first class customer service. What did you learn from watching the video about the importance of being very good at the strategy you select? Also, if Zappo’s had chosen a ..

Show that the method terminates : Show that the method terminates and that each node visits the candidate list at most once.

User Account

All Pages