The Word report should address Task 1 Question (e) and (f). To answer Question (e), some…
- User
The Word report should address Task 1 Question (e) and (f). To answer Question (e), some EOQ and total cost calculations are needed. To answer Question (f), it requires your own research and analysis. Harvey Norman sells DEEBOT X2 OMNI Robot Vacuum & Mop ordered from ECOVACS at all its stores in Australia. The average demand is 700 units each month. Harvey Norman incurs a fixed order placement, transportation, and receiving cost of 1,400 per unit. Recently, ECOVACS offers all-unit quantity discount to its retailers to promote sales. The price schedule is as follows: Order Quantity Per Lot Price Per Unit 1 – 1,000 is 1,350 Over 2,000 is 1,400? 3) What is the optimal order quantity if Harvey Norman decides to take the volume discount? You need to show the calculations of EOQs and total costs at all the three prices. 4) What is the new total annual cost for Harvey Norman upon taking the volume discount? 5) What is the annual saving for Harvey Norman upon taking the quantity discount in comparison with the normal situation when there is no volume discount?
- Assistant
Task 1: Inventory Management Analysis for Harvey Norman
This report addresses Task 1 Questions (e) and (f) related to Harvey Norman's ordering strategy for the DEEBOT X2 OMNI Robot Vacuum & Mop from ECOVACS. The analysis includes calculations of Economic Order Quantity (EOQ), total annual costs under various pricing scenarios, and the financial impact of adopting quantity discounts.
Question 1: Economic Order Quantity (EOQ) Without Volume Discount
Given:
- Annual Demand (D): 700 units/month × 12 months = 8,400 units/year
- Fixed Ordering Cost (S): $5,000 per order
- Unit Cost (c): $1,400
- Holding Cost Rate: 5% of unit cost
- Holding Cost per Unit (H): 5% of 70/year**
EOQ Formula: [ \text{EOQ} = \sqrt{\frac{2DS}{H}} ]
Calculation: [ \text{EOQ} = \sqrt{\frac{2 \times 8,400 \times 5,000}{70}} = \sqrt{\frac{84,000,000}{70}} = \sqrt{1,200,000} \approx 1,095 \text{ units} ]
Answer:
The Economic Order Quantity (EOQ) without volume discounts is approximately 1,095 units per order.
Question 2: Total Annual Cost Without Volume Discount
Components of Total Cost:
- Purchase Cost:
[ \text{Purchase Cost} = D \times c = 8,400 \times 1,400 = $11,760,000 ] - Ordering Cost:
[ \text{Ordering Cost} = \left(\frac{D}{\text{EOQ}}\right) \times S = \left(\frac{8,400}{1,095}\right) \times 5,000 \approx 7.67 \times 5,000 = $38,335 ] - Holding Cost:
[ \text{Holding Cost} = \left(\frac{\text{EOQ}}{2}\right) \times H = \left(\frac{1,095}{2}\right) \times 70 \approx 547.5 \times 70 = $38,325 ]
Total Annual Cost: [ \text{Total Cost} = \text{Purchase Cost} + \text{Ordering Cost} + \text{Holding Cost} = 11,760,000 + 38,335 + 38,325 = $11,836,660 ]
Answer:
The total annual cost without volume discounts is $11,836,660.
Question 3: Optimal Order Quantity with Volume Discounts
Quantity Discount Structure:
- 1 – 1,000 units: $1,400 per unit
- 1,001 – 2,000 units: $1,350 per unit
- Over 2,000 units: $1,300 per unit
Holding Cost per Unit for Each Price Level:
- **1,400/unit:** \[ H = 5\% \times 1,400 = \70 \text{ per unit/year} ]
- **1,350/unit:** \[ H = 5\% \times 1,350 = \67.50 \text{ per unit/year} ]
- **1,300/unit:** \[ H = 5\% \times 1,300 = \65 \text{ per unit/year} ]
EOQ Calculations for Each Price Level:
-
Price Level 1 (1 – 1,000 units): [ \text{EOQ}_1 = \sqrt{\frac{2 \times 8,400 \times 5,000}{70}} = \sqrt{1,200,000} \approx 1,095 \text{ units} ]
- Constraint: Maximum of 1,000 units.
- Adjusted Order Quantity: 1,000 units
-
Price Level 2 (1,001 – 2,000 units): [ \text{EOQ}_2 = \sqrt{\frac{2 \times 8,400 \times 5,000}{67.5}} = \sqrt{\frac{84,000,000}{67.5}} \approx \sqrt{1,244,444} \approx 1,115 \text{ units} ]
- Within Price Level 2 Range: Yes (1,001 – 2,000 units)
- Optimal Order Quantity: 1,115 units
-
Price Level 3 (Over 2,000 units): [ \text{EOQ}_3 = \sqrt{\frac{2 \times 8,400 \times 5,000}{65}} = \sqrt{\frac{84,000,000}{65}} \approx \sqrt{1,292,307.69} \approx 1,137 \text{ units} ]
- Constraint: Minimum of 2,001 units.
- Adjusted Order Quantity: 2,001 units
Answer:
The optimal order quantities for each price level are:- 1 – 1,000 units: 1,000 units
- 1,001 – 2,000 units: 1,115 units
- Over 2,000 units: 2,001 units
Question 4: Total Annual Cost with Volume Discounts
Total Cost Components for Each Order Quantity:
-
Order Quantity: 1,000 units ($1,400/unit)
- Purchase Cost:
[ 8,400 \times 1,400 = $11,760,000 ] - Ordering Cost:
[ \left(\frac{8,400}{1,000}\right) \times 5,000 = 8.4 \times 5,000 = $42,000 ] - Holding Cost:
[ \left(\frac{1,000}{2}\right) \times 70 = 500 \times 70 = $35,000 ] - Total Cost:
[ 11,760,000 + 42,000 + 35,000 = $11,837,000 ]
- Purchase Cost:
-
Order Quantity: 1,115 units ($1,350/unit)
- Purchase Cost:
[ 8,400 \times 1,350 = $11,340,000 ] - Ordering Cost:
[ \left(\frac{8,400}{1,115}\right) \times 5,000 \approx 7.54 \times 5,000 = $37,700 ] - Holding Cost:
[ \left(\frac{1,115}{2}\right) \times 67.5 \approx 557.5 \times 67.5 = $37,656.25 ] - Total Cost:
[ 11,340,000 + 37,700 + 37,656.25 \approx $11,415,356.25 ]
- Purchase Cost:
-
Order Quantity: 2,001 units ($1,300/unit)
- Purchase Cost:
[ 8,400 \times 1,300 = $10,920,000 ] - Ordering Cost:
[ \left(\frac{8,400}{2,001}\right) \times 5,000 \approx 4.1979 \times 5,000 \approx $20,990 ] - Holding Cost:
[ \left(\frac{2,001}{2}\right) \times 65 \approx 1,000.5 \times 65 = $65,032.50 ] - Total Cost:
[ 10,920,000 + 20,990 + 65,032.50 \approx $10,906,022.50 ]
- Purchase Cost:
Summary of Total Annual Costs:
- 1,000 units: $11,837,000
- 1,115 units: $11,415,356.25
- 2,001 units: $10,906,022.50
Answer:
The total annual costs for each order quantity with volume discounts are:- 1,000 units: $11,837,000
- 1,115 units: $11,415,356.25
- 2,001 units: $10,906,022.50
Question 5: Annual Savings from Quantity Discounts
Comparison Between No Discount and Optimal Discount Scenario:
- Total Cost Without Discount: $11,836,660
- Total Cost with Optimal Discount (2,001 units): $10,906,022.50
Annual Savings: [ \text{Savings} = 11,836,660 - 10,906,022.50 = $930,637.50 ]
Answer:
By adopting the optimal quantity discount (ordering 2,001 units), Harvey Norman saves approximately $930,638 annually compared to the scenario without volume discounts.
Conclusion
Implementing volume discounts significantly reduces Harvey Norman's total annual costs associated with ordering the DEEBOT X2 OMNI Robot Vacuum & Mop. By increasing the order quantity to 2,001 units, the company benefits from a lower unit price, resulting in substantial annual savings of approximately $930,638. This strategy not only optimizes inventory management through reduced ordering and holding costs but also leverages supplier discounts to enhance profitability.