Complete the master production schedule (enter your responses as whole numbers).On-hand inventory at end of week 1: 190WeekForecasted demandBooked ordersProjected ending inventoryMaster production scheduleAvailable to promise228012568077034001702804290265640650525015039062602659658407250240715829012512958705559310190985

A production plan that details which goods will be produced, in what quantities, and by when is…

Answered: Complete the master production schedule…

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

Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Q = 60, LT= 3 weeks, Safety Stock = 5 1 70 70 PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Planned Order Releases 1 70 70 100 2 0 > X WEEK 3 40 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". 2 0 4 0 100 WEEK 3 40 5 160 60 4 0 40 0 X 5 160 Check My Work -60 0
Assume that Product Z is made of two units of A and three units of B. A is made of four units of C and four of D. D is made of two units of E Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; A, B, C, and D take one week each; and E takes three weeks. Fifty one units of Product Z are required in Period 10. (Assume that there is currently no inventory on hand of any of these items.) b. Develop an MRP planning schedule showing gross and net requirements and order release and order receipt dates. (Leave no cells blank - be certain to enter "0" wherever required.) Period 6 8 10 Gross requirements Scheduled receipts Item Z OH = 0 LT = 2 SS = 0 Q = L4L Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Item A OH = 0 LT = 1 SS = 0 Q = L4L Scheduled receipts Projected available balance Net requirements Planned order receipts Planned order releases Gross requirements Scheduled receipts Item B…
Under which circumstances would you use single period/newsboy model for inventory management?
Critically evaluate decision to use the Economic Order Quantity (EOQ) model as part of the approach to the management of inventories.
The annual demand of Bulldogs Inc. sole product totaled 450,000 units. Due to uncertainty in supply of items, the maximum possible lead time for the orders is 2 weeks and 1 day. A safety stock of 6,250 units is determined. What is the normal lead time? (Use 360 days) A. 10 days B. 9 days C. 1 week and 5 days D. 1 week
Customer says: “Fifteen cases 4 points of olives will take up valuable space in my receiving room. It is already crowded."Salesperson says: “You will not have to face that problem. With the aid of our merchandising plan, you can display 10 cases immediately on the sales floor. Only five cases will become reserve stock. You should move all 15 cases in about two weeks."What methods of negotiation are being addressed in this scenario? * Direct Denial/Superior Benefit. O Indirect Denial/Third-party Testimony. Question/Trial offer. Superior Benefit/Postpone Method
Reorder Point Ordering: Average demand per day () is 25 units, with a std. dev. of (od) 15 units. Lead time (LT) is 49 days. Find demand during lead time (DDL), safety stock (SS) and reorder point (ROP ) for 4-sigma (z = 4). DDL= 500 units, SS = 1225 units, ROP = 1645 units DDL= 1,645 units, SS=420 units, ROP = 1225 units DDL= 1,225 units, SS = 420 units, ROP = 1645 units DDL= 0 units, SS = 1225 units, ROP = 420 units DDL= 420 units, SS = 1645 units, ROP = 420 units
Using the gross requirements schedule below*, prepare an alternative ordering system that orders every 3 weeks for 3 weeks ahead (a periodic order quantity). What is the cost of this ordering system? Period 1 2 3 4 5 6 7 Gross requirements 25 20 40 0 10 50 30 The cost of this ordering system is $ Prepare a net requirements plan (enter your responses as whole numbers). *Holding cost = $1/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 25 units. Period Gross requirements On-hand at beginning of period On-hand at end of period Net requirements Order receipt Order release (enter your response as a whole number). 25 1 25 2 20 3 40 4 5 0 10 8 0 6 50 9 10 30 65 7 30 8 9 10 0 30 65
Upon delivery, only the items quantity ordered on the PO(pruchase order) is received and a Daly Receiving Report (DRR)made by the supplier at the time of delivery. True or false?
Economic order quantity (Q*) is 2,000 units. Annual demand (D) is 12,000 units. Find number of orders per year (N*) and time between orders (T*) in weeks. N*=0.167 times per year, T*= 6 weeks N*=6 times per year, T*= 60.83 weeks N*=6 times per year, T*= 0.167 weeks N*=8.67 times per year, T*= 6 weeks N*=6 times per year, T*= 8.67 weeks
One unit of A is composed of two units of B and three units of C. Each B is composed of one unit of F. C is made of one unit of D, one unit of E, and two units of F. Items A, B, C, and D have 28, 40, 36, and 25 units of on-hand inventory. Items A, B, and C use lot-for-lot (L4L) as their lot-sizing technique, while D, E, and F require multiples of 62, 110, and 90, respectively, to be purchased. B has scheduled receipts of 15 units in Period 1. No other scheduled receipts exist. Lead times are one period for Items A, B, and D, and two periods for Items C, E, and F. Gross requirements for A are 15 units in Period 1, 12 units in Period 2, 50 units in Period 6, and 50 units in Period 8. Find the planned order releases for all items. (Leave no cells blank - be certain to enter "O" wherever required.) Period 3 4 6 7 8 Gross requirements Item A Scheduled receipts OH = 28 Projected available balance Net requirements Planned order receipts Planned order releases LT = 1 SS = 0 Q = L4L Gross…
Darren Company uses 36,000 yards of canvas each month to make tents. It usually takes four (4) days from the time Darren orders the material to when it is received. If the desired safety stock is 5,000 yards, what is the re-order point?(Answer format: 25,000) no peso sign, no unit of measure!

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