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

#title.payroll procedures., describe the procedures involved in payroll lab...

describe the procedures involved in payroll labour cost accounting

Prepaid expenses, Expenses paid in previous of their use or consumption is ...

Expenses paid in previous of their use or consumption is termed as prepaid expenses. At the ending of the year, a portion of the payment keeps unconsumed and is treated like an ass

Compute the cost of goods sold, The following data (in thousands of dollars...

The following data (in thousands of dollars) have been taken from the accounting records of Barn Burner Corporation for the just completed year.       Sales

Contingent liabilities, These should be distinguished from estimated liabil...

These should be distinguished from estimated liabilities. Estimated liabilities are identified liabilities where the amount is uncertain. Contingent liabilities conversely are not

Investment interest, what will a $5,000,000 investment be worth at 3.5% int...

what will a $5,000,000 investment be worth at 3.5% interest compounded quarterly in 10 years?

Job costing, the features and scopes of job costing

the features and scopes of job costing

Determine equivalent units of the product, Determine Equivalent Units of th...

Determine Equivalent Units of the Product Let assume there are 4,000 units of a product in ending inventory out of that 60 percent are fully complete whereas the remaining are

Explanation of the fixed cost line, A fixed cost is a cost which can't be e...

A fixed cost is a cost which can't be easily identified or related to a cost per unit or activity of any kind for example a cost which remains constant when production of a service

Calculate the variable overhead efficiency variance, Questions 8-10 rely on...

Questions 8-10 rely on the following data. FrontGrade Systems allocates manufacturing over- head based on machine hours. Each connector should require 11 machine hours. According t

Expenditure for the base period and the current period, 1. The table below ...

1. The table below gives data for Southland where there are three consumption goods: bananas, coconuts and grapes. Goods Quantity in base period basket

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