Consider the bill of material for product P and the data given in the following table. The master schedule requirements for Pare 60 units in week 6. Items Q and Rare manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item S is purchased from a local distributor, and has a Fixed Order Quantity of 50 pieces per order. Use a blank matrix to solve for the MRP requirements. P. Q(2) S(3) R(3) Quantity on Hand Scheduled receipts Item Lead Time P. 15 20 in week 2 R. 2. 2. 25 15 in week 1 Given the following information, how many R's should be ordered? O 180 O 330 O 360 O 165 O 225

Consider the bill of material for product P and the data given in the following table. The master schedule requirements for Pare 60 units in week 6. Items Q and Rare manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item S is purchased from a local distributor, and has a Fixed Order Quantity of 50 pieces per order. Use a blank matrix to solve for the MRP requirements. P. Q(2) S(3) R(3) Quantity on Hand Scheduled receipts Item Lead Time P. 15 20 in week 2 R. 2. 2. 25 15 in week 1 Given the following information, how many R's should be ordered? O 180 O 330 O 360 O 165 O 225

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

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
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.
Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 *Holding cost =$ 2.50/unit/week; setup cost =$ 150; lead time =1 week; beginning inventory =40. What is the average demand per week? with 2 decimal places): Calculate Economic Order Quantity (EOQ) Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 Scheduled receipt…
a. Determine the planned order release for the motherboards in the problem given assuming that one uses the EOQ formula to schedule production. Use K = $180 and h = 0.40.b. Using the results from part (a), determine the gross requirements schedule for the DRAM chips, which are ordered from an outside supplier. The order cost is $25.00, and the holding cost is $0.01 per chip per week. What order schedule with the vendor results if the EOQ formula is used to determine the lot size?c. Repeat the calculation of part (b) for the add-in boards. Use the same value of the setup cost and a holding cost of 28 cents per board per week.
Over in the Marvel universe, you find yourself in charge of ordering Nitinol (a nickel-titanium alloy which actually exists in the real world, as far as I can tell) for Iron Man clone suits. You have a number of kg of material on hand at the start of the time horizon, as shown in the table. You use a Periodic Ordering Quantity of 2 weeks when ordering. Fill out the rest of the table, computing the Planned Order Releases. Copy the table and paste it into the answer box to fill it out. Lead Time = 1 week. Nitinol 1 2 3 4 5 6 Gross Requirements 10 10 25 12 32 20 Scheduled Order Receipts Projected Available Balance 35 Net Requirements Planned Order Receipts Planned Order Releases
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
Suppose we are formulating a Master Production Schedule (MPS) for an item. Week O projected on- hand is 83 units. The lot-size policy for this item calls for L4L ordering. Lead time for this item is one week. There are no safety stock requirements. Here are the demand forecast and the booked orders for this item . Week 2 3 4 5 6 Forecast 60 45 45 45 45 60 Booked 59 48 30 10 What will be the order size of the first MPS Start Quantity that is needed?
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 131 units. The following is in indented form: ITEM DESCRIPTION Bracket assembly Wall board USAGE 1 A 4 Hanger subassembly Hanger casting Ceramic knob Rivet head screw Metal tong Plastic cap E G 2 Below is a table indicating current inventory levels: Item Inventory A B E G 23 18 55 25 200 170 1,100 90 b. What are the net requirements of each item in the MPS? (Leave no cells blank be certain to enter "0" wherever requirec Item Net Requirements A F Nevt
a. Discuss why the EOQ formula may give poor results for determining planned order releases.b. If the forecasted demand for the end item is the same each period, will the EOQ formula result in optimal lot sizing at each level of the product structure? Explain.
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
Part (A) To control the inventory, organizations have three alternate approaches: Economic Order Quantity (EOQ). Materials Requirements Planning (MRP) and Just-in-Time (JIT). Discuss those three approaches identify the goal of each one? And how the organization can achieve such a goal? Part (B) Some threats could be happened in the production cycle, one of them is over or under production threat. Discuss two problems and two controls related to this threat. for the toolbar, press ALT F10 (PC) or ALT+FN+F10 (Mac).
Explain the significance of the Economic Order Quantity (EOQ) formula in the Wilson approach.