(Use an Excel spreadsheet) create a household budget showing 2 columns: Monthly Budget and an Annualized Budget. Create a fictitious profile and be sure it has appropriate formatting utilized within excel, utilization of formulas when appropriate, does budget category/line items make sense, and were all items that tend to impact a budget for an average household accounted for.
***Please show the FORMULAS and where to put them on EXCEL and steps.***
*****your model should contain formulas in relevant places on EXCEL****.
Personal and Family Expenses | ||
Category | Monthly Budget | |
Current | Yearly | |
Alimony | $ 576 | $ 6,914.75 |
Bank Charges | $ 10 | $ 120.00 |
Books/Magazines | $ 20 | $ 240.00 |
Business Expense | $ 1,152 | $ 13,829.50 |
Care of Parent/Other | $ 934 | $ 11,207.60 |
Cash — Miscellaneous | $ 1,200 | $ 14,400.00 |
Cell Phone | $ 15 | $ 180.00 |
Charitable Donations | $ 100 | $ 1,200.00 |
Child Activities | $ 150 | $ 1,800.00 |
Child Allowance/Expense | $ 200 | $ 2,400.00 |
Child Care | $ 150 | $ 1,800.00 |
Child Support | $ 100 | $ 1,200.00 |
Child school help | $ 450 | $ 5,400.00 |
Clothing — Client | $ 50 | $ 600.00 |
Clothing — Co-Client | $ 55 | $ 660.00 |
Clothing — Children | $ 50 | $ 600.00 |
Club Dues | $ 100 | $ 1,200.00 |
Credit Card Debt | $ 1,500 | $ 18,000.00 |
Dining | $ 600 | $ 7,200.00 |
Entertainment | $ 200 | $ 2,400.00 |
Gifts | $ 50 | $ 600.00 |
Groceries | $ 250 | $ 3,000.00 |
Health Care - Dental | $ 10 | $ 120.00 |
Health Care - Medical | $ 50 | $ 600.00 |
Health Care - Prescription | $ 50 | $ 600.00 |
Hobbies | $ 100 | $ 1,200.00 |
Household Items | $ 600 | $ 7,200.00 |
Laundry/Dry Cleaning | $ 100 | $ 1,200.00 |
Personal Care | $ 100 | $ 1,200.00 |
Personal Loan Payment | $ 150 | $ 1,800.00 |
Pet Care | $ - | $ - |
Public Transportation | $ 25 | $ 300.00 |
Recreation | $ 200 | $ 2,400.00 |
Self Improvement | $ 50 | $ 600.00 |
Student Loan | $ 600 | $ 7,200.00 |
Vacation/Travel | $ 1,000 | $ 12,000.00 |
Other: | $ 577 | $ 6,924.00 |
$ 11,525 | $ 138,295.00 |
Personal and Family Expenses | ||
Category | Monthly Budget | |
Current | Yearly | |
Alimony | =+B41*0.05 | =+B4*12 |
Bank Charges | 10 | =+B5*12 |
Books/Magazines | 20 | =+B6*12 |
Business Expense | =+B41*0.1 | =+B7*12 |
Care of Parent/Other | =+B41*0.08+12 | =+B8*12 |
Cash — Miscellaneous | 1200 | =+B9*12 |
Cell Phone | 15 | =+B10*12 |
Charitable Donations | 100 | =+B11*12 |
Child Activities | 150 | =+B12*12 |
Child Allowance/Expense | 200 | =+B13*12 |
Child Care | 150 | =+B14*12 |
Child Support | 100 | =+B15*12 |
Child school help | 450 | =+B16*12 |
Clothing — Client | 50 | =+B17*12 |
Clothing — Co-Client | 55 | =+B18*12 |
Clothing — Children | 50 | =+B19*12 |
Club Dues | 100 | =+B20*12 |
Credit Card Debt | 1500 | =+B21*12 |
Dining | 600 | =+B22*12 |
Entertainment | 200 | =+B23*12 |
Gifts | 50 | =+B24*12 |
Groceries | 250 | =+B25*12 |
Health Care - Dental | 10 | =+B26*12 |
Health Care - Medical | 50 | =+B27*12 |
Health Care - Prescription | 50 | =+B28*12 |
Hobbies | 100 | =+B29*12 |
Household Items | 600 | =+B30*12 |
Laundry/Dry Cleaning | 100 | =+B31*12 |
Personal Care | 100 | =+B32*12 |
Personal Loan Payment | 150 | =+B33*12 |
Pet Care | 0 | =+B34*12 |
Public Transportation | 25 | =+B35*12 |
Recreation | 200 | =+B36*12 |
Self Improvement | 50 | =+B37*12 |
Student Loan | 600 | =+B38*12 |
Vacation/Travel | 1000 | =+B39*12 |
Other: | 577 | =+B40*12 |
=(76035+62260)/12 | =+B41*12 |
(Use an Excel spreadsheet) create a household budget showing 2 columns: Monthly Budget and an Annualized...
Create a budget Spreadsheet Create a spreadsheet called Budget. using Excel (Office) or Calc (Open Office) In this spreadsheet file, list 5 budget items with their -budget amount -actual amount -difference Create a pie chart that illustrates how much of your money is spent on various items. Notes: -Headings (Row 1 and Column A) must be bold -All numbers must be formatted as currency -Totals (Row 7 and Column D) must be formulas, not actual numbers -Percentage amounts (not actual...
Create an excel worksheet and populate it, in columns, with values of X that are -2, -1, 0, 1, 2 and values of Y that are -1, 1,1,1,3. As an aside, note that the sample mean of X is 0. Create the columns shown below, and enter the proper formulas into excel. (X minus (X minus mean) Mean) times (Y Y Y-mean X X-mean squared minus mean) Y-hat u-hat -1 -2 1 -1 1 0 1 1 3 2 sum...
Excel Budget Assignment THE BOB STORY.. Using the Excel Budget Spreadsheet as a guide, fill in the values below for each respective category. Answer the questions following each scenario in the "Excel Budget Assignment quiz. Bob has trouble managing Bob Meets Smart Sally They fall in love and get mad budget for them as the wedding gift Income: Bob earns a monthly net income of $160.00 for finding earthworms. Smart Sally earns a monthly net income of $6245.00 as a...
4: Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this period”, and “Total”. As depicted below. A B D E 1 2 Timestep in years Rate <enter timestep> <enter your rate> 3 4 5 6 Count 0 Date 30-Sep-16 Interest this period Total $ <enter your total> 7 8 1 9 10 You will begin with the count at 0, and the date of Sept 30, 2016. For that first row, the “Interest this period” is...
Assignment 1 Create a monthly budget using Excel. Each of the rows should represent days in the month: 1st, 2nd, 3rd, etc. with the last row titled “Total.” Each of the columns should represent areas in which you spend money: groceries, restaurants, utilities, entertainment, school/work, car, shopping, misc., etc. At the bottom of each column on the Total row, use a SUM formula to add all of the rows for the whole month so that you can track your spending...
In excel please show formula of how you got the answer and equation. You have the responsibility for making a report to help the company administrators to implement new employee's career plan, providing data to the investment/budget committee. So, you are managing the employee's payroll data from the new division of Data Research, created two years ago to provide the company departments (Marketing, Sales and Operations) with collection/analyze/update/report of real time market information, by making the calculation of their pay...
Use the case study description and list of requirements below to create an entity-relationship diagram showing the data requirements of the All You Need Are Toys Library database. Your ERD should be able to be implemented in a relational DBMS. Toy libraries operate in a manner similar to book libraries, with members able to borrow a toy for a number of weeks then return it. As with book libraries, toy libraries enable families to have access to a wider range...
LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL’s operations necessary for their master budget: •Sales Information: oActual / Projected Sales are as follows: ♣December (Prior Year; Actual): $75,000 ♣January (Estimated): $85,000 ♣February (Estimated): $91,000 ♣March (Estimated): $96,000 ♣April (Estimated): $112,000 ♣May (Estimated): $120,000 oUnits are sold at $11 each oSales in a month are paid in cash for 40% and on credit for the remainder with credit...
1. Use 2019 actual data to complete the 2019 Actual column incorporated with the budget and variance analysis tab. 2. Complete the 2020 Flexible Budget column incorporated with the budget and variance analysis tab. The flexible budget includes several changes to the data. The changes are listed in the Excel file / Instructions Tab. 3. Compute variances. 4. Explain the variances. 5. Compute the break even in units and dollars. 6. Compute the margin of safety. Calculate the variance for...
A company has received an order to manufacture 75 customized units of an entertainment cabinet. The company is being offered $960 per cabinet and the CEO must decide whether or not to accept the order. An analysis of the production process for the cabinet reveals that a new, special-purpose lathe will be required. The estimated cost of the lathe is $14,400, although there is some uncertainty due to new tariffs. The variable cost is more difficult to estimate because the...