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

Determining working capital requirements, Understanding the existing capita...

Understanding the existing capital requirements and how these are financed will assist us in understanding the process of financing of business and the flow of funds inside the bus

Calculate the cost of direct material used during the period, A company add...

A company adds overhead costs to jobs at the rate of $8 per direct labor hour. It accumulates overhead costs in a seperate manufacturing overhead account and uses normal costing to

Use account analysis to determine fixed cost, Reef Office Supplies is inter...

Reef Office Supplies is interested in estimating the cost involved in hiring new employees. The following information is available regarding the costs of operating the Human Resour

Exploration costs, are exploration cost treated as an asset or expense or b...

are exploration cost treated as an asset or expense or both?

Case study, Ask q6) The Net Sales revenue reported is derived from the sale...

Ask q6) The Net Sales revenue reported is derived from the sale of products. Each year Findley records from cash sells, sells on account and completed purchase orders. During 2016

MATERIALCOSTING, what are the material management questions

what are the material management questions

Calculate the yield to maturity of the bond, 7. The Isabelle Corporation re...

7. The Isabelle Corporation rents prom dresses in its stores across the southern United States. It has just issued a five-year, zero-coupon corporate bond at a price of $74. You ha

Determine the internal rate of return, AOL is considering two proposals to ...

AOL is considering two proposals to overhaul its network infrastructure. They have received two bids. The first bid, from Huawei, will require a $20 million upfront investment and

Equity adjustment account, Partner A (50%) Partner B (50%) sharing profi...

Partner A (50%) Partner B (50%) sharing profits equally New partner introduced $13,000 total cash including $3000 as goodwill which is raised to its full value. Partner C

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