Develop a budget for the fictitious Brown family and Create a chart of the famil
ID: 2342736 • Letter: D
Question
Develop a budget for the fictitious Brown family and Create a chart of the family budget
Mr. Brown is a city worker earning $16.54 per hour for a 40 hour week, 52 weeks per year. He also earns overtime at the standard overtime rate. This year he worked 500 hours overtime. He also earns a yearly bonus of $2000 for his satisfactory performance evaluation. What as his total combined income?
Mrs. Brown is a social worker with a salary of $26000 per year. She also works 10 hours per week part-time on weekends at a retail store in the mall an hourly rate of $7.50 and a commission of 10% of sales. Her yearly sales were $25,000. What is her total combined income?
Joe, their teenage son, works 20 hours per week part-time earning $6.50 per hour. Joe has a responsibility to pay for his own student class dues of $10 per semester, his own entertainment, and his own clothes and personal items. Create a projected budget for Joe that includes a detailed list of possible expenditures.
Sandy, their pre-teen daughter, is too young to work, but receives and allowance of $10 per week for completing her chores at home. Create a typical budget for a pre-teen using her allowance as income.
Their house mortgage payment is $992 monthly.
Maintenance for the home averages $200 monthly.
The family lives in an area with mass transportation available.
Family medical insurance is available through Mr. Brown's employer for $150 per month. There are routine co-payments for each visit to the doctor. The Brown family was fortunate that no family member was ill, but each member of the family had a health check-up with a co-pay of $35.00 for each visit. Mr. Brown has a monthly prescription with a co-pay of $15.00.
The family's income tax rate is 25%.
Mrs. Brown's hourly rate (her part-time work) is put into savings, which earns 10 % interest compounded annually. How much will be in the account at the end of one year?
The family owes $5000 on credit card accounts with an annual interest rate of 12%, which is 1% monthly. The required minimum monthly payment is $75.00. How long will it take to repay the balance if the minimum amount is paid? How much must they pay each month to pay off the balance in 5 years?
***Hint: Locate a credit card calculator online to configure this amount. Provide the link to the calculator that you used.
Mr. and Mrs. Brown need to save 5% of their net income for retirement. Include this in your chart.
Identify fixed and variable expenses for the Brown family.
Explanation / Answer
Variable Expenses for Brown Family:
38,956.00
3,769.67
Credit Card Dues Repayment
-
Minimum monthly payment of $111.22 to pay credit card dues of $5000 in 5 years calculated as below:
Family Budget of Fictitious Brown Family Amount in $ Total combined income of Mr. Brown = 44,673.20 (16.54x40x52) + (16.54x500) + 2000 Total combined income of Mrs. Brown = 32,400.00 26000 + (7.5x10x52) + (25000x10%) Projected Budet for Joe: Earning of Joe 6,760.00 Expenses of Joe: Student class dues (assuming 4 semesters) 40.00 Entertainment (assuming $50 spent per week) 2,600.00 Clothes (assumed) 1,000.00 Personal Items (assumed) 1,000.00 4,640.00 Yearly saving by Joe 2,120.00 Typical Budet for Sandy: Allowance received by Sandy 520.00 Expenses done by Sandy (assuming $8 spent per week) 416.00 Yearly saving by Sandy 104.00 Total Yearly Income of Brown Family 83,833.20 (44673.20+32400+6760) Yearly Expenditure of Brown Family: House mortgage payment 11,904.00 Home maintenance 2,400.00 Transportation Expenses (assumed $100 per person per week for 2 people) 10,400.00 Family Medical Insurance 1,800.00 Expenses on routine health check-ups for a fmaily of four 2,400.00 Expenses incurred by Joe 4,640.00 Expenses incurred by Sandy 416.00 Personal and Entertainment expenses of Mr. Brown 5,200.00 (assuming $100 spent per week) Personal and Entertainment expenses of Mrs. Brown 6,500.00 (assuming $125 spent per week) Annual expenses of Mr. Brown (clothes etc.) 3,000.00 Annual expenses of Mrs. Brown (clothes etc.) 4,000.00 Repayment of Credit Card Dues 900.00 Income Tax 20,958.30 Saving for retirement 3,853.66 78,371.96 Surplus / (Deficit) 5,461.24 Fixed Expenses for Brown Family: House mortgage payment 11,904.00 Family Medical Insurance 1,800.00 Repayment of Credit Card Dues 900.00 14,604.00Variable Expenses for Brown Family:
Home maintenance 2,400.00 Transportation Expenses 10,400.00 Expenses on routine health check-ups for a fmaily of four 2,400.00 Expenses incurred by Joe 4,640.00 Expenses incurred by Sandy 416.00 Personal and Entertainment expenses of Mr. Brown 5,200.00 Personal and Entertainment expenses of Mrs. Brown 6,500.00 Annual expenses of Mr. Brown (clothes etc.) 3,000.00 Annual expenses of Mrs. Brown (clothes etc.) 4,000.0038,956.00
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.