The spreadsheet will provide a level of insight into team performance and inform managers of the progress
Question:
The spreadsheet will provide a level of insight into team performance and inform managers of the progress being made towards achieving sales goals. It must include:
- Calculated "Total Weekly Sales" for each team member, and
- Calculated "Variance" (i.e. the difference between "Total Weekly Sales" and the "Forecasted Weekly Sales") for each team member
The chart will show a pictorial representation of each team member's actual sales for the week compared to their forecasted sales.
Using this information, managers will be able to organise one-on-one coaching sessions with individual team members as well as adjust weekly forecasted sales and revenue figures.
Instructions
- Review the background information, weekly sales data and forecasted total weekly sales, as well as the WAMco Spreadsheet Style Guide. These will help you successfully plan, design, produce and finalise the spreadsheet and chart you will create.
Weekly Sales Data | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Forecasted Sales |
These are forecasted total weekly sales:
|
- male the Weekly Sales Report Spreadsheet and Chart using suitable technology and software and upload the file for assessment. You can refer to the software user information to assist you to overcome issues with spreadsheet development; for example, MS Excel has a support function, available at https://support.microsoft.com/en-us/excel or you can use the Help tab in your MS Excel spreadsheet. Specifically:
- Save the spreadsheet using appropriate filename convention.
- Enter and format the data provided, including if appropriate, shading, bold headings etc.
- Check and amend the data to ensure consistency of design and layout.
- Add 3 extra columns and add the formulae including "Total Weekly Sales", "Forecasted Weekly Sales" and "Variance" for each team member. Should you discover any negative variances (<0) highlight these figures and cells in red.
- Test the formulae to confirm the output is correct.
- make a chart suitable for analysis to show visual representation of each team member's actual sales for the week as compared to their forecasted sales for the week. You can use a colour theme of your choice.
- Using the email template below, compose an email to your manager, Joe Bloggs at WAMco, providing a summary of what you did, and summary points from the spreadsheet and chart. Use a descriptive subject heading./li>
To | |
Subject | |
Attachment (Insert the filename) | |
Evidence required
- The completed Planning Key Questions table.
- Uploaded Weekly Sales Report Spreadsheet and Chart/s - spreadsheet file (e.g. Excel).
- The completed email template.
Introduction To Health Care Management
ISBN: 9781284081015
3rd Edition
Authors: Sharon B. Buchbinder, Nancy H. Shanks