t’s your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one item and choose Michelin tires, XW size 185 x 14 BSW. A perpetual inventory system has been used, so you examine this, as well as other records, and come up with the following data. Cost per tire $55 each Holding cost 15 percent of tire cost per year Demand 1,180 per year Ordering cost $ 36 per order Standard deviation of daily demand 7 tires Delivery lead time 8 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 95 percent. Assume the demand occurs 365 days per year. Order quantity= Determine the reorder point = Use the excels NORMSINV( ) function to find the critical value for the given a-level. Do not round intermediate calculations (Round you z-value to 2 decimal places and final answer to the nearest whole number.)
It’s your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one item and choose Michelin tires, XW size 185 x 14 BSW. A perpetual inventory system has been used, so you examine this, as well as other records, and come up with the following data.
Cost per tire $55 each
Holding cost 15 percent of tire cost per year
Demand 1,180 per year
Ordering cost $ 36 per order
Standard deviation of daily demand 7 tires
Delivery lead time 8 days
Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 95 percent. Assume the demand occurs 365 days per year.
- Order quantity=
Determine the reorder point =
Use the excels NORMSINV( ) function to find the critical value for the given a-level. Do not round intermediate calculations (Round you z-value to 2 decimal places and final answer to the nearest whole number.)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
