QUESTION 27Determine the value of X in the below table.Item: ASafety Stock = 20Description: Eiger WaterbottleLot-Size: FOQ = 140Lead Time = 1 weekPeriod3738394041424344Gross Requirements125125125140140150150150Scheduled Receipts1401400 0On Hand100XNet RequirementsPlanned Order ReceiptsPlanned Order Releases

Answered: QUESTION 27 Determine the value of X in…

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

question #3 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. With a safety stock of 300 boxes, what is the approximate service level (round to two decimals)? Numeric Response 84.13 * f5 10 f6 0 4- ♫+ fg C fil W f12. insert prt sc + 11 Ə ← delete backspace home num lock 4x D end 1:23 PM 11/15/2022 pg up
52
QUESTION 1:A confectioner buys plastic boxes in bulk and uses them to pack chocolates. The annual requirement of these boxes is 1,200, and each box costs $30. The ordering and carrying costs are $10 per order and 20%, respectively. The supplier from whom the confectioner purchases these boxes sells them only in lots of 25, that is, you only purchase quantities in multiples of 25 boxes.(a) How many boxes should the confectioner order so as to minimise inventory total stocking costs?(b) If the supplier offers 2% discount on the cost of each box when the purchases are in quantities of 300 at a time, should the confectioner accept this offer?(c) Suppose the supplier has decided that instead of the 2% discount offer the following price breaks will be used:ORDER QUANTITY COST PER BOXLess than 100 $30.00100 to 199 $29.75200 or more $29.60What order quantity should the confectioner make?
Please do not give solution in image format thanku
QUESTION 2 Based on the information given below, compute the planned order releases and projected on hand balances for part A, P and M. Graph 1: Bill of Materials (BOM) J (2) Y (3) P (2) B M Table 2: Materials Requirement for Part A, P and M Part A Week 1 2 3 4 5 6. Gross requirement Scheduled receipts Projected on-hand inventory Net Requirements Planned order receipts Planned order releases Quantity = 50, Lead Time = 2, Safety Stock = 0 20 10 20 50 25 Part P Week 1 2 4 Gross requirement Scheduled receipts Projected on-hand inventory Net Requirements Planned order receipts Planned order releases Quantity = Lot-for-Lot, Lead Time = 1, Safety Stock = 30 60 100 %3D
Questions in red 10-12
Quantity Ordered From To Price Per Roll 1 and up Order Quantity 1 86 2 452 3 492 4 191 5 356 6 148 7 342 8 382 9 276 10 118 11 464 12 188 13 25 14 427 15 30 16 111 17 161 18 314 19 442 20 429 21 451 22 32 23 181 24 163 25 336 26 240 27 68 28 317 29 435 30 211 31 76 32 374 33 415 34 408 35 196 36 302 37 312 38 31 39 317 40 394 41 348 42 49 43 500 44 490 45 94 46 285 47 237 48 101 49 53 50 257 51 273 52 415 53 346 54 133 55 287 56 431 57 113 58 197 59 6 60 328 61 114 62 207 63 273 64 257 65 113 66 400 67 324 68 500 69 60 70 117 71 466 72 370 73 293 74 164 75 63 76 252 77 394 78 109 79 233 80 340 81 430 82 210 83 363…
Beginning Quantity Ending Inventory Order? Lost Week Demand inventory on-order inventory position (yes/no) Sales 1 100 53 2 40 3 36 4 38 5 55 6 34 7 30 8 31 9 40 10 57 11 30 12 53
Question 3 Which of the following Inventory Holding Costs refers to the cost associated with return on the investment in inventory? Service Capital Cost Space Risk
Q.3.2 Mpho is an avid seamstress and want to sew and sell high quality, reusable,designer face masks during the current Covid-19 pandemic. She will design andsew the masks herself and use her automatic embroidery machine to put her logoon each mask sold. With the help of her son, deliveries will be made all overGauteng within 3 days of placing the order. Every mask will have a unique threelayer design with adjustable straps to ensure comfort and fit. Mpho’s only expenseis the material needed to sew the masks and delivery costs. At this stage, Mpho’starget market is limited to Gauteng.Draw a diagram to illustrate the transformation process of Mpho’s new business.Be sure to include all relevant elements, headings and arrows to indicate the flowof products/ services.
Which of the following is NOT an assumption of the basic EOQ model? Question 29 options: No stockouts are allowed. Annual demand is constant and known. Quantity discounts are available. Lead-time is constant and known.
Demand = 1570 per quarter, T (Inventory period) = 5.4 months, Lead Time - 3.9 weeks, safety stock- 15. Q11.1. What is the inventory period (ROP, Q)?

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