Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for

Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results for the month of June. The Controller has asked you to prepare the Birthday Party Division Budget Performance Report. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.

I need the exact formula for the IF function columns

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed
14 Expenses: 15 Food costs 7,200 8,648 16 Party supplies 3,200 3,404 17 Party worker wages 6,400 7,728 18 Administrative salaries 3,700 3,500 19 Equipment depreciation 1,200 1,200 20 Rent 5,000 5.000 21 Total expense 26,700 29,480 22 Net operating income 9,300 $ 10,080 23 Food costs, party supplies and party worker wages are variable costs. ... Sheet 1 ... + 1,448 U 204 U 1,328 U 200 F - None - None 2,780 U 780 F READY Attempt(s) 3/3 6 Prepare a new report for June using the flexible budget approach. 27 Enter all variances as positive amounts. If there is a variance, write an IF statements to indicate if it is For U (using capital letters). 28 If there is no variance, enter the word None. Perfect Parties Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 Sheet1 ... READY Attempt(s) 3/3 14 Expenses: 15 Food costs 7,200 8,648 16 Party supplies 3,200 3,404 17 Party worker wages 6,400 7,728 18 Administrative salaries 3,700 3,500 19 Equipment depreciation 1,200 1,200 20 Rent 5,000 5.000 21 Total expense 26,700 29,480 22 Net operating income 9,300 $ 10,080 23 Food costs, party supplies and party worker wages are variable costs. ... Sheet 1 ... + 1,448 U 204 U 1,328 U 200 F - None - None 2,780 U 780 F READY Attempt(s) 3/3 6 Prepare a new report for June using the flexible budget approach. 27 Enter all variances as positive amounts. If there is a variance, write an IF statements to indicate if it is For U (using capital letters). 28 If there is no variance, enter the word None. Perfect Parties Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 Sheet1 ... READY Attempt(s) 3/3 signment 0 te B I U . 3- board Font Submitted 66.66/100 Total points awarded Help A - Alignment Number Conditional Format as Les Cells Editing Formatting Table Styles Styles fo Perfect Parties, Inc. has several divisions. One division provides birthday parties E F 80 92 X V I A Number of parties D $ 36,000 $ 5.400 X

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

Step: 3

blur-text-image

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

Handbook Of Energy Audits

Authors: Albert Thumann, Terry Niehus, William J. Younger

7th Edition

1420067915, 978-1420067910

More Books

Students also viewed these Accounting questions

Question

=+. How would you interpret this value?

Answered: 1 week ago

Question

Draw a labelled diagram of the Dicot stem.

Answered: 1 week ago