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
Beaver Company (a multi-product firm) produces 5,000 units of Product X each year. Each unit of Product X sells for $8 and has a contribution margin of $5. If Product X is disconti

Shubenacadie Inc. is currently considering a project with a 5-year life that it believes has the potential to return the company to profitability. Based on the results from a marke

Logan Corporation issued $800,000 of 8% bonds on October 1, 2006, due on October 1, 2011. The interest is to be paid twice a year on April 1 and October 1. The bonds were sold to y

Weighted Average Method - Work in Progress While this method is employed, all costs of production are considered in assigning costs to inventory. The method puts together open

The San Carlos Company is an electronics business with eight product lines. Income data for one of the products (XT-107) for June 2011 are as follows: Revenues, 200,000 units at av

Limitations of abc analysis

Denair Fine Wines, Inc., is planning to bring out a higher-quality wine product than any currently available in Stanislaus county. They've decided on selling the blended, fortified

Day Corporation purchased a patent on January 1, 2012 for $360,000. The patent had a useful life of 10 years at that date. In January of 2013, Day successfully defends the patent

You are considering starting a walk-in-clinic.  Your financial projections for the first year of operations are as follows: Revenues (10,000 visits) $400

#purchase price R45 order costs R175 lead time 6 days cost of capital (after taxation) 20% direct inventory holding costs R25 annual demand 8500 units business operational 330day p