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

Each Triam Deluxe gamer computer system consists of two speakers, a monitor, a system unit, a keyboard, and an installation kit. These pieces are packed together and shipped as a complete kit. In MRP terms, all of these items are level 1 items that make the level 0 kits. Complete the MRP records, using the following information: • Production plans for complete kits are as follows: Start assembling 4,500 kits in week 2 Start assembling 1,000 kits in weeks 3, 4, and 5 Start assembling 8,000 kits in week 6 • The gross requirements for the system unit have already been given to you. For the remaining items, you will need to figure out the gross requirements. • All scheduled receipts, lead times, and beginning inventory levels are shown. Click the icon to view the MRP records. Construct the material requirements plan for item System unit (enter your responses as whole numbers). System unit: Lead Time = 1 week; Minimum order quantity = 3,500 Week 1 2 3 Gross requirements 4,500 1,000…
Customer says: “Fifteen cases 4 points of olives will take up valuable space in my receiving room. It is already crowded."Salesperson says: “You will not have to face that problem. With the aid of our merchandising plan, you can display 10 cases immediately on the sales floor. Only five cases will become reserve stock. You should move all 15 cases in about two weeks."What methods of negotiation are being addressed in this scenario? * Direct Denial/Superior Benefit. O Indirect Denial/Third-party Testimony. Question/Trial offer. Superior Benefit/Postpone Method
Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Q = 60, LT= 3 weeks, Safety Stock = 5 1 70 70 PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Planned Order Releases 1 70 70 100 2 0 > X WEEK 3 40 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". 2 0 4 0 100 WEEK 3 40 5 160 60 4 0 40 0 X 5 160 Check My Work -60 0
Ordering of goods or materials in a way that they are delivered to the factory without storage Explain?
Cycle counting is conducted more frequently for C items since they are less costly and easy to count > true or false?
Assume that you are the manager of Assembly, Inc. You have just received an order for 40 units ofan industrial robot, which is to be delivered at the start of week 7 of your schedule. Using the following information, determine how many units of subassembly G to order and the timing of thoseorders, given that subassembly G must be ordered in multiples of 80 units and all other componentsare ordered lot-for-lot. Assume that the components are used only for this particular robot.Item Lead Time (weeks) On Hand ComponentsRobot 2 10 B, G, C(3)B 1 5 E, FC 1 20 G(2), HE 2 4 —F 3 8 —G 2 15 —H 1 10 —
If a work order instructs you to package 620 boxes of product and each product contains 2 bags of 50 sheets of film, how many sheets of film will need to be produced?
Net requirements =a) Gross requirements + Allocations − On-hand inventory+ Scheduled receipts.b) Gross requirements − Allocations − On-hand inventory −Scheduled receipts.c) Gross requirements − Allocations − On-hand inventory+ Scheduled receipts.d) Gross requirements + Allocations − On-hand inventory −Scheduled receipts.
Problem 16-12 (Algo) Your company assembles five different models of a motor scooter that is sold in specialty stores in the United States. The company uses the same engine for all five models. You have been given the assignment of choosing a supplier for these engines for the coming year. Due to the size of your warehouse and other administrative restrictions, you must order the engines In lot sizes of 700 units. Because of the unique characteristics of the engine, special tooling is needed during the manufacturing process for which you agree to reimburse the supplier. Your assistant has obtained quotes from two reliable engine suppliers and you need to decide which to use. The following data have been collected: Requirements (annual forecast) Weight per engine Order processing cost Inventory carry cost ORDER QUANTITY 1 to 1,499 units/order 1,500 to 2,999 units/order 3,000+ units/order Note: Assume that half of lot size is in Inventory on average (700/2=350 units). Two qualified…
Why is accurate inventory such an important issue at Wheeled Coach?
Discuss why order-point systems aren’t compatible with MRP
Read the email and write a short paragraph as a resale (around 50 - 70 words). Specify if it would be 1st, 2nd, 3rd or 4th paragraph. Write a number before the paragraph. For example: "1st As I fully understand..." Subject: Late Delivery and Damaged/Missing Products Dear SuperSonic Customer Support Team, I am writing to express my deep dissatisfaction with the recent order I placed through your Kuwait website. Unfortunately, I have encountered multiple issues, including a significant delay in delivery, a damaged product, and a missing item. On October 12th, I made a purchase for a tablet pc and a charger both of which were expected to be delivered promptly. However, I have yet to receive the tracking number email, even though the items have already been delivered. Furthermore, the delivery itself was delayed by two weeks, causing inconvenience and frustration. To my dismay, upon receiving the package, I discovered that the tablet pc had a visible crack running down the middle (refer to…