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

BicycleBro is a retailer that sells bicycles. The company had been operating for 30 days (1 month). By the end of 1 month it wants to measure its performance in terms of Inventory turnover and Days of inventory. Below is the information that the company has collected from its warehouse and accounting department Stock Count Sheet Item code Stock on hand Stock count week (week number when employees counted the stock on hand) 100 30 week1 200 10 week1 100 10 week3 200 20 week3 Inventory valuation Item code Value per unit (in $) 100 1000 200 2000 Bicycles sold by end of month Item code Units sold 100 5 200 10 Given the information above find What is the total inventory turnover rate for given period? What is the total Inventory Days of Sales for given period?
The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility: Item Unit Cost Usage Item Unit Cost Usage K34 $10 200 F99 20 60 K35 25 600 D45 10 550 K36 36 150 D48 12 110 M10 16 25 D52 15 110 M20 20 80 D57 40 120 Z45 80 200 N08 30 40 F14 20 300 P05 16 500 F95 30 800 P09 10 30 Determine the percentage of items in each category and the annual dollar value for each category for part b
The following table contains figures on the monthly volume and unit costs for a random sample of 16 items from a list of 2,000 inventory items at a health care facility. Transcribed Image Text: Item Unit Cost Usage Item Unit Cost Usage K34 $10 200 F99 20 60 K35 25 600 D45 10 550 K36 36 150 D48 12 90 M10 16 25 D52 15 110 M20 20 40 08 200 D57 120 245 80 NO8 30 40 F14 20 300 PO5 16 500 F95 30 800 P09 10 30 a-Develop an A-B-C classification for these items. b-Given the monthly usages in the following table, classify the items in A, B, and C categories according to dollar usage. c- Determine the percentage of items in each category and the annual dollar value for each category for part b.
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month periodwere as follows:Month Sales (000 units)Feb. 19Mar. 18Apr. 15May 20Jun. 18Jul. 22Aug. 20a. Plot the monthly data on a sheet of graph paper
"Nordlund Boat Company has been repairing, refitting, and building custom boats. for over 60 years in the Pacific Northwest." The company is located in Tacoma, Washington. One of the engine's most critical components is the exhaust manifolds. The company purchases this item from the best manufacturers in the world. TJ is the buyer in charge of managing this item. TJ's purchasing agent currently submits an order release for this item every 4 weeks. The company's annual demand is 400 units (2 units per working day). Nordlund's relatively low volume and quality focus, rather than volume focus, means the company cannot take advantage of quantity discounts. The supplier has agreed to deliver this item within 1 week following an order release. For this reason, Nordlund has never had a shortage of exhaust manifolds. The total time between the release date and date of receipt is 1 week or 5 working days. The accounting has generated the following inventory-related costs. Procurement costs…
A golf specialty wholesaler operates 50 weeks per year. Management is trying to determine an inventory policy for its 1-irons, which have the following characteristics:Demand 1D2 = 2,000 units/yearDemand is normally distributedStandard deviation of weekly demand = 3 unitsOrdering cost = $40/orderAnnual holding cost 1H2 = $5/unitsDesired cycle@service level = 90 percentLead time 1L2 = 4 weeksa. If the company uses a periodic review system, what should P and T be? Round P to the nearest week.b. If the company uses a continuous review system, what should R be?
a. List the major assumptions of the EOQ model.b. How would you respond to the criticism that EOQ models tend to provide misleading resultsbecause values of D, S, and H are, at best, educated guesses?
A distributor of large appliances needs to determine the order quantities and reorderpoints for the various products it carries. The following data refer to a specii c refrigeratorin its product line:Cost to place an orderHolding costCost of refrigeratorAnnual demandStandard deviation of demand during lead timeLead time$10020 percent of product cost per year$500 each500 refrigerators10 refrigerators7 daysConsider an even daily demand and a 365-day year.a. What is the economic order quantity?b. If the distributor wants a 97 percent service probability, what reorder point, R, shouldbe used?
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…
A retailer determines that the cost of ordering and storing units of a product can be modelled by C(x)= 3x + 2000 / x, 0 < x < 200. Find the order size that will minimise ordering and storage cost.
Explain what is the definition of a deterministic inventory model ? When is it appropriate to use ?
Models of inventory systems frequently consider the relationships among a beginning inventory,a production quantity, a demand or sales, and an ending inventory. For a givenproduction period j, letsj-1 = ending inventory from the previous period (beginning inventory for period j)xj = production quantity in period jdj = demand in period jsj = ending inventory for period ja. Write the mathematical relationship or model that shows ending inventory as a functionof beginning inventory, production, and demand.b. What constraint should be added if production capacity for period j is given by Cj?c. What constraint should be added if inventory requirements for period j mandate anending inventory of at least Ij?

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

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.