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.

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.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 2CE: Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each...

See similar textbooks

Similar questions

PLEASE MAKE IT IN EXCEL AND SHOW THE 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.
A supplier sells MF Tires to dealers. The annual demand is approximately1,000 tires. The supplier pays P50 for each tire and estimates that the annualholding cost is 20 percent of the total value of tires. It costs approximatelyP25 to place an order. The supplier currently orders 80 tires per month.Required:a. Calculate ordering, holding, and total inventory costs for thecurrent ordered quantity.b. Determine the EOQ.c. How many orders will be placed per year using the EOQ?d. Calculate ordering, holding, and total inventory costs for the EOQand also determine the change in total inventory cost.
Electric spark Co., uses 60,000 of component Zima. The cost of placing an order is estimated at $17.28 per order. The annual holding cost is 20% of the purchase price of $20 per unit. The following information is provided to you by the management accountant to use in your analysis: The Normal usage 200 units per day Maximum usage 280 units per day Minimum usage 120 units per day Reorder period 20 to 30 days Required: 1. Determine the EOQ using the equation method 2. Calculate the total cost of inventory per year, in case the company decided to use the EOQ. 3. Electric spark has been offered a 2 per cent discount on the cost if it places orders in quantities of 20,000. Discuss whether the company should accept the discount and place larger orders .
An auto parts supplier sells batteries to car dealers and auto mechanics. The annual demand is approximately 1,200 batteries. The suppliers pays $28 for each battery and estimates that the annual holding cost is $8.40 per year. It costs approximately $20 to place an order. Assume a 250-day working year. a. Compute for the EOQ round off your answer to the nearest whole number. b. Compute for the expected number of orders. Round off your answer to the nearest whole number. c. Compute for the expected time between orders. Round off your answer to the nearest whole number.
Wesley Utility Company uses 2,500 units per year which it stores at $0.50 per unit per annum. The cost to place an order is $100. a) Calculate: i. The economic order quantity (EOQ) b) If the company decides to make the items on its own machine with a potential capacity of 5,000 units per year, calculate: i. The economic order quantity (EOQ) ii. The annual ordering cost iii. The annual carrying cost
An auto parts supplier sells Hardy-brand batteries to car dealers and auto mechanics. The annual demand is approximately 1,200 batteries. The supplier pays set up cost equal to $20 for each battery and estimates that the annual holding cost is $8.4. The working days for the company are 300 days per year Determine the economic order quantity (EOQ)
A hardware store sells paint that has a demand of 9,706 gallons per year. The store purchases the paint from a supplier for 11.2 dollars per gallon The unit holding cost per year is 24 percent of the unit purchase cost. while the ordering cost is 175 dollars per order. The paint supplier has a lead time of 10 days. What is the annual ordering cost if the store uses the order quantity of 2,103 gallons per order? Assume EOQ model is appropriate. Use at least 4 decimal places.
Roadside Inc. manufactures the Megalite, and is reviewing the product's cost structure. Accounting records show these costs:factory space: $250,000 per yearinsurance: $47,000 per yearsupervisor salaries: $125,000 per yearmaterials: $5.00 per lampdirect labor: $2.69 per lamprecycling charge: $0.37 per lampRoadside Inc sells the Megalite to wholesalers for $13.69 each. Calculate Roadside's contribution margin as percent of selling price on the Megalite. (Rounding: tenth of a percent. Report 25.3%, for example, as "25.3".)
Auto Zone purchases replacement brake fluid reservoirs directly from the manufacturer. Demand is roughly 1000 units per month over the year. Ordering costs are $25 per order and the reservoirs are $10.00 per unit. Annual holding costs are 20% of the value of the inventory. There are 311 working days per year and the lead time is 5 days. Address the following inventory management issues that need to be resolved. a) What is the EOQ for this component? b) What is the reorder point? c) What is the cycle time? d) What are the total annual holding and ordering costs associated with your recommended EOQ?
A microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. The annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. a) If the order quantity is 1000 gallons, what is the average inventory? b) If the order quantity is 1500 gallons, how many orders are placed each year? c) What is the EOQ quantity? d) If the order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for the EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost? f)If orders must be in integer multiples of 1000 gallons, how much should be ordered to minimize ordering and holding costs PER GALLON? g) A 3% purchase price discount is given if orders are for 8000 gallons or more. What would total annual costs (purchasing, ordering, and holding) be using this discount?
Machine Operator, manufacturer of shelving keeps stock of a wide range of components. The following data, you have established that: The cost to hold one unit for one year is $1.60. The cost of placing an order is $70.00. Lead Time: The supplier takes from one to two weeks to deliver goods ordered. Maximum 2 Weeks Minimum 1 Week The annual demand is 50,000 units Maximum usage5,000 usage Minimum usage 2,000 units Required: (a) On the basis of the above information, calculate for component B: (i) The minimum stock level (ii) The reorder level (iii) The EOQ (iv) The maximum stock level
ABC Corporation resells one type of candle. It has 250 working days. Each day, it sells an average of 500 boxes but may sometimes sell a maximum of 600 boxes. The supplier takes an average of 5 days to deliver the order. During busier times, the supplier may take 7 days.Based on ABC’s records, ordering cost average P400 per order. Storage cost per box average P5 per year. There is also an opportunity cost of 1% per year for every peso invested in inventories. Each box of candles costs P450.If ABC would continue its current inventory management policy, it would keep 10,000 boxes as safety stock and order ten- days-worth of inventory. 19. What would the average number of boxes be if the safety stock was kept and the EOQ was followed? Round off to two decimal places.20. How much would the carrying cost for the year be based on item 19?21. How much would the total inventory related (ordering plus carrying) costs be if the economic order quantity was followed (including safety stock)?