Here is the synopsis of our sample research paper on Bookstore Accounting Case. Have the paper e-mailed to you 24/7/365.
Essay / Research Paper Abstract
This 3 page paper is based on a case study provided by the student. Figures are given for a revenue range and percentages for costs for a bookstore, using the instructions a profit statement is created for a period of six months, and the percentage of profit in is to be retained to achieve an investment at the end of the six month period is calculated.
Page Count:
3 pages (~225 words per page)
File: TS14_TEbookacct.rtf
Buy This Term Paper »
Unformatted sample text from the term paper:
been undertaken present the results. The revenue (this is the total sales) is stated as being between $170,000 and $180,000 for one month, and the remaining months the sales of
between $185,000 and $225,000. To make the scenario believable the first month is set at $105,000, it is assume that the sales increase by 5% each month over the next
six months which means that by the end of the six-month period the June revenue figure is $223,349.27. With the revenue determining the next stage is to calculate the
costs. The first costs to be assessed are usually those which are related to the direct sales. The case study tells us the percentage of revenue allocated to each type
of good. This can be calculated easily by putting a formula into the relevant box. For example, we are told the cost of books equates to 45% of the revenue.
Therefore, when looking at the cost of books for January, we moved to the relevant sell, once that cell is highlighted we take on the formula symbol and then put
in the formula which takes the revenue from January and multiplies it by 45% of that revenue. In the Excel spreadsheet the formula looks like this =SUM(B2*45%). This is then
repeated for each of the costs for the different departments, and the advertising, for January, using the given percentages in the case study. There is also one costs remain stable
throughout, that is the only cost of $20,000 per month. Once all the expenses are in this column we can add them together so we have the total amount of
expenses for that month. The next stage is to calculate the profit, this is done by deducting the expenses from the revenue. The formula looks like this; =SUM(B2-B10). A
...