Inflation Rate - Assignment.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Inflation Rate - Assignment.xlsx as PDF for free.
More details
- Words: 357
- Pages: 4
S/No A 1 2 3 4 5 6 7 8 9
Item Household Supplies Drinking Water Beans Meat Potatoes Sugar Salt (500 grms) Cooking Oil Bread Rice SUB TOTAL
B Public Services 10 Electricity 11 Water Services SUB TOTAL
Units
Monthly Consumption Price in 2015
Price in 2016
Ltrs kg kg kg kg kg Ltrs loaf kg
90 5 10 30 2 1 10 20 20
500 2,000 2,500 1,000 1,700 500 18,000 1,000 1,400
800 2,200 3,000 1,200 2,000 500 18,500 1,300 1,600
units
60
300
350
m
20
5,000
5,500
3
C Health Services 12 Medical Services SUB TOTAL
Visit
3
40,000
50,000
D Shelter 14 House Rent SUB TOTAL
month
1
300,000
350,000
E Clothing 15 Trousers / T-shirt SUB TOTAL
No
6
80,000
100,000
OVERALL TOTAL
Amount in 2015
Amount in 2016
45,000 10,000 25,000 30,000 3,400 500 180,000 20,000 28,000 341,900
72,000 11,000 30,000 36,000 4,000 500 185,000 26,000 32,000 396,500
18,000
21,000
100,000 118,000
110,000 131,000
120,000 120,000
150,000 150,000
300,000 300,000
350,000 350,000
480,000 480,000
600,000 600,000
1,359,900
1,627,500
S/No A 1 2 3 4 5 6 7 8 9
Item Food Rice Beans Meat Maize Flour Sugar Salt (500 grms) Cooking Oil Bread Tea (30 leaves pack) SUB TOTAL
Units
Monthly Consumption
Amount 2014
Amount 2015
kg kg kg kg kg kg Ltrs loaf pcs
20 5 5 30 4 1 5 20 2
28,000 10,000 12,500 30,000 6,800 500 90,000 20,000 3,000 200,800
32,000 10,500 15,000 31,500 6,800 600 92,500 24,000 3,200 216,100
B Social Services 10 Electricity 11 Water Services SUB TOTAL
units m3
50 15
18,700 75,000 93,700
18,250 90,000 108,250
C Health Services 12 Medical Services SUB TOTAL
visit/day
3
90,000 90,000
120,000 120,000
D Shelter 14 House Rent SUB TOTAL
month
1
300,000 300,000
350,000 350,000
E Clothing 15 Trousers / T-shirt SUB TOTAL
No
3
150,000 150,000
165,000 165,000
834,500
959,350
GRAND TOTAL
CP1
203,355.70
CP2
231,971.93
INFLATION RATE
(CPI 2-CPI 1/CP1)X100%=
14.07
Weight Weight 2014 2015
CPI 2014
CPI 2015
0.24062 0.225257
48,317.12
48,677.97
0.11228 0.112837
10,520.90
12,214.59
0.10785 0.125085
9,706.41
15,010.16
0.3595 0.36483 107,849.01
127,690.62
0.17975 0.171991 1
1
26,962.25
28,378.59
Item Household Supplies Drinking Water Beans Meat Potatoes Sugar Salt (500 grms) Cooking Oil Bread Rice SUB TOTAL
B Public Services 10 Electricity 11 Water Services SUB TOTAL
Units
Monthly Consumption Price in 2015
Price in 2016
Ltrs kg kg kg kg kg Ltrs loaf kg
90 5 10 30 2 1 10 20 20
500 2,000 2,500 1,000 1,700 500 18,000 1,000 1,400
800 2,200 3,000 1,200 2,000 500 18,500 1,300 1,600
units
60
300
350
m
20
5,000
5,500
3
C Health Services 12 Medical Services SUB TOTAL
Visit
3
40,000
50,000
D Shelter 14 House Rent SUB TOTAL
month
1
300,000
350,000
E Clothing 15 Trousers / T-shirt SUB TOTAL
No
6
80,000
100,000
OVERALL TOTAL
Amount in 2015
Amount in 2016
45,000 10,000 25,000 30,000 3,400 500 180,000 20,000 28,000 341,900
72,000 11,000 30,000 36,000 4,000 500 185,000 26,000 32,000 396,500
18,000
21,000
100,000 118,000
110,000 131,000
120,000 120,000
150,000 150,000
300,000 300,000
350,000 350,000
480,000 480,000
600,000 600,000
1,359,900
1,627,500
S/No A 1 2 3 4 5 6 7 8 9
Item Food Rice Beans Meat Maize Flour Sugar Salt (500 grms) Cooking Oil Bread Tea (30 leaves pack) SUB TOTAL
Units
Monthly Consumption
Amount 2014
Amount 2015
kg kg kg kg kg kg Ltrs loaf pcs
20 5 5 30 4 1 5 20 2
28,000 10,000 12,500 30,000 6,800 500 90,000 20,000 3,000 200,800
32,000 10,500 15,000 31,500 6,800 600 92,500 24,000 3,200 216,100
B Social Services 10 Electricity 11 Water Services SUB TOTAL
units m3
50 15
18,700 75,000 93,700
18,250 90,000 108,250
C Health Services 12 Medical Services SUB TOTAL
visit/day
3
90,000 90,000
120,000 120,000
D Shelter 14 House Rent SUB TOTAL
month
1
300,000 300,000
350,000 350,000
E Clothing 15 Trousers / T-shirt SUB TOTAL
No
3
150,000 150,000
165,000 165,000
834,500
959,350
GRAND TOTAL
CP1
203,355.70
CP2
231,971.93
INFLATION RATE
(CPI 2-CPI 1/CP1)X100%=
14.07
Weight Weight 2014 2015
CPI 2014
CPI 2015
0.24062 0.225257
48,317.12
48,677.97
0.11228 0.112837
10,520.90
12,214.59
0.10785 0.125085
9,706.41
15,010.16
0.3595 0.36483 107,849.01
127,690.62
0.17975 0.171991 1
1
26,962.25
28,378.59
Related Documents
Inflation Rate - Assignment.xlsx
May 2020 9
Inflation Rate Of Pakistan
May 2020 12
Rate Of Inflation, 1998 - 2009
June 2020 7
Inflation
November 2019 43
Inflation
November 2019 42More Documents from ""
Inflation Rate - Assignment.xlsx
May 2020 9
Ssb05_detailed_design_of_trusses.pdf
May 2020 4
Stiffeners Design.docx
May 2020 6
Remedies For Breach Of Contract.ppt
May 2020 6
Rel 4.docx
April 2020 9