The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 402 Weeks Ago, 2 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
(Comprehensive; analyzing cost control) The financial results for the Business Education Department of Omega Educational Services Corporation for November 2010 are presented in the schedule at the end of this problem. Caroline Roper, president of Omega Educational Services, is pleased with the final results but has observed that the revenue and most of the costs and expenses of this department exceeded the budgeted amounts. Bret Shulman, vice president of the Business Education Department, has been requested to provide an explanation for any amount that exceeded the budget by 5 percent or more.
Shulman has accumulated the following facts to assist in his analysis of the November results:
Historically, 70 percent of the participant day registrations are at the full fee of $150 per day, and 30 percent of the participant day registrations receive the discounted fee of $135 per day. These percentages were used in developing the November 2010 budgeted revenue.
|
Food charges per participant day (lunch/coffee breaks) |
$ 27 |
|
Course materials per participant |
8 |
|
Instructor fee per day |
1,000 |
|
Full fee registrations |
704 |
|
Discounted fees |
 |
|
Current periodical subscribers |
128 |
|
New periodical subscribers |
128 |
|
Second registration from the same organization |
320 |
|
Total participant day registrations |
1,280 |
A combined promotional mailing was used to advertise the St. Louis pro-gram and a program in Boston that was scheduled for December 2010. The incremental costs of the combined promotion were $5,000, but none of the promotional expenses ($20,000) budgeted for the Boston program in December will have to be incurred. This earlier-than-normal promotion for the Boston program has resulted in early registration fees collected in November as follows(in terms of participant days):
|
Full fee registrations |
140 |
|
Discounted registrations |
60 |
|
Total participant day registrations |
200 |
Shulman has prepared the following quantitative analysis of the November 2010 variances:
|
Omega Educational Services Corporation |
 | |||
|
Statement of Operations Business Education Department |
 | |||
|
For the Month Ended November 30, 2010 |
 | |||
| Â | Â | Â |
Favorable |
Favorable |
| Â | Â | Â |
(Unfavorable) |
(Unfavorable) |
| Â |
Budget |
Actual |
Dollars |
Percent |
|
Revenue: Course fees |
$145,500 |
$212,460 |
$ 66,960 |
46.0 |
|
Expenses |
 |  |  |  |
|
Food charges |
$ 27,000 |
$ 32,000 |
$ (5,000) |
(18.5) |
|
Course materials |
3,400 |
4,770 |
(1,370) |
(40.3) |
|
Instructor fees |
40,000 |
42,000 |
(2,000) |
(5.0) |
|
Instructor travel |
9,600 |
9,885 |
(285) |
(3.0) |
|
Staff salaries and benefits |
12,000 |
12,250 |
(250) |
(2.1) |
|
Staff travel |
2,500 |
2,400 |
100 |
4.0 |
|
Promotion |
20,000 |
25,000 |
(5,000) |
(25.0) |
|
Course development |
2,000 |
5,000 |
(3,000) |
(150.0) |
|
Total expenses |
$116,500 |
$133,305 |
$(16,805) |
(14.4) |
|
Revenue over expenses |
$ 29,000 |
$ 79,155 |
$ 50,155 |
172.9 |
Â
|
Omega Educational Services Corporation |
 | |
|
Analysis of November 2010 Variances |
 | |
|
Budgeted revenue |
 |
$145,500 |
|
Variances |
 |  |
|
Quantity variance [(1,280 − 1,000) X $145.50] |
$40,740 F |
 |
|
Mix variance [($143.25 − $145.50) X 1,280] |
2,880 U |
 |
|
Timing difference ($145.50 X 200) |
29,100 F |
66,960 F |
|
Actual revenue |
 |
$212,460 |
|
Budgeted expenses |
 |
$116,500 |
|
Quantity variances |
 |  |
|
Food charges [(1,000 − 1,280) X $27] |
$ 7,560 U |
 |
|
Course materials [(425 − 530) X $8] |
840 U |
 |
|
Instructor fees (2 − $1,000) |
2,000 U |
10,400 U |
|
Price variances |
 |  |
|
Food charges [($27 − $25) X 1,280] |
$ 2,560 F |
 |
|
Course materials [($8 − $9) X 530]Timing differences |
530 U |
2,030 F |
|
Promotion |
$ 5,000 U |
 |
|
Course development |
3,000 U |
8,000 U |
|
Variances not analyzed (5% or less) |
 |  |
|
Instructor travel |
$ 285 U |
 |
|
Staff salaries and benefits |
250 U |
 |
|
Staff travel |
100 F |
435 U |
|
Actual expenses |
 |
$133,305 |
After reviewing Shulman’s quantitative analysis of the November variances, pre-pare a memorandum addressed to Roper explaining the following:
a. The cause of the revenue mix variance.
b. The implication of the revenue mix variance.
c. The cause of the revenue timing difference.
d. The significance of the revenue timing difference.
e. The primary cause of the unfavorable total expense variance.
f. How the favorable food price variance was determined.
g. The impact of the promotion timing difference on future revenues and expenses.
h. Whether or not the course development variance has an unfavorable impact on the company.
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------sol-----------uti-----------on.-----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- ca-----------tch-----------