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
a machine is purchased on july 1 2009 for $181,500. It has an expected useful life of 11 years and no salvage value. After five years, the machine is sold for $98,000 cash. What is

A retailer knows the annual demand for one of its product is 100,000 units, the ordering costs are £25 per order and the average carrying cost per unit is 35 pence. You are require

There are different activities undertaken through a business that prove to be either source or use of cash. These can be categorizes under three broad categories that are: investin

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

#what is the formula for calculating payback period and what are its limitations ?

The Critical Thinking about CVP is described below CVP is more than just a mathematical tool/device to calculate values such as the break-even point. It can be used for the cri

A retail dealer in garments is currently selling 24000 shirts annually. He supplies the following details for the year ended 31st December,2007. Rs Selling Price per shirt

Mr. Marley is a wholesaler who buys and sells a wide range of products, one of which is the Laker. Mr. Marley sells 24,000 units of the Laker each year at a unit price $20. Sales o

Operating Income 1. Operating Income is derived from two sources, Rental Income from businesses operating in the warehouse complex and Interest Income of the project operating

some clarificationon how to compute closing stock and openning stock using marginal costing technique and absorption.