Total annual sales revenue, Cost Accounting

Assignment Help:

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.


Related Discussions:- Total annual sales revenue

Planning Budgetting, Bugga Corp expects to sell 3,000 units in October, and...

Bugga Corp expects to sell 3,000 units in October, and expects sales to increase 20% each month thereafter. Sales price is expected to stay constant at $8 per unit. What are budge

Methods of allocating service costs, Methods of Allocating Service Costs ...

Methods of Allocating Service Costs Direct Method The service costs are merely allocated to the production department according to the usage of the services given. St

Prepare an income statement, Mrs. M. Botham is a sole trader, selling a var...

Mrs. M. Botham is a sole trader, selling a variety of fashionable clothing materials. Her business year end is 31 December 2011. You have been given the following trial balance

Standard cost and standard costing, Standard Cost and Standard Costing ...

Standard Cost and Standard Costing To effectively control the costs of a certain organization, we require a yard stick to measure the real performance against. Traditionally,

Qualitative characteristic of understandability means, The enhancing qualit...

The enhancing qualitative characteristic of understandability means that information should be understood by a those who are experts int eh interpretation of financial informat

Estimate finished goods cost of goods sold , ln an attempt to conceal a the...

ln an attempt to conceal a thefi of funds, Kaito Kid, controller of Shinichi Products, lnc. placed a bomb in the company s record vault. The ensuing explosion left only fragments o

Change in useful life for deperciation, A machine originally had an estimat...

A machine originally had an estimated useful life of 5 years, but after 3 complete years, it was decided that the original estimate of useful life should have been 10 years. At tha

Emu Manufacturing produces two popular toys - Blox and Shape, Blox ($) Sha...

Blox ($) Shapez ($) Direct material per unit 10 23 Direct labour per unit 19 32 Manufacturing overhead per unit 7 10 Selling & Admin. expenses per unit 17 31 T

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd