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, 6 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
Facilitator Corp. is a company that acts as a facilitator in tax-favored real estate swaps. Such swaps, known as 1031 exchanges, permit participants to avoid some or all of the capital gains taxes that would otherwise be due. The bookkeeper for the company has been asked to prepare a report for the company to help its owner/manager analyze performance. The first such report appears below:
| Facilitator Corp Analysis of Revenues and Costs For the Month Ended May 31 |
|||||||||
| Â | Planning Budget Unit Revenues and Costs | Actual Unit Revenues and Costs | Variances | ||||||
| Exchanges completed | Â | 25 | Â | Â | 30 | Â | Â | Â | Â |
| Revenue | $ | 780 | Â | $ | 730 | Â | $ | 50 | U |
| Â | Â | ||||||||
| Expenses: | Â | Â | Â | Â | Â | Â | Â | Â | Â |
| Legal and search fees | Â | 132 | Â | Â | 139 | Â | Â | 7 | U |
| Office expenses | Â | 167 | Â | Â | 129 | Â | Â | 38 | F |
| Equipment depreciation | Â | 15 | Â | Â | 12 | Â | Â | 3 | F |
| Rent | Â | 52 | Â | Â | 37 | Â | Â | 15 | F |
| Insurance | Â | 14 | Â | Â | 11 | Â | Â | 3 | F |
| Â | Â | ||||||||
| Total expense | Â | 380 | Â | Â | 328 | Â | Â | 52 | F |
| Â | Â | ||||||||
| Net operating income | $ | 400 | Â | $ | 402 | Â | $ | 2 | F |
| Â | Â | ||||||||
|
Note that the revenues and costs in the above report are unit revenues and costs. For example, the average office expense is $167 per exchange completed on the planning budget; whereas, the average actual office expense is $129 per exchange completed. |
|
Legal and search fees is a variable cost; office expenses is a mixed cost; and equipment depreciation, rent, and insurance are fixed costs. In the planning budget, the fixed component of office expenses was $4,100. |
|
All of the company%u2019s revenues come from fees collected when an exchange is completed. |
| Required: | |||||
| 1. | Whether report prepared by the bookkeeper is useful as a performance report? | ||||
| Â | Â | ||||
| Â |
|
||||
| 2. |
Complete a performance report that would help the owner/manager assess the performance of the company in May. (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). Omit the "$" sign in your response.) |
|
Facilitator Corp |
|||||||
| Â | Planning Budget | Activity Variances | Flexible Budget | Revenue and Spending Variances | Actual Results | ||
| Exchanges completed | Â | Â | Â | Â | Â | Â | Â |
| Revenue | $ | $ | Â | $ | $ | Â | $ |
| Â | Â | Â | |||||
| Expenses: | Â | Â | Â | Â | Â | Â | Â |
| Legal and search fees | Â | Â | Â | Â | Â | Â | Â |
|
Office expenses |
 |  |  |  |  |  |  |
| Equipment depreciation | Â | Â | Â | Â | Â | Â | Â |
| Rent | Â | Â | Â | Â | Â | Â | Â |
| Insurance | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | |||||
| Total expense | Â | Â | Â | Â | Â | Â | Â |
| Â | Â | Â | |||||
| Net operating income | $ | $ | Â | $ | $ | Â | $ |
| Â | Â | Â | |||||
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