Given the following data:PeriodGross1 2 3 45 6 7 8Requirements 20 20 50 50 80 8050 50The beginning inventory is 0 and there are no scheduled receipts. The order cost is $50 and theholding cost is $1 per part per period.What are the order costs, carrying costs, and totals cost over the 8 periods using the period orderquantity rule with POQ = 2?Oorder costs $200, carrying costs $200, and total costs $400Oorder costs $400, carrying costs $340, and total costs = $740Oorder costs $200, carrying costs $340, and total costs $540Oorder costs $400, carrying costs $0, and total costs = $400

Answered: Given the following data: Period Gross…

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 an EOQ solution and calculate total relevant costs for the data in the preceding table.
The seasonal demand for a particular product is given below: Period 1 2 3 4 5 6 Demand 300 450 100 450 450 100 The fixed parameters are: Fixed Cost $8 Unit Production Cost $1 Holding Cost $1.3 Calculate total ordering cost using following three methods: i) Lot-for-Lot ii) Wagner-Whitin algorithm iii) Fixed order quantity Please do fast .. ASAP.. fast
Discuss considerations that should be fully taken into account when developing inventory related relevant costs for use in an economic order quantity (EOQ) model. Why do conflicts arise between the EOQ model's optimal order quantity and the order quantity that managers regard as optimal?
Using the gross requirements schedule below*, prepare an alternative ordering system that always orders 100 units the week prior to a shortage (a fixed order quantity of 100). What is the cost of this ordering system? D Period 1 2 3 Gross requirements 35 30 40 4 5 6 7 8 9 10 0 10 40 30 0 30 55 *Holding cost = $1/unit/week; setup cost = $100; lead time = 1 week; beginning inventory = 35 units. Prepare a net requirements plan (enter your responses as whole numbers). The holding cost of this ordering system is $ The setup cost of this ordering system is $ The total cost of this ordering system is $ Period Gross requirements On-hand at beginning of period 35 On-hand at end of period Net requirements Order receipt Order release (enter your response as a whole number). (enter your response as a whole number). (enter your response as a whole number). 1 35 2 3 30 40 4 0 7 8 9 10 0 30 55 5 6 10 40 30
SF, owner of the kebab houses, uses 20 pounds of mince each day in preparing meatball. Order costs for mince are $10.00 per order, and carrying costs are 4 cents per pound per day. Lead time for each order is three days, and the mince itself costs $3.00 per pound. At what point should she reorder mince? Select one: 20 pounds remaining 60 pounds remaining 100 pounds remaining 80 pounds remaining 40 pounds remaining
A museum of natural history is having problems managing their inventories. Low inventory turnover is squeezing profit margins and causing cash-flow problems. A Class A item, a birdfeeder is also a top-selling item. See information for this item in the table below. Management has been ordering in lots of 390 units. 1) What is the annual cost of the current policy (hint: find the current total cost with the current order size, Q)? 2) What is the Economic Order Quantity or the optimum order quantity (EOQ) for the birdfeeders? 3) What is the total annual cost of ordering at the EOQ? How much could be saved if the museum ordered at the EOQ opposed to their current order size of 390 units? 4) When should the museum place an order, at how many units (i.e.: what is their reorder point or lead time demand)? Sales per week (demand) Purchase cost Order cost Annual holding cost Birdfeeder: Operating weeks per year Lead time for orders (weeks) Order size EOQ (calculated) 18 $ $ 60.00 45.00 25% of…
A company has a demand for 25,750 units annually. The holding cost is 33% of the item cost which is $10.00. The ordering or set-up cost is $250.00 per order and the lead time is 5 days. Assume that there are 350 days per year Suppose a price break of $50 per order is offered for purchase quantities of 2,000 or greater. Question: What is the reorder point for this inventory strategy? What is the inventory position immediately after an order is placed for the inventory strategy that you have selected?
You have been asked by your boss to calculate the Economic Order Quantity (EOQ) for one of the major sub-components used by your firm. You have been provided the following data: The weekly demand for this part is 125 units. The cost of the sub-component is $300. The annual holding cost is 0.5% and the ordering or setup cost is $50.
A certain type of computer costs RO 1000, and the annual holding cost is 20% of the value of the item. Annual demand is 12,000 units, and the order cost is RO 200 per order. What is the approximate economic order quantity? Round-up to the nearest integer Select one: O a. 155 O b. 142 O c. 110 O d. None correct O e. 123
Best Buy's monthly demand for an Olympus Digital Camera FX 5500 is Poisson distributed with a mean of 3 cameras/month. The order quantity is 6 cameras, holding costs are $6.00 per camera per year, the backorder cost per outage is $12.00/unit, and the lead-time is 1 month. Determine the safety stock. 00 01 02 03 O4
If Sarah wants to minimize inventory holding and ordering costs, how much Palm oil should she purchase with each order (in kgs)?
How does the Wilson approach help in optimizing inventory levels? Provide a step-by-step explanation of the Wilson EOQ (Economic Order Quantity) model.

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