- Styles Task 6 Calculate Sales And Commissions 1 Using The Information Below Select The Appropriate Technology And Sof 1 (454.13 KiB) Viewed 47 times
i.Total sales for the quarter excluding GST
ii. GST component of the total sales, using an Absolute cell reference
iii.Total quarterly sales including GST amount
iv.Commission on Total Sales excluding GST for each employee, using an Absolute cell reference
v. Totals for each column
3. Under your main table, create a summary that only includes:
· Employees’ names
· Employee’s individual commission, to be paid
· Total row showing total commission for all employees
Insert a formula linking the summary cells back to your main table, so that if you are to change the data in the cells above, your summary will automatically update.
4. Rename the sheet as 1st Quarter Sales.
5. Insert a Pie Chart as an object in the sheet for the commission for each employee, including an appropriate chart title, percentages as your labels and a legend for employee names.
6. Insert a Column Chart as a new sheet (new sheet to be called Monthly Sales Comparison) for the monthly sales for all employees. Include an appropriate chart title and legend with the employees’ names.
7. Proofread your document and check your document to ensure that it meets the requirements of the Plan2go Style Guide.
Styles Task 6: Calculate sales and commissions 1. Using the information below, select the appropriate technology and software to create the following document: Sales Report January - March Total Qurly Employee Commission January February March Total Qtrly Sales excl. GST Sales Incl. GST Alexandra $25,000 $30,000 $27,500 Muir Tracey Holden $15.500 $17,810 $26.480 Raine Bowder $38.000 $10.000 $19,780 Susan Ponyta $7.500 $14,478 $29,000 Lee Tan $35.945 $40,521 $29.654 TOTALS