9-13 Finnish Furniture manufactures tables in facilities located inthree cities-Reno, Denver, and Pittsburgh. The tables are thenshipped to three retail stores located in Phoenix, Cleveland, andChicago. Management wishes to develop a distribution schedulethat will meet the stores' demands at the lowest possible cost.The shipping cost per unit from each of the sources to each ofthe destinations is shown in the following table: TO FROMPHOENIXCLEVELANDCHICAGORENO101619DENVER121413PITTSBURGH181212The available supplies are 120 units from Reno, 200 fromDenver, and 160 from Pittsburgh. Phoenix has a demand of 140units, Cleveland has a demand of 160 units, and Chicago has ademand of 180 units. How many units should be shipped fromeach manufacturing facility to each of the retail stores if cost isto be minimized? What is the total cost?

Answered: Image /qna-images/answer/d0fd9628-1b03-426a-9781-269357df1741.jpg

Answered: The available supplies are 120 units…

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

The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: May 2,100 January February 1,450 1,700 1,700 June 2,300 July 1,900 March April 1,700 August 1,300 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $65 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. Evaluate the following plan. This exercise contains only Plan E. Plan E: Keep the current workforce, which is producing 1,600 units per month, and subcontract to meet the rest of the demand. Subcontract cost is $75 per unit. Month 10 December 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August Demand 1,450 1,700 1,700 1,700 2,100 2,300 1,900 1,300 Production (Units) 1,600 1,600 1,600 1,600 1,600 1,600 1,600 1,600 Plan E Ending Subcontract (Units) Inventory 200 The total subcontracting cost = $ (Enter your response as…
Compute the following using excel. Use the formula given in the picture below.
what is a conitnues location problem in supply chain? how can we solve it? what are the givens and what is the output? briefly give a way to solve a continues location problem
Your company offers a weekly consolidation service from Toronto to Frankfort , via Lufthansa Airways. The carrier has given you a 1000 kg (or less) buying rate of CAN $2.27/kg and a plus 1000 kg buying rate of CAN $1.85/kg. You sell this service to clients who ship 700 kg (or less) at a rate of CAN $2.95/kg and for clients who ship in excess of 700 kg at a rate of CAN $2.55/kg. A) Shipper: J&J Company 123 John Street Toronto, ON, Canada, L5R 2N3 Shipment: 140 cartons of books Total weight: 426 kg Dimensions of each carton: 15 cm x 49 cm x 47 cm B) Shipper: R&R Company 432 Avenue Road Toronto, ON, Canada, R2S 1A3 Shipment: 380 cartons of umbrellas Total weight: 700 kg Dimensions of each carton: 39 in x 18 in x 19 in What is the profit on this shipment? full calculation
In a sales rebate contract, a rebate is paid by supplier for any items sold above certain. Select one: O a Quantity Ob. Price Oc Sales locations Od. Inventory Level The supply chain strategy category would include a decision about Select one: Oa which warchouse will supply the Sur location. Ob when the order should be shipped to the customer from Muscat distribution center. Oc how large the warehouse in Khazayen should be. Od which items in the warehouse will be shipped to Sohar.
Milo Limited, South Africa, is a specialist manufacturer of security doors and gates. In seeking to expand its operations, it could acquire a Dutch subsidiary company, Nabby Guard, or set up a new division in its home market. The relevant figures for these two options are: Set up new division at home Rand Cost of setting up premises 25 000 000 Cost of machinery 14 000 000 Annual sales 41 500 000 Annual variable cost 13 000 000 Head office expenses o The Head office expense includes existing head office expense of R1 000 000 5 000 000 Depreciation: machinery 10% on cost annually 3 900 000 Acquisition Euro Acquire shares from existing shareholders 13 000 000 Redundancy costs 7 000 000 Annual Sales 27 000 000 Annual variable costs 15 000 000 Annual fixed costs 5 000 000 Consultants fees 6 300 500…
please answer quickly
ABC Inn has 2 departments: rooms and F&B. the rooms department has a CMR of 0.6 and the F&B department has a CMR of 0.4 the rooms department take in 70% of total revenue and the F&B department takes in 30% of total revenue. If the combined total monthly fixed costs for the entire hotel are equal to $100,00. What is the break-even level of sales?
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?

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