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

Effects of increasing fixed cost, Jones Company operates within a monopolis...

Jones Company operates within a monopolistically competitive industry. The estimated demand for its products is given by the following inverse demand function P = 1760 - 12Q

How many bottles do they need to sell to breakeven, Denair Fine Wines, Inc....

Denair Fine Wines, Inc., is planning to bring out a higher-quality wine product than any currently available in Stanislaus county. They've decided on selling the blended, fortified

Limitations of budgeting, Limitations of Budgeting 1. Too mush relian...

Limitations of Budgeting 1. Too mush reliance may reason resistance or inflexibility to change. 2. Difficult to set levels of attainment. It may result into too tight budg

Assignment, with relevant illustrations and examples, discuss the different...

with relevant illustrations and examples, discuss the different overhead costing and control method.

Will by means of fca save money, Q. WILL BY MEANS OF FCA SAVE MONEY? A...

Q. WILL BY MEANS OF FCA SAVE MONEY? Ans. It depends. in the end, the more departments know about what it obtain to deliver a unit of service, the more efficiently they can

Calculate contribution to sales ratio, Q. Calculate contribution to sales r...

Q. Calculate contribution to sales ratio? Contribution per unit= sales price per unit less variable cost per unit Break-even volume = Fixed overhead/Contribution per uni

Determine expected net income and net cash flow, Elite Company is planning ...

Elite Company is planning to add a new product to its line. To manufacture this product, the company needs to buy a new machine at a $300,000 cost with an expected four-year life a

Budgetary planning and control - accounting techniques, Budgetary Planning ...

Budgetary Planning and Control - Accounting Techniques A budget is a   plan of action expressed in monetary terms. Therefore it is a quantified plan of what one intends to do.

Literature review - effectiveness auditing, EFFECTIVENESS AUDITING is one t...

EFFECTIVENESS AUDITING is one type of internal audit. Describe and evaluate this type of internal audit. What types of organisation would it be most useful for? Required: 1)

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