Complete the following MRP table given the following: LT= 1 period Q (order quantity)= multiples of 20 SS (safety stock) = 15 PO for 18 will be delivered period 1 Current stock quantity: 30 Part C Period Gross Requirements Scheduled Receipts Projected available balance 30 Planned order releases 1 25 18 2 33 3 25 4 0 5 13 Complete the problem above, and enter your answers for the PROJECTED AVAILABLE BALANCE from periods ONE through FIVE.

Complete the following MRP table given the following: LT= 1 period Q (order quantity)= multiples of 20 SS (safety stock) = 15 PO for 18 will be delivered period 1 Current stock quantity: 30 Part C Period Gross Requirements Scheduled Receipts Projected available balance 30 Planned order releases 1 25 18 2 33 3 25 4 0 5 13 Complete the problem above, and enter your answers for the PROJECTED AVAILABLE BALANCE from periods ONE through FIVE.

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

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.
Tuff-Rider, Inc., manufactures touring bikes and mountain bikes in a variety of frame sizes, colors, and component combinations. Identical bicycles are produced in lots of 90. The projected demand, lot size, and time standards are shown in the following table: LOADING... Item Touring Mountain Demand forecast 4,000 units/year 12,000 units/year Lot size 110 units 90 units Standard processing time 0.30 hour/unit 0.75 hour/unit Standard setup time 2 hours/lot 3 hours/lot The shop currently works 8 hours a day, 5 days a week, 50 weeks a year. It operates five workstations, each producing one bicycle in the time shown in the table. The shop maintains a 15 percent capacity cushion. How many workstations will be required next year to meet expected demand without using overtime and without decreasing…
What is meant when we say that the least total cost (LTC) and least unit cost (LUC) methods are dynamic lot-sizing techniques?
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
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
Please do not give solution in image format thanku Calculate the ending inventory at month 6 of the following aggregate plan. The initial inventory is equal to zero. Month 1 2 3 4 5 6 Forecast 2,000 2,000 3,000 4,000 5,000 2,000 Output Regular permanent 2,800 2,800 2,800 2,800 2,800 2,800 Temporary Overtime 600 500 100 100 Select one: a. 1000 b. 0 c. 500 d. None of the options provided. e. 100
Irvine Consolidated Closets (ICC) builds and sells shelving for homes and offices. For a certain shelving unit, SS1, ICC has gross requirements of 500, 800, and 650 units in weeks 4, 5, and 6, respectively. The lead-time on the SS1 shelving unit is two weeks. ICC currently has 600 of the SS1 on hand and this product is ordered in lot sizes of 300, that is, the order in multiples of 300. Determine the MRP schedule for the SS1 unit over a time frame of weeks 1 through 6. When and for how many units should ICC place their orders for the SS1? A key component of the SS1 is the TT2. Each SS1 contains four TT2s. Currently TT2’s are ordered in lots of size 1000 and there are 800 on hand. TT2s have a one-week lead time. Determine the MRP schedule for the TT2 unit over a time frame of weeks 1 through 6. When and for how many units should ICC place their orders for the TT2? Suppose annual demand for the SS1 shelving unit is 32,500. ICC’s holding cost is $0.50 per week for each SS1…
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
Musa's Cashmere Sweaters has authorized the following MPS for her exclusive line of cashmere sweaters. She wants to use the MPS record for promising future orders. Current order promises are included. The MPS order quantity is 60 units. Beginning Inventory is 0. Complete the following MPS record. Period 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 15 15 15 15 20 20 20 20 25 25 25 25 Customer orders 12 10 8 25 40 0 15 30 30 0 0 40 Projected available Available-to-promise MPS 60
For Question 1 you are required to mannualy (without the use of excel) develop two MRP matrices: one with no lot sizing (you order what is required) and a lot seize equal to the EOQ. To determine the EOQ note that the inventory carrying cost is given as R1/unit/period. This means that you have to calculate the average demand per period and use this demand value in your EOQ calculation. This is then the order quantity to be used for the second MRP matrix.
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
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: January 1,400 May 2,300 February 1,700 June 2,100 March 1,600 July 1,900 April 1,700 August 1,300 Her operations manager is considering a new plan, which begins in January with 200units on hand and ends with zero inventory. Stockout cost of lost sales is $125per unit. Inventory holding cost is $25per unit per month. Ignore any idle-time costs. The plan is called plan B. Plan B: Produce at a constant rate of 1,300units per month, which will meet minimum demands. Then use subcontracting, with additional units at a premium price of $75per unit. Subcontracting capacity is limited to 1,000units per month. Evaluate this plan by computing the costs for January through August. Part 2 In order to arrive at the costs, first compute the ending inventory and subcontracting units for each month by…