Question: 4. Consider the following data for a product which is produced in lots of 300 (or multiples of 300) units. Assume that the beginning inventory

4. Consider the following data for a product

4. Consider the following data for a product which is produced in lots of 300 (or multiples of 300) units. Assume that the beginning inventory is 140. 1 100 110 2 100 80 3 100 50 Weeks 5 6 100 100 4 100 20 7 100 Forecast Orders 8 100 9 100 10 100 (a) Develop an MPS, and calculate the projected-on-hand (POH) quantities. (b) Calculate the available-to-promise (ATP) using the discrete (period-by-period) method. c) Calculate the available-to-promise (ATP) using the cumulative with look-ahead method. (d) Calculate the projected-on-hand (POH) using the consuming the forecast method and the assumption that orders are following their normal pattern (the original total forecast is still valid). (e) Calculate the projected-on-hand (POH) using the consuming the forecast method and the assumption that 30 units ordered in Week 8 are from a new customer. All other orders are following their normal pattern (the original total forecast must be increased). (1) Using the receipt of an additional order for 20 units in Week 8, calculate both the ATP (with look ahead) and the revised POH. (9) Consider the MPS results obtained in part (a). Suppose that the product is assembled in 250 units of batches in the final assembly department, and its lead time is 2 weeks. There is a scheduled receipt of 300 units in week 2. Note that the inventory at the beginning of week 1 is zero since it has been accounted for in the MPS calculations. Prepare an MRP record for the product and determine its planned order releases, assuming that (1) Safety stock for the assembled product in each week is zero. (i) Safety stock for the assembled product in each week is 15 units

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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 General Management Questions!

pls solve the all part clearly 4. Consider the following data for a product which is produced in lots of 300 (or multiples of 300) units. Assume that the beginning inventory is 140. Weeks 2 3 4 5 6 7...

pls just solve g part 4. Consider the following data for a product which is produced in lots of 300 (or multiples of 300) units. Assume that the beginning inventory is 140. Weeks 2 5 6 7 10 Forecast...

4. Consider the following data for a product which is produced in lots of 300 (or multiples of 300 units. Assume that the beginning inventory is 140. Weeks 1 2 3 4 5 6 7 8 9 10 Forecast 100 100 100...

Consider the following data for a product which is produced in lots of 300 (or multiples of 300) units. Assume that the beginning inventory is 140. 4 1 100 110 2 100 80 Weeks 5 6 100 100 3 100 50 7...

please answer quiz................ .................. ............... ......... Finance Quiz 1. What statement best describes the overall objectives of the finance function? A: Measuring financial...

True/False Indicate whether the statement is true orfalse. 1. Direct costs can be conveniently traced to a cost object. 2. All product costs are expensed in the period in which they are paid in cash....

15. One unit of A is made of two units of B and one unit of C. B is made of three units of D and one unit of F. C is composed of three units of B, one of D, and four units of E. D is made of one unit...

4 Consider the following data for two products of Vigano Manufacturing. (Round OH rate and cost per unit answers to 2 decimal places.) Number of units produced Direct labor cost (@$31 per DLH) Direct...

18. Product A is an end item and is made from two uits of B and four of C. B is made of three units of D and two of E. C is made of two units of F and two of E. A has lead time of one week. B, C, and...

Hydrogen peroxide is unstable and decomposes readily: 2H2O2(aq) 2H2O(l) + O2(g) This reaction is accelerated by light, heat, or a catalyst. (a) Explain why hydrogen peroxide sold in drugstores comes...

Human Resource is every managers business. Why is the management of human resources key to every management job in every organization, regardless of whether there is a human resources department in...

The bond angles in C O 3 2 - are expected to be a little less than 1 2 0 . a little more than 1 2 0 . a little less than 1 0 9 . 5 . 1 2 0 . 1 0 9 . 5 .

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...