Required: Prepare a new report for June using the flexible budget approach.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

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 prepare the Birthday Party Division Budget Performance Report.

Please provide me with the answers for the cells in yellow. greatly appreciate your help!

Perfect Parties, Inc. has several divisions. One division provides birthday parties at their facility.
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.
Perfect Parties
Birthday Party Division Analysis of Revenues and Costs
For the Month Ended June 30
Planning
Actual
Budget
Results
Variances
Number of parties
80
92
Revenue
$36,000
$39,560
$3,560 F
Expenses:
Food costs
7,200
8,648
1,448 U
Party supplies
3,200
3,404
204 U
Party worker wages
6,400
7,728
1,328 U
Administrative salaries
3,700
3,500
200 F
Equipment depreciation
1,200
1,200
0 None
Rent
5,000
5,000
0 None
Total expense
26,700
29,480
2,780 U
Net operating income
$9,300
$10,080
$780 F
Food costs, party supplies, and party worker wages are variable costs.
Administrative salaries, equipment depreciation, and rent are fixed costs.
Required:
Prepare a new report for June using the flexible budget approach.
Enter all variances as positive amounts. Leave no cells blank.
(Use cells A10 to E20 from the given information, as well as A34 to H44 to complete this question.)
Number of parties
Revenues
Expenses:
Food costs
Party supplies
Party worker wages
Administrative salaries
Equipment depreciation
Rent
Total expense
Net operating income
Perfect Parties
Birthday Party Division Flexible Budget Performance Report
For the Month Ended June 30
Planning
Budget
Activity
Variances
Flexible
Budget
Revenue and Spending
Actual
Variances
Results
Transcribed Image Text:Perfect Parties, Inc. has several divisions. One division provides birthday parties at their facility. 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. Perfect Parties Birthday Party Division Analysis of Revenues and Costs For the Month Ended June 30 Planning Actual Budget Results Variances Number of parties 80 92 Revenue $36,000 $39,560 $3,560 F Expenses: Food costs 7,200 8,648 1,448 U Party supplies 3,200 3,404 204 U Party worker wages 6,400 7,728 1,328 U Administrative salaries 3,700 3,500 200 F Equipment depreciation 1,200 1,200 0 None Rent 5,000 5,000 0 None Total expense 26,700 29,480 2,780 U Net operating income $9,300 $10,080 $780 F Food costs, party supplies, and party worker wages are variable costs. Administrative salaries, equipment depreciation, and rent are fixed costs. Required: Prepare a new report for June using the flexible budget approach. Enter all variances as positive amounts. Leave no cells blank. (Use cells A10 to E20 from the given information, as well as A34 to H44 to complete this question.) Number of parties Revenues Expenses: Food costs Party supplies Party worker wages Administrative salaries Equipment depreciation Rent Total expense Net operating income Perfect Parties Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 Planning Budget Activity Variances Flexible Budget Revenue and Spending Actual Variances Results
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education