Assumptions: 1. Estimated Shipping cost, C, - $3300 (full container) C. $2100 (half container) - • Lead time for Full Container is 13 weeks • Lead time for Half Container is 15 weeks. Inventory holding cost, C, - 18% of the product price Product Price - $90 Assume Service level - 95% The aggregated quantity of products needs to be ordered for the business. Please use sales data from the attached excel file to determine The task: Please determine the best inventory model based on 2 years sales data, select the shipping method (full container vs half container) and calculate annual operating cost.

Assumptions: 1. Estimated Shipping cost, C, - $3300 (full container) C. $2100 (half container) - • Lead time for Full Container is 13 weeks • Lead time for Half Container is 15 weeks. Inventory holding cost, C, - 18% of the product price Product Price - $90 Assume Service level - 95% The aggregated quantity of products needs to be ordered for the business. Please use sales data from the attached excel file to determine The task: Please determine the best inventory model based on 2 years sales data, select the shipping method (full container vs half container) and calculate annual operating cost.

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

Problem 5: You have the following information:Demand rate = 250 units per hourLead time = 15 hourscontainer capacity = 300 units per hourSafety Stock = 20%a Determine the number of Kanban cards required.b Convert these Kanban cards into the number of hoursof demand they represent.c. If the container size is reduce from 300 to 150 units,what impacts, if any, will it have on inventory levels?
What are just-in-time systems? What are their advantages? Why isquality especially important if a JIT system is used?
29 Meritor is so pleased with the outcome from previous suggestions that the consultants are invited back for more work. The consultants now suggest a more complete robotic automation of the making of muffler assemblies and also a reduction in container size to five per container. Meritor implements these suggestions and the result is that the muffler assembly fabrication cell now averages approximately 20 assemblies per hour, and the catalytic converter assembly cell can now respond to an order for a batch of catalytic converters in one hour. The safety stock remains at 11.5 percent. How many kanban cards are needed? Note: Round up your answer to the next whole number.
Discuss the essential requirements for mixed model lines to be practical ?
The Ostrya Virginiana furniture company produces wooden chairs. The demand for chairs is 500 units per month. The setup cost for production is $300, and the holding cost is $12 per chair per year. The production rate is 100 chairs per day. Assume 30 working days per month. Determine the following: a) D, S, H, p, u b) EPQ c) Run time
True or False? Containers protect and secure material to allow for efficient transport.
Inventory Problem at Three Spoons Market Randy is the owner of Three Spoons Market. Three Spoons Market is an upscale tapas restaurant in a town of about 200,000 people. According to both Yelp and Trip Advisory, it is the highest restaurant in town. Randy had been having trouble with inventory management (he runs out some items while others go bad) and has brought you in as a consultant to help, due your background in inventory management. The menu at the restaurant changes monthly, and there are daily specials. Randy follows what other restaurant Owners are doing to improve their bottom line-he reads trade publication and online blogs. He also tries to keep up with trends in other industries that may help him manage better. He recently read about the success small-jobs have had with many managing inventory as A,B or C. As Randy thinks about his business, it is really a job shop, since food is prepared after the consumer orders from the menu. The food is prepared to customer tastes and…
What Companies Use JIT Inventory Management?
i need the answer quickly
Which of the following items is most likely to be stored at the back of a warehouse, furthest away from the shipping dock?a) low number of trips and low number of storage blocksb) low number of trips and high number of storage blocksc) high number o f trips and low number of storage blocksd) high number of trips and high number of storage blocks
What role does load balancing play in maintaining high-availability systems?
When are Reduced setup times are particularly useful?