Which Job Offer Should I Take? Job Title Marketing Analytics Annual Income Offer $ 60,000 Monthly Income $ 5,000 1,200 550 100 40 Monthly expenses Rent $ Transportation $ Food $ Water/Sewer $ Electricity $ Incidentals $ Phone $ Health insurance $ Income and Sales Taxes $ 100 150 50 200 680 Total Expenses Monthly Disposable Income Add up all of the expenses from the expense variables How much money is left over each month after expenses? Say you get three job offers for a job doing marketing analytics. The three jobs are in three cities. There are differences in the pay and cost of living in all three cities. The job with the highest remueration may not be the most lucritive job because the living expenses may leave you with less surplus cash each month to spend or to save. After a spreadshee it made to determine the value of one offer for the costs in that city, some people would just duplicate that spreadsheet two more times to work on the other two offers. However there is a better way. Using scenario manager in Excel, one sheet can be reused for the other two scenarios. In fact all three offers can be set up as scenarios using the one sheet. This is your task. The cities are: Charleston, San Fransisco and Detroit The offers are: $60,000, $90,000, and $50,000 respecitvely You figure out (or guess) the cost of living variables for each city. The values given are for the Charleston offer. Which offer is best based on Monthly Disposable Income? Instructions Use a formula in C23 to sum up the Monthly Expenses Use a formula in c24 to determine the difference between income and expenses Ceate a scenerio for a job the Charleston with the current values Create a scenerio for a job in San Francisco, CA; adjust the expenses as you researched them Create a scenerio for a job in Portland, OR; adjust the expenses as you researched them Which Job Offer Should I Take? Job Title Marketing Analytics Annual Income Offer $ 60,000 Monthly Income $ 5,000 1,200 550 100 40 Monthly expenses Rent $ Transportation $ Food $ Water/Sewer $ Electricity $ Incidentals $ Phone $ Health insurance $ Income and Sales Taxes $ 100 150 50 200 680 Total Expenses Monthly Disposable Income Add up all of the expenses from the expense variables How much money is left over each month after expenses? Say you get three job offers for a job doing marketing analytics. The three jobs are in three cities. There are differences in the pay and cost of living in all three cities. The job with the highest remueration may not be the most lucritive job because the living expenses may leave you with less surplus cash each month to spend or to save. After a spreadshee it made to determine the value of one offer for the costs in that city, some people would just duplicate that spreadsheet two more times to work on the other two offers. However there is a better way. Using scenario manager in Excel, one sheet can be reused for the other two scenarios. In fact all three offers can be set up as scenarios using the one sheet. This is your task. The cities are: Charleston, San Fransisco and Detroit The offers are: $60,000, $90,000, and $50,000 respecitvely You figure out (or guess) the cost of living variables for each city. The values given are for the Charleston offer. Which offer is best based on Monthly Disposable Income? Instructions Use a formula in C23 to sum up the Monthly Expenses Use a formula in c24 to determine the difference between income and expenses Ceate a scenerio for a job the Charleston with the current values Create a scenerio for a job in San Francisco, CA; adjust the expenses as you researched them Create a scenerio for a job in Portland, OR; adjust the expenses as you researched them