answer in 30 mins. Q3) The cost for a product B is 18 TL per unit. Holding cost is 16 TL per unit per quarter and ordercost is given as 750 TL. Find optimal lot sizing for product B using Wagner whitin aigorithm. Demandfor upcoming quarters are given below.Demand Quarter1 Quarter2 Quarter3 Quarter4225180345267B.

Find the Given details below: Given details: Product cost (k) 18 TL per Unit Holding cost…

Answered: Q3) The cost for a product B is 18 TL…

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

M. P. VanOyen Manufacturing has gone out on bid fora regulator component. Expected demand is 700 units per month.The item can be purchased from either Allen Manufacturing orBaker Manufacturing. Their price lists are shown in the table.Ordering cost is $50, and annual holding cost per unit is $5.ALLEN MFG. BAKER MFG.QUANTITY UNIT PRICE QUANTITY UNIT PRICE1–499 $16.00 1–399 $16.10500–999 15.50 400–799 15.601,0001 15.00 8001 15.10a) What is the economic order quantity?b) Which supplier should be used? Why?c) What is the optimal order quantity and total annual cost ofordering, purchasing, and holding the component? PX
2) Daily demand for a product is normally distributed with a mean of 100 and a standard deviation of 12. The lead time is normally distributed with a mean of 5 days and a standard deviation of 1.5 days. a) What is the ROP to satisfy a %90 probability of not stocking out? b) What is the safety stock? c) What is the probability of stocking out if the manager has decided not to keep any safety stock? What is the Z value, and what is the probability?
Given the following list of items,a. Classify the items as A, B, or C.b. Determine the economic order quantity for each item (round to the nearest whole unit).ItemEstimatedAnnualDemandOrderingCostHoldingCost(%)UnitPriceH4-010 20,000 50 20 2.50H5-201 60,200 60 20 4.00P6-400 9,800 80 30 28.50P6-401 14,500 50 30 12.00P7-100 6,250 50 30 9.00P9-103 7,500 50 40 22.00TS-300 21,000 40 25 45.00TS-400 45,000 40 25 40.00TS-041 800 40 25 20.00V1-001 33,100 25 35 4.00
Solve the newsperson problem. Probability 0.11 0.15 Value 1 2 Purchase cost c Selling price p Salvage value v = |||||| Optimal order quantity = 0.24 3 13 29 양 11 What is the optimal order quantity? 0.28 4 0.16 5 0.06 6
SOLVE THE NEWSPERSON PROBLEM. PROBABILITY 0.24 0.08 0.21 0.16 0.08 0.23 VALUE 1 2 3 4 5 6 PURCASE COST C = 12 SELLING PRICE P = 28 SALVAGE VALUE V = 4 What is the optimal order quantity?
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $50, and annual holding cost per unit is $6. Allen Mfg. Quantity 1-499 Baker Mfg. Unit Price Quantity Unit Price $16.00 1-399 $16.10 15.50 15.00 400-799 800+ 500-999 1000+ 15.60 15.10 a) What is the economic order quantity if price is not a consideration? 381 units (round your response to the nearest whole number). b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg. c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? The optimal order quantity is ☐ with a total cost of $ (round your responses to the nearest whole number).
Mary hopes to sell 10,000 pieces of chrysanthemum last November but she was able to sell 15,000 chrysanthemum. Her chrysanthemum is sold at 20 pesos each. Her total expenses was 150,000, hence, cost per unit is 15.00. What was her sales volume variance? * 15,000 75,000 25,000 O 100,000
A Las Vegas supermarket bakery must decide how many wedding cakes to prepare for the upcoming weekend. Cakes cost $33 each to make, and they sell for $60 each. Unsold cakes are reducedto half-price on Monday, and typically one-third of those are sold. Any that remain are donated toa nearby senior center. Analysis of recent demand resulted in the following table:Demand 0 1 2 3Probability .15 .35 .30 .20How many cakes should be prepared to maximize expected profit?a. Use the ratio method.b. Use the tabular method
A jewelry shop procures a ring at $20 each and sells it at $80 each. Weekly demands for the ring over the past 20 weeks are as follows. Demand 51 52 53 54 55 56 57 58 59 60 Frequency o 1 3 2 2 3 4 2 2 1 What are the under-stocking and over-stocking costs for the shop? What is the newsvendor critical ratio? How many rings per week should the shop order? Suppose that the weekly demand is uniformly distributed between 40 and 80. How many rings per week should the shop order?
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 700 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $45, and annual holding cost per unit is $4. Allen Mfg. Quantity 1-499 500-999 1000+ Baker Mfg. Unit Price $16.00 15.50 15.00 Quantity 1-399 400-799 800+ Unit Price $16.10 15.60 15.10 a) What is the economic order quantity if price is not a consideration? 435 units (round your response to the nearest whole number). b) Which supplier, based on all options with regard to discounts, should be used? Allen Mfg. c) What is the optimal order quantity and total annual cost of ordering, purchasing, and holding the component? (round your responses to the nearest whole number). The optimal order quantity is ☐ with a total cost of $
M. P. VanOyen Manufacturing has gone out on bid for a regulator component. Expected demand is 725 units per month. The item can be purchased from either Allen Manufacturing or Baker Manufacturing. Their price lists are shown in the table. Ordering cost is $50, and annual holding cost per unit is $4. Allen Mfg. Quantity 1-499 Baker Mfg. Quantity Unit Price Unit Price $16.00 1-399 $16.10 500-999 15.50 400-799 15.60 1000+ 15.00 800+ 15.10 a) What is the economic order quantity if price is not a consideration? units (round your response to the nearest whole number).
6 5 7 8 Assume the lead time is 1.5 weeks, the inventory period is 4.6 weeks, and the stockout level is 10%. Week Demand 1 3 2 470 424 467 412 426 426 480 507 487 44 9 10 Note: 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) is Formulas: ROP = Mean*Lead time +Z*sqrt (Variance* Lead time) Lot size = Mean Demand * Inventory Period. (Q=M*T) 401 LL 44 LT

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

Q3) The cost for a product B is 18 TL per unit. Holding cost is 16 TL per unit per quarter and order cost is given as 750 TL Find optimal lot sizing for product 8 using wagner Whitin algorithm. Demand for upcoming quarters are given below. Demand Quarteri Quarter2 Quarter3 Quartera 267 225 180 345