Please look over this expense table to make sure I completed it right. I\'m not
ID: 3068311 • Letter: P
Question
Please look over this expense table to make sure I completed it right. I'm not sure of the last total in the percent column of 79.5% is correct. Please let me know if I did this chart right thanks.
Record of Expenses
Home work unit 10 Total monthly income after deductions. To do this, take 2/3 of annual salary for estimation divided by 12. For example, if you make $67,240, then 2/3 times 67,240 = 44,832/12=3,736. The $3,736 should be your denominator for fraction.
Annual salary before deduction: _$67,248_______________
Annual salary after deduction:____$44,832______________
Monthly salary: ________$_3,736___________
Expense Category
Amount per month
Amount as a Fraction of Total Income
As a decimal of total income
As a percent of total income
Rent
$1195
1195/3736=1195/3736
0.32
32%
Gas& Electric
$300
300/3736=75/934
0.08
8%
Water
$200
200/3736=25/467
0.054
54%
Food
$600
600/3736=75/467
0.161
16.1%
Student Loan
$5.00
5/3736=5/3736
0.001
0.1%
Transportation
/Gas
$160
160/3736=20/467
0.043
4.3%
Cell phone
$40
40/3736=5/467
0.011
1.1%
Children Needs
$400
400/3736=50/467
0.107
10.7
WiFi Bill
$69.00
69/3736=69/3736
0.018
1.8%
TOTALS:
$2,969
2,969/3736
0.795
79.5
Expense Category
Amount per month
Amount as a Fraction of Total Income
As a decimal of total income
As a percent of total income
Rent
$1195
1195/3736=1195/3736
0.32
32%
Gas& Electric
$300
300/3736=75/934
0.08
8%
Water
$200
200/3736=25/467
0.054
54%
Food
$600
600/3736=75/467
0.161
16.1%
Student Loan
$5.00
5/3736=5/3736
0.001
0.1%
Transportation
/Gas
$160
160/3736=20/467
0.043
4.3%
Cell phone
$40
40/3736=5/467
0.011
1.1%
Children Needs
$400
400/3736=50/467
0.107
10.7
WiFi Bill
$69.00
69/3736=69/3736
0.018
1.8%
TOTALS:
$2,969
2,969/3736
0.795
79.5
Explanation / Answer
Yes ;as per given information; all the calculations have been rightly done
only in Water category ; as a percent of total income should be 5.4% instad of 54%.
( please revert if any help is required on this)