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

Distinction between absorption and marginal costing, Distinction between Ab...

Distinction between Absorption and Marginal Costing These are two approaches of arriving at the cost of production or total profit for a specified period. The major difference

Budgetary planning and control, Budgetary Planning and Control Budgeti...

Budgetary Planning and Control Budgeting refers to the process of quantifying the plans of an organization such as to enable it get its objectives in the defined duration.  Th

Case study, A family in Cambridge received their Christmas presents from fr...

A family in Cambridge received their Christmas presents from friends in Paris this week – 50 days after their parcel was posted. French posties sent it to Cambodia, and the near-20

Example of lifo, Example of LIFO, FIFO and Weighted Average Method Su...

Example of LIFO, FIFO and Weighted Average Method Suppose the following purchases were made in ABC Ltd as like: Date of purchase     Units purchased              Price/uni

Determine the cost that changes in total proportionately, Presented below i...

Presented below is a list of terms relating to cost behavior, followed by definitions of those terms: a. Rent on a factory building b. Engineering approach c. Fixed cost

Management Acconting, what is the different between Financial accounting an...

what is the different between Financial accounting and management accounting?

Prepare a preliminary cost benefit analysis, Managers need financial inform...

Managers need financial information to help them make decisions, communicate important information about their organization, and demonstrate fiscal responsibility to stakeholders.

Uniform costing, Uniform Costing It is a general system utilizing agre...

Uniform Costing It is a general system utilizing agreed concepts, standard and principles accounting practices adopted via different entities in the similar industry to ensure

Determine the costs of goods, Savage Distribution markets CDs of performing...

Savage Distribution markets CDs of performing artist Little Sister.  At the beginning of October, Savage had in beginning inventory 1,200 Little Sister's CDs with a unit cost of $5

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