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: | 452 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