Wamco sales variance analysis for July XX

In July XX Wamco sold three different products. There are three sales representatives who work at Wamco. Bob sells product A; Abdul sells product B and Zac sells product C. If the sales managers achieve 5% more than their budget target the sales representatives are entitled to a bonus. The sales representative's bonus is 10% of the amount of favourable variance between the budget and actual amount for July XX. Using spreadsheet or other software your task is to calculate the variance between the budget and actual results for each product in both dollars and percentages. Where applicable you are required to calculate the bonus amount for each sales representative.

July XX Wamco Sales Variance analysis

Item	Budget	Actual	Variance	%	Bonus amount
Sales Product A- Bob	$250,000	$300,000
Sales Product B-Abdul	$600,000	$800,000
Sales Product C-Zac	$100,000	$70,000

Part 2

Using a spreadsheet or other software you are required produce a simple bar or line chart reflecting the Sales results for Wamco July XX. In the chart you must visually display the budgeted and the actual results for each sales category for Wamco for the month of July XX.