Can you assist me with Problem 5 One unit of A is made of two units of B, three units of C. and two units of D. B is composed of one unit of E and two units of F. Cismade of two units of F and one unit of D. E is made of two units of D. Items A. C. D. and F have one-week lead times; B and E havelead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D; lots of size 57 and 180 are used for Items E and F.respectively. Item C has an on-hand (beginning) inventory of 16: D has an on-hand inventory of 57; all other items have zero beginningInventory. We are scheduled to receive 16 units of Item E in Week 2: there are no other scheduled receipts.If 13 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned order releases for allcomponents. (Leave no cells blank - be certain to enter "0" wherever required.)bem AOH-0LT=1SS-0Q=LALem BOH-0LT=2SS=0em COH = 16LT=1SS=0Q=LALPeriodGross requirementsScheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releases1 2 3 4 5 6 7 8 Item COH = 16LT = 1SS=0Q=L4LItem EOH = 0|LT=2|SS=0Q = 57Item F|OH = 0LT = 1SS=0Q=180Item DOH = 57|LT=1SS=0Q=L4LGross requirementsScheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releasesGross requirementsScheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releases

One unit of A is made of two units of B, three units of C. and two units of D. B is composed of one unit of E and two units of F. Cis made of two units of F and one unit of D. E is made of two units of D. Items A. C. D. and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D: lots of size 57 and 180 are used for items and F. respectively. Item C has an on-hand (beginning) inventory of 16: D has an on-hand inventory of 57, all other items have zero beginning Inventory. We are scheduled to receive 16 units of Item E in Week 2: there are no other scheduled receipts. If 13 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned order releases for all components. (Leave no cells blank-be certain to enter "0" wherever required.) A OH-O LT=1 SS-0 Q-LEL Period Gross requirements Scheduled receipts Projected available balance Planned order receipts Planned order releases Gross requirements 1

One unit of A is made of two units of B, three units of C. and two units of D. B is composed of one unit of E and two units of F. Cis made of two units of F and one unit of D. E is made of two units of D. Items A. C. D. and F have one-week lead times; B and E have lead times of two weeks. Lot-for-lot (L4L) lot sizing is used for Items A, B, C, and D: lots of size 57 and 180 are used for items and F. respectively. Item C has an on-hand (beginning) inventory of 16: D has an on-hand inventory of 57, all other items have zero beginning Inventory. We are scheduled to receive 16 units of Item E in Week 2: there are no other scheduled receipts. If 13 units of A are required in Week 8, use the low-level-coded bill-of-materials to find the necessary planned order releases for all components. (Leave no cells blank-be certain to enter "0" wherever required.) A OH-O LT=1 SS-0 Q-LEL Period Gross requirements Scheduled receipts Projected available balance Planned order receipts Planned order releases Gross requirements 1

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

Economics MDOT recently widened I-55 from Miss. 302 in Southaven to Commerce Street in Hernando to relieve traffic congestion. The construction cost was $164 million. Annual maintenance is estimated at $1.25 million and every 10 years, the pavement surface will have to be milled off and replaced at an estimated cost of $12 million. This project is expected to save drivers approximately $60,000 per day in lost wages by alleviating travel delays. What is the benefit-cost ratio for this project if the life is assumed to be infinite and MDOT's cost of capital is 3% per year?
How does the model known as "software as a service" work?
Understand the characteristics of service processes?
QoS levels in response time, availability, and security may be used to evaluate the AIT Lemass's performance. Talk about ways to improve service in any of the assessed categories.
write a request for proposal for new EMR system
Write an essay titled "Here, There, and Everywhere" on the construction and hardware supply company FOUR ACES.
List 8 business functions that are used in the boat making game
Scenario 9.9"Gollee those cats sure go through a lot of food," Geoff exclaimed as he saw the shopping list pad that had been pre-printed with the words "cat food" at the top. He pondered a different approach to shopping for the furry little darlings, reviewed his shopping records, and discovered the following. The price of cat food has held steady at 89 cents per can. Despite feigning indifference, each of the seven cats nibbles their way through an average of one can per day, three hundred sixty five days a year. The price of gasoline has held constant at $3.50 per gallon and his pickup uses a gallon each way to the cat food store. The cost to hold a can of cat food is 10% of the unit price.Use the information in Scenario 9.9 to determine the average pantry space occupied by cat food if each can takes up 13 cubic inches and Geoff obeys an EOQ policy for managing the cat food purchase process.
Evaluate the role of service-level agreements (SLAs) in governing service interactions and quality of service in SOA.
Suggest how we could set the time between deliveries in a fixed period system.
hw4q1
Help enhance the service processes already in place.