The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Apr 2017 |
| Last Sign in: | 419 Weeks Ago, 1 Day Ago |
| Questions Answered: | 3232 |
| Tutorials Posted: | 3232 |
MBA,MCS,M.phil
Devry University
Jan-2008 - Jan-2011
MBA,MCS,M.Phil
Devry University
Feb-2000 - Jan-2004
Regional Manager
Abercrombie & Fitch.
Mar-2005 - Nov-2010
Regional Manager
Abercrombie & Fitch.
Jan-2005 - Jan-2008
Production Planning & Control
Master Production Scheduling and Available-to-Promise
Â
Georgia Clay and Gravel was updating the MPS record for one of its products, Smell Fresh Cat Litter.
Â
a.      Complete the following MPS time-phased record.
Â
|
 Smell Fresh   |
 On Hand |
 Week  |
|||||||
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
 8  |
||
|
 Forecast  |
20 |
20 |
20 |
30 |
30 |
30 |
30 |
30 |
|
|
 Orders  |
5 |
3 |
2 |
 |
 |
 |
 |
 |
|
|
 Projected available balance  |
20 |
50 |
30 |
10 |
30 |
50 |
20 |
40 |
10 |
|
 Available to promise  |
 |
 |
 |
 |
 |
 |
 |
 |
|
|
 MPS  |
50 |
 |
 |
50 |
50 |
 |
50 |
 |
|
MPS Lot Size = 50
Â
b.     The following events occurred in week 1:
·        Actual demand during week 1 was 10 units.
·        Marketing forecasted that 50 units would be needed for week 9.
·        An order for 12 in week 2 was accepted.
·        An order for 8 in week 3 was accepted.
·        An order for 25 in week 4 was accepted.
·        The MPS in week 1 was produced as planned.
Â
Update the record below after rolling through time.
Â
Â
Â
|
 Smell Fresh   |
 On Hand |
 Week  |
|||||||
|
2 |
3 |
4 |
5 |
6 |
7 |
8 |
 9  |
||
|
 Forecast  |
 |
 |
 |
 |
 |
 |
 |
 |
|
|
 Orders  |
 |
 |
 |
 |
 |
 |
 |
 |
|
|
 Projected available balance  |
60 (Hint) |
 |
 |
 |
 |
 |
 |
 |
 |
|
 Available to promise  |
 |
 |
 |
 |
 |
 |
 |
 |
|
|
 MPS  |
 |
 |
 |
 |
 |
 |
 |
 |
|
MPS Lot Size = 50
Â
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l