Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Projected Vehicle Sales CY24 Vehicles Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 CY24 Fatbob 534 539 774 580 562 427
Projected Vehicle Sales CY24 | |||||||||||||
Vehicles | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | CY24 |
Fatbob | 534 | 539 | 774 | 580 | 562 | 427 | 613 | 692 | 651 | 253 | 570 | 454 | 6,649 |
Low rider | 67 | 38 | 47 | 62 | 93 | 121 | 101 | 58 | 68 | 69 | 41 | 54 | 819 |
Breakout | 101 | 79 | 218 | 247 | 254 | 182 | 140 | 127 | 146 | 67 | 105 | 134 | 1,800 |
Total | 601 | 577 | 821 | 642 | 655 | 548 | 714 | 750 | 719 | 322 | 611 | 508 | 7,468 |
Parts Information | ||||
Part Number | Source | Models | Install Rate | Lead Time (Months) |
P1 | S 1 | Fatbob | 30% | 1 |
P2 | S 1 | fatbob, low rider | 30%, 42% | 2 |
P3 | S 2 | low rider | 80% | 1 |
P4 | S 2 | Breakout | 75% | 2 |
P5 | S 3 | Fatbob, Break out | 60%, 100% | 3 |
Forecast | |||||||||||||||
Source | Parts Number | Oct-23 | Nov-23 | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 |
Supplier 1 | P1 | 161 | 162 | 233 | 174 | 169 | 129 | 184 | 208 | 196 | 76 | 171 | 137 | ||
Supplier 1 | P2 | 190 | 178 | 253 | 201 | 209 | 180 | 227 | 233 | 225 | 105 | 189 | 160 | ||
Supplier 2 | P3 | 54 | 31 | 38 | 50 | 75 | 97 | 81 | 47 | 55 | 56 | 33 | 44 | ||
Supplier 2 | P4 | 76 | 60 | 164 | 186 | 191 | 137 | 105 | 96 | 110 | 51 | 79 | 101 | ||
Supplier 3 | P5 | 403 | 683 | 595 | 592 | 439 | 508 | 543 | 537 | 219 | 447 | 407 |
Can you find me the safety stock for each part that should be maintained?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started