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

Case study, what could it cost the fezas to launder?show your detailed culc...

what could it cost the fezas to launder?show your detailed culculation

Business process mapping, Using some variation of business process mapping,...

Using some variation of business process mapping, graph out the mango concentrate supply chain focusing on when cost is added to the supply chain. (i.e. Display/draw the process

Changes in product mix, Changes in Product Mix A change in product mix...

Changes in Product Mix A change in product mix in which individual products have different contribution will contain different contribution. Sales ratio will conclude in a cha

Contribution, CONTRIBUTION : It is the variation between the marginal cost ...

CONTRIBUTION : It is the variation between the marginal cost of sales and sales and it contributes towards fixed profit and expenses.  It is differ from the profit which is the net

What is the net present value using a 12% cost of capital?, Keira Knightley...

Keira Knightley Company buys a piece of equipment for $36,442 that will last for 7 years. The equipment will generate cash flows of $7,000 per year and will have no salvage value a

Segment reporting, Juniper Ltd is a listed diversified company.  In prepari...

Juniper Ltd is a listed diversified company.  In preparing its financial statements in accordance with AASB 8, the chief operating officer has identified three operating segments:

Cost Estimation, On a New product development process of making a new S3 ST...

On a New product development process of making a new S3 STORAGE SIM card phone storage device for end users, forecast the following With full working and tabulations; a) With fu

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