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, 3 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
Auto Lavage is a Canadian company that owns and operates a large automatic carwash facility near Quebec. The following table provides data concerning the company%u2019s costs:
Â
| Â |
Fixed Cost per Month |
 |
Cost per Car Washed |
||
|
Cleaning supplies |
 |  |  |
$ |
0.40 |
|
Electricity |
$ |
1,450 |
 |
$ |
0.10 |
|
Maintenance |
 |  |  |
$ |
0.40 |
|
Wages and salaries |
$ |
3,700 |
 |
$ |
0.40 |
|
Depreciation |
$ |
6,900 |
 |  |  |
|
Rent |
$ |
2,100 |
 |  |  |
|
Administrative expenses |
$ |
2,000 |
 |
$ |
0.05 |
|
 |
|||||
Â
|
For example, electricity costs are $1,450 per month plus $0.10 per car washed. The company expects to wash 9,500 cars in October and to collect an average of $4.90 per car washed. The company actually washed 9,620 cars in October. |
Â
|
The actual operating results for October appear below: |
Â
|
Auto Lavage Income Statement For the Month Ended October 31 |
||
|
Actual cars washed |
 |
9,620 |
|
Revenue |
$ |
48,453 |
| Â |
 |
 |
|
Expenses: |
 | |
|
Cleaning supplies |
 |
4,228 |
|
Electricity |
 |
2,377 |
|
Maintenance |
 |
4,108 |
|
Wages and salaries |
 |
7,878 |
|
Depreciation |
 |
6,900 |
|
Rent |
 |
2,300 |
|
Administrative expenses |
 |
2,326 |
| Â |
 |
 |
|
Total expense |
 |
30,117 |
| Â |
 |
 |
|
Net operating income |
$ |
18,336 |
| Â |
  |
  |
|
 |
||
Â
|
Required: |
|
Prepare a report showing revenue and spending variances. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance).) |
Â
|
Auto Lavage Revenue and Spending Variances For the Month Ended October 31 |
||||
| Â |
Flexible Budget |
Actual Results |
Revenue and Spending Variances |
|
|
Revenue |
$ |
$ |
$ |
(Click to select)NoneFU |
| Â |
 |
 |
 |
 |
|
Expenses: |
 |  |  |  |
|
Cleaning supplies |
 |  |  |
(Click to select)UFNone |
|
Electricity |
 |  |  |
(Click to select)FNoneU |
|
Maintenance |
 |  |  |
(Click to select)NoneUF |
|
Wages and salaries |
 |  |  |
(Click to select)UNoneF |
|
Depreciation |
 |  |  |
(Click to select)UFNone |
|
Rent |
 |  |  |
(Click to select)NoneFU |
|
Administrative expenses |
 |  |  |
(Click to select)FNoneU |
| Â |
 |
 |
 |
 |
|
Total expense |
 |  |  |
(Click to select)NoneFU |
| Â |
 |
 |
 |
 |
|
Net operating income |
$ |
$ |
$ |
(Click to select)FUNone |
| Â |
  |
  |
  |
|
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll