Question: A . Create an excel spreadsheet for one month of expenditures Then, create an excel spreadsheet for one month of actual current recorded expenditures. Please
A Create an excel spreadsheet for one month of expenditures
Then, create an excel spreadsheet for one month of actual current recorded expenditures. Please include the date, amount of spending, category for each item you spend on for one month. You can pick the month for which you will keep track of your current expenses. Then, please sum them by the above listed categories and report your results. I will provide a spreadsheet for both the budgeted categories and the monthly expenditure tracking for you but you can also create your own if you wish. The excel spreadsheets will be submitted to me In the spreadsheet there are three tabs budget, recorded expenditures, and a pivot table. The pivot table allows us to sum by category. Please reach out if you need any assistance with the excel fine.
B Reflection on budget and expenses
Once you have completed the budget and recorded expenses in excel, reflect on how you are spending your money. Please submit this information in a word document.
Are there any surprises?
Are you spending more than you anticipated in any particular categories?
How does the budget you have for yourself reconcile with your actual expenditures?
Are there any categories that you feel you can spend more in or should spend less in
Look at all your variable expenses first and see if you can save some money. Keep in mind that you have more control over your variable expenses than your fixed expenses. Fixed expenses are expenses that dont generally change from month to month, like rent, most utilities and car payments. Variable expenses are expenses that can easily change, like the amount spent on food, entertainment or clothing. What are your total fixed expenses? What are your total your variable expenses per month?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
