Question: please provide excel formula for each highlighted box, i really need this A C D E G H 1 Perfect Parties, Inc. has several divisions.


A C D E G H 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 Perfect Parties Birthday Party Division Analysis of Revenues and costs For the Month Ended June 30 Planning 9 Budget Actual Results Variances 10 11 Number of parties 92 12 13 Revenue 36,000 $ 39,560 S 14 Expenses: 15 Food costs 7,200 8,648 16 3,200 3,404 Party supplies Party worker wages 17 6,400 7,728 18 Administrative salaries 3,700 3,500 19 Equipment depreciation 1,200 1,200 20 Rent 5,000 5,000 21 Total expense 26,700 29,480 S 9,300 5 10,080 5 22 Net operating income 23 Food costs, party supplies and party worker wages are variable costs. 24 Administrative salaries, equipment depreciation and rent are fixed costs. 75 S 9 3,560 F 1,448 U 204 U 1,928 U 200 F 2,780 U 780 F None None th S 649 7 C D E G Perfect Parties Birthday Party Division Analysis of Revenues and Costs For the Month Ended June 30 Planning Budget Actual Results 80 92 36,000 $ 7,200 3,200 6,400 3,700 1,200 5,000 26,700 9 10 11 Number of parties 12 13 Revenue 39,560 14 Expenses: 15 Food costs 8,648 16 Party supplies 3,404 17 Party worker wages 7,728 18 Administrative salaries 3,500 19 Equipment depreciation 1,200 20 Rent 5,000 21 Total expense 29,480 22 Net operating income S 9,300 $ 10,080 S 23 Food costs, party supplies and party worker wages are variable costs. 24 Administrative salaries, equipment depreciation and rent are fixed costs. 25 5 H Variances S 3,560 F 1,448 U 204 U 1,328 U 200 F - None - None 2,780 U 780 F K A G 25 26 Prepare a new report for June using the flexible budget approach. 27 Enter all variances as positive amounts. If there is a variance, write an IF statements to indicate if it is For U (using capital letters). 28 if there is no variance, enter the word None. 29 Perfect Parties 30 Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 31 32 33 Planning Budget Flexible Budget Revenue and Spending Variances Actual Results Activity Variances 34 Number of parties 80 35 36 Revenues S 35,000 $ 39,560 37 Expenses: 38 Food costs 7,200 8,648 39 Party supplies 3,200 3,404 40 Party worker wages 6,400 7,728 41 Administrative salaries 3,700 3,500 42 Equipment depreciation 1,200 1,200 43 Rent 5,000 5,000 44 Total expense 26,700 29,450 45 Net operating income 9.300 10.080 46 H S 92 S 92
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
