Please look at the ORIGINAL information for U.S. Pharmaceutical below.But now St. Louis needs only 9 units and New York has only 12 units available (UPDATED information).Please MODIFY the Excel file for Linear Programming (POSTED) and RESOLVE. The UPDATED / NEW total costof shipment for U.S. Pharmaceutical will be:FACTORYIndianapolisPhoenixNew YorkAtlantaSUPPLY1561411WAREHOUSEColumbusSt. LouisDenverLos AngelesDEMAND1012159FROMIndianapolisPhoenixNew York.AtlantaSHIPPING COSTS PER CASE (IN DOLLARS)ToST. LOUISToCOLUMBUS$25554030$35305040ToDENVER$36258066ToLOS ANGELES$60259075

The shipping costs are given below:The supply and demand are given as:

Answered: Please look at the ORIGINAL information…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

please answer quickly
Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 *Holding cost =$ 2.50/unit/week; setup cost =$ 150; lead time =1 week; beginning inventory =40. What is the average demand per week? with 2 decimal places): Calculate Economic Order Quantity (EOQ) Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 Scheduled receipt…
Costco also employs a just-in-time inventory management system, which includes sharing data directly with many of its largest suppliers. Companies like Kimberly-Clark calculate re-order points in real time and send new inventory, as needed, to replenish store shelves. Costco also works to redesign product packaging to squeeze more bulky goods onto trucks and shelves, reducing the number of orders Costco needs to place with suppliers.Occasionally, the company leverages its 75 million square feet of warehouse space to reduce purchasing costs. For example, when Procter & Gamble recently announced a 6% price increase for its paper goods, Costco bought 258 truckloads of paper towels at the old rate and stored them using available capacity in its distribution centers and warehouses.These inventory management techniques have allowed Costco to succeed in tough times while others have failed. Costco turns its inventory nearly 12 times a year, far more often than other retailers. With many…
Problem 11-3 Solve the newsvendor problem. What is the optimal order quantity? Probability Value Purchase cost c Selling price p Salvage value v 0.13 0.03 0.19 1 2 3 Optimal order quantity 45 70 25 0.16 0.10 4 5 0.39 6
Yu Amy Xia bas developed a specialized airtightvacuum bag to extend the freshness of seafood shipped to restaurants.She has put together the following demand cost data: You decides that the initial inventory of 250 units will incur the$0.20/unit cost from each prior quarter (unlike the situation inmost other companies, where a 0 unit cost is assigned).a) Find the optimal pla n using the transportation method.b) What is the cost of the plan?c) Does any regula r time capacity go unused? If so, how much in which periods?b) What is the extent of backordering in units and dollars?
What are major limitations of using the transportationmethod for aggregate planning?
Calculate MPS for all periods
Determine the optimal Q and TC given the following information: D = 30,000 boxes Ch = $2 Co $300 Discount schedule: Quantity (boxes) Price ($ per box) 43 1 to 9,999 10,000 to 14,999 41 15,000 to 19,999 38 20,000 or more 36 Show complete solution.
J 2 PLEASE SOLVE USING EXCEL SOLVER
what are the average collection period values for Costco for 2023 & 2022. How do I solve for this using realtime data and what advantages would knowing this add to strategy?

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS