Read the case study, "Nothcutt Bikes: The Service Department" (pp. 362-363) to answer the questions After you complete t

[answerhappygod]

Read The Case Study Nothcutt Bikes The Service Department Pp 362 363 To Answer The Questions After You Complete T 1 (69.74 KiB) Viewed 16 times

Read The Case Study Nothcutt Bikes The Service Department Pp 362 363 To Answer The Questions After You Complete T 2 (64.77 KiB) Viewed 16 times

Read The Case Study Nothcutt Bikes The Service Department Pp 362 363 To Answer The Questions After You Complete T 3 (15.67 KiB) Viewed 16 times

Read The Case Study Nothcutt Bikes The Service Department Pp 362 363 To Answer The Questions After You Complete T 4 (63.23 KiB) Viewed 16 times

Read The Case Study Nothcutt Bikes The Service Department Pp 362 363 To Answer The Questions After You Complete T 5 (18.56 KiB) Viewed 16 times

Read the case study, "Nothcutt Bikes: The Service Department" (pp. 362-363) to answer the questions After you complete the case study, please go to Brightspace (activities -> assignments -> case study) to submit your case study analysis. The file name should be "BUS343_Case study_your full name" For instance, "BUS343 Case study Yunsik Choi" QI (3 points). What problems does the company face? Even though there was plenty of inventory, the timing and quantities have been misplaced. Also, the space in the warehouse had increased from being 45% utilized to over 95% utilized and the service level was below 80%, Ann wants to aim for a 95% service level 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 25 29 30 31 32 33 34 35 36 Q2. Develop the forecasting models and find the forecasting accuracy. Q2-1 (3 points). Develop one exponential smoothing model (a-0.4) for FB378 theek I-week 26) and GS131 (week 11-week 267) (Keep two decimals) Q2-2 (4 points). Calculate FE, MAD, and tracking signals for the exponential smoothing model (a-04) for FB378 (week 2-week 26) and GS131 (week 12-week 26 (Keep two decimals) FB378 Forecast Error (FE) GS131 Actual demand Forecast MAD Forecast (0.4) 45.00 Tracking signal Weck 1 2 3 4 $ 6 Actual demand 45 44 33 39 45 30 26 45 33 33 30 40 31 42 Week 1 2 3 4 3 6 7 8 9 10 11 12 13 14 15 16 17 18 7 8 9 10 11 12 13 14 15 16 17 18 20:00 30 39 40 81 42 43 0 20 30 35 32 35 44 37 59 49 24 41
o Add Category Pivot Table Insert Table Chart Text Shape Media c G H K L M S131 (week 11-week 267). 4) for FB378 (week 2-week 26) and GS131 (week 12-week 26). GS131 Actual demand Forecast (a-0.4) Forecast Error (FE) MAD Tracking signal . 20.00 Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 30 35 52 55 44 57 59 46 60 59 60 58 66 SS 60
55 A 56 several questions (below) 57 03-1 (3 points) Determine if there is uptrend or downtrend from the actual demand of FB378 (week 1-26) and the actual demand of GS131. 58 (Show a scatter plot with a linear line for the relationship between weeks and the actual demand of FB378 and weeks and the acutal demand of GS131.) 59 A scatter plot(FB378) A scatter plot (GS131) 60 (Insert here) (Insert here) 61 52 Size
Q3-2 (2 points) Determine whether the two forecasting models (for FB378 and GS131) are performing normally or not. 24 (4 points). Use the available data to develop inventory policies such as EOQ and reorder point for the FB378 and GS131. Assume that the holding cost is 20% of u (Fill out the table to the inventory policies) (52 weeks per year) FB378 GS131 2 Annual demand: Annual demand: Annual holding cost, per unit: Annual holding cost, per unit: 4 Cost per order: Cost per order S Cost per unit Cost per unit: Economic order quantity: Economic order quantity: 32 18 Average order lead time: Average order lead time: 39 Standard deviation of lead time: Standard deviation of lead time: 00 Average demand during time unit Average demand during time unit 91 Standard deviation of demand during time unit Standard deviation of demand during time unit: 02 Percent desired service levels Percent desired service levels 03 z value (for desired service level) z value (for desired service level) 04 Reorder point Reorder point 95 0025 (4 points). Compare the inventory costs associated with your suggested order quantities (EOC) with those of the current order quantities. What can you conclude 07 Current order quantity Current order quantity OB Current annual holding Com Current annual holding cost 30 Current annual ordering cost: Current annual ordering cost 100 Total holding and ordering cost: Total holding and ordering cost: 101 102 Economic order quantity: Economic order quantity EOQ annual holding cost EOQ annual holding cost: 104 EO annual ordering cost: EOQ annual ordering costi 105 EOQ total holding and ordering cost: EOQ total holding and ordering cost 103
Pos 100 Q6 (3 points). How many orders (per year) should the company make with the current order quantity to meet the customer demands? 110 How many orders (per year) should the company make with EOQ to meet the customer demands? 111 (Assuming 365 days per year) What is the reorder period with the current order quantity? 112 (Assuming 365 days per year) What is the reorder period with EOQ? 113 114 07 (4 points). What are your suggestions to solve the current problem that the company is facing? (You need to answer the question within a minimum of 250 words) 115 Rota