A company manufactures two products A and B. Each A requires two C's and one D.Each D requires two F's and one E, while each E requires one F. Each product B requiresone D and two E's. The table below shows data from the inventory records.DATAITEMCATEGORYCDEFLot-SizingFixed OrderFixed OrderPeriod OrderLot for LotRuleQuantity = 220Quantity= 300 Quantity P = 2Lead Time3 weeks2 weeks3 weeks2 weeksScheduled280 (week 1)None300 (week 3)NoneReceiptsBeginning25150600InventoryThe MPS for product A calls for 85 units to be started in week 3 and 100 units to bestarted in week 6. The MPS for product B calls for 180 units to be started in week 5.Develop the material requirements plan (showing Gross requirements, Scheduledreceipts, On hand inventory, Net requirements, and Planned-order release) for the nextsix weeks for items C, D, E and F.

A Small Introduction about Inventory Management Stock administration alludes to the most common…

Answered: A company manufactures two products A…

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

Bigby Riggs sells high-end art frames that are ordered every Thursday to prepare for next week's demand. The most popular frame style is sold at $50 per unit and it costs Bigby $35 per piece. If too many art frames are ordered, Bigby incurs an inventory carrying cost of $2 per frame. If Bigby runs out of stock for the week, he forgoes the profits from missed sales. Bigby has the option to order 100, 150, or 200 art frames to meet next week's demand which can be either 100, 150, or 200 frames. Based on historical demand, Bigby has determined the following probability information: P(100) = 0.4, P(150) = 0.3, P(200) = 0.3 What is the Expected Monetary Value of your best alternative?
A company wants to develop a level production plan for a family of products. The opening inventory is 100 units, and then increase to 180 units is expected by the end of the plan the demand for each of the next 6 periods is: 100, 120, 125, 130, 115 and 110. Assume that all periods at the same number of working days. Based on this data, company should produce how many units per period for the next 6 periods ? : 780 units 130 units. 140 units O 700 units O None of the above
Daily demand of a chemical at an oil refinery is normally distributed with a mean of 60 litres and a standard deviation of 7. The supplier reliably delivers the chemical by maintaining a constant lead time of 1 week. There are no delivery charges from the supplier. Sales occur throughout the year. An order placement requires one hour of an administrative employee who is paid $20 per hour. Receiving and storing a chemical shipment requires two workers to work for half an hour. Workers are paid $12 per hour each. Chemical’s purchase price is $500 per litre. Annual cost of capital is 5%. Other holding costs are estimated to be $0.5 per litre. Find the order quantity and the reorder point to satisfy a 95% service level during the lead time. (Round answers to 2 decimal places.)
MA Training (MAT) is a national organisation which provides private tuition courses in accounting. The courses are generally attended by individuals who work as bookkeepers for other companies and who want to develop their practical skills. None of the attendees is aiming towards any professional qualification or examination. Courses are run on basic bookkeeping, value added tax, payroll, credit control, company administration and basic business management. Other bespoke courses, run on demand, are charged out at higher than normal rates. MAT has six branches nationwide with individual branch managers. Head office is situated at Nottingham and has responsibility for company accounting, payroll and inventory ordering activities. Individual branch managers have responsibility for all other areas of the business, such as pricing, product mix and staffing. Each branch rents its premises (a national company policy) and staff numbers range from 4 in Newcastle to 18 in Cardiff. Staff are…
Algro Inc. keeps a wide range of parts and materials on hand for use in its production processes. Management has recently had difficulty managing parts inventory as demand for its finished goods has increased; they frequently run out of some critical parts while having an endless supply of others. They would like to classify their parts inventory according to the ABC approach to better control inventory. The following is a list of parts, along with their annual usage and unit value: Item Annual Unit Item Annual Unit Number Usage Cost Number Usage Cost 1 36 $350 2 510 30 3 50 23 4 300 45 5 18 1900 6 500 8 7 710 4 8 80 26 9 344 28 10 67 440 11 510 2 12 682 35 13 1216 95 50 14 10 3 15 820 1 KARAN2222222222 16 60 $610 17 120 20 18 270 15 19 45 50 20 19 3200 21 910 3 12 4750 23 30 2710 24 24 1800 25 870 105 26 244 30 27 750 15 28 45 110 29 46 160 30 165 25 a. Classify the inventory items according to the ABC approach using the dollar value of annual demand. b. Clearly explain why you…
Avexim Pharmaceutical Laboratories is an international group of companies that manufactures an antiepileptic prescription drug in huge volumes. The setup time for manufacturing the drug is 75 minutes, the processing time is 8 minutes, and the order size is 700 units. In this case, which of the following is the total time required to meet the given production volume? a. 4275 minutes b. 968 minutes c. 1300 minutes d. 5675 minutes
E4 The Handy Manufacturing Company manufactures small air conditioner compressors. The estimated demand for the year is 140,000 units. The setup cost for the production process is $200 per run, and the carrying cost is $10.00 per unit per year. The daily production rate is 100 units per day, and demand has been 50 units per day. Determine (a) the number of units to produce in each batch. (The problem assumes 240 operating days.) and (b) the ordering cost
A buyer purchases 75 yd of material for $135. Then an additional 80 yd are ordered at the same unit cost. What is the additional cost (in dollars)?

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

A company manufactures two products A and B. Each A requires two C's and one D. Each D requires two F's and one E, while each E requires one F. Each product B requires one D and two E's. The table below shows data from the inventory records.