Reference no: EM13720069
Purpose: This assignment will utilize multiple worksheets to enter data then sort, filter the data into a worksheet(s) that provides useful information to management.
General concepts that are included in this assignment are: basic formulas & functions, copy / paste, absolute references, sorting / filtering of data and the use of charts / graphs to provide visual interpretation of information.
Student will demonstrate the ability to develop a workbook that is professional in appearance and easily understandable to other users.
Your Assignment:
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 whenever 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, sales of the various products 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.
|
Assignment regarding leadership and ethics in healthcare
: The major code of ethics for your practice as a HCA was developed through the American College of Healthcare Executives (ACHE).
|
|
Describe project schedule and budget
: A project plan cannot be considered complete until the resources have been assigned (including budget and cost estimate). You will assign the resources required to work on your project to your scheduled tasks
|
|
Assignment regarding the leadership evaluation
: The purpose of this assignment is to explore how leadership is formally evaluated in different organizations. In this assignment, examine and analyze the process used to evaluate leaders in a specific organization. Obtain a copy of a leadership pe..
|
|
Estimate the average power output of the sun
: Estimate the average power output of the Sun, given that about 1350 W/m2 reaches the upper atmosphere of the Earth. The distance from the Sun to the Earth is 1.5 × 1011 m
|
|
Demonstrate the ability to develop a workbook
: Demonstrate the ability to develop a workbook that is professional in appearance and easily understandable to other users.
|
|
Flexibility in the workforce
: Flexibility in the workforce is not only about an employee's schedule but also their compensation and benefits. Read the case study and in a 1-2 page paper, answer the following questions:
|
|
Most effectively in a combined approach
: Write a 500 to 700 word paper in which you compare and contrast the two approaches: What are the strengths and weaknesses of each approach? How can they be used most effectively in a combined approach?
|
|
Select two articles in the university library
: Select two articles in the University Library: one in which the business problem is researched using a descriptive statistical method and another using an inferential method.Summarize each of the data collection instruments, sampling methods, and..
|
|
Functional organisational politics
: Although many people view organisational politics in a negative light or one that causes dysfunction, it can be an effective strategy.
|