please do it in 40 minutes please urgently... I'll give you up thumb definitely

32. Prepare flexible budgets for Hope & Hagen Real Estate to show pessimistic, most likely and optimistic scenarios with the following information. The Sales Commission Rate to be used is 2.75%. INCOME Sales Pessimistic Most Likely Optimistic Property Management Pessimistic Most Likely Optimistic EXPENSES Sales Staff Wages Sales Staff Commission Office Staff Wages Depreciation on Equipment Insurance and Licenses Rent Motor Vehicle Expenses Electricity Telephone Advertising for Office Advertising on Properties Total Sales Value Of Property $12 000 000 $15 000 000 $20 000 000 Total Management Fees $ 120 000 $ 140 000 $ 160 000 Are consistent through all scenarios $ 150 000 25% of Sales $ 90 000 $ 5 500 $ 13 000 $ 16 000 $ 12 500 $ 4 500 $ 12 500 $ 18 000 1% of Sales Price