1. Speedy, Inc. is a company that produces automotive electrical components. AI5I is acommon part for all its products. Consider the following grass requirements and inventorydata for AISI part:Week367Grass requirements4030307020Inventory Data:Lead timeBeginning inventorryScheduled receiptsHolding costSetup cost1 week40$2.50/unit/weekS150Based on the L4L. lot-sizing rule, develop a Material Requirements Plan (MRP) for the next8 weeks for A15I part.Item: A151Week5Lot size: L4L12478Lead time: 1Gross RequirementsScheduled ReceiptsOn Hand InventoryNet RequirementsPlanned Order ReceiptsPlanned Order Releases(ii)Based on the FOQ - 57 units lot-sizing rule, develop a Material Requirements Plan (MRP)for the next 8 weeks for A151 part.Item: A151Lot size: FOQ 57Lead time: 1Gross RequirementsScheduled ReceiptsOn Hand InventoryNet RequirementsPlanned Order Receipts|Planned Order ReleasesWeek124578 (iii) Based on the POQ = 3 lot-sizing rule, develop a Material Requirements Plan (MRP) forthe next 8 weeks for A151 part.Item: A151Lot size: POQ = 3Lead time: 1Gross RequirementsScheduled ReceiptsOn Hand InventoryNet RequirementsPlanned Order ReceiptsPlanned Order ReleasesWeek12356.8.(iv) Analyze each of the above plans and determine which lot sizing rule is the cheapest – L4L,FOQ = 57 or POQ = 3. Show your calculation.

Material Requirements Planning (MRP) is a standard planning system to provide assistance to…

Answered: Speedy, Inc. is a company that produces…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section3.8: A Multiperiod Production Model

Problem 22P

See similar textbooks

Similar questions

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?
Given the following list of items,a. Classify the items as A, B, or C.b. Determine the economic order quantity for each item (round to the nearest whole unit).ItemEstimatedAnnualDemandOrderingCostHoldingCost(%)UnitPriceH4-010 20,000 50 20 2.50H5-201 60,200 60 20 4.00P6-400 9,800 80 30 28.50P6-401 14,500 50 30 12.00P7-100 6,250 50 30 9.00P9-103 7,500 50 40 22.00TS-300 21,000 40 25 45.00TS-400 45,000 40 25 40.00TS-041 800 40 25 20.00V1-001 33,100 25 35 4.00
A hospital must order the drug Porapill from DaisyDrug Company. It costs $500 to place an order and $30 toreview the hospital’s inventory of the drug. Annual demandfor the drug is N(10,000, 640,000), and it costs $5 to holdone unit in inventory for one year. Orders arrive one monthafter being placed. Assume that all shortages are backlogged.a Estimate R and the number of orders per year thatshould be placed.b Using the answer in part (a), determine the optimal(R, S) inventory policy. Assume that the shortage costper unit of the drug is $100.
A busness is aunchng a new product. The aunch wil require a number of related actvties as follows hre (7 weeks) select an advertising agency (2 weeks), plan an advertising campaign wth the agency (4 weeks),products from the manufacturer (13 weeks) select distributors for the product (9 weeks), take initial orders fromoperation (12 weeks), pack enough products for the launch stock (8 weeks), order the launch quantty ofthe distrbutors (3 weeks), dispatch the initial orders to the distrbutors (2 weeks). (a) What is the earest timeconduct the advertsing campaign (10 weeks), design the packaging of the product (4 weeks), set up packinga sales manager (5 weeks), requre the sales manager to recruit saes peope (4 weeks), tran the sales people that the new product can be ntroduced to the market? (b) If the company hre traned salesmen who do notneed further training, coud the product be introduced 7 weeks earler? (c) How long could one delay selectngthe advertising agency? In the example above,…
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 ona. Silver–Meal.
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 onb. Least unit cost
Please complete the sup part: e,f and g. 1.B&H needs to decide how to manage its inventory of cameras. The demand for cameras at B&H is 200 cameras per week. Each time that B&H places an order for a new shipment of cameras, it must pay $80 in fixed processing fees. A camera costs B&H $60 to purchase. The cost for B&H to hold a camera in its store for one week is $4. Assume that the lead time for the delivery of a camera is 0 weeks.a. Suppose that B&H places orders for cameras in quantities of 50 cameras at a time and places a new order for cameras each time that it runs out. Draw a graph showing the number of cameras that B&H has on-hand in inventory at each point in time up until the time when it places its fourth-order. Label the points in time at which B&H places a new order. Assume that B&H places its first order for 50 cameras on day 0.b. Suppose again that B&H places orders for 50 cameras at a time. What will be B&H’s average holding…
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?
Dave’s local college football team is playing for the national championship in next month’s bowl game, and he’s thinking about having “We’re number one” T-shirts imprinted in honor of the team. It’s too late to get the shirts before game day, but if he orders today, he can get them within a few days after the game. The shirts must be ordered in multiples of 1000, and Dave has estimated the amount of profit he will make for possible outcomes of the game. Given the following payoff table, what will Dave do if he uses the maximin criterion? The maximax criterion? The minimax regret criterion? Order no shirts $0 wins $0 loses $0 ties Order 1000 shirts $800 wins $-200 loses $200 ties Order 2000 shirts $1600 wins $-400 loses $300 ties
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
c. Once you find the optimal order quantity i.e., EOQ, create a Data Table that generates inventory cost within ±100 units (with 10units increment) from the optimal order quantity. For example, if the EOQ=150, then you need to generate Data Table for inventory cost starting from 50 to 250 with 10 increments. Explain the exact steps completed in excel to create the data table d. Create a Scatter plot with “smooth lines” for the Data Table created in c) to show the inventory cost. Label your plot clearly (axis and title). The optimum order quantity should indicate the minimum cost in your plot.
1. Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, "That's life." On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolate-covered shrimp in some boxes so that "You never know what you'll get." Quarterly demand (in boxes of chocolates) for the last three years is shown in the table below: b. If the expected sales for chocolates are 14,400 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. (Round all intermediate calculations to two decimal places.) The first quarter forecast is what? boxes of chocolates. (Enter your response rounded to the nearest whole number.)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS