EOQ analysis
Thompson Paint Company uses 60,000 gallons of pigment per year. The cost of ordering pigment is $200 per order, and the cost of carrying the pigment in inventory is $1 per gallon per year. The firm uses pigment at a constant rate every day throughout the year.
- a. Calculate the EOQ.
- b. Assuming that it takes 20 days to receive an order once it has been placed, determine the reorder point in terms of gallons of pigment. (Note: Use a 365-day year.)
a.
To determine: The Economic order quantity (EOQ).
Answer to Problem 15.2STP
Explanation of Solution
Given information:
Annual usage: 60,000 gallons
Ordering cost: $200 per gallon
Carrying cost:$1.00 per gallon
Calculation of the EOQ:
Therefore, the EOQ is 4,899 gallon..
b.
To determine: The reorder point in terms of gallons of pigment, if it take 20 day to r3ecive pigment per year.
Answer to Problem 15.2STP
Explanation of Solution
Lead time: 20 days.
Calculation of the daily usage:
Calculation of the reorder point:
Therefore, the reorder point is 3,287.6gallons.
Want to see more full solutions like this?
Chapter 15 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
- Direction: Read the problems carefully. Provide proper solutions. Round your answers to the nearest hundredths. 1. The Air Supply store begins each week with 365 tires in stock. This stock is depleted each week and reordered. If the carrying cost per tire is P56 per year and the fixed order cost is P95. What is the total carrying cost? 2. Each year The Carpenters sell 2300 units of a product at a price of P630.25 each. The variable cost per unit is P392 and the carrying cost per unit is P167.50. The fixed cost of ordering is P78.50. 2.1 What is the economic order quantity (whole number)? 2.2 How much are the total ordering costs (nearest hundredths)? 3. The BeeGees' sells guitars for P6,999 each. The store consistently sells 450 guitars every year. The fixed cost to order more guitars is P680 and the carrying cost is P120. What is the economic order quantity? 4. Each year PBB sells 285 units of a product at a price of P600 each. The variable cost per unit is P575 and the carrying cost…arrow_forwardMacagba Company uses 1,100 units of an particular item each year. Carrying the item in inventory costs $200 per unit per year. It costs $150 for each order of the chemical. Macagba uses the item at a constant rate each year. Calculate the Economic Order Quantity. 40.62 Use the data from above and assume that Macagba Company operates 250 days per year. Also assume that its total usage is 1,100 units per year. There is a lead time of 2 days and Macagba desires to keep a safety stock of 4 units. Calculate the reorder point.arrow_forwardWhat is the economic-order quantity (rounded to nearest whole lens)?arrow_forward
- One of the bulk raw beverages, which Blanchard buys, is gin. Assume that the cost of purchasing enough raw gin for one case is $100. Each time they place an order their cost for processing the order is $20. The annual holding cost is 33% of item cost and demand for gin is 2500 cases per year. Calculate the EOQ for this product. If the lead-time is one day, what is the reorder point ROP? What is the annual total cost of this strategy? What is the average inventory? What is the inventory turnover? Please do fast ASAP fastarrow_forwardAnswer all subparts a,b,c,d,e,f.if answered within 30mins,it would be great Accounting ETS manufactures a component for its computer products. The annual demand for thiscomponent is 2500 units. The annual cost of maintaining inventory is10% per unit and the cost of preparing an order and setting up productionfor the order is $ 50.The machine used to make this part has a production rate of 10,000units per year and the cost is $ 22 per unit.a. Find the EPQ(Economic Production Quantity)A. How long does it take to produce the batch?B. How many batches will be produced per year?C. What is the maximum inventory level?D. What is the total cost per year?E. A supplier offers to sell a similar component for $ 25 per unit with a charge$ 5 per service per order. Should the company accept the offer?F. Find the average inventory level for each situationarrow_forwardTTT Inc. sells 100,000 tea bags a year. Other data are as follows: Selling price/bag=P2.50 Purchase cost/bag =P1.50Ordering cost =P5.40/orderCarrying cost=20% of unit costOperating days per year=250Ave. lead time on purchases=6 daysMaximum lead time=13.5 days Compute the reorder point for TTT Inc.arrow_forward
- Question No.6: An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. The annual demand is approximately 1500 batteries. The supplier pays 25 R.O for each battery and estimates that the annual holding cost is 30% of the battery's value. It costs approximately 30 R.o to place an order. The supplier currently orders 125 batteries per month. a. Determine the EOQ. b. How many orders will be placed per year using the EOQ? c. Determine the total cost for the current order quantity. d. Determine the total inventory cost for the EOQ, How has ordering cost changed?arrow_forwardWhat is the EOQ for a firm that sells 5,800 units when the cost of placing an order is $5.20 and the carrying costs are $4.00 per unit? Round your answer to the nearest whole number. units How long will the EOQ last? Use the rounded value from the previous question. Assume 365 days in a year. Round your answer to the nearest whole number. days How many orders are placed annually? Assume 365 days in a year. Use the rounded value from the previous question. Round your answer to the nearest whole number. orders per year As a result of lower interest rates, the financial manager determines the carrying costs are now $2.2 per unit. What is the new EOQ? Round your answer to the nearest whole number. units What is the annual number of orders? Assume 365 days in a year. Use the rounded values of the new EOQ and duration of the new EOQ in your calculations. Round your answer to the nearest whole number. orders per yeararrow_forwardAnnual Demand = 10,000 units Days per year considered in average daily demand = 365 Cost to place an order = $10 Holding cost per unit per year = 0.01% of cost per unit Lead time = 3 days Cost per unit = $15 Determine the economic order quantity and the reorder point. Also find the Annual Ordering and Holding Cost. State some significance of the obtained results.arrow_forward
- PLEASE TO PERFORM IN EXCEL AND SHOW FORMULAS Comercial El Suspiro, S.A., purchases 2'100,000 units per year of a component. The cost of each order is $25.00. The annual unit maintenance cost is 27% of its cost of $2.00. On a 360-day basis, calculate the reorder point, knowing that it takes 10.5 days for the supplier to put in the LAB company the goods, and the company sorts and stores them in 1.5 days, calculate the reorder point.arrow_forwardA local distributor for a national tire company expects to sell approximately 9,600 steel-belted radial tires of a certain size and tread design next year. Annual carrying costs are $16 per tire, and ordering costs are $75. The distributor operates 288 days a year. Determine the EOQ How many times per year does the store reorder? Determine the length of an order cyclearrow_forward1. Krissy operates its factory 300 days per year. Its annual used of Material Y is 300,000 gallons. It carries a 2,500 gallon safety stock of material and its lead time is 3 business days. What is the order point for Material Y? 2. The EOQ for Material is 7,500 gallons, and the carrying cost per gallon per year is P.25. What is the total annual carrying cost for Material? 3. Peter's order quantity for tocino is 5,000 kilos. Peter maintains a safety stock of Tocino at 500 kilos, and its order point is 1,500 kilos. What is the lead time, assuming daily usage is 50 kilos? 4. Peter's order quantity for tocino is 5,000 kilos. Peter maintains a safety stock of Tocino at 500 kilos, and its order point is 1,500 kilos. What would be the total annual carrying costs, assuming the carrying cost per unit is P.80 5. The following are data of materials inventory for the year 2020 of Mars Corp: Number of pounds required annually Cost of placing an order Annual carrying cost per pound of 144,000 P180…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT