*Holding cost = $3.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40.Develop a lot-for-lot solution (enter your responses as whole numbers).PeriodGross requirementsOn-hand at beginning of periodOn-hand at end of periodOrder receiptOrder release40120234045181306 73070J▬▬▬8 9 10 11 1210 7060||||| ↑Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*.Period1Gross requirements 202340PeriodGross requirementsOn-hand at haninning of period 404Develop a lot-for-lot solution (enter your responses as whole numbers).120256730 70 30*Holding cost = $3.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40.34045308670910 707308119101012607011 1260T

Find the Calculation methods below: Project on hand = Project on hand - Gross requirementsNet…

Answered: Develop a lot-for-lot solution (enter…

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

Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table". 1 2 3 4 40 5 6 7 40 60 30 Period Gross requirements 30 Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements On-hand at beginning of period On-hand at end of period Order receipt Order release "Holding cost = $1.50/unit/week; setup cost-$150; lead time = 1 week; beginning inventory = 40. 40 1 30 2 3 40 8 4 5 6 7 40 60 30 9 20 70 10 11 12 50 8 10 11 9 20 70 12 50
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)?
Using the gross requirements schedule below*, prepare an alternative ordering system that orders every 3 weeks for 3 weeks ahead (a periodic order quantity). What is the cost of this ordering system? Period 1 2 3 4 5 6 7 Gross requirements 25 20 40 0 10 50 30 The cost of this ordering system is $ Prepare a net requirements plan (enter your responses as whole numbers). *Holding cost = $1/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 25 units. Period Gross requirements On-hand at beginning of period On-hand at end of period Net requirements Order receipt Order release (enter your response as a whole number). 25 1 25 2 20 3 40 4 5 0 10 8 0 6 50 9 10 30 65 7 30 8 9 10 0 30 65
Average daily demand (normally distributed) = 15 Standard deviation = 5 Lead time is constant at 2 days 90% service level desired Z for 90% = 1.28 From Appendix I Q2.2. What reorder point should be?
Develop a solution with PPB Lot-Sizing technique and calculate the total relevant costs for the gross requirements in the following table Period 1 Gross requirements 30 2 3 30 Period Gross requirements On-hand at beginning of period 40 On-hand at end of period 4 Develop a PPB solution (enter your responses as whole numbers) 2 1 30 5 6 7 30 60 30 "Holding cost-$2 50/unit/week, setup cost = $200, lead time=1 week; beginning inventory = 40. 3 30 Order receipt Order release The total cost is $ (enter your response as a whole number) 8 4 9 10 11 12 20 80 50 5 6 7 30 60 30 8 9 20 80 10 11 12 50
Given: Demand = 1248 items per year, Inventory period or Time between orders = 13 weeks. Q5.1. Calculate Lot Size or Order Quantity
Give 3 examples of inventory risk.
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!
Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
Famous Albert prides himself on being the Cookie King of the West. Small, freshly baked cookies are the specialty of his shop. Famous Albert has asked for help to determine the number of cookies he should make each day. From an analysis of past demand, he estimates demand for cookies as DEMAND PROBABILITY OF DEMAND 1,800 dozen 0.05 2,000 0.10 2,200 0.20 2,400 0.30 2,600 0.20 2,800 0.10 3,000 0.05 Each dozen sells for $0.69 and costs $0.49, which includes handling and transportation. Cookies that are not sold at the end of the day are reduced to $0.29 and sold the following day as day-old merchandise. Compute the expected profit or loss for each cookie making decision quantity. (Round your answers to the nearest whole number. Enter expected losses with a negative sign) Based on your answers to part a., what is the optimal number of cookies to make? By using marginal analysis, what is the optimal number of cookies to make?
Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 40 30 20 20 10 40 50 *Holding cost=$1.50/unit/week; setup cost=$150; lead time=1 week; beginning inventory=40. What is the average demand per week? (enter your responses with 2 decimal places): enter your response here Calculate Economic Order Quantity (EOQ) (enter your responses as whole numbers): enter your response here Calculate the number of periods for POQ (enter your responses as whole numbers): enter your response here Develop a POQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20…
Given the information below, conduct an ABC analysis and determine which items should be classified as A, B, and C. Which items do you suggest the firm keep the tightest control over? Explain. Item Part Number Item Cost Quantity In Stock 142-AZ $546.00 318 4392-GF $45.00 1250 86935-ES $15.35 3546 173-DC $653.00 1876 999-BA $199.00 526 7846-NM $23.00 973 2765-OP $385.00 790 103-VX $12.50 4875 2648-YT $16.75 5185

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

Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements On-hand at beginning of period 40 On-hand at end of period Order receipt Order release 1 20 2 3 40 4 5 6 7 30 70 30 8 10 11 12 60 9 10 70 T