The Acme Company operates four factories that ship products to five warehouses. The shipping costs, requirements capacities, and optimal allocations are shownbelow.Shipping Cost per Case to WarehousesFactoryСарacityW1W2W3W4W5$1.20$3.60| $4.80$6.00$7.20F140,00030,00010,000$2.40$2.40| $1.20$4.80$6.00F230,00025,0005,000$1.20$6.00$1.20$3.60$1.20F330,00010.00020,000$6.00$2.40$4.80$6.00$4.80F425,00025,000Demand30,00035,00025,00015,00020,000125,000What is the total cost of the optimal solution?Total cost = $ (Enter your response to the nearest dollar.)

Optimal Solution is a practical arrangement that is supposed to be optimal arrangement on the off…

Answered: The Acme Company operates four…

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

1
A supplier is willing to offer Plant Electronic Ltd, additional amounts of the resources. PACKAGING PRICES (GHC) RESOURCES QUANTITY Plastic 30 24m Copper 10 15m Transistors 100 10m If one the above packages is to be purchased, which one should Plant Electronic Ltd purchase?
Sapphire Aerospace operates 52 weeks per year, and its costof goods sold last year was $6,500,000. The firm carries eightitems in inventory: four raw materials, two work-in-processitems, and two finished goods. Table 12.3 shows last year’saverage inventory levels for these items, along with their unitvalues.a. What is the average aggregate inventory value?b. How many weeks of supply does the firm have?c. What was the inventory turnover last year?
A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It carries seven items in inventory: three raw materials, two work-in-process items, and two finished goods. The following table contains last year’s average inventory level for each item, along with its value. a. What is the average aggregate inventory value? b. How many weeks of supply does the firm maintain? c. What was the inventory turnover last year?
part b
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…
Destination 1 2 3 Supply 1 15 13 7 Source 2 11 M 17 5 3 9. 11 9. 3 Demand 7 3 5 Activ
Answer using the excel screenshot format to do the question. Secondly, please use the Net flow, sign and the RHS to work on Solver.
A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It carries seven items in inventory: three raw materials, two work-in-process items, and two finished goods. The following table contains last year’s average inventory level for each item, along with its value. a. What is the average aggregate inventory value? b. How many weeks of supply does the firm maintain? c. What was the inventory turnover last year?
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?
A logistics manager wants to assess how varied the weight of lorry loads is over a period of time. He takes a 5 samples of 20 lorry loads (n) and notes the average load (tonnes) and the range within each sample. Sample Weight average in tonnes (x) Range (R) 1 15.5 4.5 2 12.3 5.3 3 8.8 6.2 4 10.3 5.2 5 13.1 3.8 What are the population means for the mean and the range? What are the upper and lower control limits for the sample means chart? What are the upper and lower controls for the range chart?
9) APP Transportation Summary Table Given the following summary table from a Transportation Method Production Plan: What is the value of X (inventory at the end of the 3rd quarter)? Group of answer choices a) 8,100 b) 7,300 c) 1,900 d) 15,400 e) 0

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