Question: Construct a Chart that would best show the data about Frangold Real Estate to its owners. B D E F G H L M N

 Construct a Chart that would best show the data about Frangold

Construct a Chart that would best show the data about Frangold Real Estate to its owners.

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!