MS Excel: Budget Analysis

Computer Assignment

Computer Applications for Business – Assignment MS Excel: Budget Analysis

Apply your creative thinking and problem-solving skills to design and implement a solution.

NOTE:  You will need to use file from the textbook for the assignment:  Lab 8-3 Budget Analysis

Household Budget Analysis
Income	Jan	Feb	Mar	Apr	May	Jun
Wages	1,430	1,430	1,430	1,430	1,430	1,430
Student Loan	2500	0	0	0	0	800
Savings	800	400	200	375	625	700
Total	4,730	1,830	1,630	1,805	2,055	2,930
Exenses
Rent	850	850	850	850	850	850
Food	425	425	425	425	425	425
Utilities	225	210	175	165	120	135
Phone	75	75	75	75	75	75
Insurance	165	165	165	165	165	165
Tuition	2,200	0	0	0	0	1100
Books	450	0	0	0	0	300
Travel	190	120	150	450	120	180
Clothing	150	100	75	145	60	150
Total	4,730	1,945	1,915	2,275	1,815	3,380
Cash Flow	0	-115	-285	-470	240	-450

Part 1:

The workbook provided shows household income and expenses. You will create charts to help analyze your budget.

1.    Open the workbook Lab 8-3 Budget Analysis provided and save as CS155Week8LastnameFirstname. Ensure that you use your lastname and firstname.

2.    In the budget analysis file change; wages, food, phone, and clothing data for each month. (Leaving these items the same will result in a deduction)

3.    Create a chart using the expenses from the budget.
 

4.    Create a second chart using the cash flow data from the budget.
 

5.    The following areas will be part of grading criteria:

         Changes to data asked for in Part 1

         Ensure the charts created display months and appropriate items from column A

         Create a chart from expenses data

         Move expense data chart to own sheet

         Rename new sheet with expense chart to descriptive title

         Create chart title for expense data chart

         Create a chart from cash flow data

         Move cash flow chart to own sheet

         Rename new sheet with cash flow chart to descriptive titles

         Create chart title for cash flow chart

         Save the file as CS155Week8LastnameFirstname. Ensure that you use your lastname and firstname

         Add a footer in left section of sheet named Budget with your name and GIDnumber

NOTE:Charts not required to be pivot charts Part 2:

In Part 1 you made choices about which type(s) of chart(s) to use to present budget data. What was the rationale behind those selections? How did the data in the Household Expenses pose a special challenge? How might you address that challenge?

         Answer Part 2 questions in comments or submission text area when submitting

WE HAVE DONE THIS ASSIGNMENT BEFORE, WE CAN ALSO DO IT FOR YOU

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER on MS Excel: Budget Analysis

Are You looking for Assignment and Homework Writing help? We Provide High-Quality Academic Papers at Affordable Rates. No Plagiarism.

TO BE RE-WRITTEN FROM THE SCRATCH