An electronics store stocks and sells a particular brand of personal computer. It costs the store $450 each time it places an order with the manufacturer of the PCs. The annual cost of carrying the PCs in inventory is $170. The store manager estimates that the annual demand for the PCs will be 1200 units. Calculate the total minimum inventory cost. (answer should be correct to two decimal places)
Question
An electronics store stocks and sells a particular brand of personal computer. It costs the store 170. The store manager estimates that the annual demand for the PCs will be 1200 units. Calculate the total minimum inventory cost. (answer should be correct to two decimal places)
Solution 1
To calculate the total minimum inventory cost, we need to first find the Economic Order Quantity (EOQ), which is the number of units that a company should add to inventory with each order to minimize the total costs of inventory—such as holding costs, order costs, and shortage costs. The EOQ formula is:
EOQ = sqrt((2DS)/H)
where: D = Demand rate (annual demand) S = Setup costs (cost per order) H = Holding cost (cost per unit per year)
Substituting the given values into the formula:
EOQ = sqrt((21200450)/170) = 283.07 units (rounded to two decimal places)
The total minimum inventory cost is then calculated by adding the cost of the orders and the cost of holding the inventory. The number of orders is the annual demand divided by the EOQ, and the average inventory is EOQ/2.
Number of orders = D/EOQ = 1200/283.07 = 4.24 orders (rounded to two decimal places) Average inventory = EOQ/2 = 283.07/2 = 141.54 units (rounded to two decimal places)
Total order cost = Number of orders * cost per order = 4.24 * 450 = 24061.8
Therefore, the total minimum inventory cost = Total order cost + Total holding cost = 24061.8 = $25969.8.
Solution 2
To calculate the total minimum inventory cost, we need to first find the Economic Order Quantity (EOQ), which is the number of units that a company should add to inventory with each order to minimize the total costs of inventory—such as holding costs, order costs, and shortage costs.
The EOQ formula is:
EOQ = sqrt((2DS)/H)
where: D = Demand rate (annual demand) S = Setup costs (cost per order) H = Holding cost (cost per unit per year)
Substituting the given values into the formula:
EOQ = sqrt((21200450)/170) = 283.07 units (rounded to two decimal places)
The total minimum inventory cost is then calculated by adding the cost of the orders and the cost of holding the inventory. The number of orders is the annual demand divided by the EOQ, and the average inventory is EOQ/2.
Number of orders = D/EOQ = 1200/283.07 = 4.24 orders (rounded to two decimal places) Average inventory = EOQ/2 = 283.07/2 = 141.54 units (rounded to two decimal places)
Cost of orders = Number of orders * S = 4.24 * 450 = 24061.8
So, the total minimum inventory cost = Cost of orders + Cost of holding inventory = 24061.8 = $25969.8
Therefore, the total minimum inventory cost is $25969.8.
Similar Questions
A company has the following products in its ending inventory. Compute lower of cost or market for inventory applied separately to each product Product Quantity Cost per Unit Market per UnitProduct A 10 $ 710 $ 680Product B 15 $ 510 $ 550Product C 20 $ 660 $ 685Multiple Choice$27,950.$27,650.$1,880.$28,750.$1,915.
A company purchased inventory as follows: 200 units at $9 300 units at $10 The average unit cost for inventory is: Group of answer choices $9.00. $9.50. $9.60. $10.00.
Given an Economic Order Quantity (EOQ) of 600 units, an annual demand of 25,000 units, an ordering cost of $40 per order, and a holding cost of $1.50 per unit per year, calculate the total annual inventory cost.Question 6Answera.$2,117b.$11,500c.$3,000d.$3,600
Beginning Inventory consists of 4 items at $10 each. During the month, the company purchased 3 items for $11 each and it sold 3 items. Using first-in, first-out, Cost of Goods Sold equals ______.
An entity just starting business made the following four inventory purchases in June: June 1 150 units $1,500 June 10 130 units 1,170 June 15 90 units 1,260 June 23 110 units 990 $4,920A physical count of inventory on June 30 reveals that there are 20 units on hand. Using the weighted average cost method the amount allocated to the ending inventory on June 30 is:Question 5Answera.$205b.$180c.$220d.$200
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.