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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
What is Sales Forecasting Sales forecasting is the process of predicting future sales revenueIts a c...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started