I need last 2 questions please Consider the bill of material for a product, A, and the data given in the table that follows. The gross requirements for A are150 units in week 5 and 200 units in week 8.Item Lead-Time (weeks) On hand quantityABCA. 60 unitsB. 200 unitsC. 90 unitsD. 100 unitsA. 50 unitsB. 10 unitsOC. 40 unitsD. 210 unitsB(1)121What is the planned order release for product A in week four?A. 210 unitsB. 200 unitsC. 170 unitsD. 240 units60400What is the projected on hand inventory for component B in week eight?A. 400 unitsB. 0 unitsC. 480 unitsOD. 140 unitsALot sizeLot-For-Lot60120What is the planned order receipt for component B in week seven?A. 220 unitsB. 120 unitsOC. 140 unitsD. 0 unitsWhat is the gross requirement for component C in week five?What is the planned order receipt for component C in week four?C(1)

To be determined: solve the last 2 MCQ's with the help of given infomation. Answer to last 2 parts:…

Answered: Consider the bill of material for a…

Consider the bill of material for a product, A, and the data given in the table that follows. The gross requirements for A are 150 units in week 5 and 200 units in week 8. B(1) C(2) C(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

Given the following partial product tree, explode, offset, and determine the gross andnet requirements for components H, I, J, and K. There are other components, but theyare not connected to this problem. The quantities required are shown in parentheses.The master production schedule calls for the completion of 60 Hs in week 3 and 80 inweek 5. There is a scheduled receipt of 120 Is in week 2. There are 400 Js and 400 Ksavailable. All lot sizes are lot-for-lot
Item4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 eBookReferences Item 4 Time Remaining 2 hours 53 minutes 2 seconds 02:53:02 The production planner for a private label soft drink maker is planning the production of two soft drinks: root beer (R) and sassafras soda (S). There are at most 12 hours per day of production time and 1,500 gallons per day of carbonated water available. A case of root beer requires 2 minutes of time and 5 gallons of water to produce, while a case of sassafras soda requires 3 minutes of time and 5 gallons of water. Profits for the root beer are $6.00 per case, and profits for the sassafras soda are $4.00 per case. The firm’s goal is to maximize profits. What is the time constraint? rev: 09_21_2020_QC_CS-229783 Multiple Choice 5R + 5S ≤ 720. 3R + 5S ≤ 720. 2R + 5S ≤ 720. 3R + 2S ≤ 720. 2R + 3S ≤ 720.
Courtney Kamauf schedules production of a popular Rustic Coffee Table at Kamauf Enterprises, Inc. The tablerequires a top, four legs, 18 gallon of stain, 116 gallon of glue, 2 shortbraces between the legs and 2 long braces between the legs, anda brass cap that goes on the bottom of each leg. She has 100 gallons of glue in inventory, but none of the other components. Allitems except the brass caps, stain, and glue are ordered on a lotfor-lot basis. The caps are purchased in quantities of 1,000, stainand glue by the gallon. Lead time is 1 day for each item. Schedulethe order releases necessary to produce 640 coffee tables on days5 and 6, and 128 on days 7 and 8.
If the forecasted demand for the end item is the same each period, will the EOQformula result in optimal lot sizing at each level of the product structure?Explain
A product (A) consists of a base (B) and a casting (C). The base consists of a plate(P) and three fasteners (F). The lead time, current on-hand inventory and scheduledreceipts are given in the table below. All components are lot for lot. The MasterSchedule requires 100 units of product A be available in week 4 and 150 in week 6. Part Lead time On - Hand inventory Scheduled receipts A 1 20 None B 1 100 50 in Week 1 C 3 30 20 in Week 1, 30 in Week 2 P 2 0 50 in Week 1 F 3 0 30 in Week 1, 40 in Week 3 Required:A. Draw the product structure tree. B. Develop the MRP for Parts A, B, C, P, and F in order to meet the demand. Therows for MRP tables are Gross Requirement (GR), Scheduled Receipt (SR),On-Hand Inventory (OHI), Net Requirement (NR), and Planned Production (PP).
Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 8. Assume lot-for- lot ordering. Below is information about the steppers and the quantity required for each parent. Item Lead Time On Hand Inventory Components Stepper 2 20 A(1), B(3), C(2) A 1 10 D(1), F(2) B 2 30 E(1), F(3) C 3 10 D(2), E(3) D 1 15 E 2 5 F 2 20 Develop a product structure diagram for Develop a net material requirements plan for
A linear programming computer package is needed. Greenville Cabinets received a contract to produce cabinets for a major furniture distributor. The contract calls for the production of 3,300 small cabinets and 4,100 large over the next two months, with the following delivery schedule Model Month 1 Month 2 Small 2,100 1,200 Large 1,500 2,600 Greenville estimates that the production time for each small cabinet is 0.7 hours and the production time for each large cabinet is 1 hour. The raw material costs are $10 for each small cabinet and $12 for each large cabinet. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2,400 hours of regular production time available each month and up to 1,000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet. For each product, determine the number of units that should be…
1. RBF, an emerging singer, is getting ready to cut his first album. The cost of recordingthe CD is Php 500,000 but copies are Php 500 apiece. If the album can be sold forPhp1,500 each, (a) how many CDs must be sold to break even? (b)What is thebreakeven point in dollars?RBF is confident that demand for his album will substantially exceed the break-evenpoint computed above. So, Mikey is contemplating having his album at a classier (andpricier) studio. The cost to record the CD would rise to Php 90,000. However, since thisnew studio works with very high volume, production costs would fall to Php 200 per CD.(c) What is the breakeven point for this new process?(d) Compare this process to the process proposed in the pre SHOW COMPLETE SOLUTION.
Consider the product structure diagram given. Assume that the MPS for the end item for weeks 10 through 17 isWeek 10 11 12 13 14 15 16 17Net requirements 100 100 40 40 100 200 200 200Assume that lot-for-lot scheduling is used throughout. Also assume that there is no entering inventory in period 10 and no scheduled receipts. For the example given above, assume that the setup cost for both components A and B is $100 and that the holding costs are respectively $0.15 and $0.25 per component per week. Using the Silver–Meal algorithm, determine the planned order releases for both components A and B and the resulting gross requirements schedules for components C, D, and E.
The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead timefor A is three weeks and setup cost is $10. There is a carrying cost of $0.01 per unit perweek. Beginning inventory is 90 units.Week1 2 3 4 5 6 7 8 9 10Gross requirements 30 50 10 20 70 80 20 60 200 50Use the least total cost or the least unit cost lot-sizing method to determine when and forwhat quantity the i rst order should be released.
A firm has the following gross requirements for Item F. If ordering costs are $60 per order and carrying costs are $0.50 per period. If Mult. 60 lot sizing is used, the planned order releases is Group of answer choices 60 in period 2 and 80 in period 3 120 in period 2 and 60 in period 3 80 in period 1 and 0 in period 3 0 in period 1 and 40 in period 3
Electro Fans has just received an order for one thousand 20˝ fans due in week 7. Each fan consists of a housing assembly, two grills and a fan assembly. The housing assembly consists of a frame, two supports and a handle. The following table gives lead times, on-hand inventory, and scheduled receipts. Table 1.1: Lead time and quantity on hand Item Lead Time Qty on hand Lot size# Scheduled receipt 20˝ Fan Housing Frame Supports (2) Handle Grills (2) Fan Assembly 1 1 2 1 1 2 3 80 90 - 50 400 200* 150 - - - 100 400 450 - 50 fan assembly in week 2 * In week 3 it was found that 50% of the on hand inventory of the grills was damaged. # Items without any lot size given should be considered as lot-for-lot. (i) Construct a product structure. (ii) Construct a time-phased product structure. (iii) Prepare a net requirement plan.