Company XYZ follows fixed order quantity model for Inventory planning. Annual Demand for the product is 1000 units; Cost per Order is $5,Inventory carrying cost per unit is $ 1.25, Lead time for procurement is 5 days and Cost per item is $ 12.5. With the given data calculate:a. EOQ-Economic Order Quantityb. Reorder Quantityc. Total cost of Inventory(answer by file attachment options)

Economic order quantity is the optimal quantity of inventory that the company should purchase to…

Answered: Company XYZ follows fixed order…

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

PLEASE ANSWER ASAP, I REALLY NEED HELP
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?
4
am. 105.
What are the procedures for completing an office inventory of supplies and equipment? How could you create an office policy for inventory? Include ideas for an inventory schedule, how you would distribute tasks among staff members, and what tools you would need to create to accomplish these tasks.
21- Which one of the following represent FIFO method of inventory evaluation? a. Old items remain in inventory b. Old merchandise is sold first c. New merchandise is sold first d. Average number of goods are sold
As with other products, Fisher-Price faces the decision of how many Weather Teddy units to order for the comingholiday season. Members of the management team suggested order quantities of 15,000, 18,000, 24,000, or28,000 units. The wide range of order quantities suggested indicates considerable disagreement concerning themarket potential. The product management team asks you for an analysis of the stock-out probabilities forvarious order quantities, an estimate of the profit potential, and to help make an order quantity recommendation.Fisher-Price expects to sell Weather Teddy for $24 based on a cost of $16 per unit. If inventory remains afterthe holiday season, Fisher-Price will sell all surplus inventory for $5 per unit. After reviewing the sales historyof similar products, Fisher-Price’s senior sales forecaster predicted an expected demand of 20,000 units with a.95 probability that demand would be between 10,000 units and 30,000 units. Question: One of Fisher-Price’s managers felt…
f2 Same problem statement: Weekly demand for DVD-Rs at a retailer is normally distributed with a mean of 1,000 boxes and a standard deviation of 150. Currently, the store places orders to the supplier, with a reorder point of 4,200 boxes. The order quantity to the supplier is fixed at 5,000 boxes. Replenishment lead time is 4 weeks, fixed order cost per order is $100, each box costs the retailer $10, and the inventory holding cost is 25% per year. Assume 50 weeks in a year. Given the problem parameters, what is the optimal order quantity the retailer should order? Numeric Response f3 2040 f4 f5 40 f6 0 4- f7 ♫+ f11 W f12. X insert prt sc + = O delete ← backspace home num lock
Demand forecasting and planning is not a part of inventory management function. Select one : 1.True 2.Fales
Suppose that we would like to determine Reorder Point for the product. From the historical data the manager determined demand during lead-time for that product fits Normal distribution with a mean of 200 and standard deviation of 10 products. The maximum stock out risk is 10%. Answer the following questions according to the (Q, R) system. a) Find the safety stock if the lead time is 2 weeks. b) Find the reorder point. c) Find the reorder point if the stock out risk decreases to 1%. Comment on the result.
The purpose of EQQ is: A. measure the cost of ordering inventory B. to lower the level of inventory C. to determine the optimal amount of inventory to order D. to find the number of days before inventory needs to be reordered
A clothing manufacturing company requires raw materials for 8 consecutive weeks as follows: 30, 40, 50, 35, 60, 30, 40, and 30 units with a one-time order cost of $50,000 and a storage fee of $500 per unit/week. From these data calculate the total cost of procurement using:a. Lot For Lot (LFL) Methodb. Economic Order Quantity (EOQ) Methodc. Period Order Quantity (POQ) Method Using this table format: Week 1 2 3 4 5 6 7 8 Gross requirements Schedule receipts Projected on hand Net requirements Planned order receipts Planned order releases

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