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

What can't be done online?
Can you achieve things primarily through hard work rather than creative ideas.
Explain the concept of "business continuity maturity" and how it relates to plan effectiveness.
what does it mean if, while doing a swot analysis, an organization cannot identify any opportunities? what if it can't identify any threats ?
Why is brainstorming helpful in engineering financial decisions? What are some tools that are helpful to use?
what is the solutions to the debt problems of the organization, layoffs and freezing salaries?
How do organizations balance the need for automation with human labor in production management?
Of what value would it be to know that you were going to be training a class of persons between the ages of 20 and 35? What suggestions would you make to the instructor or trainer as to how to better teach the course given the generations represented in the class? Would this affect your design or delivery method? Why or why not?
Is coordination is important for the management.do you agree? Give reasons
You have recently been awarded funds to set up a large sized bakery. With specific references to the bakery, describe the managerial activities you are likely to undertake while running the business.
Please do not copy and paste from online or printed resources, instead use your own words. Scenario: You work for B&B Import and Export Incorporated, who just acquired a new business, Agro Smart Suppliers, a Canadian distributor of outdoor power equipment such as trimmers, chainsaws, blowers, mowers, log splitters, pressure washers, parts and accessories. As a new division of B&B, your manager has given you the task of laying out a road map to success from an operations management and supply chain perspective?
What kinds of obstacles does the organisation experience when it tries to recruit employees from different backgrounds? Explain the idea to me in as much detail as you can.