Assuming that you are a supply chain manager of a local electric bike shop. In the past 5 years, you monitor the sales and inventory level every week and order electric bikes from suppliers. se EOQ and Continuous Inventory Review Policy to manage inventories. COVID-19 has affected your community and the number of confirmed cases has been increasing recently. Please analyze which component(s) of EOQ (D, K, or H) will be affected and how COVID-19 will affect the economic order quantity (increase, decrease, or no change) and average inventory level. You need to provide logic for your arguments. Based on the historical data, you found that the demand for an electric bike is 20 units per week and the standard deviation of demand is 3 units. The lead time for an order is normally 4 weeks. In addition, you are expecting a 95% service level. The order cost is $2 per order and the holding cost per unit per week is $5. Based on EOQ theory, what will be the best order quantity that minimizes the total cost? Please show all calculations and round to the closest whole number Based on the information provided in question b, to achieve the 95% service level, how many units of safety stock will you carry? Please show all calculations and round up to a whole number. Based on the information provided in question b, what will be the re-order point?
Assuming that you are a supply chain manager of a local electric bike shop. In the past 5 years, you monitor the sales and inventory level every week and order electric bikes from suppliers. se EOQ and Continuous Inventory Review Policy to manage inventories. COVID-19 has affected your community and the number of confirmed cases has been increasing recently. Please analyze which component(s) of EOQ (D, K, or H) will be affected and how COVID-19 will affect the economic order quantity (increase, decrease, or no change) and average inventory level. You need to provide logic for your arguments. Based on the historical data, you found that the demand for an electric bike is 20 units per week and the standard deviation of demand is 3 units. The lead time for an order is normally 4 weeks. In addition, you are expecting a 95% service level. The order cost is $2 per order and the holding cost per unit per week is $5. Based on EOQ theory, what will be the best order quantity that minimizes the total cost? Please show all calculations and round to the closest whole number Based on the information provided in question b, to achieve the 95% service level, how many units of safety stock will you carry? Please show all calculations and round up to a whole number. Based on the information provided in question b, what will be the re-order point?
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...
Related questions
Question
Please Answer all parts of the questions.
Assuming that you are a
- COVID-19 has affected your community and the number of confirmed cases has been increasing recently. Please analyze which component(s) of EOQ (D, K, or H) will be affected and how COVID-19 will affect the economic order quantity (increase, decrease, or no change) and average inventory level. You need to provide logic for your arguments.
- Based on the historical data, you found that the demand for an electric bike is 20 units per week and the standard deviation of demand is 3 units. The lead time for an order is normally 4 weeks. In addition, you are expecting a 95% service level. The order cost is $2 per order and the holding cost per unit per week is $5. Based on EOQ theory, what will be the best order quantity that minimizes the total cost? Please show all calculations and round to the closest whole number
- Based on the information provided in question b, to achieve the 95% service level, how many units of safety stock will you carry? Please show all calculations and round up to a whole number. Based on the information provided in question b, what will be the re-order point?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 5 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.