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
Gomez incurred $350,000 of research and development costs to develop a product for which a patent was granted on January 2, 2008. Legal fees and other costs associated with the re

i want to know the different types of costs.

Q. What are the advantages and disadvantages of free float? Advantages: It is one of the most suitable ER regimes for transitional countries that experience external shocks l

the folloeing job order cost sheets were purchased for three jobs that were in production during january job 97 job 98 job 99 material

This can be explained as the process of accumulating, calculating, analyzing, interpreting and reporting cost information that is both helpful and relevant to the internal and exte

A company has an authorized share capital of 250 million divided into 1,500,000 ordinary shares of sh.100 each and 1,000,000 preference shares of sh.100 each. 1,000,000 ordinary sh

costing in respect of mathematical accounting a research project.

Martinez Corporation engaged in the following cash transactions during 2012. Sale of land and building $186,710 Purchase of treasury stock 42,130 Purchase of land 39,130

EFFECTIVENESS AUDITING is one type of internal audit. Describe and evaluate this type of internal audit. What types of organisation would it be most useful for? Required: 1)

Discuss how SD can use standard costing and variance analysis to prepare meaningful reports when using Kaizen Costing. By the use of standard costing and variance analysis, fr