Homework Help is Here – Start Your Trial Now!
Business
Operations Management
>>>> < > G סוי - C Mind Tap Cengage Learning CENGAGE MINDTAP Chapter 12 Homework: Managing Inventories in Supply Chains Questions Problem 12-44 Algo (Managing Fixed-Quantity Inventory Systems) 1. e 2. 3. 自 4. 5. ? ↑ 6. 7. 8. 9. 10. 11. ng.cengage.com + O C Excel Online Student Work Q Search this course ? Question 3 of 11 ► Hint(s) Check My Work Brenda opened a pool and spa store in a lively shopping mall and finds business to be booming but she often stocks out of key items customers want. The 28-ounce bottle of Super Algaecide (SA) is a high margin SKU, but it stocks out frequently. Ten SA bottles come in each box, and she orders boxes from a vendor 160 miles away. Brenda is busy running the store and seldom has time to review store inventory status and order the right quantity at the right time. She collected the following data: Demand = 9 boxes per week Order cost = $90/order Store open = 48 weeks/year Lead-time = 3 weeks Item cost = $180/box Inventory-holding cost = 10 percent per year Std. deviation in weekly demand Service level = 98 percent = 8 Brenda wants to consider setting up a fixed-period inventory system for the 28-ounce bottle of Super Algaecide (SA) SKU. At the beginning of the current week, D. J. Kole, the materials manager, checked the inventory level and found 65 units on-hand. There were no scheduled receipts and 20 units were on backorder. a. What is the review period (7)? Do not round intermediate calculations. Round your answer up to the nearest whole number. 7 weeks b. What is stock replenishment level with safety stock (M)? Do not round intermediate calculations. Round your answer to the nearest whole number. 1534 bottles c. How many units should be ordered? Do not round intermediate calculations. Round your answer to the nearest whole number. 149 Hide Feedback Partially Correct Icon Key orders/year Hint(s) Check My Work e A-Z A+ Office

>>>> < > G סוי - C Mind Tap Cengage Learning CENGAGE MINDTAP Chapter 12 Homework: Managing Inventories in Supply Chains Questions Problem 12-44 Algo (Managing Fixed-Quantity Inventory Systems) 1. e 2. 3. 自 4. 5. ? ↑ 6. 7. 8. 9. 10. 11. ng.cengage.com + O C Excel Online Student Work Q Search this course ? Question 3 of 11 ► Hint(s) Check My Work Brenda opened a pool and spa store in a lively shopping mall and finds business to be booming but she often stocks out of key items customers want. The 28-ounce bottle of Super Algaecide (SA) is a high margin SKU, but it stocks out frequently. Ten SA bottles come in each box, and she orders boxes from a vendor 160 miles away. Brenda is busy running the store and seldom has time to review store inventory status and order the right quantity at the right time. She collected the following data: Demand = 9 boxes per week Order cost = $90/order Store open = 48 weeks/year Lead-time = 3 weeks Item cost = $180/box Inventory-holding cost = 10 percent per year Std. deviation in weekly demand Service level = 98 percent = 8 Brenda wants to consider setting up a fixed-period inventory system for the 28-ounce bottle of Super Algaecide (SA) SKU. At the beginning of the current week, D. J. Kole, the materials manager, checked the inventory level and found 65 units on-hand. There were no scheduled receipts and 20 units were on backorder. a. What is the review period (7)? Do not round intermediate calculations. Round your answer up to the nearest whole number. 7 weeks b. What is stock replenishment level with safety stock (M)? Do not round intermediate calculations. Round your answer to the nearest whole number. 1534 bottles c. How many units should be ordered? Do not round intermediate calculations. Round your answer to the nearest whole number. 149 Hide Feedback Partially Correct Icon Key orders/year Hint(s) Check My Work e A-Z A+ Office

Practical Management Science
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
icon
Related questions
Question
>>>> < > G סוי - C Mind Tap Cengage Learning CENGAGE MINDTAP Chapter 12 Homework: Managing Inventories in Supply Chains Questions Problem 12-44 Algo (Managing Fixed-Quantity Inventory Systems) 1. e 2. 3. 自 4. 5. ? ↑ 6. 7. 8. 9. 10. 11. ng.cengage.com + O C Excel Online Student Work Q Search this course ? Question 3 of 11 ► Hint(s) Check My Work Brenda opened a pool and spa store in a lively shopping mall and finds business to be booming but she often stocks out of key items customers want. The 28-ounce bottle of Super Algaecide (SA) is a high margin SKU, but it stocks out frequently. Ten SA bottles come in each box, and she orders boxes from a vendor 160 miles away. Brenda is busy running the store and seldom has time to review store inventory status and order the right quantity at the right time. She collected the following data: Demand = 9 boxes per week Order cost = $90/order Store open = 48 weeks/year Lead-time = 3 weeks Item cost = $180/box Inventory-holding cost = 10 percent per year Std. deviation in weekly demand Service level = 98 percent = 8 Brenda wants to consider setting up a fixed-period inventory system for the 28-ounce bottle of Super Algaecide (SA) SKU. At the beginning of the current week, D. J. Kole, the materials manager, checked the inventory level and found 65 units on-hand. There were no scheduled receipts and 20 units were on backorder. a. What is the review period (7)? Do not round intermediate calculations. Round your answer up to the nearest whole number. 7 weeks b. What is stock replenishment level with safety stock (M)? Do not round intermediate calculations. Round your answer to the nearest whole number. 1534 bottles c. How many units should be ordered? Do not round intermediate calculations. Round your answer to the nearest whole number. 149 Hide Feedback Partially Correct Icon Key orders/year Hint(s) Check My Work e A-Z A+ Office
Transcribed Image Text:>>>> < > G סוי - C Mind Tap Cengage Learning CENGAGE MINDTAP Chapter 12 Homework: Managing Inventories in Supply Chains Questions Problem 12-44 Algo (Managing Fixed-Quantity Inventory Systems) 1. e 2. 3. 自 4. 5. ? ↑ 6. 7. 8. 9. 10. 11. ng.cengage.com + O C Excel Online Student Work Q Search this course ? Question 3 of 11 ► Hint(s) Check My Work Brenda opened a pool and spa store in a lively shopping mall and finds business to be booming but she often stocks out of key items customers want. The 28-ounce bottle of Super Algaecide (SA) is a high margin SKU, but it stocks out frequently. Ten SA bottles come in each box, and she orders boxes from a vendor 160 miles away. Brenda is busy running the store and seldom has time to review store inventory status and order the right quantity at the right time. She collected the following data: Demand = 9 boxes per week Order cost = $90/order Store open = 48 weeks/year Lead-time = 3 weeks Item cost = $180/box Inventory-holding cost = 10 percent per year Std. deviation in weekly demand Service level = 98 percent = 8 Brenda wants to consider setting up a fixed-period inventory system for the 28-ounce bottle of Super Algaecide (SA) SKU. At the beginning of the current week, D. J. Kole, the materials manager, checked the inventory level and found 65 units on-hand. There were no scheduled receipts and 20 units were on backorder. a. What is the review period (7)? Do not round intermediate calculations. Round your answer up to the nearest whole number. 7 weeks b. What is stock replenishment level with safety stock (M)? Do not round intermediate calculations. Round your answer to the nearest whole number. 1534 bottles c. How many units should be ordered? Do not round intermediate calculations. Round your answer to the nearest whole number. 149 Hide Feedback Partially Correct Icon Key orders/year Hint(s) Check My Work e A-Z A+ Office
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
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
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS