please solve the question. A company has to delivery its product with the following week wise schedule.| 7Week123458Qty1101001305020013590Given thatItem cost per unit = $25Setup cost per order = $100Inventory cost per year = 20% of cost of item.Beginning inventory= 0Propose an MRP Schedule under each rule of lot sizing. Which one you willrecommend and why?%3D

1) Average weekly demand, D =110+100+130+50+200+0+135+908= 101.9 Setup cost, S = $100 Holding cost…

Answered: A company has to delivery its product…

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

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.
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based onc. Part period balancing
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 —
1. Which of the following statements about lot-sizing rules for MRP is true? a) The periodic order quantity (POQ) rule generates a higher level of average inventory since it creates inventory remnants. b) FOQ is a dynamic lot-sizing rule which reduces the amount of inventory, by doing a better job of matching the order quantity to the projected on-hand inventory quantity. c) The lot for lot rule minimizes inventory investment but maximizes the number of orders placed. d) In general, static lot-sizing rules introduce greater instability into the production process 2. Which one of the following is a reason to have small inventories? a) To improve customer service b) To reduce ordering costs c) To reduce equipment setup costs d) To reduce interest expense or opportunity costs 3. Which one of the following is the most likely example of dependent demand for an MRP controlled item? a) Demand for spare parts b) Demand directly from customers c) Demand from quality control department for…
help me teacher please a) (10 pts) BBOT UTE Company produces a product “A”. Below you can find the BOM (with number of units per parent given in the parenthesis next to the subcomponent code), lead times, demand for Product-A, beginning inventory and scheduled receipts for “A” and all sub components. Determine the planned order release for A, B and C. Assume a lot for lot scheduling rule. FİLL IN THE CS Q1.Table1 COMPLETELY for A, B and C. b) (10 pts) The time-phased net requirements for a product ‘D’ over the next weeks are: The setup cost for the product is 500TL, and the holding cost is 0.10TL per unit per week. Determine the lot sizes using the Wagner Whitin approach. Assume holding cost occurs only if the inventory is held for the complete month. Show all computations. WRITE THE RESULTING SCHEDULE AND TOTAL COST IN A TABLE LIKE BELOW. c) (10 pts) The time-phased net requirements for a product ‘E’ over the next weeks and the shop floor capacity are given below. The setup cost is…
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based ond. Which lot-sizing method resulted in the lowest cost for the 12 periods?
Planning orders using a lot-for-lot (L4L) technique is commonly done because it is simpleand intuitive. It also helps to minimize holding costs as you are only ordering what isneeded when it is needed. So far it sounds like a good idea. Are there any disadvantagesto this approach?
The inventory control models discussed in Chapters 4 and 5 are often labeledindependent demand models and MRP is often labeled a dependent demandsystem. What do the terms independent and dependent mean in this context?
Complete the master productin schedule based on thefollowing information:Week 1 2 3 4 5 6 7 8 9Forecast 320 100 30 110 40 240 290 60 410Customer Orders 60 50 80 20 60 60 0 0 0Projected On-Hand Inventory 600MPS ReleasedMPS DueAvailable-to-promise (ATP) Scheduled production whenever projected on-had inventory drops below 30MPS lot size: 300Production lead time or lead time for MPS releases 1
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
A initially assume that Phi wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using a lot-for-lot (L4L). Gear box requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input shaft requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release
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.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS