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

Effective annual rate, The credit term from the supplier is 2/30, net 60. ...

The credit term from the supplier is 2/30, net 60. Requirements: Write the calculation Determine the effective annual rate if the firm does not take the discount.

Methods of costing, METHODS OF COSTING : 1. Job costing :  Job costing ...

METHODS OF COSTING : 1. Job costing :  Job costing is the essential costing technique appropriate to those industries somewhere the work consist of separate contracts, or batch

Cost estimation methods, using the high low method how do i calculate the c...

using the high low method how do i calculate the costs that are expected when the output expected is out of the range given for example cost prdctn volume 110000

What is the predetermined overhead rate, Morrow Company applies overhead ba...

Morrow Company applies overhead based on direct labor hours. At the beginning of the year, Morrow estimates overhead to be $620,000, machine hours to be 180,000, and direct labor h

Assignment, Ed Mettway was concerned about his firm''s ability to acquire t...

Ed Mettway was concerned about his firm''s ability to acquire the necessary property, plant, and equipment to take advantage of steadily increasing sales. Touring Enterprises, esta

Journal entry for sale of machinery, Rayya Co. purchases and installs a mac...

Rayya Co. purchases and installs a machine on January 1, 2013, at a total cost of $105,000. Straight-line depreciation is taken each year for four years assuming a seven-year life

Idea behind activity-based costing, Idea behind Activity-Based Costing ...

Idea behind Activity-Based Costing The most important ideas behind activity-based costing are as given as: Activities cause costs; activities involve ordering, ma

Determine expected rate, Bebe, a manufacturer of sophisticated and fas...

Bebe, a manufacturer of sophisticated and fashionable women's clothing, is completing a new assembly plant in Malaysia.  A final construction payment of 6,000,000 MY

Calculate the amounts that will show in the statement, MX obtains 80% of th...

MX obtains 80% of the 1 million issued $1 ordinary share capital of FZ on 1 May 2009 for $1,750,000 when FZ's reserved earnings were $920,000. The carrying worth was considered

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