4. Do a Stacked bar chart for expense items by month.

5. Be creative and construct a Chart that you think would best show the data about Frangold Real Estate to its owners.

N Revenue Commission Rentals Commission Real Estate Interest Total revenue lanuary February March April 120005 12.000 14,000 $ s 48.000 32.000 S 40,000 IS 100 100 100 $ 50,100 $ 44,100 $ 54,100 |May 14,000 52,000 $ 100 66,100 $ M Frangold Real Estate Budget Monthly estimates June July August September October November December Total 16,000 $ 18,500 20,000 18,500 18,500 14,000 $ 14,000 $ 16,500 5 72,000 $ 82,000 $ 92,000 $ 125.000 96,000$ 41,000 $ 32,000 $ 12,500 $ 100 100 100 100 100 100 100 100S 88,100 S 100,600S 112,100 $ 143,600 $ 114,600 S 55,100 $ 46,100 $ 29,100 $ 188,000 724 500 1200 913,700 62,975 25,300 15,950 Expenses Rent Sales Commissions Utilities Advertising Website Printing Office supplies Gas Misc. Total Expenses January February March s 4 500$ 4,500 $ 33.000 24.200 325 325 400 750 325 325 200 200 725 625 100 100 250 250 $ 39,825 31,275S April 4.500 $ 29,700 325 1,850 325 200 855 100 250 38 1055 May 4,500 $ 36,300 325 2,800 325 200 925 100 250 45,725 $ June 4,500 $ 48,400 325 4,500 500 200 1,250 100 250 60.025 s July 4,500 $ 55.275 375 5.600 500 200 1,850 100 250 68,600 $ August 4,500 $ 61,600 325 7,000 500 200 2.250 100 250 76,725 s September October November December Total 4,500 4,500 $ 4,500 $ 4,500 $ 4,500 $ 78.925 30,250 325 325 375 325 325 8,200 3.500 1,500 750 3,500 500 500 500 500 500 200 200 200 200 200 3,250 2.100 1,950 350 3,500 100 100 100 100 100 250 250 250 250 250 96,250 74,450 $ 39,575$ 32,7755 54,000 501,875 3,900 40,350 5,300 2,400 20.130 1,200 3,000 632.155 28,825 Net Income 5 20,275 12,825 15,995 20,375 28,075 $ 32,000 $ 35,375S 47,350 $ 40,150 $ 15,525 $ 13 325$ 275 281,545