How do you do this step by step? Problem 21-16 (Algo)One unit of A is composed of two units of B and three units of C. Each B iscomposed of one unit of F. C is made of one unit of D, one unit of E, and twounits of F. Items A, B, C, and D have 32, 40, 36, and 25 units of on-handinventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique,while D, E, and F require multiples of 62, 120, and 90, respectively, to bepurchased. B has scheduled receipts of 15 units in Period 1. No otherscheduled receipts exist. Lead times are one period for Items A, B, and D, andtwo periods for Items C, E, and F. Gross requirements for A are 15 units inPeriod 1, 12 units in Period 2, 50 units in Period 6, and 50 units in Period 8.Find the planned order releases for all items. (Leave no cells blank - becertain to enter "0" wherever required.)Period2 3 4 56 7 8Gross requirementsItem AScheduled receiptsOH = 32Projected available balanceLT 1Net requirementsSS 0Planned order receiptsQ=L4LPlanned order releasesGross requirementsItem BScheduled receiptsOH = 40Projected available balanceLT = 1Net requirementsSS = 0Planned order receiptsQ= L4LPlanned order releasesGross requirementsItem CScheduled receiptsOH = 36Projected available balanceLT = 2Net requirementsSS = 0Planned order receiptsQ= L4LPlanned order releases Gross requirementsItem DScheduled receiptsOH = 25Projected available balanceLT = 1Net requirementsPlanned order receiptsSS = 0Q = 62Planned order releasesGross requirementsItem EScheduled receiptsOH = 0Projected available balanceLT = 2Net requirementsSS = 0Planned order receiptsQ = 120Planned order releasesGross requirementsItem FScheduled receiptsOH = 0Projected available balanceLT= 2Net requirementsSS 0Planned order receiptsQ= 90Planned order releases

One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 32, 40, 36, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 62, 120, and 90, respectively, to be purchased. B has scheduled receipts of 15 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 15 units in Period 1, 12 units in Period 2, 50 units in Period 6, and 50 units in Period 8. Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.)

One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 32, 40, 36, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 62, 120, and 90, respectively, to be purchased. B has scheduled receipts of 15 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 15 units in Period 1, 12 units in Period 2, 50 units in Period 6, and 50 units in Period 8. Find the planned order releases for all items. (Leave no cells blank - be certain to enter "0" wherever required.)

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Why top level Management require more conceptual skills?
What are the positive aspects of using an incremental approach?
What are the advantages of top down budgeting? Of bottom-up budgeting?
What are the easiest and hardest parts of brainstorming? And what brainstorming techniques do you use?
Could you go into a more detail on each of these?
If you are a project Project analyst intern Submit a 1-2 page final report describing what you did, what you learned, how you improved your skills and/or understanding, and how this externship/internship/volunteer or work experience has impacted your career goals.
what are the drawbacks or shortcomings commonly associated with the line organization structure ?
To what extent do the benefits of adopting an agile approach contrast with any potential drawbacks? If so, how much more so do you think they succeed than more traditional approaches? Give me your best guess as to why this would be the case.
How can a lack of proper planning lead to coordination issues within an organization?
What are succession plan strategies for a bank teller or customer service representative?
How would you characterise the most significant steps that go into the building of a system, and what steps do you believe to be the most crucial steps?
What is the stage of preparation? And what needs to be change if things are not working?