Activity 5.3 Jose's Budgeting
Jose, a college working student, wants to create a budgeting spreadsheet application
for a month's worth of financial activity. Create a similar Budgeting Spreadsheet
Application following the lesson discussed earlier with the data provided in Figure 2.16. It
must have two (2) tabs namely Allowance & Expense and Summary.
A
B
C
D
Income
Amoun
Expense Amoun
Parent's Allowance 500 Food
P850
Sallary
$5,000 Transport
700
Extra Income
P300 Dormitory
P1,000
5,800 School Expenses P1,750
School Supplies +250
Misc.
2500
P5,050
Figure 2.16: Jose's Budgeting Data
The Allowance & Expense tab contains Jose's source of income and its amount as
well as his expenses and amount. Follow the formatting as seen in Figure 2.16.
The Summary tab must contain a summary of the total income, expense, and the
remaining money along with the pie chart. This is similar to what you did in the
discussion​