Problem 2:WeekForecastCustomer OrdersProjected On-Hand InventoryMPSAvailable-to-PromiseOn-hand Inventoryschedule productionwhenever projected on-handinventory drops belowMPS lot sizeComplete the master production schedule based on thefollowing information16016030300112011021001003130754110505140326140117170581800

The master production schedule is a detailed plan that describes the number of goods that should be…

Answered: Problem 2: Week Forecast Customer…

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

Can you assist me with Problem 5
A Figure 16.19 B (1) C(2) LT = 1 LT = 2 TABLE 16.1 D (1) INVENTORY RECORD DATA ITEM LT = 3 DATA CATEGORY Lat sizing rule Lead time Scheduled rece pts FOQ = S00 units 3 weeks POQ (P=3) L4L 1 week 2 weeks Nane 200 (week 1) None Beginning (on hand) inventory 20 425 POQ tum: 8 Lat sie: POQP - 3) Description. Lead time: 1wek Week 10 Gross 100 200 120 180 60 requirements Scheduled Projected on hand inventory Hanned receipti Hanned order reteases L4L tam: C Lat sue: LAL Description Lead time 2 weks Week 10 Gross 200 400 240 120 requirements Scheduled cepts Projected on hand imventory Hanned recets Manned ordur releases
Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 1 week February Item: A Quantity on Hand: 80 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 1 60 35 20 0 January 2 70 15 3 18 8 60 90 BID 4 40 0 LE Week 5 45 30 6 45 70 7 55 0 8 50 0
Which product represent cash caw, question mark, dog and star in mtn products
2.7 Which of the following help explain how the Reorder Point (ROP) works in conjunction with the Economic Order Quantity (Q), the number of orders (N) and the time between orders (T)? a) The Economic Order Quantity (Q) and the Annual Demand (D) are used to determine the number of Order (N) b) The number of orders (N) and the number of days that a firm works (W) are used to determine the time span between orders (T) c) Orders are placed every T days unless the inventory on hand fall to or below the Reorder Point d) Only a and b e) f) Only b and c All of a, b and c 2.8 The objective of Inventory Management is to balance inventory investment (cost) and customer service. a) TRUE b) False 2.9 The Economic Order Quantity (EOQ), the number of orders, the Reorder Point (ROP), the time between orders are important analytics in Inventory Management. a) TRUE b) FALSE 2.10 The number of working days for a firm is an important input in calculating the components of the Economic Order Quantity…
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
question #2 Same problem statement: Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier, with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each box costs the retailer $10, and the inventory holding cost is 25% per year. If the retailer wants to achieve a 99% service level (use the z-value with one decimal, as in Table 13.4 on page 400 of the textbook), what should be the safety stock value? Numeric Response 772.8 SHARE f5 f6 4- f7 ♫+ fg fil W f12. insert prt sc delete home @ 0 end 1:23 PM 11/15/2022 pg L
2
Component Immediate Parent Usage per Parent Lead Time (weeks) Beginning Inventory A none — 1 0 B A 2 2 250 C A 1 6 500 D A 3 3 750 E A 2 2 750 F B 4 2 3000 G B 2 4 1000 H D 3 2 5000 I D 2 4 5000 J E 1 8 1000 K E 5 1 5000 L E 2 4 2500 M F 3 3 250 N F 6 3 2560 O H 2 4 0 P K 1 2 500 Q K 2 3 1000 Using the information given, calculate the replenishment time when no beginning inventory exists.
question #5 Same problem statement: Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier, with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each box costs the retailer $10, and the inventory holding cost is 25% per year. Under the current order quantity of 5,000 boxes and current reorder point of 4,200 boxes, what would be the order-up-to level S that the retailer should use as a baseline to calculate how much inventory to order when conducting a periodic review? Numeric Response 1500 f4 ***** LA f5 40 % f6 4- 0 C + & 7 < Prev. 門 fg KAA * 8 5 of 5 DII hp f10 DDI 9 Next fi W f12. insert prt sc + 11 ( ← delete backspace home num lock end 1:24 PM 11/15/2022 pg up
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
Discussion Questions 1. The customer order decoupling point was described as the point at which the demand changed from independent to dependent. Describe what this means and why it is important to managers. 2. Provide examples of make-to-stock, assemble-to-order, and make-to-order products. What advantages are there in moving from make-to-stock to assemble- or make-to- order?

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