Product Z is made from three units of A, two of B, andfour of C. A, in turn, is made of one unit of C and five ofD. A customer order was received for 200 units of Z inWeek 8. (Hint: You will need to use "low-level coding",i.e., pull each item to the lowest level it appears onthe BOM.) Item Lot Size On Hand Lead Time Z LFL 30 3A LFL 40 1 B LFL 100 4 C 1000 50 3 D 500 2000 3 a.Show the Bill of Materials b. Develop MRP schedulesshowing gross/net requirements and planned orderreleases/receipts for each item.

Answered: Product Z is made from three units of…

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

Saché, Incorporated, expects to sell 2,030 of its designer suits every week. The store is open seven days a week and expects to sell the same number of suits every day. The company has an EOQ of 1,450 suits and a safety stock of 290 suits. Once an order is placed, it takes three days for Saché to get the suits in. How many orders does the company place per year? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Assume that it is Monday morning before the store opens, and a shipment of suits has just arrived. When will Saché place its next order? multiple choice Monday Tuesday Wednesday Thursday Friday Saturday Sunday
. CPG Bagels starts the day with a large production run of bagels. Throughout the morning, additional bagels are produced as needed. The last bake is completed at 3 p.m. andthe store closes at 8 p.m. It costs approximately $0.20 in materials and labor to make a bagel. The price of a fresh bagel is $0.60. Bagels not sold by the end of the previous day are sold the next day as “day old” bagels in bags of six for $0.99 a bag. About two-thirds of the day-old bagels are sold; the remainder are just thrown away. There are many bagel flavors, but for simplicity, concentrate just on the plain bagels. The store manager predicts that demand for plain bagels from 3 p.m. until closing is normally distributed with a mean of 54 and a standard deviation of 21. a. How many bagels should the store have at 3 p.m. to maximize the store’s expected profit (from sales between 3 p.m. and closing)? (Hint: Assume day-old bagels are sold for $0.99/6 = $0.165 each; that is, don’t worry about the fact that…
A’s lead time is 1 week; B’s lead time is 2 weeks; and C’s lead time is 2 weeks. This is true regardless of order size. Currently you have the following amounts in on-hand inventory; A = 50. a) How many units of B and C will I need to produce for A if I have an order for 100 units of A? b) Give me a time-phased assembly plan for A, B, and C such that I will receive 100 units of A at the beginning of Week 5. Assume that I can work on B and C at the same time (overlap).
Tasty Beverage Co. produces soft drinks, specializing in fruit drinks. Tasty produces 5,000 cans ofproduct per batch. Setup cost for each batch is $50 and each drink costs $0.10 to produce. What is thetotal cost per batch? How much would it cost to fill an order for 100,000 cans?
i was reading this answer and the way its calculated is a longer process then what someone else wrote can you check if ishould use this one that bartleby has given me or the other one: Step 1: Basic Information The question is related to Economic order quantiy Economic Order Quantity is that level of inventory at which ordering cost and handling cost are minimum. It is calculated with the help of following formula Economic Order Quantity = √2RO ÷ C R = Annual Requirment C = Carrying or Holding cost O = Ordering Cost Step 2: Solution Economic Order Quantity = √2RO ÷ C Economic Order Quantity = √2 × 3000 × 20 ÷ 4.25 Economic Order Quantity = √28,235.294117647 Economic Order Quantity = 168.0336100834 pounds R = Annual Requirment i.e.250 × 12 = 3000 pounds per annum. C = Carrying or Holding cost i.e. £4.25 O = Ordering Cost i.e. £20 Quantity to be ordered = 168.03 pounds. Supplier = Vendor 1 should be used as the cost per pound for 168 pounds is £32.25 (as per table…
Complete the master production schedule based on the following information On-hand Inventory - 160 schedule production whenever projected on-hand inventory drops below - 30 MPS lot size - 300 Week 1 2 3 4 5 6 7 8Forecast 120 100 130 110 140 140 170 180 Customer Orders 110 100 75 50 32 11 5 0Projected On-Hand Inventory 160MPSAvailable-to-Promise
One 100 units per day. Safety stock is dimensioned to meet 95% of demand requirements considered normally distributed. According to the company's internal procedures, the stock of this item is reviewed every 20 days, with an average replacement time of 16 days. The materials manager raised the following costs, taking into account that the business year is 360 days: the cost of owning inventory is R$1.00 per unit per year, and the cost of an order is R$1,250.00 per order. Two systems are being examined for inventory control of this item: “P” or periodicity system and “Q” or fixed quantity system. The stock position of this item on the indicated day shows the existence of 8,500 units. Considering the above data, the question is: The. For system P, considering that the stock review is carried out on the day, what quantity defines the maximum stock?
ABC's beginning inventory is $2,000 and its ending inventory is $1,000. The inventory turnover is 6 times. Cost of goods sold for the year must equal: Numeric Response:??????????????????
OMG Corp.'s order quantity for Material T is 5,000 lbs. If the company maintains a safety stock of T at 500 lbs., and its order point is 1,500 lbs., what is the lead time assuming daily usage is 50 lbs.? a. 30 days b. 10 days c. 100 days d. 20 days
Which of the following is the planned order receipts using an MRP program with lot-for-lot policy if the inventory on hand is 0, scheduled receipts are 150, and gross requirements are 200? Now what about if the policy is EOQ = 500?
The Grinell Machine Shop makes a line of metal tables. Some of these tables are carried in finished goods inventory.A particular table has the following characteristics:Sales = 300 per yearSetup cost = $1200 per setup (this includes machinesetup for all the different parts in the table)Carrying cost = 20 percent per yearItem cost = $25a. How many of these tables should be made in a production lot?b. How often will production be scheduled?c. What factors might cause the firm to schedule a lot size different from the one you have computed?
Terminator, Inc., manufactures a motorcycle part in lots of 250 units. The raw materials cost for the part is $150, and the value added in manufacturing 1 unit from its components is $300, for a total cost per completed unit of $450. The lead time to make the part is 3 weeks, and the annual demand is 4,000 units. Assume 50 working weeks per year. a. How many units of the part are held, on average, as cycle inventory? What is its value? b. How many units of the part are held, on average, as pipeline inventory? What is its value?

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