The ePaint stocks paint in its warehouse and sells it online on its Internet Web siteThe store stocks several brands of paint; however, its biggest seller is SW-ITpaint. The company wants to determine the optimal order size and total inventorycost for SW-IT paint given an estimated annual demand of 10,000 gallons of paint,an annual carrying cost of $0.75 per gallon, and an ordering cost of $150 per order.They would also like to know the number of orders that will be made annually and thetime between orders (i.e., the order cycle).

For businesses that stock and sell products, it is essential to optimize their inventory management…

Answered: The ePaint stocks paint in its…

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

The manager of an auto parts store is reviewing the inventory policy for one of their fastest selling products — car batteries. The store sells an average of 40 car batteries every week. The cost to hold one battery in inventory for a year is $15. The ordering cost per order is estimated at $50. The store operates all 52 weeks in a year.Use the information in Scenario 9.5. If the manager decides to order at the economic order quantity, what is the sum of the annual ordering cost and holding cost? Group of answer choices greater than $1800 but less than or equal to $2100
Johnson Tire Plaza (JTP) is a large chain of tire shops, who sells various brand of automobile tires. The yearly demand of a particular brand of time is about 10,908 units per year. JTP purchases these tires from a supplier. The ordering cost is $112 per order and the holding cost is $17.8 per tire per year. The supplier always deliver the shipment within 9 days after receiving a replenishment order from JTP. The company operates 250 days per year. Assume EOQ model is applicable. What is the average inventory level if JTP uses an order quantity of 1,371 tires?
Johnson Tire Plaza (JTP) is a large chain of tire shops, who sells various brand of automobile tires. The yearly demand of a particular brand of time is about 10,821 units per year. JTP purchases these tires from a supplier. The ordering cost is $109 per order and the holding cost is $14.6 per tire per year. The supplier always delivers the shipment within 13 days after receiving a replenishment order from JTP. The company operates 250 days per year. Assume EOQ model is applicable. What is the number of orders per year if JTP uses an order quantity of 1,728 tires? Use at least 4 decimal places.
A gift shop sells 2,500 musical greeting cards each year. The ordering cost for musical greeting cards is $100 per order and the holding cost is $10 per musical greeting card per year. If the gift shop always orders 100 musical greeting cards when it places an order from its supplier, how many musical greeting cards does the gift shop have in inventory, on average?
An eyeglass retailer buys lenses from a supplier at $100 each. The retailer orders 250 lens pairs every year and the ordering cost is $36. Carrying costs per year (based on average inventory) are estimated to be 20% for each pair. The supplier offers a 10% on order quantities of 50 or more lens pairs. Determine the best order quantity and total cost
PART A Speedy Bicycle Company (SBC) is a wholesale distributor of a wide variety of bicycles and bicycle parts. The most popular model is the Dragonfly, which sells for $170. All manufacturing is done at a plant in China, and shipment takes a month (30 days) from the time an order is placed. The estimated order cost is $75, including customs clearance. SBC's cost per bicycle is 65% of retail price, and inventory carrying cost is 11% per year of SBC's cost. If the company cannot fulfill a retail order, the retailer will get the shipment from another distributor and SBC loses that business. SBC is planning inventory for 2023 based on forecasted demand and wants to maintain a 93% service level to minimize lost orders. The company has 300 working days per year. 2021 Forecasted Demand for the Dragonfly Bicycle Model: F A J 15 58 J 8 M 31 M 96 J 59 38 A 23 S 16 0 14 N 26 D 41
The distribution manager for Putnam Corporation is trying to establish the most economic ordering policy for the standard model of its best-selling microwave oven. He has control of the finished goods warehouse for the factory and must satisfy wholesaler demand. The following information is available: Wholesale value $100 Annual demand 50,000 units Std. Deviation of Demand 30 units per day Working year 250 days Production lead time 9 days Ordering cost for production $1,800 Holding cost per unit per year 20% of value Desired service level 96 percent: If Putnam wishes to use the periodic review system, what should be the safety stock, reorder point? If the current on hand inventory is 1,000 units, how many units should be ordered?
A billiard ball maker must place orders for resin, a raw material for billiard balls. It uses resin at a rate of 120 kilograms each day, and incurs a cost of $0.4 per kilogram per day to hold inventory. The ordering cost is $150 per order. Lead time for delivery is 4 days. Assume 365 day in a year.What is the optimal length of the order cycle associated with the minimum total cost of ordering and inventory holding? [Round your final number with two decimals] 0.13 days 1.10 days 2.50 days 47.76 days None of the above PLEASE SHOW CALCULATIONS NOT JUST ANSWER
Double T appliance is a retailer of small appliances in West Texas. Double T gets all of their merchandise from GE which it then sells to the people of the South Plains. Their annual demand is 10,000 units and the ordering cost is $100 per order. The carrying cost per unit is $50.00 What is their expected annual carrying cost (not including the costs of the goods) if the Economic Order Quantity is used and is equal to 200 units?
The relationship between price and quantity supplied is typically O direct O inverse
Palin’s Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand 2,750 mufflers Ordering cost $ 35 per order Standard deviation of daily demand 6 mufflers per working day Service probability 76 % Item cost $ 28.00 per muffler Lead time 4 working days Annual holding cost 22 % of item value Working days 275 per year Review period 21 working days a. What is the optimal target level (order-up-to level)? If the service probability requirement is 93 percent, the optimal target level will: Increase Decrease Stay the same
The distribution manager for Divine Corporation is trying to establish the most economic ordering policy for the standard model of its best-selling microwave oven. He has control of the finished goods warehouse for the factory and must satisfy wholesaler demand. The following information is available: Wholesale Value $100 Annual Demand 50,000 units Standard Deviation of Demand 30 units per day Working Year 250 days Production Lead Time 9 days Ordering Cost for Production $1,800 Holding Cost per unit per year 20% of value Desired Service Level 96 percent If Divine decides to use a continuous review system, what should be economic order quantity, safety stock, and the reorder point? If on the other hand, Divine wishes to use the periodic review system, what should be the safety stock, reorder point? If the current on hand inventory is 1,000 units, how many units should be ordered?

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