**Inventory Management in the Automotive Section: A Case Study**As the new head of the automotive section of Nichols Department Store, it is crucial to ensure accurate reorder quantities for various items. This exercise focuses on Michelin tires, specifically the XW size 185 × 14 BSW. To manage inventory effectively, a perpetual inventory system is utilized, and the following data has been collected:- **Cost per tire:** $35 each- **Holding cost:** 20% of tire cost per year- **Demand:** 1,000 per year- **Ordering cost:** $20 per order- **Standard deviation of daily demand:** 3 tires- **Delivery lead time:** 4 daysGiven that customers often choose alternatives if tires are unavailable, a service probability of 98% is targeted. The demand is evenly distributed throughout the year, occurring 365 days annually.**Tasks:**a. **Determine the order quantity.** *Instructions:* Round your answer to the nearest whole number. - **Order quantity:** [__________] tiresb. **Determine the reorder point.** *Instructions:* Use Excel's `NORMSINV()` function to find the z-value. Do not round intermediate calculations. Round the z-value to two decimal places and the final answer to the nearest whole number. - **Reorder point:** [__________] tires

Name: **Inventory Management in the Automotive Section: A Case Study**As th
Uploaded: 2024-03-20T07:06:41.000Z
Channel: Bartleby
Description: **Inventory Management in the Automotive Section: A Case Study**As the new head of the automotive section of Nichols Department Store, it is crucial to ensure accurate reorder quantities for various items. This exercise focuses on Michelin tires, sp

Given data: Cost per tire = $35 each Holding cost = 20% of tire each year Annual demand = 1000 per…

Math

Statistics

Cost per tire Holding cost Demand $35 each 20 percent of tire cost per year 1,000 per year $20 per order 3 tires Ordering cost Standard deviation of daily demand Delivery lead time 4 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 98 percent. Assume the demand occurs 365 days per year. a. Determine the order quantity. (Round your answer to the nearest whole number.) Order quantity tires b. Determine the reorder point. (Use Excel's NORMSINV() function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.) Reorder point| | tires

Cost per tire Holding cost Demand $35 each 20 percent of tire cost per year 1,000 per year $20 per order 3 tires Ordering cost Standard deviation of daily demand Delivery lead time 4 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 98 percent. Assume the demand occurs 365 days per year. a. Determine the order quantity. (Round your answer to the nearest whole number.) Order quantity tires b. Determine the reorder point. (Use Excel's NORMSINV() function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.) Reorder point| | tires

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Refer to the accompanying data set and use the 30 screw lengths to construct a frequency distribution. Begin with a lower class limit of 3.470 in., and use a class width of 0.010 in. The screws were labeled as having a length of 3 1/2 in. Click on icon to view the data. Complete the frequency distribution below. ..... Length (in.) Frequency 3.470 - (Type integers or decimals rounded to the nearest thousandth as needed.) Next MacBook DII DD F12 F10 F11 888 F8 F9 F6 F7 F4 F5 esc F3 F1 & ! @ # $ 7 8. 1 3 4 { W E R Y Q K
Find a 96% confidence interval for Hg. Let µa = H1 - H2, where u, is the mean solar energy generated for the east-west highways and µ, is the mean solar energy generated for the north-south highways. (Round to one decimal place as needed.)
Expenditure (Rs.) Item 240 Food 66 e 4:4. The adjoining table gives the break-up of Clothing expenditure of a family on different items of Rent consumption. Draw percentage bar diagram to represent the Fuel and Lighting data. 125 57 42 Education 190 Miscellaneous
Calculate the value A. 0.3 B. 0.4 C. 0.5 D. 0.6 E. 0.7
Find the mean of the estimated miles per gallon of the automobiles in the table to the right. The mean is - (Round to one decimal place as needed.)
make a chart data for this
DATA file Autoinsurance 20. Assignment 3 The average annual premium for automobile insurance in the United States is $1503 (Insure.com website, March 6, 2014). The following annual premiums ($) are representa- tive of the website's findings for the state of Michigan. 1905 2725 2677 2600 2962 2184 2332 3112 2545 2525 2370 2545 2529 2442 2312 2981 2627 2857 2675 2115 Assume the population is approximately normal. a. Provide a point estimate of the mean annual automobile insurance premium in Michigan. b. Develop a 95% confidence interval for the mean annual automobile insurance pre- mium in Michigan. C. Does the 95% confidence interval for the annual automobile insurance premium in Michigan include the national average for the United States? What is your interpreta- tion of the relationship between auto insurance premiums in Michigan and the national average?
Step by step solutions pls. Answer #3-5 only thanks.
Quiz Module 1 The stem-and-leaf plot shows house sale prices over the last week in Tacoma. The stem is in hundres of thousands of dollars the leaf is in tens of thousands of dollars. What is the price of the most expensive house sold? 0|6677789991|024477788899992|00112344456678893|00011224
Classify as Discrete or Continuous The number of hours children Choose.. watch television The time and speed it takes Choose.. to drive to work The number of cars sold Choose... each week in Metro Manila
e 50 part-time students were asked how many courses they were taking this term. The (incomplete) results are shown below: # of Courses Frequency Relative Frequency Cumulative Frequency 1 0.38 2 3 19 18 a. Complete the table. b. What percent of students take exactly one course? Submit Question %
Floor Space (sq. ft.) 6,060 5,230 4,280 5,580 5,670 5,020 5,410 4,990 4,220 4,168 4,870 5,470 weekly Sales (dollars) 16,380 14,400 13,820 18,230 14,200 12,800 15,840 16,610 13,610 10,050 15,320 13,270 A Click here for the Excel Data File (a) Using the table above, select the most appropriate scatter plot from the given cholces. Scatter Plot A Scatter Plot B Scatter Plot C Floor Space and We ekly Sales Floor Space and Weekly Sales Floor Space and We ekly Sales 20,000 18,000 16,000 14.000 12.000 10,000 8,000 6,000 4,000 2,000 20,000 18,000 16,000 14,000 12.000 10,000 8,000 6,000 4.000 2,000 20,000 18,000 16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 1,000 2,000 3,000 4,000 5,000 6,000 7,000 1,000 2,000 3,000 4,000 5,000 6,000 7,000 1,000 2,000 3,000 4,000 5,000 6,000 7,000 FLOOR SPACE FLOOR SPACE FLOOR SPACE O Scatter Plot A O Scatter Plot B O Scatter Plot C (b) Define the relationship between X and Y. (You may select more than one answer. Click the box with a check mark for the…