Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how do you do the excel work for this question? 1. Prepare a flexible budget. 2. Prepare a performance report that combines activity variances and

how do you do the excel work for this question? image text in transcribedimage text in transcribed

1. Prepare a flexible budget. 2. Prepare a performance report that combines activity variances and revenue and spending variances. Preparing a Performance Report Excel FILE Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW A. Alignment Number Conditional Format as Cel Cells Editing Formatting Table Styles Paste B I U Clipboard Font Styles E36/E34 H34 1.200 1,200 None 19 Equipment depreciation None 5,000 5,000 20 Rent 2,780 U 26,700 29,480 21 Total expense 9,300 10,080 80 F 22 Net operating income 23 Food costs, party supplies and party worker wages are variable costs. 24 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 Ifthere is a variance, write an IF statements to indicate if it is For U (using capita 27 etters) 28 If there is no variance, enter the word None. Perfect Parties 29 Birthday Party Division Flexible Budget Performance Report 30 For the Month Ended June 30 31 Planning Revenue and Budget Spending Variances Results Activity Variances 34 Number of parties 80 92 35 36,000 41,400 36 Revenues 37 Expenses: 38 Food costs 7,200 39 Party supplies 3,200

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

More Books

Students also viewed these Accounting questions

Question

Which form of proof do you find least persuasive? Why?

Answered: 1 week ago