[go: up one dir, main page]
Scribd
Upload
8 views5 pages

Book 1

Uploaded by

Lan Chi Vũ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
8 views5 pages

Book 1

Uploaded by

Lan Chi Vũ
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

1.

QDA
No. Units per orders 50 100 200
Price per unit 800 750 650
Total price per order 40000 75000 130000
Price diff. between orders 40000 35000 55000
Quantity diff. Between orders 50 50 100
Price per unit per order qty diff. 800 700 550
Per unit price diff at breaks 100 150
Percentage price reduction 12.50% 21.43%

Incremental Unit Price Chart


900
800
700
600
Dollars

500
400
300
200
100
0
50 100 200 300

Units

Price per unit Price per unit per order qty diff.

2. Fixed and variable cost calculator


Price # 1 2
Quantity 50 100
Unit Price 800 750

QtyToTest Prices calculated for quantities in


50
Price Pairs 1&2
Fixed Costs 5000
Vari Unit Costs 700 800
Price Pairs 1&3
Fixed Costs 10000
Vari Unit Costs 600 800
Price Pairs 1&4
Fixed Costs 12000
Vari Unit Costs 560 800
Price Pairs 2&3
Fixed Costs 20000
950
Vari Unit Costs 550 950
Price Pairs 3&4
Fixed Costs 30000
Vari Unit Costs 500 1100

3. Price Productivity Calculator


300
600
180000
50000
100
500
50
9.09%

The Quantity Discount Analysis (QDA) indicates that the unit price (Price per Unit) decrease
as order quantities increase, reflecting the supplier’s quantity-based discount strategy. The
reduction in unit price is more significant at smaller quantities (from 50 to 200 units) and
becomes less pronounced as the quantity reaches 300 units. This is further supported by th
percentage price reduction, which peaks at 21.43% (from 100 to 200 units) and drops to 9.09
(from 200 to 300 units).

While QDA highlights the price reduction pattern designed to incentivize larger orders, it doe
not explain why the rate of reduction diminishes at higher quantities. This may be influenced
factors such as production costs, economies of scale, or specific pricing strategies, which
300 would require further analysis to better understand the underlying reasons.

3 4
200 300
650 600

es calculated for quantities in first row


100 200 300

750 725 716.67

700 650 633.33

680 620 600

750 650 616.67


750 650 616.67

800 650 600


e per Unit) decreases
scount strategy. The
50 to 200 units) and
rther supported by the
ts) and drops to 9.09%

e larger orders, it does


s may be influenced by
ng strategies, which
ying reasons.

You might also like