how much would this assessment be
BSBITU304: 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%) Task 3 Create a spreadsheet template Question 1 a) Open a blank Excel workbook and develop a spreadsheet similar to the following b) Insert the Readalot logo.jpg image as the company logo in the centre of the header. (You will need to be in Page Layout view to see the logo) c) Insert the following in the footer using the Header and Footer in the Page Setup section (2016 Excel) or the Header and Footer Elements Group (2013 Excel) · Your Name (left section of the footer); · File Name (middle section of the footer); and · Current Date (right section of the footer) 2016 Excel 2013 Excel Save your spreadsheet file as Sales and Commission Template.xltx (a template file type). Keep your file open for the next question. Question 2 Format your spreadsheet by applying the company Style Guide below. Keep your file open for the next question. Question 3 1. Enter the formula in your spreadsheet to calculate the following. There are no sales data at this stage because it is a template. · Employee Total for each sales employee · The percentage (%) of total sales for each employee by applying absolute cell reference (mandatory) · Total Sales of the quarter · The Commission Earned for each sales employee by applying absolute cell reference (mandatory) · Total Commission of this quarter Enter the Excel function formula to calculate the following. · Average Commission Earned · Maximum Commission Earned · Minimum Commission Earned Enter the Excel automatically updatable date function in cell H2. This function will automatically update the date to today's date. Check the following. Check your formulae to confirm that their outputs are correct and they comply with the task requirements (Tips: This can be done by entering hypothetical sales data into the spreadsheet. Erase your data after checking.) Check your spreadsheet design to ensure that it complies with the company style requirements Save your spreadsheet as Sales and Commission Template.xltx Checklist You have now completed Assessment 1. Please upload your completed work to the OLS website. Make sure you have completed the following tasks below before uploading your assessment. Questions Completed Yes / No Task 1 Questions 1-3 in word document Task 2 Questions 1-4 in word document Task 3 Sales commission template in Excel Assessment 1, LA number [#PRODUCT-NO#], Unit code [#CODE-NO#], Edition number [#EDITION-NO#] 1 © New South Wales Technical and Further Education Commission, [#YEAR#] (TAFE NSW – WSI), Archive version [#VERSION#], [#MONTH#] [#YEAR#] 2LA022560 Assessment 1, Unit BSBITU304, Ed 4 © New South Wales Technical and Further Education Commission, 2017 (TAFE NSW – OTEN), Archive version 1, July 2017 LA022560 Assessment 1, Unit BSBITU304, Ed 4 3 © New South Wales Technical and Further Education Commission, 2017 (TAFE NSW – OTEN), Archive version 1, July 2017