Janis has demand for 40,000 desks p.a. and the purchase price of each desk is 25. There are ordering costs of 20 for each order placed. Inventory holding costs amount to 10% p.a. of inventory value. Calculate the inventory costs p.a. for the following order quantities, and plot them on a graph:

Business/Management
Janis has demand for 40,000 desks p.a. and the purchase price of each desk is 25. There are ordering costs of 20 for each order placed. Inventory holding costs amount to 10% p.a. of inventory value. Calculate the inventory costs p.a. for the following order quantities, and plot them on a graph:

ScanSolve AI Answer

Answer

$2,225

First, let's determine the annual holding cost per unit. The inventory holding cost rate is 10% p.a. of inventory value, and the purchase price is $25 per desk.

AnnualHoldingCostperunit(H)=HoldingCostRate×PurchasePriceAnnual Holding Cost per unit (H) = Holding Cost Rate \times Purchase Price H=0.10×$25=$2.50perunitp.a.H = 0.10 \times \$25 = \$2.50 per unit p.a.

The total annual inventory cost (TC) is the sum of the annual ordering cost and the annual holding cost. TC=(AnnualDemand(D)OrderQuantity(Q))×OrderingCostperOrder(S)+(OrderQuantity(Q)2)×AnnualHoldingCostperunit(H)TC = \left(\frac{Annual Demand (D)}{Order Quantity (Q)}\right) \times Ordering Cost per Order (S) + \left(\frac{Order Quantity (Q)}{2}\right) \times Annual Holding Cost per unit (H) Given: Annual Demand (D) = 40,000 units Ordering Cost per Order (S) = 20AnnualHoldingCostperunit(H)=20 Annual Holding Cost per unit (H) = 2.50

a) 500 units Step 1: Calculate Annual Ordering Cost. AnnualOrderingCost=40,000500×$20=80×$20=$1,600Annual Ordering Cost = \frac{40,000}{500} \times \$20 = 80 \times \$20 = \$1,600 Step 2: Calculate Annual Holding Cost. AnnualHoldingCost=5002×$2.50=250×$2.50=$625Annual Holding Cost = \frac{500}{2} \times \$2.50 = 250 \times \$2.50 = \$625 Step 3: Calculate Total Annual Inventory Cost. TC=$1,600+$625=$2,225TC = \$1,600 + \$625 = \$2,225

b) 750 units Step 1: Calculate Annual Ordering Cost. AnnualOrderingCost=40,000750×$2053.33×$20=$1,066.67Annual Ordering Cost = \frac{40,000}{750} \times \$20 \approx 53.33 \times \$20 = \$1,066.67 Step 2: Calculate Annual Holding Cost. AnnualHoldingCost=7502×$2.50=375×$2.50=$937.50Annual Holding Cost = \frac{750}{2} \times \$2.50 = 375 \times \$2.50 = \$937.50 Step 3: Calculate Total Annual Inventory Cost. TC=$1,066.67+$937.50=$2,004.17TC = \$1,066.67 + \$937.50 = \$2,004.17

c) 1,000 units Step 1: Calculate Annual Ordering Cost. AnnualOrderingCost=40,0001,000×$20=40×$20=$800Annual Ordering Cost = \frac{40,000}{1,000} \times \$20 = 40 \times \$20 = \$800 Step 2: Calculate Annual Holding Cost. AnnualHoldingCost=1,0002×$2.50=500×$2.50=$1,250Annual Holding Cost = \frac{1,000}{2} \times \$2.50 = 500 \times \$2.50 = \$1,250 Step 3: Calculate Total Annual Inventory Cost. TC=$800+$1,250=$2,050TC = \$800 + \$1,250 = \$2,050

d) 1,250 units Step 1: Calculate Annual Ordering Cost. AnnualOrderingCost=40,0001,250×$20=32×$20=$640Annual Ordering Cost = \frac{40,000}{1,250} \times \$20 = 32 \times \$20 = \$640 Step 2: Calculate Annual Holding Cost. AnnualHoldingCost=1,2502×$2.50=625×$2.50=$1,562.50Annual Holding Cost = \frac{1,250}{2} \times \$2.50 = 625 \times \$2.50 = \$1,562.50 Step 3: Calculate Total Annual Inventory Cost. TC=$640+$1,562.50=$2,202.50TC = \$640 + \$1,562.50 = \$2,202.50

To plot these on a graph, you would use the order quantity (Q) on the x-axis and the total annual inventory cost (TC) on the y-axis. The points to plot are: • (500 units, 2,225)(750units,2,225) • (750 units, 2,004.17) • (1,000 units, 2,050)(1,250units,2,050) • (1,250 units, 2,202.50)

What's next? Send 'em!

Was this helpful?

Need help with your own homework?

Get instant step-by-step solutions to any question. Free to start.

Ask Your Question
Handwritten step-by-step solution preview

Handwritten Step-by-Step Solution

Get this as a handwritten image on WhatsApp — like a tutor wrote it for you.

Try on WhatsApp

Still have questions?

Quick Answer

The inventory holding cost rate is 10% p.a. of inventory value, and the purchase price is 25 per desk.

Janis has demand for 40,000 desks p.a. and the purchase price of each desk is 25. There are ordering costs of 20 for each order placed. Inventory holding costs amount to 10% p.a. of inventory value. Calculate the inventory costs p.a. for the following order quantities, and plot them on a graph:
Business/Management

This business/management problem is solved step by step below, with detailed explanations to help you understand the method and arrive at the correct answer.

ScanSolve AI Answer
First, let's determine the annual holding cost per unit. The inventory holding cost rate is 10% p.a. of inventory value, and the purchase price is 25 per desk. Annual Holding Cost per unit (H) = Holding Cost Rate × Purchase Price H = 0.10 × \25 = \2.50 per unit p.a. The total annual inventory cost (TC) is the sum of the annual ordering cost and the annual holding cost. TC = (Annual Demand (D)Order Quantity (Q)) × Ordering Cost per Order (S) + (Order Quantity (Q)2) × Annual Holding Cost per unit (H) Given: Annual Demand (D) = 40,000 units Ordering Cost per Order (S) = 20 Annual Holding Cost per unit (H) = 2.50 a) 500 units Step 1: Calculate Annual Ordering Cost. Annual Ordering Cost = (40,000)/(500) × \20 = 80 × \20 = \1,600 Step 2: Calculate Annual Holding Cost. Annual Holding Cost = (500)/(2) × \2.50 = 250 × \2.50 = \625 Step 3: Calculate Total Annual Inventory Cost. TC = \1,600 + \625 = \2,225 b) 750 units Step 1: Calculate Annual Ordering Cost. Annual Ordering Cost = (40,000)/(750) × \20 ≈ 53.33 × \20 = \1,066.67 Step 2: Calculate Annual Holding Cost. Annual Holding Cost = (750)/(2) × \2.50 = 375 × \2.50 = \937.50 Step 3: Calculate Total Annual Inventory Cost. TC = \1,066.67 + \937.50 = \2,004.17 c) 1,000 units Step 1: Calculate Annual Ordering Cost. Annual Ordering Cost = (40,000)/(1,000) × \20 = 40 × \20 = \800 Step 2: Calculate Annual Holding Cost. Annual Holding Cost = (1,000)/(2) × \2.50 = 500 × \2.50 = \1,250 Step 3: Calculate Total Annual Inventory Cost. TC = \800 + \1,250 = \2,050 d) 1,250 units Step 1: Calculate Annual Ordering Cost. Annual Ordering Cost = (40,000)/(1,250) × \20 = 32 × \20 = \640 Step 2: Calculate Annual Holding Cost. Annual Holding Cost = (1,250)/(2) × \2.50 = 625 × \2.50 = \1,562.50 Step 3: Calculate Total Annual Inventory Cost. TC = \640 + \1,562.50 = \2,202.50 To plot these on a graph, you would use the order quantity (Q) on the x-axis and the total annual inventory cost (TC) on the y-axis. The points to plot are: • (500 units, 2,225) • (750 units, 2,004.17) • (1,000 units, 2,050) • (1,250 units, $2,202.50) What's next? Send 'em!