Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*.Period12345678 9 101112Gross requirements20304070 3010 7050*Holding cost $3.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40.Develop a lot-for-lot solution (enter your responses as whole numbers).Period1 2345 6 7 8910 1112Gross requirements203040 7030107050On-hand at beginning of period40On-hand at end of periodOrder receiptOrder release

Answered: Image /qna-images/answer/3b61932a-607a-4c52-81b9-fee88b75db8b.jpg

Answered: Develop a lot-for-lot solution and…

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*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 40 70 30 10 70 50 *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). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 40 70 30 10 70 50 On-hand at beginning of period 40 On-hand at end of period…
Develop a lot-for-lot 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 30 30 30 60 30 20 70 60 *Holding cost=$3.50/unit/week; setup cost=$150; lead time=1 week; beginning inventory=40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 30 30 30 60 30 20 70 60 Scheduled receipt Projected On-hand 40 enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here…
Develop a lot-for-lot 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 30 30 70 30 20 80 50 *Holding cost=$1.50/unit/week; setup cost=$200; lead time=1 week; beginning inventory=40. Part 2 Develop a lot-for-lot solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 70 30 20 80 50 On-hand at beginning of period 40 enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter…
The time-phased net requirements for the base assembly in a table lamp over the next six weeks are: Week 1 2 3 4 5 6 Requirements 335 240 180 320 320 200 The setup cost for the construction of the base assembly is $200, and the holding cost is $0.30 per assembly per week. What lot sizing do you obtain from the EOQ formula? Determine the lot sizes using the Silver–Meal heuristic. Determine the lot sizes using the least unit cost heuristic. Determine the lot sizes using part period balancing. Determine the lot size using the Wagner–Whitin algorithm. Compare the holding and setup costs obtained over the six periods using the policies found in parts (a) through (e) with the cost of a lot-for-lot policy.
i have found anther answer for this question on bartleby and it has a lot less working out and he didnt give answer to second question but the answer he gave for the first one is very different i am not sure which one to use below is his answer: Step 1: Basic Information The question is related to Economic order quantiy Economic Order Quantity is that level of inventory at which ordering cost and handling cost are minimum. It is calculated with the help of following formula Economic Order Quantity = √2RO ÷ C R = Annual Requirment C = Carrying or Holding cost O = Ordering Cost Step 2: Solution Economic Order Quantity = √2RO ÷ C Economic Order Quantity = √2 × 3000 × 20 ÷ 4.25 Economic Order Quantity = √28,235.294117647 Economic Order Quantity = 168.0336100834 pounds R = Annual Requirment i.e.250 × 12 = 3000 pounds per annum. C = Carrying or Holding cost i.e. £4.25 O = Ordering Cost i.e. £20 Quantity to be ordered = 168.03 pounds. Supplier = Vendor 1 should be used as the cost…
The time-phased net requirements for the base assembly in a table lamp over the next six weeks areWeek 1 2 3 4 5 6Requirements 335 200 140 440 300 200The setup cost for the construction of the base assembly is $200, and the holding cost is $0.30 per assembly per week.a. What lot sizing do you obtain from the EOQ formula?b. Determine the lot sizes using the Silver–Meal heuristic.c. Determine the lot sizes using the least unit cost heuristic.d. Determine the lot sizes using part period balancing.e. Compare the holding and setup costs obtained over the six periods using the policies found in parts (a) through (d) with the cost of a lot-for-lot policy.
Please complete the sup part: e,f and g. 1.B&H needs to decide how to manage its inventory of cameras. The demand for cameras at B&H is 200 cameras per week. Each time that B&H places an order for a new shipment of cameras, it must pay $80 in fixed processing fees. A camera costs B&H $60 to purchase. The cost for B&H to hold a camera in its store for one week is $4. Assume that the lead time for the delivery of a camera is 0 weeks.a. Suppose that B&H places orders for cameras in quantities of 50 cameras at a time and places a new order for cameras each time that it runs out. Draw a graph showing the number of cameras that B&H has on-hand in inventory at each point in time up until the time when it places its fourth-order. Label the points in time at which B&H places a new order. Assume that B&H places its first order for 50 cameras on day 0.b. Suppose again that B&H places orders for 50 cameras at a time. What will be B&H’s average holding…
In a typical fast-food operation, identify various forms and functions of inventory. How could investment in inventories be lowered? What might be the potential consequences?
What changes can you envisage in economic order quantity based planning when the demand for the item increases by 5%? A) The economic order quantity will come down by √(5%) B) The carrying cost will increase by 1/ √(5%) C) The total cost of the plan will go up by √(5%) D) The total cost of the plan will go up by 5%
A initially assume that Phi wants to minimize his inventory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using a lot-for-lot (L4L). Gear box requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release Input shaft requirements Week 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements Scheduled receipts Projected available balance Net requirements Planned order receipt Planned order release
DOGGE Ltd has annual demand of 50,000 desks and the purchase price of each desk is K250. There are ordering costs of K200 for each order placed. Inventory holding costs amount to 10% per year of inventory value. Calculate the inventory costs p.a. for the following order quantities, and plot them on a graph: 500 units, 750 units, 1000 units, 1250 units b) Using the information in (a) above calculate i) Economic Order Quantity and the total inventory costs for this order quantity.
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 30 30 30 20 10 40 60 *Holding cost =$ 2.50/unit/week; setup cost =$ 150; lead time =1 week; beginning inventory =40. What is the average demand per week? with 2 decimal places): Calculate Economic Order Quantity (EOQ) Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 Scheduled receipt…

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