MUME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in * LO Calibri 111 A A % M Paste B TU Cells Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Al & Perfect Parties, Inc. has several divisions. One division provides birthday parties A B c D F G H 1 Perfect Paties, 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. The bookkeeper has prepared a report comparing actual results for the month of June to budgeted results. 4 Variances S 3,560 F 5 Perfect Parties 5 Birthday Party Division Analysis of Revenues and Costs 7 For the Month Ended June 30 3 Planning Budget Actual Results 0 1 Number of parties 80 92 2 3 Revenue $ 36,000 $ 39,560 4 Expenses: 5 Food costs 7,200 8,648 6 Party supplies 3,200 3,404 7 Party worker wages 6,400 7,728 8 Administrative salaries 3,700 3,500 9 Equipment depreciation 1,200 1,200 0 Rent 5,000 5,000 1 Total expense 26,700 29,480 2 Net operating income $ 9,300 $ 10,080 3. Food costs, party supplies and party worker wages are variable costs. Sheet1 1,448 U 204 U 1,328 U 200 F None None 2,780 U 780 F $ C + 100% READY Attempt(s) Saved HILE HOME INSERT X Calibri 11 Paste BIU- PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In A % M Alignment Number Conditional Format as Cell Cells Editing Formatting Table Styles Styles Perfect Parties, Inc. has several divisions. One division provides birthday parties Cpboard Font A1 v X A D E F G H K B 23 Food costs, party supplies and party worker wages are variable costs. 24 Administrative salaries, equipment depreciation and rent are fixed costs. 25 26 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. 29 Perfect Parties 30 Birthday Party Division Flexible Budget Performance Report 31 For the Month Ended June 30 32 Planning Flexible 33 Revenue and Actual Budget Activity Variances Budget Spending Variances Results 34 Number of parties 35 36 Revenues 37 Expenses: 38 Food costs 39 Party supplies 40 Party worker wages 41 Administrative salaries Equipment depreciation 43 Rent 42 Sheet 1 READY EL + 100% ULUIL.CUende LIHI!_con=con&external_browser=0&dlaunchUrl #3 - Chapters 8 & 9 Sared FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign in X 05 Calibri 11 A A % Paste BIU A Alignment Number Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard A1 v fe Perfect Parties, Inc. has several divisions. One division provides birthday parties A B C D E H K 30 31 32 Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 33 Planning Budget Activity Variances Flexible Budget Revenue and Spending Variances Actual Results 34 Number of parties 35 36 Revenues 37 Expenses: 38 Food costs 39 Party supplies 40 Party worker wages 41 Administrative salaries 42 Equipment depreciation 3 Rent 4 Total expense 5 Net operating income 56 37 48 39 6 Sheet1 + READY L 100% Attempt(s)