How you organize the details for the sellers and the sales: Excel Assignment, GCD, Ireland
| University | Griffith College Dublin (GCD) |
| Subject | Excel |
Part 1 – Excel (70% of marks)
Look at the sales figures for the company “Farraige Teoranta” for various products they sell in the spreadsheet Assessment 2 – Sales Data (on Blackboard ).
The layout does not have to be as it currently is on the sheet and it is up to you how you organize the details for the sellers and the sales figures as long as the following requirements are met. You will need to organize and lay out these figures wisely on a spreadsheet based on the requirements below.
Basic data for the calculation
Commission
Below are the commission rates for all the employees for the different products:
Product A Product B Product C Product D
8.5% 7.5% 9.0% 10%
Are You Searching Answer of this Question? Request Ireland Writers to Write a plagiarism Free Copy for You.
Prices
Below are the prices of the products:
Product A: €50 *
Product B: €60 **
Product C: €75
Product D: €95
You can change the product names yourself but print with the same prices.
Changes
The price of Product A increases from €50 to €60 from the beginning of October onwards.
The price of Product B increases from €60 to €75 from the beginning of October onwards.
(So you will need to enter a different price in the last quarter of the year for these products)
Tax Rate
The rate of value added tax (VAT) on all products is 23%.
These basic data (rates/prices etc.) should be stored on a separate worksheet (in one place) and referred to as appropriate.
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
Looking for a homework helper in Ireland? Look no further than our team of experts at Ireland Assignments. We have a wide range of experience helping students with their homework, and we can provide you with the customized help you need to succeed. Whether you're struggling with a specific assignment or you need help understanding the material, we can provide you with the guidance you need.
