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
31. Special Orders Maria’s Food Service provides meals that nonprofi t organizations distribute to handicapped and elderly people. Here is her forecasted income statement for April

. Which of the following is a reason why traditional product costing techniques have become obsolete in a lean operating environment? a. More complex accounting is required in a le

You perform a travel cost study that looks at the relationship between the cost of visiting a lake (including costs of travel, value of time spent not working & any entry fees), it

Q. A firm uses capital and labor to produce a single output good. The production function is given by F(K, L) = K 2 L where K is the amount of capital and L is the amount of labo

Jones Company operates within a monopolistically competitive industry. The estimated demand for its products is given by the following inverse demand function P = 1760 - 12Q

Brandywine Homecare, a not-for-profit business, had revenues of $12 million in 2011. Expenses other than depreciation totaled 75 percent of revenues, and depreciation expense was $

What is the easiest of calculate equivalents before producing a process account 2

Calculate the equal monthly payments and the cost of financing on a 25-year mortgage. The cash value of the house today is $500,000. You are paying monthly at a fixed rate of 6% pe

Incremental Costs as Relevant Costs An incremental cost is specifically incurred with the following a course of action and ignorable if such action is not implemented. It cont

Constant Gross Margin Rate This method assumes that every product contributes an equal percentage of gross profit for every shilling of sales. It works back from gross margin