Category: Curriculum & Instructional Design

  • [Solved] WEEK 7 CHFD 360 BUDGET PLANNING.docx

    ✓ Verified Academic Solution Available

    Executive Solution Overview

    **files (2)** – ## WEEK7CHFD360BUDGETPLANNING.docx – ## interactive_budgeting_sheet6.xlsx_safe.pdf **## WEEK7CHFD360BUDGETPLANNING.docx** | | | | — | — | | Hide Assignment Information | | Instructions | | | **Assignment 3: Budget Planning**<br>This week you read about the importance of a budg…

    Instant Solution Download

    $6.99

    Immediate access to the full model answer, formatted citations, and rubric breakdown.

    Need a Fresh Custom Paper?

    Have this question answered from scratch according to your specific instructions and deadline.

    Order on TutorsGallery →

    Assignment Prompt & Instructions

    **files (2)**

    – ## WEEK7CHFD360BUDGETPLANNING.docx

    – ## interactive_budgeting_sheet6.xlsx_safe.pdf

    **## WEEK7CHFD360BUDGETPLANNING.docx**

    | | |
    | — | — |
    | Hide Assignment Information |
    | Instructions | |
    | **Assignment 3: Budget Planning**<br>This week you read about the importance of a budget when managing family resources. Now it's time to create your own budget!<br>**Related Course Objectives:** [**CO1, CO5**](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1399197&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Directions**<br>For this assignment complete the following steps using the interactive Excel worksheet that is attached. It is VERY important for you to look at the bottom of the spread sheet and starting with the Directions tab, click on each tab (1-4): <br>1. Access the <br>**Family Details** sheet of the workbook and fill in the required information. You may use your own family as an example or create one. <br> <br>· Provide the family name, jobs, income, etc. <br>2. Access the <br>**Budget** Sheet of the workbook and enter the requested financial details. <br> <br>· Use the information from your Family Details sheet where requested.<br>· Fill in the remaining blanks on the form based on your own information or you may make up a family.<br>· You may provide your own salary or research the average salary for whatever profession you choose. Here is an example: <br>_According to salary.com: "The average Medical Laboratory Technician salary in Georgia is $48,223 as of September 01, 2018, but the range typically falls between $43,180 and $52,955."_<br>· If I was making up a family, I would use the average salary of $48,223 for my worksheet. <br>· Enter your references for each source (all of your sources – utilities, insurance, etc.) on the <br>**Research links** sheet of the worksheet.<br> <br>3. Access the <br>**Reflection Questions** sheet of the workbook and answer the questions in the space provided. Make sure to support your answers with facts from the textbook.<br> <br>**Submission Guidelines**<br>· Download the attached interactive budgeting sheet and save it to your computer. <br>· Complete the interactive budget sheet and save your entries.<br>· Upload your completed interactive budget sheet as an attachment for this assignment. |

    Week 7: Assignment 3 Budget Planning

    Top of Form

    Bottom of Form

    **## interactive_budgeting_sheet6.xlsx_safe.pdf**

    Assignment 3: Budget Planning Case Study
    Using this Workbook

    This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
    and Research Links.
    To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
    To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
    tab key and the arrow keys on your keyboard to easily move between cells.

    Directions

    Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
    example or create one. Be prepared with the family name, jobs, income, etc.
    Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
    Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
    would be based on your research. Enter your references on the Research links sheet of the workbook.
    Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.

    Family Details
    Where does the family live?

    Type of home

    How many adults are in the family?
    For each adult, enter the following information

    Adult 1 Name Adult 2 Name
    Adult 1 Role Mother Adult 2 Role

    Adult 1 Career Adult 2 Career
    Adult 1 Age Adult 2 Age

    Adult 3 Name Adult 4 Name
    Adult 3 Role Adult 4 Role

    Adult 3 Career Adult 4 Career
    Adult 3 Age Adult 4 Age

    How many childern are in the family?
    For each child, enter the following information:

    Child 1 Name Child 2 Name
    Child 1 Age Child 2 Age

    Child 1 Activities Child 2 Activities
    Child 3 Name Child 4 Name

    Child 3 Age Child 4 Age
    Child 3 Activities Child 4 Activities

    Child 5 Name Child 6 Name
    Child 5 Age Child 6 Age

    Child 5 Activities Child 6 Activities

    How many, if any, additional forms of
    income are there?

    Identify the family member and what it's for
    Additional Income 1 Additional Income 2

    Associated Family Member Associated Family Member
    Additional Income 3 Additional Income 4

    Associated Family Member Associated Family Member

    Items that require fixed monthly payments
    List all of the items that have recurring payments

    Item 1 Item 6
    Item 2 Item 7
    Item 3 Item 8
    Item 4 Item 9
    Item 5 Item 10

    How many pets are in the family?
    For each pet, enter the following information:

    Pet 1 Name Pet 2 Name
    Pet 1 Age Pet 2 Age

    Pet 1 Kind/Type Pet 2 Kind/Type

    Pet 3 Name Pet 4 Name
    Pet 3 Age Pet 4 Age

    Pet 3 Kind/Type Pet 4 Kind/Type
    Pet 5 Name Pet 6 Name

    Pet 5 Age Pet 6 Age
    Pet 5 Kind/Type Pet 6 Kind/Type

    Family Budget Sheet

    Current Assets Current Debt
    Home value Credit Debt mortgages
    Other Real Estate auto loans

    Total Real Estate Assets $- credit cards
    other

    Automobile Values Total Credit Debt $-

    Total Auto Assets $-

    Savings
    Liquid
    Pension/Retirement

    Total Savings $-

    Annual Incomes Before Taxes
    Adult 1
    Adult 2
    Adult 3 or child support

    Total Annual Income Before Taxes $-

    Monthly Incomes Before Taxes
    $- Adult 1
    $- Adult 2
    $- Adult 3 or child support

    Total Monthly Income Before Taxes $-

    Monthly Income After Taxes

    mortgages
    auto loans
    credit cards
    other

    Adult 1
    Adult 2
    Adult 3
    Government assistance

    Total Spendable Monthly Income $-

    Monthly Expenses
    Insurances
    Health/Medical
    Life
    Home/Rental
    Automobile
    Health insurance deductible
    Other:
    Other:

    Total Insurances $-

    Soft Goods
    Food
    Hygiene
    Clothing
    Small incidentals
    Other

    Total Soft Goods $-

    Home Expenses
    Mortgage/Rent
    Up-keep
    Taxes
    Electricity
    Gas
    Telephone
    Cell phone

    Garbage/Water/Sewer
    Lawn Care
    Cleaning Services
    Fees-home owner dues
    Cable
    Internet
    Other:
    Other:
    Total Home Expenses $-

    Entertainment Expenses
    Dining Out
    Movies/Theater
    Club memberships
    Travel
    Sporting Events
    Other:
    Other:
    Total Entertainment $-

    Automobile Expenses
    Vehicle 1 payment
    Vehicle 2 payment
    Vehicle 3 payment
    Maintenance & Repairs
    Gasoline
    Tax/license fees
    Total Automobile Expenses $-

    Miscellaneous Expenses:
    Credit card & Short term loans
    Other
    Education (books and tuition)
    Veterinarian

    Beauty expenses
    Gifts
    Contributions
    Pets
    Other:
    Other:
    Total Miscellaneous $-

    Total Anticipated Expenses $-

    Flex $-
    Monthly Savings Contributions
    Liquid
    Retirement
    Other:
    Other:
    Other:
    Total Savings per Month $-

    Unallocated Money $-

    .

    Reflection Questions

    Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
    Question 1: What is your strategy for saving?
    Enter Answer Here

    Question 2: If you had to make changes, looking at your budget, where could you make them?
    Enter Answer Here

    Question 3: How would you handle a large, unexpected expense?
    Enter Answer Here

    Question 4: If a friend or family member was struggling financially and not using a budget, based
    on what you've learned in the course, what techniques and/or strategies would you suggest?
    Enter Answer Here

    References
    Item Supported
    Adult #1 Salary (example line)

    Reference
    Med Tech Salary.com

    DO NOT USE OR EDIT THIS SHEET
    Family Roles Family Members
    Type your Own Type your Own
    Mother (divorced from Father and remarried) 0
    Father 0
    Father (divorced from Mother and remarried) 0
    Mother (divorced from Father and remarried) 0
    Wife's Mother 0
    Wife's Father 0
    Husband's Mother 0
    Husband's Father 0
    Husband 0
    Wife 0
    Partner
    Son
    Daughter

    Note to Developer, see Instructor Only Section for Workbook password if edits are needed.

    Additional Incomes Type of Home
    Type your own Type your Own
    Alimony Apartment
    Child Support Condo
    Social Security Mobile Home
    Stocks/Bonds Travel Travel
    Real Estate/Rentals Homeless/Shelter
    2nd Job

    **## interactive_budgeting_sheet6.xlsx_safe.pdf**

    Assignment 3: Budget Planning Case Study
    Using this Workbook

    This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
    and Research Links.
    To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
    To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
    tab key and the arrow keys on your keyboard to easily move between cells.

    Directions

    Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
    example or create one. Be prepared with the family name, jobs, income, etc.
    Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
    Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
    would be based on your research. Enter your references on the Research links sheet of the workbook.
    Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.

    Family Details
    Where does the family live?

    Type of home

    How many adults are in the family?
    For each adult, enter the following information

    Adult 1 Name Adult 2 Name
    Adult 1 Role Mother Adult 2 Role

    Adult 1 Career Adult 2 Career
    Adult 1 Age Adult 2 Age

    Adult 3 Name Adult 4 Name
    Adult 3 Role Adult 4 Role

    Adult 3 Career Adult 4 Career
    Adult 3 Age Adult 4 Age

    How many childern are in the family?
    For each child, enter the following information:

    Child 1 Name Child 2 Name
    Child 1 Age Child 2 Age

    Child 1 Activities Child 2 Activities
    Child 3 Name Child 4 Name

    Child 3 Age Child 4 Age
    Child 3 Activities Child 4 Activities

    Child 5 Name Child 6 Name
    Child 5 Age Child 6 Age

    Child 5 Activities Child 6 Activities

    How many, if any, additional forms of
    income are there?

    Identify the family member and what it's for
    Additional Income 1 Additional Income 2

    Associated Family Member Associated Family Member
    Additional Income 3 Additional Income 4

    Associated Family Member Associated Family Member

    Items that require fixed monthly payments
    List all of the items that have recurring payments

    Item 1 Item 6
    Item 2 Item 7
    Item 3 Item 8
    Item 4 Item 9
    Item 5 Item 10

    How many pets are in the family?
    For each pet, enter the following information:

    Pet 1 Name Pet 2 Name
    Pet 1 Age Pet 2 Age

    Pet 1 Kind/Type Pet 2 Kind/Type

    Pet 3 Name Pet 4 Name
    Pet 3 Age Pet 4 Age

    Pet 3 Kind/Type Pet 4 Kind/Type
    Pet 5 Name Pet 6 Name

    Pet 5 Age Pet 6 Age
    Pet 5 Kind/Type Pet 6 Kind/Type

    Family Budget Sheet

    Current Assets Current Debt
    Home value Credit Debt mortgages
    Other Real Estate auto loans

    Total Real Estate Assets $- credit cards
    other

    Automobile Values Total Credit Debt $-

    Total Auto Assets $-

    Savings
    Liquid
    Pension/Retirement

    Total Savings $-

    Annual Incomes Before Taxes
    Adult 1
    Adult 2
    Adult 3 or child support

    Total Annual Income Before Taxes $-

    Monthly Incomes Before Taxes
    $- Adult 1
    $- Adult 2
    $- Adult 3 or child support

    Total Monthly Income Before Taxes $-

    Monthly Income After Taxes

    mortgages
    auto loans
    credit cards
    other

    Adult 1
    Adult 2
    Adult 3
    Government assistance

    Total Spendable Monthly Income $-

    Monthly Expenses
    Insurances
    Health/Medical
    Life
    Home/Rental
    Automobile
    Health insurance deductible
    Other:
    Other:

    Total Insurances $-

    Soft Goods
    Food
    Hygiene
    Clothing
    Small incidentals
    Other

    Total Soft Goods $-

    Home Expenses
    Mortgage/Rent
    Up-keep
    Taxes
    Electricity
    Gas
    Telephone
    Cell phone

    Garbage/Water/Sewer
    Lawn Care
    Cleaning Services
    Fees-home owner dues
    Cable
    Internet
    Other:
    Other:
    Total Home Expenses $-

    Entertainment Expenses
    Dining Out
    Movies/Theater
    Club memberships
    Travel
    Sporting Events
    Other:
    Other:
    Total Entertainment $-

    Automobile Expenses
    Vehicle 1 payment
    Vehicle 2 payment
    Vehicle 3 payment
    Maintenance & Repairs
    Gasoline
    Tax/license fees
    Total Automobile Expenses $-

    Miscellaneous Expenses:
    Credit card & Short term loans
    Other
    Education (books and tuition)
    Veterinarian

    Beauty expenses
    Gifts
    Contributions
    Pets
    Other:
    Other:
    Total Miscellaneous $-

    Total Anticipated Expenses $-

    Flex $-
    Monthly Savings Contributions
    Liquid
    Retirement
    Other:
    Other:
    Other:
    Total Savings per Month $-

    Unallocated Money $-

    .

    Reflection Questions

    Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
    Question 1: What is your strategy for saving?
    Enter Answer Here

    Question 2: If you had to make changes, looking at your budget, where could you make them?
    Enter Answer Here

    Question 3: How would you handle a large, unexpected expense?
    Enter Answer Here

    Question 4: If a friend or family member was struggling financially and not using a budget, based
    on what you've learned in the course, what techniques and/or strategies would you suggest?
    Enter Answer Here

    References
    Item Supported
    Adult #1 Salary (example line)

    Reference
    Med Tech Salary.com

    DO NOT USE OR EDIT THIS SHEET
    Family Roles Family Members
    Type your Own Type your Own
    Mother (divorced from Father and remarried) 0
    Father 0
    Father (divorced from Mother and remarried) 0
    Mother (divorced from Father and remarried) 0
    Wife's Mother 0
    Wife's Father 0
    Husband's Mother 0
    Husband's Father 0
    Husband 0
    Wife 0
    Partner
    Son
    Daughter

    Note to Developer, see Instructor Only Section for Workbook password if edits are needed.

    Additional Incomes Type of Home
    Type your own Type your Own
    Alimony Apartment
    Child Support Condo
    Social Security Mobile Home
    Stocks/Bonds Travel Travel
    Real Estate/Rentals Homeless/Shelter
    2nd Job

    **## WEEK7CHFD360BUDGETPLANNING.docx**

    | | |
    | — | — |
    | Hide Assignment Information |
    | Instructions | |
    | **Assignment 3: Budget Planning**<br>This week you read about the importance of a budget when managing family resources. Now it's time to create your own budget!<br>**Related Course Objectives:** [**CO1, CO5**](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1399197&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Directions**<br>For this assignment complete the following steps using the interactive Excel worksheet that is attached. It is VERY important for you to look at the bottom of the spread sheet and starting with the Directions tab, click on each tab (1-4): <br>1. Access the <br>**Family Details** sheet of the workbook and fill in the required information. You may use your own family as an example or create one. <br> <br>· Provide the family name, jobs, income, etc. <br>2. Access the <br>**Budget** Sheet of the workbook and enter the requested financial details. <br> <br>· Use the information from your Family Details sheet where requested.<br>· Fill in the remaining blanks on the form based on your own information or you may make up a family.<br>· You may provide your own salary or research the average salary for whatever profession you choose. Here is an example: <br>_According to salary.com: "The average Medical Laboratory Technician salary in Georgia is $48,223 as of September 01, 2018, but the range typically falls between $43,180 and $52,955."_<br>· If I was making up a family, I would use the average salary of $48,223 for my worksheet. <br>· Enter your references for each source (all of your sources – utilities, insurance, etc.) on the <br>**Research links** sheet of the worksheet.<br> <br>3. Access the <br>**Reflection Questions** sheet of the workbook and answer the questions in the space provided. Make sure to support your answers with facts from the textbook.<br> <br>**Submission Guidelines**<br>· Download the attached interactive budgeting sheet and save it to your computer. <br>· Complete the interactive budget sheet and save your entries.<br>· Upload your completed interactive budget sheet as an attachment for this assignment. |

    Week 7: Assignment 3 Budget Planning

    Top of Form

    Bottom of Form

    **## interactive_budgeting_sheet6.xlsx_safe.pdf**

    Assignment 3: Budget Planning Case Study
    Using this Workbook

    This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
    and Research Links.
    To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
    To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
    tab key and the arrow keys on your keyboard to easily move between cells.

    Directions

    Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
    example or create one. Be prepared with the family name, jobs, income, etc.
    Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
    Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
    would be based on your research. Enter your references on the Research links sheet of the workbook.
    Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.

    Family Details
    Where does the family live?

    Type of home

    How many adults are in the family?
    For each adult, enter the following information

    Adult 1 Name Adult 2 Name
    Adult 1 Role Mother Adult 2 Role

    Adult 1 Career Adult 2 Career
    Adult 1 Age Adult 2 Age

    Adult 3 Name Adult 4 Name
    Adult 3 Role Adult 4 Role

    Adult 3 Career Adult 4 Career
    Adult 3 Age Adult 4 Age

    How many childern are in the family?
    For each child, enter the following information:

    Child 1 Name Child 2 Name
    Child 1 Age Child 2 Age

    Child 1 Activities Child 2 Activities
    Child 3 Name Child 4 Name

    Child 3 Age Child 4 Age
    Child 3 Activities Child 4 Activities

    Child 5 Name Child 6 Name
    Child 5 Age Child 6 Age

    Child 5 Activities Child 6 Activities

    How many, if any, additional forms of
    income are there?

    Identify the family member and what it's for
    Additional Income 1 Additional Income 2

    Associated Family Member Associated Family Member
    Additional Income 3 Additional Income 4

    Associated Family Member Associated Family Member

    Items that require fixed monthly payments
    List all of the items that have recurring payments

    Item 1 Item 6
    Item 2 Item 7
    Item 3 Item 8
    Item 4 Item 9
    Item 5 Item 10

    How many pets are in the family?
    For each pet, enter the following information:

    Pet 1 Name Pet 2 Name
    Pet 1 Age Pet 2 Age

    Pet 1 Kind/Type Pet 2 Kind/Type

    Pet 3 Name Pet 4 Name
    Pet 3 Age Pet 4 Age

    Pet 3 Kind/Type Pet 4 Kind/Type
    Pet 5 Name Pet 6 Name

    Pet 5 Age Pet 6 Age
    Pet 5 Kind/Type Pet 6 Kind/Type

    Family Budget Sheet

    Current Assets Current Debt
    Home value Credit Debt mortgages
    Other Real Estate auto loans

    Total Real Estate Assets $- credit cards
    other

    Automobile Values Total Credit Debt $-

    Total Auto Assets $-

    Savings
    Liquid
    Pension/Retirement

    Total Savings $-

    Annual Incomes Before Taxes
    Adult 1
    Adult 2
    Adult 3 or child support

    Total Annual Income Before Taxes $-

    Monthly Incomes Before Taxes
    $- Adult 1
    $- Adult 2
    $- Adult 3 or child support

    Total Monthly Income Before Taxes $-

    Monthly Income After Taxes

    mortgages
    auto loans
    credit cards
    other

    Adult 1
    Adult 2
    Adult 3
    Government assistance

    Total Spendable Monthly Income $-

    Monthly Expenses
    Insurances
    Health/Medical
    Life
    Home/Rental
    Automobile
    Health insurance deductible
    Other:
    Other:

    Total Insurances $-

    Soft Goods
    Food
    Hygiene
    Clothing
    Small incidentals
    Other

    Total Soft Goods $-

    Home Expenses
    Mortgage/Rent
    Up-keep
    Taxes
    Electricity
    Gas
    Telephone
    Cell phone

    Garbage/Water/Sewer
    Lawn Care
    Cleaning Services
    Fees-home owner dues
    Cable
    Internet
    Other:
    Other:
    Total Home Expenses $-

    Entertainment Expenses
    Dining Out
    Movies/Theater
    Club memberships
    Travel
    Sporting Events
    Other:
    Other:
    Total Entertainment $-

    Automobile Expenses
    Vehicle 1 payment
    Vehicle 2 payment
    Vehicle 3 payment
    Maintenance & Repairs
    Gasoline
    Tax/license fees
    Total Automobile Expenses $-

    Miscellaneous Expenses:
    Credit card & Short term loans
    Other
    Education (books and tuition)
    Veterinarian

    Beauty expenses
    Gifts
    Contributions
    Pets
    Other:
    Other:
    Total Miscellaneous $-

    Total Anticipated Expenses $-

    Flex $-
    Monthly Savings Contributions
    Liquid
    Retirement
    Other:
    Other:
    Other:
    Total Savings per Month $-

    Unallocated Money $-

    .

    Reflection Questions

    Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
    Question 1: What is your strategy for saving?
    Enter Answer Here

    Question 2: If you had to make changes, looking at your budget, where could you make them?
    Enter Answer Here

    Question 3: How would you handle a large, unexpected expense?
    Enter Answer Here

    Question 4: If a friend or family member was struggling financially and not using a budget, based
    on what you've learned in the course, what techniques and/or strategies would you suggest?
    Enter Answer Here

    References
    Item Supported
    Adult #1 Salary (example line)

    Reference
    Med Tech Salary.com

    DO NOT USE OR EDIT THIS SHEET
    Family Roles Family Members
    Type your Own Type your Own
    Mother (divorced from Father and remarried) 0
    Father 0
    Father (divorced from Mother and remarried) 0
    Mother (divorced from Father and remarried) 0
    Wife's Mother 0
    Wife's Father 0
    Husband's Mother 0
    Husband's Father 0
    Husband 0
    Wife 0
    Partner
    Son
    Daughter

    Note to Developer, see Instructor Only Section for Workbook password if edits are needed.

    Additional Incomes Type of Home
    Type your own Type your Own
    Alimony Apartment
    Child Support Condo
    Social Security Mobile Home
    Stocks/Bonds Travel Travel
    Real Estate/Rentals Homeless/Shelter
    2nd Job

    **## WEEK7CHFD360BUDGETPLANNING.docx**

    | | |
    | — | — |
    | Hide Assignment Information |
    | Instructions | |
    | **Assignment 3: Budget Planning**<br>This week you read about the importance of a budget when managing family resources. Now it's time to create your own budget!<br>**Related Course Objectives:** [**CO1, CO5**](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1399197&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Directions**<br>For this assignment complete the following steps using the interactive Excel worksheet that is attached. It is VERY important for you to look at the bottom of the spread sheet and starting with the Directions tab, click on each tab (1-4): <br>1. Access the <br>**Family Details** sheet of the workbook and fill in the required information. You may use your own family as an example or create one. <br> <br>· Provide the family name, jobs, income, etc. <br>2. Access the <br>**Budget** Sheet of the workbook and enter the requested financial details. <br> <br>· Use the information from your Family Details sheet where requested.<br>· Fill in the remaining blanks on the form based on your own information or you may make up a family.<br>· You may provide your own salary or research the average salary for whatever profession you choose. Here is an example: <br>_According to salary.com: "The average Medical Laboratory Technician salary in Georgia is $48,223 as of September 01, 2018, but the range typically falls between $43,180 and $52,955."_<br>· If I was making up a family, I would use the average salary of $48,223 for my worksheet. <br>· Enter your references for each source (all of your sources – utilities, insurance, etc.) on the <br>**Research links** sheet of the worksheet.<br> <br>3. Access the <br>**Reflection Questions** sheet of the workbook and answer the questions in the space provided. Make sure to support your answers with facts from the textbook.<br> <br>**Submission Guidelines**<br>· Download the attached interactive budgeting sheet and save it to your computer. <br>· Complete the interactive budget sheet and save your entries.<br>· Upload your completed interactive budget sheet as an attachment for this assignment. |

    Week 7: Assignment 3 Budget Planning

    Top of Form

    Bottom of Form

    **## interactive_budgeting_sheet6.xlsx_safe.pdf**

    Assignment 3: Budget Planning Case Study
    Using this Workbook

    This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
    and Research Links.
    To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
    To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
    tab key and the arrow keys on your keyboard to easily move between cells.

    Directions

    Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
    example or create one. Be prepared with the family name, jobs, income, etc.
    Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
    Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
    would be based on your research. Enter your references on the Research links sheet of the workbook.
    Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.

    Family Details
    Where does the family live?

    Type of home

    How many adults are in the family?
    For each adult, enter the following information

    Adult 1 Name Adult 2 Name
    Adult 1 Role Mother Adult 2 Role

    Adult 1 Career Adult 2 Career
    Adult 1 Age Adult 2 Age

    Adult 3 Name Adult 4 Name
    Adult 3 Role Adult 4 Role

    Adult 3 Career Adult 4 Career
    Adult 3 Age Adult 4 Age

    How many childern are in the family?
    For each child, enter the following information:

    Child 1 Name Child 2 Name
    Child 1 Age Child 2 Age

    Child 1 Activities Child 2 Activities
    Child 3 Name Child 4 Name

    Child 3 Age Child 4 Age
    Child 3 Activities Child 4 Activities

    Child 5 Name Child 6 Name
    Child 5 Age Child 6 Age

    Child 5 Activities Child 6 Activities

    How many, if any, additional forms of
    income are there?

    Identify the family member and what it's for
    Additional Income 1 Additional Income 2

    Associated Family Member Associated Family Member
    Additional Income 3 Additional Income 4

    Associated Family Member Associated Family Member

    Items that require fixed monthly payments
    List all of the items that have recurring payments

    Item 1 Item 6
    Item 2 Item 7
    Item 3 Item 8
    Item 4 Item 9
    Item 5 Item 10

    How many pets are in the family?
    For each pet, enter the following information:

    Pet 1 Name Pet 2 Name
    Pet 1 Age Pet 2 Age

    Pet 1 Kind/Type Pet 2 Kind/Type

    Pet 3 Name Pet 4 Name
    Pet 3 Age Pet 4 Age

    Pet 3 Kind/Type Pet 4 Kind/Type
    Pet 5 Name Pet 6 Name

    Pet 5 Age Pet 6 Age
    Pet 5 Kind/Type Pet 6 Kind/Type

    Family Budget Sheet

    Current Assets Current Debt
    Home value Credit Debt mortgages
    Other Real Estate auto loans

    Total Real Estate Assets $- credit cards
    other

    Automobile Values Total Credit Debt $-

    Total Auto Assets $-

    Savings
    Liquid
    Pension/Retirement

    Total Savings $-

    Annual Incomes Before Taxes
    Adult 1
    Adult 2
    Adult 3 or child support

    Total Annual Income Before Taxes $-

    Monthly Incomes Before Taxes
    $- Adult 1
    $- Adult 2
    $- Adult 3 or child support

    Total Monthly Income Before Taxes $-

    Monthly Income After Taxes

    mortgages
    auto loans
    credit cards
    other

    Adult 1
    Adult 2
    Adult 3
    Government assistance

    Total Spendable Monthly Income $-

    Monthly Expenses
    Insurances
    Health/Medical
    Life
    Home/Rental
    Automobile
    Health insurance deductible
    Other:
    Other:

    Total Insurances $-

    Soft Goods
    Food
    Hygiene
    Clothing
    Small incidentals
    Other

    Total Soft Goods $-

    Home Expenses
    Mortgage/Rent
    Up-keep
    Taxes
    Electricity
    Gas
    Telephone
    Cell phone

    Garbage/Water/Sewer
    Lawn Care
    Cleaning Services
    Fees-home owner dues
    Cable
    Internet
    Other:
    Other:
    Total Home Expenses $-

    Entertainment Expenses
    Dining Out
    Movies/Theater
    Club memberships
    Travel
    Sporting Events
    Other:
    Other:
    Total Entertainment $-

    Automobile Expenses
    Vehicle 1 payment
    Vehicle 2 payment
    Vehicle 3 payment
    Maintenance & Repairs
    Gasoline
    Tax/license fees
    Total Automobile Expenses $-

    Miscellaneous Expenses:
    Credit card & Short term loans
    Other
    Education (books and tuition)
    Veterinarian

    Beauty expenses
    Gifts
    Contributions
    Pets
    Other:
    Other:
    Total Miscellaneous $-

    Total Anticipated Expenses $-

    Flex $-
    Monthly Savings Contributions
    Liquid
    Retirement
    Other:
    Other:
    Other:
    Total Savings per Month $-

    Unallocated Money $-

    .

    Reflection Questions

    Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
    Question 1: What is your strategy for saving?
    Enter Answer Here

    Question 2: If you had to make changes, looking at your budget, where could you make them?
    Enter Answer Here

    Question 3: How would you handle a large, unexpected expense?
    Enter Answer Here

    Question 4: If a friend or family member was struggling financially and not using a budget, based
    on what you've learned in the course, what techniques and/or strategies would you suggest?
    Enter Answer Here

    References
    Item Supported
    Adult #1 Salary (example line)

    Reference
    Med Tech Salary.com

    DO NOT USE OR EDIT THIS SHEET
    Family Roles Family Members
    Type your Own Type your Own
    Mother (divorced from Father and remarried) 0
    Father 0
    Father (divorced from Mother and remarried) 0
    Mother (divorced from Father and remarried) 0
    Wife's Mother 0
    Wife's Father 0
    Husband's Mother 0
    Husband's Father 0
    Husband 0
    Wife 0
    Partner
    Son
    Daughter

    Note to Developer, see Instructor Only Section for Workbook password if edits are needed.

    Additional Incomes Type of Home
    Type your own Type your Own
    Alimony Apartment
    Child Support Condo
    Social Security Mobile Home
    Stocks/Bonds Travel Travel
    Real Estate/Rentals Homeless/Shelter
    2nd Job