FB378 GS131 FB378 ACTUAL DEMAND WEEK ACTUAL FORECAST DEMAND FORECAST DEMAND GS131 ACTUAL 222 25 36...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
FB378 GS131 FB378 ACTUAL DEMAND WEEK ACTUAL FORECAST DEMAND FORECAST DEMAND GS131 ACTUAL 222 25 36 31 54 42 26 35 45 53 57 27 36 53 WEEK ACTUAL FORECAST DEMAND FORECAST 1 30 34 2345678 2 32 44 35 33 34 39 5 35 48 6 38 30 36 26 8 33 45 9 37 33 10 37 30 11 36 47 10 16 12 37 40 18 27 13 38 31 30 35 14 36 38 42 52 15 36 32 55 51 16 35 49 54 44 17 37 24 52 57 18 35 41 53 59 19 37 34 53 46 20 36 24 52 62 2222 21 34 52 53 51 36 41 53 23 37 30 54 46 24 36 37 53 58 848 60 Mike realized he also needed input from Ann about her perspective on the business. She indicated that she felt strongly that with better management, Northcutt Bikes should be able to use the existing warehouse for years to come, even with the anticipated growth in business. Currently, however, she views the situation as a crisis because "we're bursting at the seams with inventory. It's costing us a lot of profit, yet our service level is very poor, at less than 80%. I'd like to see us maintain a 95% or better service level without back orders, yet we need to be able to do that with a net reduction in total inventory. What do you think, Mike? Can we do better?" Questions 1. Use the available data to develop inventory policies (order quantities and reorder points) for the FB378 and GS131. Assume that the holding cost is 20% of unit price. 2. Compare the inventory costs associated with your sug- gested order quantities with those of the current order quantities. What can you conclude? 3. Do you think the lost customer sales should be included as a cost of inventory? How would such an inclusion impact the ordering policies you established in question 1? FB378 GS131 FB378 ACTUAL DEMAND WEEK ACTUAL FORECAST DEMAND FORECAST DEMAND GS131 ACTUAL 222 25 36 31 54 42 26 35 45 53 57 27 36 53 WEEK ACTUAL FORECAST DEMAND FORECAST 1 30 34 2345678 2 32 44 35 33 34 39 5 35 48 6 38 30 36 26 8 33 45 9 37 33 10 37 30 11 36 47 10 16 12 37 40 18 27 13 38 31 30 35 14 36 38 42 52 15 36 32 55 51 16 35 49 54 44 17 37 24 52 57 18 35 41 53 59 19 37 34 53 46 20 36 24 52 62 2222 21 34 52 53 51 36 41 53 23 37 30 54 46 24 36 37 53 58 848 60 Mike realized he also needed input from Ann about her perspective on the business. She indicated that she felt strongly that with better management, Northcutt Bikes should be able to use the existing warehouse for years to come, even with the anticipated growth in business. Currently, however, she views the situation as a crisis because "we're bursting at the seams with inventory. It's costing us a lot of profit, yet our service level is very poor, at less than 80%. I'd like to see us maintain a 95% or better service level without back orders, yet we need to be able to do that with a net reduction in total inventory. What do you think, Mike? Can we do better?" Questions 1. Use the available data to develop inventory policies (order quantities and reorder points) for the FB378 and GS131. Assume that the holding cost is 20% of unit price. 2. Compare the inventory costs associated with your sug- gested order quantities with those of the current order quantities. What can you conclude? 3. Do you think the lost customer sales should be included as a cost of inventory? How would such an inclusion impact the ordering policies you established in question 1?
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
Mike realized he also needed input from Ann about her perspective on the business. She indicated that she felt strongly that with better management, Northcutt Bikes should be able to use the existing...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Mark Cotteleer owns a company that manufactures sailboats, Actual demand for Marks sailboats during each season in 2006 through 2009 was as follows: Mark has forecasted that annual demand for his...
-
The Stockholders' Equity section of Webster Inc. showed the following data on December 31, 2012: common stock, $3 par, 300,000 shares authorized, 250,000 shares issued and outstanding, $750,000;...
-
Identify the risks and the benefits that The Pasta Shoppe faces by operating as a global business.
-
Zappos.com is a popular website known mainly for its discounted shoe sales. In 2012, a hacker hacked into the Zappos website in an effort to obtain the personal account information of Zappos...
-
Blythe Industries Inc. expects to maintain the same inventories at the end of 2012 as at the beginning of the year. The total of all production costs for the year is therefore as, summed to be equal...
-
2. What is the computational complexity of the following function Mystery1? int Mystery1(int n) { int sum = 0; for (int i=0; i
-
. With the information generated from the following table derivate from the Bureau of Economic Analysis (https://apps.bea.gov/iTable/index_nipa.cfm), please do the regression analysis, with the...
-
Under ASC 606, the client formed the contract with the constructor. The client needs two buildings but will be build in different location. Also, there are several requirements to form the contract...
-
As the chief financial officer (CFO) for the hospital, you have now directed your attention to the financial aspects because you realize that it is crucial. Regardless of the challenges, you have...
-
Consider a market with a demand curve given (in inverse form) by P(Q) = 80 0.25Q, where Q is total market output and P is the price of the good. Two firms compete in this market by simultaneously...
-
Particle A has four times the speed and eight times the kinetic energy of particle B. What is the mass ratio m/mB
-
Give an example of 4 entirely different possible investments that in your opinion are almost equally risky (on their own), have almost equal 'expected returns', but where the risks are highly...
-
The density of Si is 2.3 g/cm. Assume you are making square mc-Si wafers, 15 x 15 cm, 180 m thick, leading to solar cells of 16% efficiency (assume wafers have 16% efficiency also). Assume 150 m kerf...
-
What is the radius of the smallest circle that encloses an equilateral triangle with 12-inch sides? What is the radius of the largest circle that will fit inside the same triangle?
-
What are the six activities involved in the physical supply/distribution system?
-
Calculate a standardized effect size, Cohens d, for the data given in Exercise 3. Interpret this effect size using Cohens guidelines which are provided in your textbook. Data from exercise 3...
-
McConnell, Brown, Shoda, Stayton, and Martin (2011) carried out an investigation of the well-being benefits of pets for everyday people. In Study 1, they addressed the question: Do pet owners enjoy...
-
Megan is working with a distribution of reaction times that is positively skewed. Megan transforms the reaction times to z scores. 1. Will the distribution of these z scores have an approximately...
-
Using tha data file usmacro, estimate the ARDL \((2,1)\) model Your estimates should agree with the results given in equation (9.42). Use these estimates to verify the forecast results given in Table...
-
Using the data file usmacro, estimate the \(\operatorname{AR}(1)\) model \(G_{t}=\alpha+\phi G_{t-1}+v_{t}\). From these estimates and those obtained in Exercise 9.16, use the results from Exercise...
-
Consider the \(\operatorname{ARDL}(p, q)\) equation and the data in the file usmacro. For \(p=2\) and \(q=1\), results from the LM test for serially correlated errors were reported in Table 9.6 for...
Study smarter with the SolutionInn App