Question
6. 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
6. 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.
The following events occurred during week 1:
Actual demand during week 1 was 25 units.
Marketing forecasted that 40 units would be needed for week 9.
An order for 10 in week 2 was accepted.
An order for 20 in week 4 was accepted.
An order for 6 in week 3 was accepted.
The MPS in week 1 was produced as planned.
Please show work/formulas in Excel
a. Complete the following MPS time-phased record. MPS Lot Size =50. b. Update the record below after rolling through time. MPS Lot Size =50Step 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
Project Management A Managerial Approach
Authors: Jack R. Meredith, Samuel J. Mantel Jr.
8th edition
470533021, 978-0470533024
