The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three weeks and setup cost is $10.There is a carrying cost of $0.010 per unit per week. Beginning inventory is 100 units.WEEK410Gross requirements 4020540203060802060100Use the least total cost and the least unit cost lot-sizing methods to determine the quantity to order with the first order released witheach method and which periods' requirements will be covered by that order.Quantity Ordered Periods CoveredLeast total costLeast unt cost

Least total cost method: Item A Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8…

Answered: The MRP gross requirements for Item A…

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

Newpaper sales data suggest that 20% of the days, 80 papers are sold; 40% of the days, 90 papers are sold; and the remaining days, 100 papers are sold. Given the vendor plans to stock 90 each day, what approx. expected CSL is the vendor targeting? 60% 36% 57% 65%
So, what exactly is the function of finished-goods inventory?
Item X is a standard item stocked in a company's inventory of spare parts. Each year, the firm uses about 2,000 units of Item X, which costs Php 1,000 per unit. Storage costs, which include insurance and cost of capital, amount to 18 percent of item unit cost. Placing an order for more of Item X costs Php 400. The company operates 360 days per year and Item X is received 9 days after placement of order.
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. 5 6 7 30 70 30 9 10 11 12 60 10 70 Period 1 Gross requirements 20 2 Period Gross requirements On-hand at beginning of period 40 On-hand at end of period Order receipt Order release 3 40 1 20 4 *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). 2 3 40 4 8 5 6 30 7 70 30 8 9 10 11 12 10 70 60 corn
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period Gross requirements 1 2 20 3 4 56 7 8 9 10 11 12 30 30 60 20 20 80 60 *Holding cost $1.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 Gross requirements On-hand at beginning of period On-hand at end of period 1 2 3 4 56 7 8 9 10 11 12 20 30 30 60 20 20 80 60 40 20 30 20 20 Order receipt Order release
Please do not give solution in image format thanku
Please solve correctly. Don't solve if you don't know -
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period Gross requirements 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 1 Order receipt Order release 30 2 3 30 1 30 40 || 4 5 2 6 7 40 70 20 *Holding cost = $3.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. 3 4 30 8 9 10 11 12 5 6 7 40 70 20 20 80 8 60 9 10 20 80 11 12 60
Full steps
Calculate reorder level from the following, consumption per week 100 – 200 units and delivery period 42 – 70 days. a. 800 units b. 1,600 units c. 2,000 units d. 2,400 units
Explain the economic order quantity (EOQ) and its impact on cost of operations.
Calculate reorder level from the following, consumption per week 100 – 200 units and delivery period 28 – 56 days. a. 2,000 units b. 2,400 units c. 800 units d. 1,600 units

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