Answered step by step
Verified Expert Solution
Link Copied!

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 image text in transcribed
image text in transcribed
image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting

Authors: Heintz and Parry

20th Edition

1285892070, 538489669, 9781111790301, 978-1285892078, 9780538489669, 1111790302, 978-0538745192

More Books

Students also viewed these Accounting questions

Question

-x/2 x/4 If A = -x/2 and A-1 =6 then x equals

Answered: 1 week ago