please answer step by step using excel formula ( or type out how it comes out, like revenues)

A The undlocated income whimon! of MOU Inn is blow Assume he squirt book of he noma department buk 50,000 while he squats booby of he food dip mel buk 10,000 thing squint booup and he 5484, propane a fully allocated income subimer! Food Toud 70 000 307100 12,100 16,000 10,000 Char Dinal Equrian 6,100 4,000 11 12 13 14 15 16 17 18 4,100 19 2,000 20 2,000 21 22 23 24 Fixid Changing 25 26 3,100 27 Property Taxin 2,100 10,100 29 Toud Fixed Chapin 30 3:1 Fcome Before Income Titoin 32 Income Titoin 6,100 33 34 35 36 37 38 ANSWER Coul allocation Rooma diparmer! (amain formula using numbun] 40 Food doparimarl = formula] (arain formula using numbersj 41 42 43 Food Toud 44 30000 100000 45 Cou of Salin 12000 12000 46 Payell and blabid Equiin 16000 10000 26000 47 600O 4000 10000 48 49 22000 26000 48000 51 Dopar moral income 48000 4000 52000 5.2 53 54 Admirlumin & Garand formula) (ormula] formula] (formula] 4000 56 Properly Opinion and Mirbro (formula) (formula) 20100 57 Uility Cook Formula] (formula) 2000 (formula] 36000 60 61 Fixad Charging 62 Mermula] 6000 63 formula) 3000 64 Properly Tazoin Mermula] (formula) 2000 65 formula] 10000 66 Toud Froid Changin (formula] 21000 67 income Before Income Titoin (formula] 15000 64 6000 70 31