Computer Applications for Business – Week 8 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

Computer Applications for Business – Week 8 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
Week 8 Computer Assignment Computer Applications for Business – Week 8 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