Question: Please put the excel equations F G H B C D E 1 Perfect Parties, Inc. has several divisions. One division provides birthday parties at

F G H B C D E 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 9 Planning Budget Actual Results Variances 80 92 $ 36,000 $ 39,560 $ 3,560 F 10 11 Number of parties 12 13 Revenue 14 Expenses: 15 Food costs 16 Party supplies 17 Party worker wages 18 Administrative salaries 19 Equipment depreciation 20 Rent 21 Total expense 22 Net operating income 7,200 3,200 6,400 3,700 1,200 5,000 26,700 9.300 $ 8,648 3,404 7,728 3,500 1,200 5,000 29,480 10,080 1,448 U 204 U 1,328 U 200 F None None 2,780 U 780 F $ $ Actual Results 92 28 if there is no variance, enter the word None. 29 Perfect Parties 30 Birthday Party Division Flexible Budget Performance Report 31 For the Month Ended June 30 32 Planning Flexible 33 Revenue and Budget Activity Variances Budget Spending Variances 34 Number of parties BO 92 35 36 Revenues 36,000 37 Expenses: 38 Food costs 7.200 39 Party supplies 3,200 40 Party worker wages 6,400 41 Administrative salaries 3,700 42 Equipment depreciation 1,200 43 Rent 5.000 44 Total expense 26,700 45 Net operating income 9.300 14
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
