Question: Could you also explain the input for excel's ztest? Im not sure which numbers to put in. thanks Check My Work (2 remaining) Crew Soccer

Could you also explain the input for excel'sCould you also explain the input for excel's ztest? Im not sure which numbers to put in. thanks

Check My Work (2 remaining) Crew Soccer Shoes Company is considering a change of their current inventory-control system for soccer shoes. The information regarding the shoes is given below: Demand = 90 pairs/week Lead time = three weeks Order cost = $40/order Holding cost = $3.00/pair/year Cycle service level = 91 percent Standard deviation of weekly demand = 45 Number of weeks per year = 52 a. The company decides to use a fixed-order quantity system. What would be the reorder point and the economic order quantity? Round your answers to the nearest whole number. Economic order quantity: units Reorder point: units b. In this system, at the beginning of the current week, the materials manager, Luke Thomas, checked the inventory level of shoes and found 500 pairs. There were no scheduled receipts and no back orders. Should he place an order? Explain your answer. Since the inventory level of 500 pairs is -Select-than the reorder point, Emily -Select- place an order C. If the company changes to a fixed-period system and reviews the inventory every two weeks (T = 2), how much safety stock is required? Round your answer to the nearest whole number. units Check My Work (2 remaining)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!