A manufacturing company produces two products X and Y. Each product X requires one A and two Bs. Each B requires one C and one D. Each product Y requires 1 C and 4Ds. Table Q5A shows data from the inventory records of components. Table Q5A Data category A B C D Lot - sizing rule Fixed order quantity = 250 Lot for lot Lot for lot Fixed order quantity = 1000 Lead time 3 weeks 2 weeks 1 week 2 weeks Beginning inventory 70 0 200 800 The MPS for products X and Y is given in Table Q5B. The on-hand inventories are as follows: X = 100, Y = 30. The only scheduled receipts are 250 units of X in period 2.The lead times are as follows: X = 2 weeks, Y = 3 weeks. The chase strategy is used for both products. Table Q5B Demand in period Product SS 1 2 3 4 5 6 7 8 X 50 300 200 250 Y 30 400 Required: a) Draw a product structure tree for each product. b) Develop the MRP for items X, Y, A, B, C, and Din order to meet the demand. Use the MRP format showing the following; Gross requirements, Net requirements and Planned order releases.

A manufacturing company produces two products X and Y. Each product X requires one A and two Bs. Each B requires one C and one D. Each product Y requires 1 C and 4Ds. Table Q5A shows data from the inventory records of components. Table Q5A Data category A B C D Lot - sizing rule Fixed order quantity = 250 Lot for lot Lot for lot Fixed order quantity = 1000 Lead time 3 weeks 2 weeks 1 week 2 weeks Beginning inventory 70 0 200 800 The MPS for products X and Y is given in Table Q5B. The on-hand inventories are as follows: X = 100, Y = 30. The only scheduled receipts are 250 units of X in period 2.The lead times are as follows: X = 2 weeks, Y = 3 weeks. The chase strategy is used for both products. Table Q5B Demand in period Product SS 1 2 3 4 5 6 7 8 X 50 300 200 250 Y 30 400 Required: a) Draw a product structure tree for each product. b) Develop the MRP for items X, Y, A, B, C, and Din order to meet the demand. Use the MRP format showing the following; Gross requirements, Net requirements and Planned order releases.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

Similar questions

Your company makes hand sanitizer in two lines: Moisturizing+, and StandardSoap. On the market, Moisturizing+ retails for $175/L and StandardSoap retails for $95/L. You make the hand sanitizer by combining lotion, soap, and secret ingredient SpecialX. These ingredients are purchased from a mysterious supplier, and you can purchase at most 4000L of lotion, 5000L of soap, and 750L of SpecialX in a month. Lotion costs $25/L, soap costs $10/L, and SpecialX costs $35/L. To make 1L of Moisturizing+, you need to combine 0.5L of lotion, 0.3L of soap, and 0.2L of SpecialX. To make 1L of StandardSoap, you need to combine 0.4L of lotion, 0.55L of soap, and 0.05L of SpecialX. Your company has committed to donating 500L of StandardSoap to a local charity. Since this is a donation, you will not receive any revenue. However, the costs and purchasing limits apply to both the hand sanitizer that is sold on the market and donated to charity. You want to maximize your monthly profit. Assume that…
The Chisokone Company located in Chimwemwe manufactures typewriters called AK4 model Z. The company has an average total inventory of K15, 000,000 and places 12,000 orders every year. Order details are as follows:Purchase department expenses……………………………..K400, 000Stores warehouse personnel salary……………………......K400, 000Obsolescence, spoilage, etc…………………………………K120, 000Floor space charge related to stores activities…………….K260, 000Cost of collecting materials…………………………………..K60, 000Cost of receiving materials…………………………………...K70, 000Cost of Inspection……………………………………………..K100, 000Cost of material handling for warehousing activities………K300, 000Cost of bill payment……………………………………………K170, 000Interest…………………………………………………………..11.5%Insurance charges………………………………………………1.9%The company wants to buy a certain component, whose cost is K24 each and the annual requirement is 34,560 units. Calculate the following:i. The cost of carrying inventory as a percentage of inventory ii. The carrying cost as a…
XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is OR 2.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. What is the Economic Order Quantity (EOQ) while not consider the purchase cost? Round - up to the nearest integer?? a. 199 units O b. None is correct 500 units d. 180 units e. 220 units
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
Omega DB Corp. has a policy of maintaining an inventory of finished goods equal to 40 percent of the next month’s budgeted sales. If Omega DB Corp. plans to produce 6,000 units in June, what are budgeted sales for July in units? Budgeted sales for the first six months of 2019 for Omega DB Corp. are listed below: Units:JANUARY 6,000FEBRUARY 7,000MARCH 8,000APRIL 7,000MAY 5,000JUNE 4,000
Rocky Mountain Tire Centre sells 20,000 tires of a particular type per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. The purchase price is $20. per tire if fewer than 500 tires are ordered, $18. Per tire if more than 500 but fewer than 1,000 tires are ordered and $17. per tire if 1,000 or more tires are ordered. Quantity Unit Price 1-499 $20. 500-999 $18. 1000 & over $17 Based on available information, lead time demand for CD-ROM drives averages 50 units (normally distributed), with a standard deviation of 5 drives. Management wants a 97% service level. What value of Z should be applied? How many drives should be carried as safety stock?
Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown: Type of Beans Shipment Amount in pounds Cost Per Shipment in dollars Arabica 6000 7500 Robusta 7500 7125 Liberica 7500 6750 Excelsa 6000 7200 Juno 7500 7875 The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno. Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the…
Dr. Thompson makes three bean mixes for coffee shops located in the Austin. The three mixes, referred to as the Tameka Mix, the Christian Mix, and the Tamia Mix, are made by mixing different percentages of five types of beans. In preparation for the fall season, Dr. Thompson just purchased the following shipments of beans at the prices shown: Type of Beans Shipment Amount in pounds Cost Per Shipment in dollars Arabica 6000 7500 Robusta 7500 7125 Liberica 7500 6750 Excelsa 6000 7200 Juno 7500 7875 The Tameka Mix consists of 15% Arabica, 25% Robusta beans, 25% Liberica, 10% Excelsa, and 25% Juno. The Christian Mix consists of 20% of each type of beans, and the Tamia Mix consists of 25% Arabica, 15% Robusta beans, 15% Liberica, 25% Excelsa, and 20% Juno. Dr. Thompson analyzed the cost to get the beans ready and determined that the profit contribution per pound is $1.65 for the Tameka Mix, $2.00 for the Christian Mix, and $2.25 for the…
A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a year, andordering costs are $96. The following price schedule applies. Determine the following:a. The optimal order quantityb. The number of orders per yearNumber of Boxes Price per Box1,000 to 1,999 $1.25 2,000 to 4,999 1.205,000 to 9,999 1.1510,000 or more 1.10
A company manufactures 5,000 units of a product per month. The cost of placing an order is Rs. 100. The purchase price of the raw material is Rs. 10 per kg. The re-order period is 4 to 8 weeks. The consumption of raw materials varies from 100 kg to 450 kg per week, the average consumption being 275 kg The carrying cost of inventory is 20% per annum. You are required to calculate- (a) Re-order Quantity (b) Re order Level (c) Maximum Level (d) Minimum Level le) Average Stock Level
Consider a firm that knows that the price of the productit is ordering is going to increase permanently by $X. Howmuch of the product should be ordered before the priceincrease goes into effect?Here is one approach to this question: Suppose the firmorders Q units before the price increase goes into effect.a What extra holding cost is incurred by ordering Qunits now?b How much in purchasing costs is saved by orderingQ units now?c What value of Q maximizes purchasing cost savingsless extra holding costs?d Suppose that annual demand is 1,000 units, holdingcost per unit-year is $7.50, and the price of the item isgoing to increase by $10. How large an order should beplaced before the price increase goes into effect?
Suppose that in the given problem the space consumed by each vegetable is not proportional to its cost. In particular, suppose that one pound of lettuce required 0.4 square foot of space and one pound of zucchini required 1 square foot of space. Determine upper and lower bounds on the optimal values of the order quantities in this case. Test different values of the Lagrange multiplier to find the optimal values of the order quantities. (A spreadsheet is ideally suited for this kind of calculation. If you solve the problem using a spreadsheet, place the Lagrange multiplier in a cell so that its value can be changed easily.)

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Data category
	A	B	C	D
Lot - sizing rule	Fixed order quantity = 250	Lot for lot	Lot for lot	Fixed order quantity = 1000
Lead time	3 weeks	2 weeks	1 week	2 weeks
Beginning inventory	70	0	200	800