8. Three types of motors are being inventoried by a company. The inventory carrying costrate is 15%. Total space available is 1500 ft. Using the following information todetermine the optimum order quantity for each motor with the space constraint. Solve bytrial and error using excel.Motor 1Motor 3Motor 220005 USDDemand per year150030007.5 USD50 USD2.5 ft?Item cost10 USD50 USD0.5 ft?50 USDOrdering costFloor space/item1.0 ft

carrying cost = Order quantity / 2 x carrying cost per unit Ordering cost = Demand / order…

Answered: 8. Three types of motors are being…

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

Economic Order Quantity and Reorder PointFind the economic order quantity and the reorder point, givenAnnual demand ( D )= 1, 000 unitsAverage daily demand ( d¯ ) = 1, 000 ∕365ordering cost ( S ) = $5 per orde rHolding cost ( H ) = $1.25 per unit per yearLead time ( L ) = 5 daysCost per unit ( C ) =$12.50What quantity should be ordered?
Catlea Merchandising is engaged in selling school shoesfor both boys and girls in their teenage years. Catlea needs 32,000 pairs of shoes in a year in order to satisfy the market demand. It costs ₱ 48 to place an order while ₱ 8 is needed to hold each quantity of shoe in Catlea's inventory. Upon checking on Catlea's supplier, it takes 8 days in between placing an order and eventually receiving it. a. Determine the Economic Order Quantityb. Determine the number of order per monthc. Determine the reorder point
3. Petromax Enterprises uses a continuous review inventory control system for one of its SKUs. The following information is available on the item. The firm operates 48 weeks in a year. Refer to the table for z-values. ≻Demand = 91,000 units/year ≻Ordering cost = $38.50/order ≻Holding cost = $4.50/unit/year ≻Average lead time = 9 weeks ≻Standard deviation of weekly demand = 120 units a. The economic order quantity for this item is _____ units. (Enter your response rounded to the nearest whole number.) b. If Petromax wants to provide a 90% service level, the safety stock is _____ units (enter your response rounded to the nearest whole number) and the reorder point is ____units (enter your response rounded to the nearest whole number).
For a specific farm implement ‘FI’ is to be ordered by a food processing company, following data is available: Monthly Demand= 800 units Purchase cost/unit = $40/unit Ordering costs= $60/ order Holding costs (Ch) = $12/unit/year, fire insurance = 6% of the unit cost, 2% other overheads. Determine optimal order quantity of ‘FI’ items and how frequently the order should be placed?
The following information regarding inventory policy was assembled by the GB Inc. The company uses a 50-week year in all calculations: Sales: 10,000 units per year Order quantity: 2,000 units Safety stock: 1,300 units Lead time: 4 weeks The reorder point is: a. 3,300 units b. 2,100 units c. 100 units d.300 units
The economic order quantity of NEKO Inc. is 1,000 unit. They sold their sole product for a selling price of P5. It takes P20,000 a year for NEKO Inc. in ordering 1,000 units per transaction. Carrying cost is P4 per unit per year. The lead time for this product is one week. How much sales revenue should NEKO Inc. have for this economic order quantity to be plausible? (Use 360 days a year)
The materials manager for a billiard ball maker must periodically place orders for resin, one of the raw materials used in producing billiard balls. She knows that manufacturing uses resin at a rate of 50 kilograms each day, and that it costs $.04 per day to carry a kilogram of resin in inventory. She also knows that the order costs for resin are $100 per order, and that the lead time for delivery is four days. If the order size was 1,000 kilograms of resin, what would be the average inventory level?
The following information regarding inventory policy was assembled by the GB Inc. The company uses a 50-week year in all calculations: Sales: 10,000 units per year Order quantity: 2,000 units Safety stock: 1,300 units Lead time: 4 weeks The reorder point is: 3,300 units 2,100 units 100 units 1,300 units
1. Calculate Economic Order Quantity (EOQ), number of orders, annual ordering costs, annual carrying costs and total inventory costs from the following: Annual consumption: 6000 units ; Cost of placing one Order: RO 60 Carrying cost per unit: RO 22. Find out the EOQ, Annual ordering cost and annual holding cost from the following information. The demand is 19500 units per year, holding cost is RO 4 per unit for a year and ordering cost is RO 25 order. 3. Find out the ordering cost from the following information, Annual demand is 240 units, holding cost RO 4 per unit for a year and EOQ is 60 units.
Petromax Enterprises uses a continuous review inventorycontrol system for one of its SKUs. The following informationis available on the item. The firm operates 50 weeks in a year.Demand = 50,000 units>yearOrdering cost = $35>orderHolding cost = $2>unit>yearAverage lead time = 3 weeksStandard deviation of weekly demand = 125 unitsa. What is the economic order quantity for this item?b. If Petromax wants to provide a 90 percent cycle-servicelevel, what should be the safety stock and the reorder point?
DOGGE Ltd has annual demand of 50,000 desks and the purchase price of each desk is K250. There are ordering costs of K200 for each order placed. Inventory holding costs amount to 10% per year of inventory value. Calculate the inventory costs p.a. for the following order quantities, and plot them on a graph: 500 units, 750 units, 1000 units, 1250 units b) Using the information in (a) above calculate i) Economic Order Quantity and the total inventory costs for this order quantity.
10 Use the information presented in the graph to answer the following questions: Annual Cost C3 C2 Q1 You are also given the following information: Q1 =450 .Q2 = 700 C1 = 350 C2 = 750 1300 Q2 Order Quantity Which annual inventory cost component does the blue line represent? Total cost Which annual inventory cost component does the green line represent? Holding cost What is the Economic Order Quantity (EQ9) based on th Which annual inventory cost component does the red line represent? Ordering cost 220

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