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
Using the chosen company from Bursa Malaysia, prepare a consolidated accounts assuming that the chosen company acquire Sure Cargo Behard at 80% of its ordinary shares. Given bel

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

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 labor em

The Gladys Corporation buys office equipment costing $426,000 on May 12, 2013. In 2015, new and improved models of the equipment make it obsolete, and Gladys sells the old equipme

What depreciation method does Amazon use for property and equipment? What is the range of useful lives for buildings and for fixtures and equipment? Do these useful lives make sens

explain the practical application of differential costing with the help of suitable example.

Kaplan Computers manufactures high end computer systems for the graphics design industry. At the present time, the company makes three computers with the following characteristics

Your company completed the site work for the South Pointe office complex. The costs are shown in Figure 11-3. The site concrete labor and landscaping were done by subcontractors. T

critically explain cost accounting as 1. a service activity 2. a descriptive/analytical discipline 3. an information system

what is the equivalent unit for materials? if the cost of normal lots units are absorbed by the units transferred out to the next department the work in process- beginning (60% com