6578Assume the lead time is 1.5 weeks, the inventory period is 4.6 weeks, and thestockout level is 10%.Week Demand13247042446741242642648050748744910Note: Use Excel function to find Mean and Sample Demand Variance of the dataset.Q13.1. The Reorder point is approximately -Q13.2. The Lot size (Q) isFormulas: ROP = Mean*Lead time +Z*sqrt (Variance* Lead time)Lot size = Mean Demand * Inventory Period. (Q=M*T)401LL44LT

Economic order quantity (EOQ) is the optimal order quantity that helps in minimizing the total…

Answered: 7 69 6 8 5 3 4 Assume the lead time is…

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

here its the right answered please just provide me an explanation of how did you get this number with an calculation(24, 33, 33, 18, 10)
1. Which of the following quantities has no effect on the first period’s ATP calculation? a) Current on-hand Inventory b) Booked customer orders for the first periods c) MPS quantity for the first period d) Forecasted demand for the first period 2. Which one of the following is an MRP lot-sizing rule that attempts to minimize the amount to minimize the amount of average inventory? a) Periodic order quantity (POQ), WITH P=2 b)Fixed order quantity (FOQ) c) Economic order quantity (EOQ) d)Lot for Lot (L4L). 3. Which of the following statements about lot-sizing rules for MRP is true? a) The periodic order quantity (POQ) rule generates a higher level of average inventory since it creates inventory remnants. b) FOQ is a dynamic lot-sizing rule which reduces the amount of inventory, by doing a better job of matching the order quantity to the projected on-hand inventory quantity. c) The lot for lot rule minimizes inventory investment but maximizes the number of orders placed. d) In…
c4 need urgent in 15 minutes
The table above provides the aggregate plan of production by a firm. It is known that the firm uses a level plan with backorders. Given this information, what is the number in the cell with the question mark?
OQ14
a) The average monthly demand requirementequals = ___ units. (whole number) b) The total stockout cost = $____(whole number.) c) The total inventory carrying cost = $____(whole number) d) The total cost, excluding normal time labor costs, is = $____(whole number.)
dt = demand Kt = ordering cost Ct = cost per item ht = holding cost per item per unit time
Backorders: A company is working on its quarterly aggregate production plan. Its quarter forecasts are 6000, 1000, 2500 and 2000, respectively. Suppose that it will use a level plan with backorders (one that produces at the average demand over the four quarters). What is the ending inventory in Quarter 3? (Do not round your intermediate calculations. Round your final answer to the nearest whole number. Only enter the number. Do not enter any units.)
You have the data on the application during the 6 consecutive years below Requirement / Find the expected demand for the year 2008 using the simple moving average method The basis of three periods of time the years 2002 2003 2004 2005 2006 2007 2008 Order quantity 10 20 30 40 50 60
Historical demands observed for the last 5 months are 1000, 2300, 3200, 1750, and 1200. To match the demand, the company placed respective orders of 1100, 2500, 4000, 1000, and 900 units. (a) Compute the variance of demand. (b) Compute the variance of orders. (c) Compute the bullwhip measure. Is there an amplifying or smoothing effect?
Ram Roy's firm has developed the following supply, demand, cost, and inventory data Period 1 2 3 Regular Time 30 30 40 Supply Available Overtime Subcontract 5 15 15 15 5 5 Demand Forecast 40 20 units $100 $150 $200 $6 45 55 Initial inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost per unit per month Assume that the initial inventory has no holding cost in the first period and backorders are not permitted Allocating production capacity to meet demand at a minimum cost using the transportation method, the total cost is $ (enter your response as a whole number)
I want the answer

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

7 69 6 8 5 3 4 Assume the lead time is 1.5 weeks, the inventory period is 4.6 weeks, and the stockout level is 10%. Week Demand 1 470 424 467 412 426 426 2 480 507 487 401 H 10 Note: Use Excel function to find Mean and Sample Demand Variance of the dataset. int is approximately