Lead Time = 2 Weeks Safety Stock = 10 UnitsOrder Quantity = Lot for Lot(produce or order exactly what is needed.Period14 5Gross Requirements40 0 10 15 75Scheduled Receipts40On Hand Inventory25 25 25 15 10 10Planned Order Relaeses0 10 75The following transactions occur during period 1:5 units of the scheduled receipt of 40 in period 1 are scrapped.40 units of part N are disbursed in period 1. (The gross requirements of 40 are met.)Referring to the above information, assume that the 5 units ofscrap were recorded properly and that 8 more parts, not previouslyshown by the records, were found. When the MRP record isupdated for the beginning of period 2, the projected on-handbalance for period 3 would be:a. Greater than 15 but less than or equal to 20 units.O b. Greater than 20 units.O c. Greater than 10 but less than or equal to 15 units.O d. Less than or equal to 10 units.2.

Find the Given details below: Period 1 2 3 4 5 Gross Requirements 40 0 10 15 75

Answered: Lead Time =2 Weeks Safety Stock = 10…

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

Suppose that a product with an annual demand of 2400 units, a setup cost per production run of $8, and a holding cost of $1 per unit per year. With 200 working days in a year, conisder the following ordering plans: 1) order 600 units once each quarter and all 600 units will be delivererd in a single day 2) order 200 units once each month and all 200 units will be delivered in a single day 3) order 120 units each 6-month, and each order will be delivered over a period of 60 days a) Suppose that the items will be delivered at a rate of 40 pieces per day, what is the minimum overall costs in this case? b) Which ordering strategy has the lowest overall cost and why?
Suppose that a product with an annual demand of 2400 units, a setup cost per production run of $8, and a holding cost of $1 per unit per year. With 200 working days in a year, conisder the following ordering plans: 1) order 600 units once each quarter and all 600 units will be delivererd in a single day 2) order 200 units once each month and all 200 units will be delivered in a single day 3) order 120 units each 6-month, and each order will be delivered over a period of 60 days a) Calculate the annual holding and setup costs associated with each plan b) When items arrive in one batch, what is the optimal order quantity to minimize overall costs?
The materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are rem
The two most important inven tory-based questionsanswered by the typical inventory model are:a) when to place an order and the cost of the order.b) when to place an order and how much of an item to order.c) how much of an item to order and the cost of the order.d) how much of an item to order and with whom the order should be placed.
In the Walton Bookstore example, suppose thatWalton receives no money for the first 50 excesscalendars returned but receives $2.50 for every calendar after the first 50 returned. Does this change theoptimal order quantity?
We are given the following information for a product:Order cost $50Annual demand N(960, 3,072.49)Annual holding cost $6/item/yearShortage cost $80 per unitLead time one monthSales price $40 per unitProduct cost $30 per unita Determine the order quantity and the reorder pointunder the assumption that all demands are backordered. b Determine the order quantity and reorder point un-der the lost sales assumption.
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
Fixed-order-interval. This type of problem can be recognized when an order interval is given (e.g.,inventory is ordered every 10 days) along with the demand rate, lead time, and quantity on hand atorder time. Use Formula 13–16 to find the optimal order size.A lab orders a number of chemicals from the same supplier every 30 days. Lead time is five days.The assistant manager of the lab must determine how much of one of these chemicals to order. Acheck of stock revealed that eleven 25-milliliter (ml) jars are on hand. Daily usage of the chemical isapproximately normal with a mean of 15.2 ml per day and a standard deviation of 1.6 ml per day. Thedesired service level for this chemical is 95 percent.a. How many jars of the chemical should be ordered?b. What is the average amount of safety stock of the chemical?
Consider that you work at Kroger Grocery store, and that you've been tasked with creating an ABC inventory classification for 6 items. The 6 items, as well as their profit per case and number of cases sold per week, are as follows:Ribeye Steak - $135 in profit per case, 3 cases sold per weekLobster Tail - $245 in profit per case, 3 cases sold per weekPasta - $23 in profit per case, 12 cases sold per weekSalt - $3 in profit per case, 2 cases sold per weekNapkins - $12 in profit per case, 2 cases sold per weekTomato Sauce - $23 in profit per case, 11 cases sold per weekUsing total weekly profits, please classify each products into A, B, or C categories. Which items form the boundary of the class A and B items in your classification, and why? Which items form the boundary of the class B and C items in your classification, and why?
The table below provides demand data for 11 days (days 10-20 for the current year) for one product for the next 4 questions. The previous order was for 300 units at the end of day 9. The lead time is a constant two days. At the beginning of day 10 the inventory level is 450 units. Orders are made at the end of a day. Suppose inventory is managed with a reorder point system where Q=300 and the reorder point is 250. Day Demand Inventory 10 120 11 150 12 120 13 100 14 80 15 80 16 60 17 60 18 60 19 40 20 80 1) When is the next order? end of day ________ 2) How large is the next order? ________ 3) When is the subsequent order (after that above)? end of day _______ 4) How large is that order? _________
The selling price of a certain type of computer RO 1,000and the annual holding cost 20\% of the value of the itemMonthly demand is 1000 units, and the order cost is RO 200 per order. What is the approximate economic order quantity Round-up to the nearest Integer 142 None is correct Od 110 155
Rocky Mountain Tire Center sells 20,000 go-cart tires 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 500 or more-but fewer than 1,000- tires a re ordered, and $17 per tire if I ,000 or more tires areordered.a) How many tires should Rocky Mountain order each time it places an order?b) What is the total cost of this policy?

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