Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*.PeriodGross requirements1 22034567891011123030 60 20208060*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).PeriodGross requirementsOn-hand at beginning of periodOn-hand at end of period123456 7 8 9 10 1112203030 60 202080604020302020Order receiptOrder release

Holding cost = Lead time = 1 weekSetup cost = Beginning Inventory = 40Formulas:

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". 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
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…
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
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
Best-Appliance makes high-powered industrial strength microwave oven and wants to create an MRP for their oven assembly with a minimum cost possible. Following table show gross requirements of their product for twelve weeks. Develop a Part Period Balancing (PPB) solution and calculate the total relevant costs for the plan. Week Gross requirements 1 30 Week Gross requirements On-hand at beginning of week 40 On-hand at end of week Order receipt Order release Total relevant cost for this plan is = $ 2 3 30 1 30 4 2 5 40 70 20 Also, for this plan the Holding cost = $2.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40 units. Use the table below to develop a PPB solution for MRP (enter your responses as whole numbers). 3 30 6 7 8 4 5 40 (enter your response as a whole number). 6 ॥ 70 9 10 70 7 20 10 11 8 D 12 50 9 10 11 12 10 70 50
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
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 40 40 60 20 10 70 50 *Holding cost=$2.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 30 40 40 60 20 10 70 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 your response here…
1. Why is accurate inventory such an important issue at Wheeled Coach? 2. Why does Wheeled Coach have excess inventory, and what kind of a plan would you suggest for dealing with it? 3. Be specific in your suggestions for reducing inventory and how to implement them. *You may wish to view the video that accompanies this case before
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 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
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.
P. Sherman Corp. purchases 8,000 transistors each year as components for fishing simulation game. The unit cost of each transistor is Php 10, and cost of carrying one transistor in inventory for a year is Php 3. Ordering cost is Php 30 per order? If you are the material planner of the company, what will be your requirements in terms of; (a) lead time between orders

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