A

B

C

D

E

F

G

H

I

J

K

$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.

$4$ The bookkeeper has prepared a report comparing actual results for the month of June to budgeted results.

$5q,$

$6$

Perfect Parties

$7,$ Birthday Party Division Analysis of Revenues and Costs

$8$

For the Month Ended June $30$

$9$

$10$ Number of parties

$\backslash$table$[[\backslash$table$[[$Planning$],[$Budget$]],\backslash$table$[[$Actual$],[$Results$]],$Variances,$],[80,17.92,,],[$$$36,000,$$$39,560,$$$3,560,$F$],[7,200,8,648,1,448,$U$],[3,200,3,404,204,$U$],[6,400,7,728,1,328,$U$],[3,700,3,500,200,$F$],[1,200,1,200,0,$None$],[5,000,5,000,0,$None$],[26,700,29,480,2,780,$U$],[$$$9,300,$$$10,080,$$$780,$F$]]$

$11$ Revenue

$12$ Expenses:

$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 A$10$ to E$20$ from the given information, as well as A $34$ to H $44$ to complete this question.$)$

$29$

$($o complete this question.$)$

Perfect Parties

Birthday Party Division Flexible Budget Performance Report

For the Month Ended June $30$

Graded Worksheet

Flexible

Revenue and Spending

Actual