Note:Use the following format for all your MRP matrices:Gross requirementsScheduled receiptsProjected on handNet requirementsPlanned order receiptsPlanned order releases01PERIOD234 ProdMan (PM) produces two products, X and Z, with product structures as shown below.An order for 200 units of X and 350 units of Z has been received for period 8.An inquiry of the available stock reveals the following:Inventory on hand (units)25403010090120150160Product/PartXNRZRSVWOf the T's on order 250 are due in by period 2 and 75 units of S should arrive in period 1.(scheduled receipts). For economic reasons, U is never made in quantities under 500.Similarly, V and W have multiple order quantities of 900 and 1 500 units respectively.S(1)LT=1V(2)LT=1XLT=1R(2)LT=2U(1)LT=2W(4)LT=1T(1)LT=3T(2)LT=3ZLT=2V(2)LT=1U(3)LT=2W(4)LT=1Determine when orders should be released for parts U and V and the size of those orders.

The product structure is given as follows.

Answered: ProdMan (PM) produces two products, X…

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

Which of the following is not an acceptable method of applying the LCNRV? Select one: a. Group inventory items b. Individual item c. Total of the inventory d. Inventory location
Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Q = 60, LT= 3 weeks, Safety Stock = 5 1 70 70 PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Planned Order Releases 1 70 70 100 2 0 > X WEEK 3 40 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". 2 0 4 0 100 WEEK 3 40 5 160 60 4 0 40 0 X 5 160 Check My Work -60 0
(a) Give examples of independent and related dependent demand (b) APL company assembles and sales an electronics device (ED) on a contract basis. End item ED has composed of 3 units of subassembly BG and 5 units of component DD. BG is assembled using 3 DDs and 4 FCs. There are orders of 500 and 875 units of the device (ED) at the beginning of week 6 and week 8. In assembling BG, an extra 20 percent scrap allowance must be added. DD can only be ordered in whole cases of 400 units per case. One case of DD is received in each of week 1 and week 2. Also, there are 200 units of BG and 425 units of DD now on hand. The lead time for the item BG, DD, and FC is 2 weeks and that is for the item ED is 1 week.i. Calculate the required number of DD and FC for producing 100 units of ED. There is no stock of any item. ii. Prepare a material requirements plan for the component DD.
MRP systems are: a. Intended to be used for independent demand items b. Intended to reduce inventory requirements, production lead times, and delivery times to customers c. Intended to determine an appropriate master production schedule d. Appropriate for all end items in the product line e. Substitutes for fixed order point/order quantity systems
Which of the following is not a fixed order cost? ( ) Administrative costs incurred to place an order ( ) Shipping cost incurred to ship an order ( ) Labor cost incurred to receive an order ( ) Supplier's packaging cost ( ) none above
14 Uncommitted inventory that is physically on-hand is called ______. a ready-to-buy b ready-to-sell c made-to-stock d available-to-promise 15 Which system calculates materials, subassemblies, and components required for end item production? a production planner b master production schedule c capacity requirements planning d materials requirements planning 16 What is the process that identifies which parent item has generated requirements for a component called? a where-used analysis b splitting c pegging d netting
You are the executive chef at a large wedding facility, and a wedding with a confirmed count of 168 is scheduled for tomorrow at noon. Everything has been ordered except the shrimp, which was missing from the last purchase order. It will have to be a last-minute rush order, and only one supplier can get it to you in time. The purchase order will be for frozen raw, U 16-20, shrimp peeled, de-veined, tail-on, in 5-pound boxes (according to your spec for the product). You’ve dealt with this supplier before, and made a note to yourself on the jumbo shrimp spec that this vendor’s product averages 19 to 20 shrimp per pound and has a 96% yield. Catering policy dictates that a 10% buffer be provided for unexpected guests, and the catering menu states that 5 shrimp are to be served per person. If you have 4 pounds of good jumbo shrimp on hand, how much will you order for the wedding? Will there be any leftover product? How much?
One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 28, 40, 36, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 62, 110, and 90, respectively, to be purchased. B has scheduled receipts of 15 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 15 units in Period 1, 12 units in Period 2, 50 units in Period 6, and 50 units in Period 8. Find the planned order releases for all items. (Leave no cells blank - be certain to enter "O" wherever required.) Period 3 4 6 7 8 Gross requirements Item A Scheduled receipts OH = 28 Projected available balance Net requirements Planned order receipts Planned order releases LT = 1 SS = 0 Q = L4L Gross…
Product categories usually listed in the master production schedule contain all of the following except: Question 7 options: a. firm customer orders b. sales forecasts c. spare parts d. production rates
Periodic Inventory Using FIFO, LIFO, and Weighted Average Cost Methods The units of an item available for sale during the year were as follows: 12 units at $47 Jan. 11 Aug. 13 20 units at $48 Nov. 30 $564 960 735 Avaliable for sale $2,259 There are 20 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the inventory cost using the (a) first-in, first-out (FIFO) method; (b) last-sout (LIFO) method; and (c) weighted average cost method (round per-unit cost to two decimal places and your final answer to the nearest whole dollar). a First-in, first-out (FIFO) b. Last-in, first-out (LIFO) c. Weighted average cost Inventory Purchase Purchase 15 units at $49 47 units 1,284 X
5. Which of the following inventory technique is appropriate for the classification of inventory depending on the necessity of spares for smooth running of the production? a. ABC analysis b. VPN analysis c. None of the options d. VED analysis
Economic order quantity (Q*) is 4,000 units. Annual demand (D) is 12,000 units. Find number of orders per year (N*) and time between orders (T*) in years. Group of answer choices N*=3 times per year, T* cannot be calculated N*=0.33 times per year, T*= 0.33 weeks N*=17.3 times per year, T*= 3 years N*=3 times per year, T*= 0.33 years N*=3 times per year, T*= 3 years

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