Section 5 Budget Pie Graph (2).xlsx

# Section 5 Budget Pie Graph (2).xlsx - Monthly Expenses...

• 2

This preview shows page 1 out of 2 pages.

Unformatted text preview: Monthly Expenses Rent/Mortgage Utilities Home Insurance Credit Card 1 Car pymt +ins Gasoline Cable +Internet Cell Phone Food Clothing/Personal Care Entertainment Actual \$ 750.00 \$ 220.00 \$ 125.00 \$ 80.00 \$ 250.00 \$ 175.00 \$ 125.00 \$ 60.00 \$ 210.00 \$ 30.00 \$ 75.00 i. Highlight your data and insert a pie-chart. ii. Give the chart a title iii. Format your chart so that both the percent and labels for each category show iv. Write a few observations about this budget. Where does most of the money go? What category is the least spent on? The most money goes to rent/mortgage, thats 36% of the monthly expenses. The least money is spent on clothing/ personal care. thats on 1% of the monthly expenses. Monthly Expenses Cell Phone; 3% Cable +Internet; 6% Clothing/Personal Care; 1 Food; 10% Ren Gasoline; 8% Car pymt +ins; 12% Utiliti Home Insurance; Credit Card 1; 4% Rent/Mortgage Car pymt +ins Food Utilities Gasoline Clothing/Personal Care Home Insu Cable +Inte Entertainm rt. cent and labels for each dget. Where does most of the nt on? thats 36% of the monthly othing/ personal care. thats only Monthly Expenses Clothing/Personal Care; 1% Entertainment; 4% Food; 10% Rent/Mortgage; 36% Car pymt +ins; 12% Utilities; 10% Home Insurance; 6% Credit Card 1; 4% Utilities Gasoline Clothing/Personal Care Home Insurance Cable +Internet Entertainment Credit Card 1 Cell Phone ...
View Full Document

• Spring '17
• Phyllis Wiegmann
• Payment, \$ 60.00, \$ 75.00, least money

{[ snackBarMessage ]}

###### "Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern