The employees salary sheet allows you to keep track

Info icon This preview shows pages 2–4. Sign up to view the full content.

View Full Document Right Arrow Icon
The employees’ salary sheet allows you to keep track of each employee’s salary every month, along with their commission (5% per item sold). You have decided that the target sales revenue per employee is RM 700 per month. If an employee has achieved the target, the commission rate is increased to 15% per item sold after the targeted amount. This worksheet keeps track of the plants sold and the amount of revenue received by each employee, and automatically calculates the commission together with the monthly salary. In addition, you want to analyse the sales revenue coming in, the cost for plants and labour, and the profit expected (excluding the rent for the garden, utility bills, etc…). The following are the things you should consider in your spreadsheet: 1. The main page consisting of your company name, company address, company contact details, company logo, and hyperlinks that would allow users to navigate to all the different sheets. All of the different sheets should also have a hyperlink that allows users to navigate back to the main page. [1 mark] 2. The inventory sheet, which should consist of the following (but not limited to): a. Plant ID that is uniquely assigned to all different type plant b. Plant description that describes the type of plant c. Number of each plant bought from suppliers d. Initial cost per number of plant bought from suppliers e. Selling price of each plant (45% in addition to the corresponding initial cost per plant) f. Number of each plant sold g. Number of on hand for each plant that are in stock [3 marks] 3. The sales sheet(s), which should consist of the following (but not limited to): Diploma Asia Pacific University of Technology & Innovation 201709
Image of page 2

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Practical IT Skills Page 3 of 10 a. Plant ID, plant description, selling price, and the number of on hand should be displayed exactly as in the inventory (no modification of data is allowed here) b. Number of plant sold via walk in customers and mail order that would automatically update the inventory’s number of plant sold (access given only to the employee with the corresponding type of plant) **Hint: Protect all non-modified access **Hint: Use passwords to enable access to the employees [5 marks] 4. The employees’ salary sheet should consist of the following (but not limited to): a. Staff’s ID that is uniquely assigned to all employees b. Staff’s name c. Staff’s fix monthly salary d. Staff’s commission i. If the target sales revenue is less than RM700, the commission is 5% from the selling price of the plant sold ii. If the target sales revenue is equal to or greater than RM 700, the plants sold after that will be counted with a commission of 15% from the selling price. e. Staff’s performance i. If the target sales revenue is equal to or greater than RM 1200, the performance is “Good”.
Image of page 3
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern