Reference no: EM131118390
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.
1- How many copies should the company ship from each warehouse to San Francisco and Sacramento to fill the order at the least cost?
2 – With the Excel's optimal solution (Using the sensitivity report from your hard copy), is the publisher happy with the result? Explain why or why not.
3 – If there is a limit of 300 copies be send for each route. How would the linear programming (LP) model be changed? How is the optimal solution for the final cost compare with the solution from question 1?. (Hint, you will need to provide a constraint for each route)
4- Another potentially “real” dilemma: If on top of the 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)?
|
Calculate the average annual transportation inventory
: Elyssa's Elegant Eveningwear (EEE) needs to ship finished goods from its manufacturing facility to its distribution warehouse. Annual demand for EEE is 3,000 gowns. EEE can ship the gowns via regular parcel service (3 days transit time), premium parc..
|
|
Mpc system would require modifications to adapt
: We have suggested that as changes take place in the world, the MPC system would require modifications to adapt. What changes can you see that will require changes in the MPC system?
|
|
Result in process with six-sigma capability
: Natural Foods sells Takeoff, a breakfast cereal, in one-pound boxes. According to Food and Drug Administration (FDA) regulations, a one- pound box must contain at least 15.5 ounces of cereal. Where should Natural Foods center its process in order to ..
|
|
Assignable cause of variation during the inspection period
: During a 4-week inspection period, the number of defects found in a sample of 500 electronic components are listed in the table, below. Construct a c chart for these data. Does it appear as though there existed an assignable cause of variation during..
|
|
How many copies should the company ship from each warehouse
: 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. How many copies should th..
|
|
Performance management and performance appraisal
: Performance management should originate with the organizations need to accomplish strategic objectives. Each employee, regardless of position, has some contribution to make to overall organizational functioning. What four components are necessary for..
|
|
Priority rules-first-come and first-served rule
: In the list of priority rules, there is no first-come/first-served (FCFS) rule, yet most banks, cafeterias, and theater ticket booths use this rule in waiting on patrons. Why isn’t it a suggested rule for the shop floor? (300 word minimum)
|
|
Provide potential illustration of Harley-Davidson SCM system
: How could Harley-Davidson’s SCM system, Manugistics, improve its business operations? Provide a potential illustration of Harley-Davidson’s SCM system including all upstream and downstream participants. Explain how an ERP system could help Harley-Dav..
|
|
Group of external consultants to devise and deliver
: For this assignment, imagine that you have been appointed to lead a group of external consultants to devise and deliver a new learning programme for a new service centre (call centre) employing a staff of 250. You may choose to locate this fictional ..
|