Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve with excel formulas Planning Budget Actual Results Variances 13 14 15 16 11 18 19 20 21 Number of parties Revenue Expense s: 80

solve with excel formulas
image text in transcribed
image text in transcribed

Planning Budget Actual Results Variances 13 14 15 16 11 18 19 20 21 Number of parties Revenue Expense s: 80 36000 9200 3200 6 goo 3.700 1 ,200 9.300 921 39560 8648 3.404 7.728 3 soo 5 000 ,480 10080 s *560 F Food costs party supplies party worker wages Administrative salaries EAuipment depreciation Rent Total expense Net operating income 14.48 204 IU I .328 None None 2,780 780 F 22 23 24 Food costs, parly supplies and party worker wages are variable costs. Administrative salaries, equipment depreciation and rent are fixed costs. 26 Prepare a new report for June using the flexible budget approach. Enter all variances as positive amounts. If there isa variance, write an IF statements to indicate if it is For U (using capital letters). 201 there is no variance, enter the word None. Attempt(s) 2/3

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

Accounting Principles A Business Perspective

Authors: Roger H. Hermanson, James Don Edwards, Michael W. Maher

1st Edition

1680921851, 978-1680921854

More Books

Students also viewed these Accounting questions