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

53. Average demand for a particular item is 1,200 units per year. It costs $100 to place an ordem for this item, and it costs $24 to hold one unit of this item in inventory for one year. If the fixed order-interval model is chosen in this instance, how often (on average) will this item be ordered a) Once a month b) Once every other month c) Twice a month d) Twice every three months e) Three times every two months 54. The EOQ model is most relevant for which one of the following? a) Ordering items with dependent demand b) Determination of safety stock c) Ordering perishable items d) Determining fixed interval ordering quantity e) Determining fixed order quantity 55. What type of process would a paper mill be most likely to use? a) Continuous flow b) Project c) Job shop d) Flow shop 56. The transportation model method that is used to evaluate location alternatives minimizes t a) sources b) destinations c) capacity d) shipping costs
XYZ company has determined that the annual demand for type A material is 20,000 pounds. Salma, who works in her brother's factory, is in charge of purchasing. She estimates that it costs $15 every time an order is placed. This cost includes her wages, the cost of the forms used in placing the order, and so on. Furthermore, she estimates that the cost of carrying one pound in inventory for a year is 0.05 $. Assume that the demand is constant throughout the year. (Note: $ is a dollar sign) a) If we are going to use the EOQ inventory model, mention all the assumptions that are made to validate that model. b) How many pounds of type A material should Huda order (i.e. Q*) at a time if she wishes to minimize total inventory cost? c) How many orders per year would be placed? d) What would the annual ordering cost be? e) What would the average inventory be? f) What would the annual holding cost be? See equations below if needed: Annual Ordering cost Annual hdding: Number of orders placed per…
. Given the following net requirements, calculate the planned order receipts basedon the period order quantity. The EOQ is 250 units, and the annual demand is4200 units.
The seasonal demand for a particular product is given below: Period 123 4 5 6 Demand 300 450 100 450 450 100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity
Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply Available Period 1 W N 3 Regular Time 30 35 40 Overtime 15 15 20 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract 10 10 10 Subcontract cost per unit Carrying cost per unit per month 20 units $100 $160 $250 $2 Demand Forecast 40 55 60 Assume that the initial inventory has no holding cost in the first period and backorders are not permitted. Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number).
Problem 20-39 (Algo) CU, Incorporated (CUI), produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, to meet the annual demand at the lowest cost. The price of copper depends on the quantity ordered. Here are price-break and other data for the problem: Price of copper $ 0.84 per pound up to 2,499 pounds $ 0.83 per pound for orders between 2,500 and 4,999 pounds $ 0.81 per pound for orders 5,000 pounds or greater Annual demand 54,000 pounds per year Holding cost 25 percent per unit per year of the price of the copper Ordering cost $ 30 Which quantity should be ordered? Quantity_____________pounds
38 In the basic EOQ model, if D = 6000 per year, S = $100, and holding cost = $5 per unit per month, what is the economic order quantity? Select one: a. 600 b. 24 c. 100 d. 490 e. 141
Problem 11-3 Solve the newsvendor problem. What is the optimal order quantity? Probability Value Purchase cost c Selling price p Salvage value v 0.13 0.03 0.19 1 2 3 Optimal order quantity 45 70 25 0.16 0.10 4 5 0.39 6
Peet’s Coffees in Menlo Park, California, sells Melitta Number 101 coffee filters at afairly steady rate of about 60 boxes of filters monthly. The filters are ordered from asupplier in Trenton, New Jersey. Peet’s manager is interested in applying some inventorytheory to determine the best replenishment strategy for the filters.Peet’s pays $2.80 per box of filters and estimates that fixed costs of employee timefor placing and receiving orders amount to about $20. Peet’s uses a 22 percent annualinterest rate to compute holding costs.a. How large a standing order should Peet’s have with its supplier in Trenton, and howoften should these orders be placed?
Answer on b) Sales price = 80 kr Purchase price = 30 kr 80 – 30 = 50 kr profit 20 magazines * 80 kr = 1.6000 kr which will maximize the profit over time. Still dont get the answer on question c)
Problem 20-39 (Algo) CU, Incorporated (CUI), produces copper contacts that it uses in switches and relays. CUI needs to determine the order quantity, Q, to meet the annual demand at the lowest cost. The price of copper depends on the quantity ordered. Here are price-break and other data for the problem: Price of copper 0.80 per pound up to 2,499 pounds 0.79 per pound for orders between 2,500 and 4,999 pounds %24 0.77 per pound for orders 5,000 pounds or greater 51,000 pounds per year 30 percent per unit per year of the price of the copper Annual demand Holding cost Ordering cost 30 Which quantity should be ordered? Quantity pounds

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