Need this answered on excel with proper format and title.

Thanks

mp/63592918/mod_resource/content/1/ACCT3320 Assignment.pdf Q2) FLEXIBLE BUDGET 1 Perfect Parties, Inc. has several divisions. One division provides birthday parties at their facility. 2 Each party sold provides entertainment, decorations, food, and party favors for 10 children, 3 The bookkeeper has prepared a report comparing actual results for the month of June to budgeted results. 4 5 Perfect Parties 6 Birthday Party Division Analysis of Revenues and Costs 7 For the Month Ended June 30 8 9 Planning Budget Actual Results Variances 10 11 Number of parties 80 92 12 13 Revenue $ 36.000 $ 39,560 $ 3,560 F 14 Expenses 15 15 Food costs 7,200 8,648 1,448 U 16 Party supplies 3,200 3,404 204 U 17 17 Party worker wages 6,400 7,728 1,328 U 18 Administrative salaries 3,700 3.500 200 F 19 Equipment depreciation 1,200 1,200 None 20 Rent 5,000 5,000 None 26,700 2,780 U 22 Net operating income $ 9,300 $ 10,080 S 780F 23 Food costs, party supplies and party worker wages are variable costs. 24 Administrative salaries, equipment depreciation and rent are fixed costs. 25 26 Prepare a new report for June using the flexible budget approach (Indicate each variance as "F" for favourable or "U" for unfavourable) 21 Total expense 29,480 O R 3 RA 15 f6 17 18 19 f10 112 X O A X