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

35 In a warehouse, the goods are usually moved around and stored on: Select one: a. Racks b. Containers c. Boxes d. Pallets
Many firms are now co - locating supply management personnel directly at operations locations so supply management can quickly respond to operations'needs . Select one : A. True B. False .
part b
1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Develop the aggregate for them. Solve using Excel Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 Period 1 2 3 2 3 80 90 40 Supply Capacity available (units) Regular time 40 65 30 Other Data Beginning Inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost Overtime 20 12 10 30 R 100 R 150 R 200 R 5 Subcontract 10 5 5
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?
2
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?
Perez POPS POS Katie Perez, owner of Perez POPS, realizes she needs a Point of Sale System (POS) for her main shop but also something that could be used for parties, events etc. Flexibility and portability is important. Choosing the right one will require some research. She has heard of Square but doesn't know anything about it. She would really like to have a couple options to consider. She has asked you, her consultant, to investigate Square and a second POS system appropriate for a small business like hers. Report your findings to Katie with a persuasive business email that has a table detailing the features/pros/cons of both POS options. Finally, offer your recommendation as to which one would be the best solution for her. Business Email should include the following: Use a standard business email template which has - To, From, Date and Subject or Re: Put page numbers on the email if it goes over 1 page Include a link embedded in the email to each POS system you are referencing in…
argue in favour of the statement made by Amazon’s former logistics executive turned automation consultant, where he sees accelerating automation as inevitable.
S C 0 r e 4 b) 3.5 3+ 2.5 2 1.5 1 0.5 + 0 4 3.17 3.18 Malaysian Logistics Performance Index 3.45 3.49 Custom Logistics Efficiency Infrasturcture 3.65 Based on the above chart: a) 3.21 World Bank Logistics Performance Index 3.46 3.57 *Note: Score: 0 - Poor, 5- Excellent 3.34 Timeliness Track and Trace Quality and Logistics Cost Competency Malaysia Logistics Performance Index 3.52 Source: https://www.lpimy.com The above chart shows the comparison between the average Malaysia Logistics Performance Index (MLPI) and the World Bank Logistics Performance Index (WBLPI). Discuss five (5) key components measured in the survey. 3.48 The MLPI is a survey based measurement of the Malaysia logistics performance from the views of industry professionals. The objective of the survey is to evaluate the status of logistics performance for Malaysia. 3.28 Compare the trend of performance between MLPI and WBLPI.
A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $7,900 per month and variable cost of 62 cents per unit produced. Each item is sold to retailers at a price that averages 85 cents. (Round all answers to a whole number.) a. What volume per month is required in order to break even? b. What profit would be realized on a monthly volume of 65,000 units? 85,000 units? c. What volume is needed to obtain a profit of $13,000 per month? d. What volume is needed to provide a revenue of $20,000 per month?

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