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. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.
**PLEASE FILL IN ALL YELLOW BOXES, AND POST EXCEL FORMULA FOR CREDIT**
Solution:
Perfect Parties | |||||||
Birthday Party Division - Flexible Budget Performance Report | |||||||
For the month ended June 30 | |||||||
Particulars | Planning Budget | Activity Variances | Flexible Budget | Revenue and spending variances | Actual results | ||
Nos of parties | 80 | 92 | 92 | ||||
Revenues | $36,000 | $5,400 | F | $41,400 | $1,840 | U | $39,560 |
Expenses: | |||||||
Food cost | $7,200 | $1,080 | U | $8,280 | $368 | U | $8,648 |
Party Supplies | $3,200 | $480 | U | $3,680 | $276 | F | $3,404 |
Party worker wages | $6,400 | $960 | U | $7,360 | $368 | U | $7,728 |
Administrative salaries | $3,700 | $0 | None | $3,700 | $200 | F | $3,500 |
Equipment depreciation | $1,200 | $0 | None | $1,200 | $0 | None | $1,200 |
Rent | $5,000 | $0 | None | $5,000 | $0 | None | $5,000 |
Total Expenses | $26,700 | $2,520 | U | $29,220 | $260 | U | $29,480 |
Net Operating Income | $9,300 | $2,880 | F | $12,180 | $2,100 | U | $10,080 |
Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and...
Preparing a Performance Report using Excel's ABS, IF and SUM Functions 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. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from...
Adams Corporation evaluates divisional managers based on Return on Investment (ROI) and has provided the operating results of the Northern Division from last year. The Controller has asked you to compute the ROI and Residual Income based on data from last year and if the division adds a new product line. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B2” was...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=B2” was entered,...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel’s Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B2” was entered,...
Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel’s Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, “=B2” was entered,...
The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th. The Controller has asked you to calculate Information about the bond assuming two different market interest rates in the Excel Simulation below. The present value factor tables are Included in the first four tabs of the Excel Simulation. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to...
Patterson, Inc. has provided details of its actual cost data for the month. The Controller has asked you to compute the basic variances and the impact of those variances on unit costs. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, -D4" was entered, the formula would...
Chapter 10 Excel Saved Help Save & Exit Submit Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market interest rates using Excel's Present Value functions. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. 10 points (8 02:46:24 eBook Print References • Cell Reference: Allows you to refer to data from another...
Reading Readiness, Inc. has provided you its list of accounts and balances as of January 31. The Controller has asked you to prepare an Income Statement for the month ended January 31. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, =C11" was entered, the formula...