Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. 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

Employee

Monday

Tuesday

Wednesday

Thursday

Friday

Tim

2

3

0

3

2

Harpreet

2

2

2

1

1

Frank

4

6

2

4

6

Cindy

2

0

0

3

3

Maree

3

4

2

0

2

Dave

5

6

7

8

3

Jackie

6

7

3

6

6

Rob

2

1

4

2

5

Josie

0

4

5

3

4

Brett

7

6

4

2

6

Forecasted Sales

These are forecasted total weekly sales:

  • Harpreet, Cindy = 10 sales each
  • Tim, Maree, Rob, Josie = 15 sales each
  • Brett = 20 sales
  • Frank, Dave, Jackie = 25 sales each


  1. 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.
  1. 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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Health Care Management

Authors: Sharon B. Buchbinder, Nancy H. Shanks

3rd Edition

128408101X, 9781284081015

More Books

Students also viewed these Finance questions

Question

Why are you interested in our program?

Answered: 1 week ago

Question

Briefly explain the qualities of an able supervisor

Answered: 1 week ago

Question

Define policy making?

Answered: 1 week ago

Question

Define co-ordination?

Answered: 1 week ago

Question

What are the role of supervisors ?

Answered: 1 week ago

Question

What does validation mean? Sensitivity analysis?

Answered: 1 week ago

Question

Give three examples of nonlinear functions or relations.

Answered: 1 week ago