15-12. Complete the following MRP matrix for item A:Item: ALLC: 1PeriodLot Size: Mult 50LT: 2 1 2 3 4 5 67 810 15 25 75 60 85 45 60Gross RequirementsScheduled ReceiptsProjected on HandNet RequirementsPlanned Order Receipts50Planned Order Releases

Answered: 15-12. Complete the following MRP…

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

1.
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 2,200 January 1,400 May February 1,600 June 2,200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August.
Using the information given and assuming that 2500 ModelA fountains are scheduled for completion, calculate the grossrequirements of each component. Use the beginning inventories given
K Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 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 2 40 3 40 1 30 U 4 2 *Holding cost = $2.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. 5 6 7 30 70 20 3 40 8 4 9 10 10 80 5 6 7 30 70 20 8 11 9 10 D 12 50 10 11 12 80 50
please answer within 30 minutes.
3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 48,000 of these trikes. Current schedules yield the following information. Component Front Seat/Frame Rear wheel (each) Available Requirement Plastic 12 16 .20 S Model Regular Deluxe Heavy 100000 Time 40 24 8 2 2 320000 60000 Page 4 of 9 Space Manufacture 8 16 8 4 Cost to 12 2 3 4 5 Cost to Purchase 24 The company obviously does not have the resources available to manufacture everything needed for the completion of 24000 tricycles so has gathered purchase information for each component. Requested: Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 24000 fully completed tricycles at the minimum cost. 18 6 4) A paint supply company makes three styles of Paint Rollers, regular, deluxe and heavy.…
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
The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead time for A is two weeks, and setup cost is $10. There is a carrying cost of $0.02 per unit per week. Beginning inventory is 72 units. WEEK 1 2 3 4 5 6 7 8 9 10 Gross requirements 21 12 15 45 10 30 100 20 40 150 Use the least total cost lot-sizing method to determine when and for what quantity the first order should be released. Least total cost method indicates that periods units should be ordered to cover the needs for
Please do not give solution in image format thanku
Order policy = 80 units Lead time = 2 weeks
Flora’s Fabulous Fountains’ (FFF) top product is its ModelA. Using the information given, draw the product structure treefor the Model A
For the following bill of material, if we need to produce 10 units of finished product P, how many component C do we need? Assume there is no on-hand inventory. P M(3) 80 0 120 O 16 40 160 N(4) B(3) C(4) D(5) C(4)

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

15-12. Complete the following MRP matrix for item A: Item: A LLC: 1 Period Lot Size: Mult 50 LT: 2 1 2 3 4 5 67 8 10 15 25 75 60 85 45 60 Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned Order Receipts 50 Planned Order Releases