Question: Consider the MPS record below Wk 1 2 3 4 5 6 Forecast 15 25 9 15 22 5 Orders 7 10 10 10 Available

Consider the MPS record below 

 Wk     
 123456 
Forecast1525915225
Orders7101010  
Available      
ATP      
MPS      

On hand = 5, Lot size = 30

a. Complete the MPS record

b. Update the record from part a

- Actual demand (order) in week 1 was 25

- An additional order of 5 units was placed in week 3

- An order of 25 units was placed in week 5

c. If the MPS record require safety stock = 1, are there any change on the MPS record in part b?

Step by Step Solution

★★★★★

3.40 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Week 1 2 3 4 5 6 Forecast 15 25 9 15 22 5 Order 7 10 10 10 0 0 Available invento... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemistry Questions!

Q:

Consider the following time series: t 1 2 3 4 5 6 7 yt 120 110 100 96 94 92 88 A. Construct a time series plot. What type of pattern exists in the data? B. Use excel solver or lingo to find the...

Q:

Determine CPI, ETC (1), and EAC. Activity Total PV 1 2 3 4 5 6 7 8 9 10 11 12 13 14 1 6 6 2 20 10 10 3 30 9 6 6 6 3 4 20 8 2 5 5 5 16 4 4 4 4 6 18 9 9 7 8 4 4 Status Report: Ending Period 5 Task %...

Q:

(1) Given A and i. (1a) Find the equivalent amount at the end of year 1. (1b) Find the equilvalent amount at the end of year B. (2) Given X and i, Find the annual equivalent A from year S to 8. *...

Q:

4. Measuring the Forecast Accuracy for Monthly Data. Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 a. Compute MSE...

Q:

1. Consider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of...

Q:

3.2. The Shades Sunglass Company assembles sunglasses from frames, which it makes, and lenses, which it purchases from an outside supplier. The sales department has prepared the following 6-week...

Q:

The Shades Sunglass Company assembles sunglasses from frames, which it makes, and lenses, which it purchases from an outside supplier. The sales department has prepared the following 6-week forecast...

Q:

5. The XYZ Companys finance manager is currently studying projected inventory investment for product 101 at the central (plant) warehouse. Quantities of product 101 are shipped from the central...

Q:

12. Consider the following MRP record: Week 1 2 3 4 5 6 Gross requirements 25 30 5 15 5 10 Scheduled receipts 50 15 Projected available balance 35 10 30 25 10 20 10 Planned order releases Q =...

Q:

The state of Michigan generates a three-digit number at random twice a day, seven days a week for its Daily 3 game. The numbers are generated one digit at a time. Consider the following set of 50...

Q:

Where does the land breeze take place? Options: 1) Near large water bodies 2) Near large ground 3) Everywhere 4) None of these

Q:

Write a paper in which you need to address the following: Section 1: Customer Relationship Management Read the article The Best CRM Software of 2017, by Rob Marvin and Molly McLaughlin, PC Magazine,...

Q:

A materials - requisition record is an example of a source document.

Q:

The following facts pertain to a non-cancelable lease agreement between Lennox Leasing Company and Gill Company, a lessee. The Collectibility of the lease payments is reasonably predictable, and...

Q:

Equivalent units, zero beginning inventory. Nihon, Inc. is a manufacturer of digital cameras. It has two departments: Assembly and Testing. In January 2009, the company incurred $750,000 on direct...

Q:

Weighted-average method, assigning costs. Bio Doc Corporation is a biotech company based in Milpitas. It makes a cancer-treatment drug in a single processing department. Direct materials are added at...

Q:

The following information concerns production in the Baking Department for March. All direct materials are placed in process at the beginning of production. a. Determine the number of units in work...

Q:

Ermler Corporation has the following accounts at December 31: Common Stock, $10 par, 5,000 shares issued, $50,000; Paid-in Capital in Excess of Par Value $20,000; Retained Earnings $45,000; and...

Q:

What is the purpose of sampling? What are some concerns and dangers of sampling? How important is the sample design to data validity? Explain. Provide an example where a sample might misrepresent...

Q:

If the coupon rate on a bond is 8 percent and current market interest rates are 6 percent, should this bond be selling at a premium or a discount?

Q:

If a firm does not provide for accrued liabilities, what problems may the firm face?

Q:

Calculate the Economic Order Quantity, or EOQ, for exercise 8 if annual demand is 10,000 thousand units, inventory storage costs average 20 percent, unit price is $50, and ordering costs are $30.

Q:

4.26. Five students, Ann, Betty, Clint, Douglas, and Edward, arc rated equally qualified for admission to law school, ahead of other applicants. However, all but two positions have been filled for...

Q:

4.20. For 5459 pregnant women using Aarhus University Hospital in Denmark in a two-year period who reported information on length of gestation until birth, the mean was 281.9 days, with standard...

Q:

4.21. Suppose that the weekly use of gasoline for motor travel by adults in North America is approximately normally distributed, with a mean of 16 gallons and a standard deviation of 5 gallons. (a)...