Donna and Sherman Terrel are preparing a budget for 2010. Donna is a systems analyst with an airplane manufacturer, and Sherman is working on a master's degree in educational psychology. The Terrels do not have any children or other dependents. Donna estimates her salary will be about $45,600 in 2010; Sherman expects to work only during the summer months, doing painting and remodeling work for a building contractor. He anticipates an income from those activities of $3000 a month in June, July, and August. Sherman does have a scholarship that pays his tuition and also provides $3,600 a year of which $2400 is payable in February and $1200 is payable in October. The Terrels don't expect to have any other income in 2010.
Donna and Sherman have listed their expected total expenses in 2010 as follows:
Housing (rent) $8,640
Food (includes dining out) 8,100
Life - payable in May
Auto - payable in January
Leisure and entertainment:
Vacation in May
Total Expenses $50,460
The Terrels will begin 2010 with about $1,000 in liquid assets, and they prefer not to draw this balance below $600 at any time during the year.© BrainMass Inc. brainmass.com June 3, 2020, 11:11 pm ad1c9bdddf
Donna's Total Salary in 2010 = $45,600
Monthly Salary =$45,600/12 = $3800
Total Housing Rent in 2010 = $8640
Monthly Rent = $8640/12 = $720
Total expenditure on ...
This solution is comprised of a detailed explanation of the steps involved in preparing a Budget Plan. Supplemented with more than 300 words of text, and Excel worksheets, this step-by-step explanation of this complicated topic provides students with a clear perspective of Budget Planning.