At present, there are 60 units of an end item in inventory. Order policy is fixed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
At present, there are 60 units of an end item in inventory. Order policy is fixed at 125 units. Complete the MPS record in the Figure below for this end item. (Use a replicate of the Table presented below, fill it out, then respond to all the following questions related to this MPS Table) Item: A / Order Policy: 125 units Lead Time: 1 week Quantity On Hand: 60 Forecast Customer orders (booked) Projected on-hand inventory. MPS quantity 1 10 15 2 15 10 3 20 14 4 30 10 5 40 5 Week 6 60 10 7 80 5 8 120 10 9 120 5 10 120 5 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start Available-to- promise (ATP) inventory 10 15 15 Answer 10 20 14 30 10 What is the projected on-hand inventory in Week 1? Your Answer: 40 5 60 10 80 5 120 10 120 5 120 5 What is the projected on-hand inventory in Week 4? Your Answer: Answer What is the projected on-hand inventory in Week 6? Your Answer: Answer What is the projected on-hand inventory in Week 9? Your Answer: Answer What is the MPS quantity in Week 5? Your Answer: Answer What is the MPS quantity in Week 7? Your Answer: Answer What is the MPS start in Week 3? Your Answer: Answer What is the MPS start in Week 5? Your Answer: Answer At present, there are 60 units of an end item in inventory. Order policy is fixed at 125 units. Complete the MPS record in the Figure below for this end item. (Use a replicate of the Table presented below, fill it out, then respond to all the following questions related to this MPS Table) Item: A / Order Policy: 125 units Lead Time: 1 week Quantity On Hand: 60 Forecast Customer orders (booked) Projected on-hand inventory. MPS quantity 1 10 15 2 15 10 3 20 14 4 30 10 5 40 5 Week 6 60 10 7 80 5 8 120 10 9 120 5 10 120 5 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start Available-to- promise (ATP) inventory 10 15 15 Answer 10 20 14 30 10 What is the projected on-hand inventory in Week 1? Your Answer: 40 5 60 10 80 5 120 10 120 5 120 5 What is the projected on-hand inventory in Week 4? Your Answer: Answer What is the projected on-hand inventory in Week 6? Your Answer: Answer What is the projected on-hand inventory in Week 9? Your Answer: Answer What is the MPS quantity in Week 5? Your Answer: Answer What is the MPS quantity in Week 7? Your Answer: Answer What is the MPS start in Week 3? Your Answer: Answer What is the MPS start in Week 5? Your Answer: Answer
Expert Answer:
Answer rating: 100% (QA)
To complete the MPS record table Item A Order Policy 125 units Lead Time 1 week Week Quantity On Han... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these general management questions
-
Eminent financial economist John Cochrane notes that the evidence shows that "high valuations are, on average, followed by many years of poor returns, and vice versa. High valuations are not, on...
-
Complete the MPS record shown in Figure for a singleitem. Item: A Order Pollcy: 100 units Lead Time: 1 week January February Quantity 75 on Hand: Forecast 65 65 6 45 50 505050 Customer orders booked...
-
Digger Exploration Inc., a regional oil and gas company, is headquartered in Butte, America. The Company operates properties in Montana, North Dakota, Wyoming, and Colorado. The Companys current...
-
A company has the following results for the three years to 31 March 2021: Assuming that the trading loss is carried forward and that maximum loss relief is taken as soon as possible, calculate the...
-
Galati Manufacturing had a bad year in 2005. For the first time in its history it operated at a loss. The company's income statement showed the following results from selling 60,000 units of product:...
-
Briefly describe the major characteristics of the following group disability-income plans: a. Short-term disability-income plans b. Long-term disability-income plans
-
(NPV and IRR) You are considering a project whose cash flows are given below: a. Calculate the present value of the future cash flows of the project. b. Calculate the projects net present value. c....
-
Lisali Company gathered the following information related to inventory that it owned on December 31, 2011: Historical cost ......... $100,000 Replacement cost ....... 95,000 Net realizable value...
-
This information is available for Bramble's Photo Corporation for 2 0 2 0 , 2 0 2 1 , and 2 0 2 2 . \ table [ [ , 2 0 2 0 , 2 0 2 1 , 2 0 2 2 ] , [ Beginning inventory.,$ 1 2 0 , 0 0 0 , $ 3 1 6 , 0...
-
1. This family business has made numerous transitions. It started as two brothers and their wives (Whitehall), then became a husband and wife team (Judds Hill), and finally parents with their son and...
-
13. The volume of a spherical object is given by the function V(r) = amr, where r is the radius of the object. Suppose at the moment the radius is 4 cm, and the radius is growing at a rate of 0.78125...
-
Let 7u + 8v g(u, v) Find a g(u, v) Quv uv2 at the point (u,v) = (4,5).
-
Coronado Company lends Wildhorse Company $9600 on April 1, accepting a four-month, 8% interest note. Coronado Company prepares financial statements on April 30. What adjusting entry should be made...
-
Trying to figure out the cost benefit analysis for Kerdall Paper Co. Cost-Benefit Analysis Benefit/Savings 25% likely 50% likely 75% likely Present Value (at 20%) of Possible Litigation Cost to...
-
Using the CAPM formula listed below: Required rate of return = ERI=Rf+i(ERM-Rf) where:ERi-expected return of investment Rf=risk-free rate Bi-beta of the investment (ERm-Rf)=market risk premium...
-
Following are the issuances of stock transactions. 1. A corporation issued 8,000 shares of $30 par value common stock for $288,000 cash. 2. A corporation issued 4,000 shares of no-par common stock to...
-
Operating Inputs........... Soybean seed Units............ Price.. Quantity.. Value Lbs. 0.250 45.00 $11.25 Nitrogen (N) Lbs...... 0.250. 15.00 3.75 Phosphate (P205) Lbs. 0.110 40.00 4.40 Potash...
-
If a test has high reliability. O the test measures what the authors of the test claim it measures O people who take the same test twice get approximately the same scores both times O scores on the...
-
Design a survey form of your own. Fill it out as it might have been completed during the database design forHenry Books. For any questions you have too little information to answer, make a reasonable...
-
How do you create a one-to-many relationship in a database system?
-
What is a sub query? When is a sub query executed?
-
The amount that will be accumulated in the future when a series of payments is invested and accrues interest until the future time. True/false
-
The amount that will be accumulated in the future when one amount is invested at the present time and accrues interest until the future time. True/false
-
Credit Terms You receive an invoice from a supplier for $5,000 on January 1 with terms 3/15, net 30. If you pay between January 1 and January 16, how much must you pay? If you pay after January 16,...
Study smarter with the SolutionInn App