Total annual sales revenue, Cost Accounting

Mr. Homer Simpson, President and Chief Executive Officer of Duff's Beer Making Supplies Inc. recently hired you as the new budget analyst for his company.  As your first duty, he has asked you to prepare an Excel workbook that can be used to tract sales / revenues, make sales forecasts and track employee commissions.

The workbook that you create should be professional in appearance, be easily understandable to other employees, utilize  cell references when ever possible and be completely flexible with the ability to alter any constant in a single cell.

At a minimum, you should have separate worksheet for listing the products / prices / commission rates, an individual worksheet for each individual region and a single summary sheet for Mr. Simpson to review.  (You may elect to have more worksheets in order to improve  overall appearance, usability and understandability of your workbook.)

The summary worksheet (s) should provide the following information:

  • Total annual sales revenue to date for the company
  • Total annual sales revenue to date per region
  • Total annual sales per product to date
  • Total annual sales per product per region to date
  • Total annual commissions paid to date
  • Total annual sales increase / decrease to date for the company
  • Total annual sales revenue increase / decrease to date for each region
  • The "top" five salespersons in the company should be ranked according their % of sales increase from last year.
  • The "top" five salespersons in the company should be ranked according to their total revenue increase from last year.

There should be a minimum of three charts / graphs that provide "relevant" information. Examples would be comparing current revenues to last year, using a trend line to forecast sales and / or comparison of sales / commissions for each region or salesperson.

  • Each chart should appear on a separate worksheet.
  • The charts should include an example of a bar / column, line and pie chart. 

You should use the "subtotals" and "name" commands  in the worksheet when appropriate.

Posted Date: 2/23/2013 3:17:50 AM | Location : United States







Related Discussions:- Total annual sales revenue, Assignment Help, Ask Question on Total annual sales revenue, Get Answer, Expert's Help, Total annual sales revenue Discussions

Write discussion on Total annual sales revenue
Your posts are moderated
Related Questions
. Alice Company has received a special order from John. John wishes to buy 100 units of Alice's product at a price of $48. The regular price is $65. The unit cost informati

QUESTION 1 Job costing Create a spreadsheet solution to the following problem. Follow the template provided. Play the Job cost podcasts and work through the example problem in tho

Cost Benefit Approach - Terms Used in Cost Accounting Is the primary criterion for selecting with alternative accounting approaches? There is a direct relationship in a co

I have a project due this week and I am having slight issues with the transactions. I cannot seem to receive the correct titles under the recordings

Balance Sheet Classi?cations and Relationships: Shelley and Co. has the following balance sheet elements as of December 31, 2012. Land. . . . . . . . . . . . . . . . . . . . . .

Calculate the β of Maine Corporation from the following data. The prices are at the beginning and at the end of each year     Normal 0 false false

A bicycle plant runs two assembly lines, A and B. 96.9% of line A's products pass instruction, while only 93.8% of line B's products pass inspection. 70% of the factory's bikes com

Elements of Manufacturing costs Manufacturing costs are the costs incurred to create a product. Keep in mind for a product that refers to both services and goods. The ele

Considerations in Variance Investigation As already notice above, not all variances are investigated; this is only the material and meaningful as for cost control reasons vari

Q. Calculate contribution to sales ratio? Contribution per unit= sales price per unit less variable cost per unit Break-even volume = Fixed overhead/Contribution per uni