Question: Use appropriate excel formulas to fill in the missing information Styles > Al B C D fe E Perfect Parties, Inc. has several divisions. One

Use appropriate excel formulas to fill in the missing information Styles > Al B C D fe E Perfect Parties, Inc. has
several divisions. One division provides birthday parties F G H I J
1 Perfect Parties, Inc. has several divisions. One division provides birthday parties

Styles > Al B C D fe E Perfect Parties, Inc. has several divisions. One division provides birthday parties F G H I J 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. 45678 Perfect Parties Birthday Party Division Analysis of Revenues and Costs For the Month Ended June 30 K 9 10 11 Number of parties 12 13 Revenue 14 Expenses: 15 Food costs Planning Budget Actual Results Variances 80 92 $ 36,000 $ 39,560 $ 3,560 F 7,200 8,648 1,448 U 16 Party supplies 3,200 3,404 204 U 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 21 Total expense 26,700 29,480 2,780 U 22 Net operating income $ 9,300 $ 10,080 $ 780 F 23 Food costs, party supplies and party worker wages are variable costs. Sheet 1 4 READY Attempt(s) 100% Winh

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!