Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Sales Analysis

 

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Prediction VS Actual Performance

BUY | Retail Performer Start

PREDICTION and ACTUAL PERFORMANCE

Prediction : creating a Sales Goal and Roster gives you a Prediction of Wages and Individual Sales Targets.Actual Performance : entering actual performance data in the Performance Scorecard (once the day or week is finished) gives you the ACTUAL ANALYSIS of what took place.Therefore most reports are divided down the center with the Prediction on the left and the Actual Performance on the right of the report layout.

Note in the example report above how the left side shows the Sales Prediction while the right side shows the Actual Performance.

Tracking Last Year's Sale and This Year's Goal Versus Actual Performance

The Weekly Budget Analysis Report

Retail Performer records each Salesperson's sales and compares them to �Last Year's Sales� (what they would have had to make in the same week last year), compared to �This Year's Goal� (what they are expected to make during this week). The purpose of this tracking methodology is to easily and quickly identify who is performing poorly and who is achieving goals.

You can quickly identify your best and worst performers compared to last year and this year. The Salespeople selling LESS than last year, or MORE than last year but LESS than this year, require coaching in a specific area of sales skill � identified in the Weekly KPI Analysis Report (and explained in the next section). The salespeople performing better than this year's goal can be rewarded.

Additionally the Weekly Sales Budget Report above shows Weekly Sales values in Red, Black and Green, revealing, at a glance, how well the Salesperson performed within the parameters of last years sales and this years goal. A Red value indicates the Salesperson sold LESS than Last Year's Sales. A black value indicates the Salesperson performed better than last year but not as well as expected this year. Green values indicate Salespeople are selling more than this year's goal.

Retail Performer Start

Budget Analysis Report of Retail Performer

Retail Performer $34.00 Payment Problems/Options

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.


Instant Download and Money Back Guarantee on Most Software

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft