anagingotalalue

by

Imelda Bell
 and Susan Gooch
 

Introduction | Task | Resources | Process | Evaluation | Conclusion

Introduction

You are a music producer for a new, young artist, Savannah.  Your duties include recording her revenue and expenses, and advising her on staying within a limited budget.  The purpose is teaching Savannah how to manage the total value of her assets.  Her monthly revenue is $2500, but Savannah is not aware of all of her daily living expenses.  She has asked you to analyze her situation and advise her as to a solution.

The Task

Upon completion of analysis of Savannah's financial situation, you will present to her the following:

• answers to four budget-related questions
• a record of her revenues and expenses, using Excel spreadsheet,
• a chart comparing total revenue to total expenses,
• actual and proposed budgets,
• a presentation, using PowerPoint, defending your proposal.

Resources

On your PowerPoint presentation to Savannah, present the answers to the following questions on separate slides:

1. Name a bargaining trick for when the seasons change. http://www.frugalfamilynetwork.com/page6.html
2. What is Cheapskate Monthly? http://www.cheapskatemonthly.com/aboutus.htm
3. Write definitions of debt, earning, and ROE.  http://www.stretcher.com/stories/00/000228j.cfm
4. List five simple tips for reducing grocery expenses.http://www.stretcher.com/stories/02/02feb18c.cfm
5. Use the following link for proposed budget data.  http://local.yahoo.com/?location_state=CA&location_city=Los+Angeles&location_lat=34.052200&location_lon=-118.242798

The Process

To accomplish the task, take the following steps using the given information. 
 

1. Enter the following actual data into an Excel spreadsheet.  Actual Revenue (take-home pay):  $2500; Actual Expenses--rent:  $900;  car payment:  $450; telephone:  $100; groceries:  $75; Entertainment:  $500; Clothing:  $1800.  Chart actual data on a bar graph.
2. Enter the following proposed budget data into an Excel spreadsheet.  Revenue remains the same at $2500.  Use the internet resources to find values for all of her expenses that would not exceed her monthly income.  Chart proposed data on a bar graph.
3. Using Powerpoint, create a presentation to explain to Savannah how the benefits of using the proposed budget.  Minimum: 12 slides.

Evaluation

The performance will be evaluated by the criteria in the rubric.  Each student will be evaluated individually on his overall presentation.

Conclusion

The students will have learned how to search the Internet, find relevant data for everyday situations, and remain within a given budget amount.  They will integrate the data from Excel spreadsheets and charts to a PowerPoint presentation.  They will present their work with an oral argument to justify their proposal.