Assignement Task :

 Assessment 1
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%)

 

This Finance Assignment has been solved by our Finance Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Grace
  • Posted on : October 13th, 2018

Whatsapp Tap to ChatGet instant assistance