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
Questions What are your recommendations to Ted Lapres? What aspects should he keep, what should he change, and in what sequence should he make the changes? • Do you think the D

The Cash Cycle: so as to deal with the problem of cash management we should have a concept about the flow of cash by a firm's accounts. The entire process of such cash flow is ide

Bubba's Crawfish Processing Company uses a traditional overhead allocation based on direct labor hours. For the current year, overhead is estimated at $1,150,000, and direct labor

Tracking Direct Materials Jack keeps full records of the material released to each job. When Donnie gathered up light bulbs, tape, breakers, wire, and wire nuts on the morning

Your client has asked you to evaluate an investment project for her using what you have learned in school regarding the net present value method. The project will run for eight yea

Economic Order Quantity This constitutes the quantity purchased of either raw materials or stocks which is considered most optimum. It is the quantity such minimizes both ord

A CPA firm estimates that an audit will require the following work: Type of Auditor Expected Hours Cost per Hour Standard Costs Manager 10 $50 $ 500 Senior 20 40 800 Staff 40 30

This coursework is intended to help you develop your understanding of shell scripting in both a Windows and Unix environment. You should undertake this coursework in groups cons


under which type of asset the investment comes