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 are the positive aspects of using an incremental approach?
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?
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?
Can you achieve things primarily through hard work rather than creative ideas.
As anHRM, you have decided to ask for a raise. Provide three bullet points that you plan to share with your manager to support your request.
What is a plan that can be put in order?
Moving to a foreign country is not easy, no matter how many times you have done it or how receptive you are to new experiences. Successful global organisations can identify the best candidates for global assignments, and one of the ways they do this is through individual assessments prior to assigning people to global facilities. Form groups of 3 to 5 individuals. Your newly formed team, the Global Assignment Task Force, has been given the responsibility for developing a global aptitude assessment form for Zara, the successful European clothing retailer. The company is starting to become well known in North America and Zara’s managers have positioned the company for continued global success. That success is based on a simple principle- in fashion, nothing is as important as time to market. Zara store managers (more than 600 worldwide) offer suggestions every day on cuts, fabrics, and even new lines. After reviewing the ideas, a team at headquarters in A Coruna, Spain decides what to…
What is the Strategies and Tactics?
If I am launching a new product or opening a new location, what are some specific examples how these areas are related to the decision that the organization must make when deciding whether to move forward with this project.
If you could craft your ideal job, what would it look like? How would you describe the job to others such as colleagues, family, or friends? Be specific about the tasks in which you would be involved, the people with whom you would interact, the nature of the work (long- versus. short-term projects, individual versus team work, internal versus external customers, single versus multiple projects), your work schedule, travel requirements, reporting relationships, and the values of the organization. Use the following space to describe the job of your dreams. Job: Strictly within the Business Field