Knowee
Questions
Features
Study Tools

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 450eachtimeitplacesanorderwiththemanufacturerofthePCs.TheannualcostofcarryingthePCsininventoryis450 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)

🧐 Not the exact question you are looking for?Go ask a question

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 = 1908Totalholdingcost=Averageinventoryholdingcostperunit=141.54170=1908 Total holding cost = Average inventory * holding cost per unit = 141.54 * 170 = 24061.8

Therefore, the total minimum inventory cost = Total order cost + Total holding cost = 1908+1908 + 24061.8 = $25969.8.

This problem has been solved

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 = 1908Costofholdinginventory=AverageinventoryH=141.54170=1908 Cost of holding inventory = Average inventory * H = 141.54 * 170 = 24061.8

So, the total minimum inventory cost = Cost of orders + Cost of holding inventory = 1908+1908 + 24061.8 = $25969.8

Therefore, the total minimum inventory cost is $25969.8.

This problem has been solved

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

1/3

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.