Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started