Essay WHS and Organisation Requirements – Annie Wilson Case Study – Law Assignment Help

Assignment Task:

Task 1: WHS and organisation requirements
You work for Readalot Books as an administration employee. Today at work, you encounter the following situations. Attend to each situation in accordance with the company policy requirements. Type your answers in a Word document.

Policy Extracts:
• Every employee is required to maintain a safe and suitable workplace environment including the establishment of an ergonomically correct workstation and safe work
systems.
• All incidents and accidents must be promptly reported to your immediate manager or the WHS officer.
• An attempt to fix a WHS or workplace problem can only be undertaken if it is safe and practical to do so. If unsure, report it to your immediate manager or the WHS
officer.
• Every employee at work must engage conservation practices to conserve energy and minimize wastage. Whenever and wherever possible, limit the usage of paper and
keep printing to a minimum.

Question 1
The electrical cable connected to your computer is frayed and you can see the wires inside. What should you do?

Question 2
Your feet do not touch the floor when you sit at your workstation. What should you do?

Question 3
You have found a MS Office guide on the Internet and believe it is very useful for yourself on the job. The guide consists of 800 pages. The small print in the guide makes your reading rather laborious on a 10.4” LCD computer screen. You prefer to print it out.
a) What could be the conservation issue?
b) What could be the WHS issue in this circumstance?
c) What should you do?

Task 2: Plan a spreadsheet
Annie Wilson, the Sale’s Manager of Readalot Books, asks you to create a spreadsheet that could effectively represent the quarterly sales made by each sales employee.
She specifies the following requirements for the spreadsheet.
i. calculation of sales commission for each sales employee;
ii. calculation of individual employee’s total sales in the quarter;
iii. calculation of individual employee’s sales contribution as a percentage of the total sales;
iv. calculation of total sales in the quarter;
v. calculation of the average commission earned in the quarter;
vi. calculation of maximum commission earned in the quarter; and
vii. calculation of minimum commission earned in the quarter.
All calculations must be automatically performed using a formula, instead of manually entering the calculated amounts into the spreadsheet.
She also instructs you to save the spreadsheet as a template file on the company intranet.
It allows the authorised employees to access and use the template.
Answer the following questions to show your planning of the spreadsheet. Type your answers in a Word document.

Question 1
Identify the purposes of your spreadsheet.

Question 2
Identify two key users of your spreadsheet.

Question 3
Explain an Excel spreadsheet template in your own words.

Question 4
In your own words, write the formula for ii and iii above. See an example below.
(An example: For requirement i, the formula in an individual’s own words is that ‘an
employee’s sales commission is calculated by multiplying his or her total sales in the quarter by a commission rate’. If the total sales in the quarter are $5,000 (for example) and the commission rate is 7%, the commission earned is $350, which is $5,000 x 7%)