Answered step by step
Verified Expert Solution
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
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
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