0% found this document useful (0 votes)
9 views8 pages

Employment Status and Budget Overview

The document includes an employment status chart detailing employee and supervisor counts across various states, totaling 121,095. It also outlines today's orders with customer IDs, item SKUs, quantities, and unit prices. Additionally, it presents a monthly family budget comparing projected and actual costs across various categories, highlighting a total difference of $(4,293.82).

Uploaded by

leepie.95er
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
9 views8 pages

Employment Status and Budget Overview

The document includes an employment status chart detailing employee and supervisor counts across various states, totaling 121,095. It also outlines today's orders with customer IDs, item SKUs, quantities, and unit prices. Additionally, it presents a monthly family budget comparing projected and actual costs across various categories, highlighting a total difference of $(4,293.82).

Uploaded by

leepie.95er
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Employment Status Chart

2000000

1800000

1600000

1400000

1200000

1000000

800000

600000

400000

200000

0
1 2 3 4 5 6 7 8

1985 1990 1992 1993 1994 1995 1996 1997


1998 1999 2000 2001 2002 2003 2008
7 8

1997
First & Last Name - all -

Sum of ID Status
Office Employee Supervisor Total Result
Arizona 15006 5001 20007
Illinois 14005 7001 21006
Maine 18009 6001 24010
New York 20020 4001 24021
Utah 12014 3001 15015
Virginia 10020 2001 12021
Washington 4014 1001 5015
Total Result 93088 28007 121095
Today's Orders
CustomerID ItemSKU Quantity UnitPrice Backorders
8725801 12345 100 10.5
8825268 23456 22 2.5
8048929 58910 93 17.5
8032245 11121 21 22.5
8147770 31415 12 17.5
8836323 16171 16 20
8286399 81920 40 8.75
8243640 21222 21 21.89
8200881 32425 1 2.0
8158122 26272 6 89.0
8115363 82930 4 50.0
8072604 31323 33 38.3
8029845 33435 0 50.8
7987086 36373 10 54.7
7944327 83940 0 58.7
7901567 41424 21 62.7
7858808 34445 26 66.6
7816049 46474 0 70.6
7773290 84950 37 74.5
7730531 51525 0 78.5
0
Monthly Family Budget
Total Projected Cost Total Actual Cost Total Difference
$ 8,731.00 $ 4,437.18 $ (4,293.82)

Housing Projected Cost Actual Cost Difference


Mortgage $ 1,000.00 $ 1,250.00 $ 250.00
Student Housing Rent $ 750.00 $ 550.00 $ (200.00)
Phone $ 62.00 $ 100.00 $ 38.00
Electricity $ 4.00 $ 125.00 $ 121.00
Gas $ 22.00 $ 35.00 $ 13.00
Water and sewer $ 8.00 $ 8.00 $ -
Cable $ 34.00 $ 39.00 $ 5.00
Waste removal $ 10.00 $ 10.00 $ -
Maintenance or repair $ 23.00 $ 45.00 $ 22.00
Supplies $ 100.00 $ 50.00 $ (50.00)
Other $ 150.00 $ 25.00 $ (125.00)
Total $ 2,163.00 $ 2,237.00 $ 74.00

Transportation Projected Cost Actual Cost Difference


Vehicle 1 payment $ 250.00 $ 256.58 $ 6.58
Vehicle 2 payment $ 400.00 $ 406.85 $ 6.85
Bus fare $ 25.00 $ - $ (25.00)
Insurance $ 96.00 $ 85.75 $ (10.25)
Licensing $ 50.00 $ 75.00 $ 25.00
Fuel $ 100.00 $ 250.00 $ 150.00
Maintenance $ 250.00 $ - $ (250.00)
Other $ 100.00 $ - $ (100.00)
Total $ 1,271.00 $ 1,074.18 $ (196.82)

Loans Projected Cost Actual Cost Difference


Personal $ 2,500.00 $ - $ (2,500.00)
Student $ - $ - $ -
Credit Card 1 $ 750.00 $ 500.00 $ (250.00)
Credit Card 2 $ 500.00 $ - $ (500.00)
Credit Card 3 $ 1,200.00 $ - $ (1,200.00)
Other $ - $ - $ -
Total $ 4,950.00 $ 500.00 $ (4,450.00)

Entertainment Projected Cost Actual Cost Difference


Netflix $ 9.00 $ 9.25 $ 0.25
Fast Food $ 125.00 $ 186.25 $ 61.25
Movies $ 32.00 $ 64.00 $ 32.00
Date Night $ 56.00 $ 75.00 $ 19.00
Online Entertainment $ 25.00 $ 36.50 $ 11.50
Other $ 100.00 $ 255.00 $ 155.00
Total $ 347.00 $ 626.00 $ 279.00
Budget
Projected Monthly Income
Income 1 $ 3,600.00
Income 2 $ 2,200.00
Extra Income $ 500.00
Total Monthly Income $ 6,300.00

Actual Monthly Income


Income 1 $ 3,800.00
Income 2 $ 1,850.00
Extra income $ 360.00
Total Monthly income $ 6,010.00

Projected Income $ 6,300.00


Actual Income $ 6,010.00
Difference $ (290.00)

Future Income
Wanting to Make $ 7,500.00

You might also like