Question: please include cell references thanks! G H 4 in NO A B E F G 2 Perfect Parties, Inc. has several divisions. One division provides

G H 4 in NO A B E F G 2 Perfect Parties, Inc. has several divisions. One division provides birthday parties at their facility. 3 Each party sold provides entertainment, decorations, food, and party favors for 10 children. The bookkeeper has prepared a report comparing actual results for the month of June to budgeted results. 5 6 Perfect Parties Birthday Party Division Analysis of Revenues and Costs 8 For the Month Ended June 30 Planning Actual 9 Budget Results Variances 10 Number of parties 80 92 11 Revenue $36,000 $39,560 $3,560 F 12 Expenses: 13 Food costs 7,2005 8,648 1,448 V 14 Party supplies 3,200 3,404 204 U 15 Party worker wages 6,400 7,728 1,328 U 16 Administrative salaries 3,700 3,500 200 F 17 Equipment depreciation 1,200 1,200 0 None 18 Rent 5,000 5,000 0 None 19 Total expense 26,700 29,480 2,780 U 20 Net operating income $9,300 $10,080 $780 F 21 Food costs, party supplies, and party worker wages are variable costs. 22 Administrative salaries, equipment depreciation, and rent are fixed costs. 23 24 Required: 25 Prepare a new report for June using the flexible budget approach. 26 27 Enter all variances as positive amounts. Leave no cells blank. 28 (Use cells B10 to E20 from the given information to complete this question.) 29 30 Perfect Parties 31 Birthday Party Division Flexible Budget Performance Report 32 For the Month Ended June 30 Planning Activity Flexible Revenue and Spending Actual quire. epare a new report for June using the flexible budget approach. ter all variances as positive amounts. Leave no cells blank. se cells B10 to E20 from the given information to complete this question.) Perfect Parties Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 Planning Activity Flexible Revenue and Spending Budget Variances Budget Variances 92 Actual Results umber of parties evenues xpenses Food costs Party supplies Party worker wages Administrative salaries Equipment depreciation Rent Total expense Net operating income
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
