1. Construct a Pie Chart for the expenses for the total year

2. Construct a Horizonal bar chart by month for Commission income items.

3. Construct a Vertical bar chart by month showing Total Income, Total Expenses, and Net Income.

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

B D E F G H L M N 1 Frangold Real Estate Budget 2 Monthly estimates 3 Revenue January February March April May June July August September October November December Total 4 Commission Rentals $ 12,000 $ 12,000 $ 14,000 $ 14,000 $ 16,000 $ 18,500 $ 20,000 $ 18,500 $ 18,500 $ 14,000 $ 14,000 $ 16,500 $ 188,000 5 Commission Real Estate $ 48,000 $ 32,000 $ 40,000 $ 52,000 $ 72,000 $ 82,000 $ 92,000 $ 125,000 $ 96,000 $ 41,000 $ 32,000 $ 12,500 $ 724,500 6 Interest 100 100 100 100 100 100 100 100 100 100 100 100 $ 1,200 7 Total revenue $ 60,100 $ 44,100 $ 54,100 $ 66,100 $ 88,100 $ 100,600 $ 112,100 $ 143,600 $ 114,600 $ 55,100 $ 46,100 $ 29,100 $ 913,700 8 9 Expenses January February March April May June July August September October November December Total 10 Rent $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 4,500 $ 54,000 11 Sales Commissions 33,000 24,200 29,700 36,300 48,400 55,275 61,600 78,925 62,975 30,250 25,300 15,950 501,875 12 Utilities 325 325 325 325 325 325 325 325 325 325 325 325 3,900 13 Advertising 400 750 1,850 2,800 4,500 5,600 7,000 8,200 3,500 1,500 750 3,500 40,350 14 Website 325 325 325 325 500 500 500 500 500 500 500 500 5,300 15 Printing 200 200 200 200 200 200 200 200 200 200 200 200 2,400 16 Office supplies 725 625 855 925 1,250 1,850 2,250 3,250 2,100 1,950 850 3,500 20,130 17 Gas 100 100 100 100 100 100 100 100 100 100 100 100 1,200 18 Misc. 250 250 250 250 250 250 250 250 250 250 250 250 3,000 19 Total Expenses $ 39,825 $ 31,275 $ 38,105 $ 45,725 $ 60,025 $ 68,600 $ 76,725 $ 96,250 $ 74,450 $ 39,575 $ 32,775 $ 28,825 $ 632,155 20 21 Net Income $ 20,275 $ 12,825 $ 15,995 $ 20,375 $ 28,075 $ 32,000 $ 35,375 $ 47,350 $ 40,150 $ 15,525 $ 13,325 $ 275 $ 281,545 22