Ii if the target sales revenue is less than rm1200

Info icon This preview shows pages 3–6. Sign up to view the full content.

ii. If the target sales revenue is less than RM1200 but greater than RM900, the performance is “Above average”. iii. If the target sales revenue is less than RM900 but greater than RM500, the performance is “Satisfactory”. iv. If the target sales revenue is less than RM500, the performance is “Below average”. [4 marks] 5. The analysis sheet should consist of the following (but not limited to): a. The sales revenue for each plant (walk in & mail order) b. The total sales revenue for all plants (walk in & mail order) c. The cost for each plant Diploma Asia Pacific University of Technology & Innovation 201709
Image of page 3

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

Practical IT Skills Page 4 of 10 d. The total cost for all plants e. The salary plus commission for each employee f. The total salary plus commission for all employees g. The profit (excluding the rent for the garden, utility bills, etc…) h. Appropriate charts for analysis-purpose (minimum 3 different charts) [5 marks] Recalling to what you have learnt in your PITS class, you realize the significance of having absolute and/or mixed referencing, conditional formatting, and data validation in your spreadsheet. You also understand that using an automated spreadsheet allows user-friendly operation and reduces redundant actions. You want what is best for your business; hence you decided to implement them wherever applicable. [5 marks] Note that you are to create a template spreadsheet to be used monthly; therefore be sure only PERMANENT data, functions, calculation, and information are within the spreadsheet when you save it as a template. Use the name of your company followed by the word template as the template name. To test whether the functionality of the template is appropriate, use the template to create a new workbook. Enter appropriate data into the spreadsheet, and save. Use the current month and year as the name of the workbook. [2 marks] [Total: 25 marks] QUESTION 2- WORD PROCESSOR On the first working day for each month, you will deliver a letter-like report to each of your employee, reflecting on their performance for the previous month. You want the letter-like report to look as professional as possible. Create the letter-like report with the use of mail merge functions, consisting of the following: 1. The letterhead of you company (which include the company name, address, contact details, and logo) and a watermark 2. The issuing date 3. The Staff name and ID Diploma Asia Pacific University of Technology & Innovation 201709
Image of page 4
Practical IT Skills Page 5 of 10 4. The report containing: a. The target sales revenue b. The actual sales revenue accumulated by the employee c. The employee’s work performance (below average, satisfactory, above average, etc…) d. Explanation on the commission rate e. The amount of commission earned by the employee f. Final remarks for the employee to take note on (disciplinary words, encouraging words, complementing words, etc…) 5. The signatory and position 6. Footer (which include company’s slogan or image of company’s product) [5 marks]
Image of page 5

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

Image of page 6
This is the end of the preview. Sign up to access the rest of the document.
  • Summer '14
  • Revenue, sales revenue, Asia Pacific University of Technology & Innovation, asia pacific university

{[ 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