N.c.math More InfoOn-hand inventory at end of week 1: 120WeekForecasted demandBooked ordersProjected ending inventoryMaster production scheduleAvailable to promise23203308403230330440023546052301306220100900726022582602658602959320300- X Complete the following master schedule record.Click the icon to view the master schedule record.Complete the master production schedule (enter your responses as whole numbers).On-hand inventory at end of week 1: 120WeekForecasted demandBooked ordersProjected ending inventoryMaster production scheduleAvailable to promise23203306308403230330300 36046044002355230130130067220 260100225810550900826026511458602959320300825

The master production schedule is a plan that helps the organization in determining what type of…

Answered: Complete the following master 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

Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 190 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 2 280 125 680 770 3 400 170 280 4 290 265 640 650 5 250 150 390 6 260 265 965 840 7 250 240 715 8 290 125 1295 870 555 9 310 190 985
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
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?
Subject: Logistic management Q): What are the 2 approaches of BPR for implementation, give example? Q): What are the types & category of inventory management?
|Product D is stocked only at the AMC Chemical Company's Dallas warehouse and at the company's plant warehouse in Akron. The sales director has forecast product sales from the Dallas warehouse to be 40 units per week for the next 8 weeks. Product D is manufactured at the firm's Akron plant using 2 units of ingredient X per unit of product D. Information: Ingredient X Projected available balance: 4 Units Schedule receipt in week 1: 320 units Safety stock quantity: 2 Product D in Dallas Product D in Plant Warehouse Warehouse Projected available balance: 85 Units Safety stock quantity: 5 units Lead time: 2 weeks Lot for lot size quantity Projected available balance: 2 Units Schedule receipt in week 1: 46 units Safety stock quantity: 8 units units Lead time: 1 week Lead time: 4 weeks Lot for lot size quantity Lot size quantity: 320 units Prepare the DRP records for product D at the Dallas warehouse and the plant warehouse as well as the MRP record for ingredient X (Assume ingredient X is…
Q1) Bullwhip effect can lead to stock shortages due to lack of proper information. Select one: a. True b. False Q2) The ability to track the location of the order is known as supplier visibility. Select one: a. False b. True
Year Cost of Good Sold Beginning Inventory (In Pesos) Ending Inventory (In Pesos) 1 503,425 10,300 12,400 2 643,056 12,400 11,200 3 690,432 11,200 10,670 4 734,509 10,670 11,200 5 758,734 ? 10,987 REQUIRED Determine the inventory turnover for year 5. Determine the number of days the finished goods stay in inventory in Year 1. There was no improvement in inventory turnover in Year 5 compared to Year 1. This statement is not correct. Write YES or NO for the answer
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…
Case Study 4: Inventory Management. I) A Furniture manufacturing company uses 1200 units of an item annually and the cost price is $250 per unit. The ordering costs are $600 per order and holding costs are $4.00 per item per annum. Required: Calculate the economic order quantity. Determine the number of orders per annum. Determine the annual stock holding cost. Determine the annual ordering cost.
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…
Discount-Mart (see Problem 16.8), as part of its newLean program, has signed a long-term contract with SpecialtyLighting and will place orders electronically for its halogen lamps.Ordering costs will drop to $.50 per order, but Discount-Mart alsoreassessed its carrying costs and raised them to $20 per lamp.a) What is the new economic order quantity?b) How many orders will now be placed?c) What is the total annual cost of managing the inventory withthis policy?
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