Kindly answer b, c and d for me. Clearly showing how the number are coming into existence. Thank you The table below gives the gross requirements for the final products A and B during the last sixweeks. Each unit of A uses three units of C and each unit of B uses three units of C. Each unitof C uses four units of D. Assume that A and B can be produced in zero time once enough C isavailable. The lead-time for both Cand Dis one week. At the beginning of Week 1, 120 units ofC and 160 units of D are on hand. 50 units of C and 80 units of D are scheduled to be receivedat the beginning of week 2. The average weekly demand for D is 100units. The cost perproduction run is $200, and the cost of holding one unit in inventory for one week is $4.WEEK420301020B10301010Determine the MRP record for D using:a)b)c)d)POQ (P=2)EOQ Lot sizing methodPart-period balancing lot-sizing is usedWhich method is the most cost effective?

Small Introduction about MRP Fabric prerequisites arranging (MRP) may be a computer-based stock…

Answered: Determine the MRP record for D using:…

Determine the MRP record for D using: a) POQ (P=2) b) EOQ Lot sizing method c) Part-period balancing lot-sizing is used d) Which method is the most cost effective?

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

Management realized that the optimal product mix, taking setup costs into account, might be different from the one recommended in part (b). Formulate a mixed-integer linear program that takes setup costs provided in part (c) into account. Management also stated that we should not consider making more than 175 units of product 1, 150 units of product 2, or 140 units of product 3. What are the new objective function and additional equation constraints? If the constant is "1" it must be entered in the box. Let Yi is one if any quantity of product i is produced and zero otherwise. Max $ P1 + $ P2 + $ P3 - $ Y1 - $ Y2 - $ Y3 s.t. P1 Y1 P2 Y2 P3 Y3 P1, P2, P3 ≥ 0 (e) Solve the mixed-integer linear program formulated in part (d). How much of each product should be produced and what is the projected total profit contribution? Compare this profit contribution to…
Management realized that the optimal product mix, taking setup costs into account, might be different from the one recommended in part (b). Formulate a mixed-integer linear program that takes setup costs provided in part (c) into account. Management also stated that we should not consider making more than 175 units of product 1, 150 units of product 2, or 140 units of product 3. What are the new objective function and additional equation constraints? If the constant is "1" it must be entered in the box. Let Yi is one if any quantity of product i is produced and zero otherwise. Max $ P1 + $ P2 + $ P3 - $ Y1 - $ Y2 - $ Y3 s.t. P1 Y1 P2 Y2 P3 Y3 P1, P2, P3 ≥ 0 and integer (e) Solve the mixed-integer linear program formulated in part (d). How much of each product should be produced and what is the projected total profit contribution? Compare this profit contribution…
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: units (enter your response as a whole number). Spring: units Clamp: units Housing: units Handle units Casting: units Bearing: units Shaft: units
If mixed model scheduling is used, how many of each model will be produced before the cycle is repeated, if the master production schedule calls for 55 units of product A, 40 units of product B, and 20 units of product C per seven-hour shift? Group of answer choices 5 of A, 5 of B, 5 of C 11 of A, 8 of B, 4 of C 22 of A, 16 of B, 8 of C 55 of A, 50 of B, 20 of C Please do fast ASAP
It is Monday morning, and you have just arrived at work. Complete the followingMRP record as it would appear Monday morning. Lead time is 2 weeks, and the lotsize is 100. During the week, the following events occur. Enter them in the MRP record.a. The planned order for 100 in week 1 is released.b. Thirty of the scheduled receipts for week 1 are scrapped.c. An order for 30 is received for delivery in week 3.d. An order for 50 is received for delivery in week 6.e. The gross requirements of 70 in week 1 are issued.
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
Which of the following best describes the last step to developing a master production schedule? a.Check preliminary MPS against available capacity b.Design a preliminary MPS c.Resolve differences between the preliminary MPS and available capacity d.Check the MPS against the production plan to ensure they match
Anticipated demands for a four-period planning horizon are 23, 86, 40, and 12.The setup cost is $300 and the holding cost is h = $3 per unit per period.a. Enumerate all the exact requirements policies, compute the holding and setupcosts for each, and find the optimal production plan.b. Solve the problem by backward dynamic programming
Terry, Inc., makes gasoline storage tanks. All production is done under contract. The company makes three basic models, but each model must be adapted to customer specifications for the location of outlets, insulation, and paint. It takes from three to six months to complete a tank. How should Terry account for the income for the business?
KSK Company produces backpacks. The company's operations manager, Mehmet Akbalcık, would like to try alternative batch production plans using the data below. Costs Labor cost ($/hour) $12.00 Contract cost ($/piece) $90.00 Retention cost ($/unit-month) $10.00 Hiring cost ($/worker) $500.00 Layoff cost ($/employee) $600.00 Capacity data Current number of workers 200 workers Initial inventory (early January) 300 pieces Labor hours required for a product (product/hour) 5 hours Monthly working hours (employees/month) 160 hours Demand forecasts (units) January 4800 February 5200 March 8500 April 6500 May 4500 June 6200 In the light of these data, apply the following 2 alternative plans by creating tables. Indicate which plan should be preferred. a) Adjusting the labor level each month to produce to meet net demand (Demand monitoring strategy). Contract manufacturing…
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 125 units. The following is the BOM in indented form: ITEM DESCRIPTION USAGE X Bracket assembly 1 A Wall board 4 B Hanger subassembly 2 D Hanger casting 4 E Ceramic knob 1 C Rivet head screw 3 F Metal tong 4 G Plastic cap 2 Below is a table indicating current inventory levels: Item X A B C D E F G Inventory 22 15 75 24 202 139 1,000 95 What are the Net Requirements for X, A, B, and C respectively?
List the system of inequalities which describe B in the graph below.ECON1003 Mathematics for Social Sciences Unit 3_Version 1 Page 33 6. Anya’s Jeans has production process organized in threedistinct stages: cutting; sewing and finishing. She produces threetypes of jeans, namely peddle-pushers, hipsters and low cuts. Thenumber of minutes each type requires in each production processin shown below.Type Cutting Sewing FinishingPeddle-Pusher 4 6 2Hipster 6 7 4Low Rider 9 3 6On average, there are 6400 minutes of cutting time, 3500 minutes ofsewing time and 2400 minutes of finishing time each day. Given thatthe company makes $10 profit on each peddle-pusher $ 50 on eachhipster and $60 on each low cut and that the company sells all thejeans made. List the system of inequalities for the cutting, sewingand finishing constraints.