fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

3 Pages
Zero-Based Budget

What is a zero-based budget? Develop a plan to implement the zero-based budget in an organization that has previously used as a historical budgeting method. Discuss how such change could be ...

Type

Home Work

Subject

Finance

8 Pages
Management

 Assignment Task You are required to select a profit-making event company of your own choice. The objectives of the company are to expand its business by organising various events for various occ ...

Type

Assignment

Subject

Finance

134 Pages
FINA1035 strategy financial management

You are required to produce a report based on the case study.  The report should answer the following:   1) A) Identify the major strategic business units (SBUs) within the ...

Course

FINA1035

Type

Assignment

Subject

Finance

University

Singapore University of Social Sciences

24 Pages
BSBMGT617 Develop And Implement A Business Plan

Questions: Prior to commencing the assessments, your trainer/assessor will explain each assessment task and the terms and conditions relating to the submission of your assessment task. Please consu ...

Course

BSBMGT617

Type

Assignment

Subject

Finance

University

Gen Institute

Season

Spring

Management

Question

Answered



Task 1

Format the two worksheets to create professional looking work sheets for each of these two worksheets. At this stage, none of the data in the two worksheets should be modified.   Please note the mobile phone number needs to start with a zero. This will also require that you modify row height and column width.  It is best not to use Excel to create tables.

Those columns missing headings, please give the columns appropriate headings.

 

Task 2

After completing task 1, a sequence of tasks needs to be completed on the Employee information worksheet.  These tasks are listed below: Hide the columns that you no longer need as you have formatted them, do NOT delete them.

 

 

1.      Join the State & Postcode data into one column.  This must be done using the various text functions available in Excel.  It will require that you insert one additional column into this worksheet.  One column should be labelled “State Postcode”.  In addition, all excess spaces should be removed from the text and all “State” text should be full upper case.  This must be done using functions from Excel.

2.      All columns should be formatted to use the correct data type for their contents.

3.      Using conditional formatting, identify any cells with missing mobile phone numbers and change their background colour to light green.

4.      Format the data in both “First Name” and “Last Name” and so that it begins with a capital letter. This must be done by using the appropriate Excel function.

5.      Sort the data alphabetically on “Last Name”.  This will put the employee number out of order.

Task 3

1.      Add ta new worksheet to your Excel workbook, called "Payroll summary".  This should be the first worksheet in your workbook.

2.      On the “Payroll summary” worksheet add one named cells called “Medicare_Levy” with a value of 1.5%.  This cell should be appropriately labelled in your worksheet.

3.      Add another named cell to the “Payroll summary” work sheet called “Period_ending” and give it todays date using an Excel Function.

Task 4

1.      On the “Employee information” worksheet, add a column and using an expression, calculate the “Total Tax Rate” for each employee.  This should be the total of the respective employees’ income tax and the medicare levy.  The resulting value should be correctly formatted.

2.      On the “Employee information” worksheet, add a column using an expression, calculate for each employee the value of their “Total Regular Deductions”.  This should not include taxes or the superannuation levy but should include “Other regular deductions” and “Medical insurance”.

Task 5

1.      On the “Payroll calculator” worksheet, retrieve the “Last Name” and “Given Name for each employee.  This must be done using a Vlookup expression.

2.      Display on the “Payroll calculator” worksheet, in the title row, the date value from the “Period ending” named cell in the “Payroll summary” worksheet.  This must be done using an expression.

3.      On the “Payroll calculator” worksheet, in the column labelled “Overtime Rate”, using an expression calculate the overtime rate for each employee.  This should be done by multiplying each employees Hourly Rate (from the “Employee information” work sheet) multiplied by the value 1.5, you may care to make this a standard value in one of your worksheets. Please note that the Payroll Calculator Sheet must be left in Employee number order.

4.      Calculate the gross pay for each employee based on the number of hours worked + sick hours+ vacation hours.  Added to this value must also be payment for overtime. This must be done using an expression.

5.      Using an expression calculate the total taxes and deduction for each employee (We are assuming that the tax rate is flat and this must include the Medicare levy).

6.      Using an expression calculate the nett pay for each employee.  Please note the Superannuation is not deducted.

7.      Using an expression calculate the superannuation liability for each employee which should be done based on each employee’s gross pay multiplied by their individual superannuation rates.

8.      Create a new column and IF the employee received sick pay in the week place “Sick Pay” in this column using an expression.  If they did not receive sick pay nothing should be in this column.

Task 6

On the Payroll summary worksheet do the following and put in a well presented table:

1.      Using an expression on the payroll summary sheet calculate the total gross pay for the company for this pay period, without putting a total on the Payroll Calculator.

2.      Using an expression on the payroll summary sheet calculate the total net pay for the company for this pay period.

3.      Using an expression on the payroll summary sheet calculate the total Tax and payments withheld from the employees, excluding Superannuation for the company for this pay period.

4.      Using an expression on the payroll summary sheet calculate the total superannuation liability for the company for this pay period.

5.      Using an expression on the payroll summary sheet calculate the number of employees who took sick hours for week 1 and separately for week 2 pay period.

6.      Using an expression on the payroll summary sheet count the number of employees currently at work and has not been on leave (no holiday pay) for this pay period.

7.      Using an expression on the payroll summary sheet calculate the number of hours of overtime worked for each week in this pay period.

8.      Using an expression on the payroll summary sheet count the number of employees who worked overtime in each week in this pay period.

9.      In the payroll summary sheet list the employees who worked 7 hours or more overtime in this pay period in a table (do this manually), then in two columns list how many hours they worked in week 1 in column 1 and week 2 in the second column, using their last name as a lookup value.
 

Assignment Requirements and Deliverables

The report is to be prepared as a single Microsoft Excel.

 

Management

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

30 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has achieved the status of the best essay writing service because of an unbreakable record of delivering high-class service. Our efficient team of essay writers are based in different countries including the USA, UK and Australia. We have build teams of native essay writers to deliver country-specific, universities' requirement based custom essay help. Other than making sure that students get customised solutions. We deliver requirement based solutions and ensure that the price remains reasonable so that students can readily access our services. Because of our flexible approach, students who search the internet with search terms like write my essay at a cheap rate, find our service most in sync with their demands.

More Management: Questions & Answers

Q

Zero-Based Budget

What is a zero-based budget? Develop a plan to implement the zero-based budget in an organization that has previously used as a historical budgeting method. Discuss how such change could be achieved from the finance point of view. Suggest that you start with defining what this budgeting pr ...

View Answer
Q

Management

 Assignment Task You are required to select a profit-making event company of your own choice. The objectives of the company are to expand its business by organising various events for various occasions and opportunities in London throughout the year. Assuming you are the assistant financial man ...

View Answer
Q
icon

We aren't endorsed by this University

FINA1035 strategy financial management

You are required to produce a report based on the case study.  The report should answer the following:   1) A) Identify the major strategic business units (SBUs) within the company you have been given to analyse, during the period described in the case study.   B) & ...

View Answer
Q
icon

We aren't endorsed by this University

BSBMGT617 Develop And Implement A Business Plan

Questions: Prior to commencing the assessments, your trainer/assessor will explain each assessment task and the terms and conditions relating to the submission of your assessment task. Please consult with your trainer/assessor if you are unsure of any questions. It is important that you understan ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Emerson Collins

MBA Specialization in Operations

2163 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Ephraim Stearn

LLM in Business Law

136 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Thomas Nelson

MS in Information Systems Technology with Specialization in Database Administration

134 - Completed Orders

Hire Me
student rating student rating student rating student rating student rating
Cecile Leone

Management Maverick

1186 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
26 Jan 2022

Economics

Course Work: 4 Pages, Deadline: 6 days

Thank you for the constant support and understanding and work towards my project

flag User ID: 8***56 Canada

student rating student rating student rating student rating student rating
26 Jan 2022

English

Essay: 8 Pages, Deadline: 10 days

the expert who worked on this assignment did a great job of following all the instruction I provided for this assignment and delivered it perfectly. G ...

flag User ID: 3***04 Melbourne, Bahrain

student rating student rating student rating student rating student rating
25 Jan 2022

Finance

Programming: 2 Pages, Deadline: 23 hours

Good not bad. But if the solution with more analysis and explanation will be great

flag User ID: 8***49 Melbourne, Saudi Arabia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Assignment: 6 Pages, Deadline: 5 days

Perfect work was delivered by the expert, I have been using my assignment help for quite some time now and it has been very helpful in providing excel ...

flag User ID: 8***14 Mississauga, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Chemistry

Assignment: 1 Page, Deadline: 5 days

Assignment was completed as requested! Was very organized and neat. Included all the parts!

flag User ID: 2***50 Kitchener, Canada

student rating student rating student rating student rating student rating
25 Jan 2022

Psychology

Assignment: 4 Pages, Deadline: 1 day

It was a good one thank you. I did have to correct some of the mistakes. After that, everything was good.

flag User ID: 6***66 Kitchener, United States

student rating student rating student rating student rating student rating
25 Jan 2022

Statistics

Programming: 2.6 Pages, Deadline: 7 days

Fully trust this service with perfect score. Would recommend to friends and family. Keep up the good work. Will definitely use the service.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Management

Essay: 6 Pages, Deadline: 2 days

Perfect score. Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Criminal Law

Thesis: 8 Pages, Deadline: 4 days

Great results and the marks was as expected. I trust this service fully with all my assessments.

flag User ID: 6***65 Hughesdale, Australia

student rating student rating student rating student rating student rating
25 Jan 2022

Nursing

Home Work: 1 Page, Deadline: 12 hours

Satisfied with the assignment solution. All is correct, no amendment needed.Thanks

flag User ID: 6***60 Hughesdale, United States

student rating student rating student rating student rating student rating
25 Jan 2022

Geography

Course Work: 5 Pages, Deadline: 6 days

Fast and prompt assignment writing services. The writer was knowledgeable in the particular subject/topics. Will engage them again for future assignme ...

flag User ID: 5***78 Hughesdale, Singapore

student rating student rating student rating student rating student rating
25 Jan 2022

Finance

Assignment: 1 Page, Deadline: 1 day

I manage to add some good point from this presentation to my assignment so thank you so much for your help I\'m awaiting marks at the moment

flag User ID: 2***49 Hughesdale, New Zealand

student rating student rating student rating student rating student rating
25 Jan 2022

HRM

Home Work: 1 Page, Deadline: 6 days

It was good work overall and I love it I will as I said always recommended people if you need help t contact them keep up the good work

flag User ID: 7***37 Hughesdale, United States

student rating student rating student rating student rating student rating
24 Jan 2022

It Write Up

Programming: 4 Pages, Deadline: 4 days

Content is related to my view point and all points are well explained with the help of examples

flag User ID: 8***83 Hughesdale, Canada

student rating student rating student rating student rating student rating
24 Jan 2022

Civil Law

Essay: 2 Pages, Deadline: 18 hours

Quality work and on time. Great site when you are crunched for time. I will use it in the future.

flag User ID: 8***55 Hughesdale, United States

student rating student rating student rating student rating student rating
24 Jan 2022

Networking

Case Study: 8 Pages, Deadline: 4 days

Very pleased with the time of delivery as it was delivered two days before time and also the contents of the file looked really good.

flag User ID: 5***59 Hughesdale, Australia

student rating student rating student rating student rating student rating
24 Jan 2022

HRM

Assignment: 2.6 Pages, Deadline: 3 days

The final draft collaborated with the expert and I was fairly good. I still needed to reword and switch around some stuff, but the paper structure was ...

flag User ID: 7***07 Hughesdale, United States

student rating student rating student rating student rating student rating
24 Jan 2022

Finance

Home Work: 1 Page, Deadline: 13 hours

thank you for fixing my answers and doing it under the 6pm time requested. Deadline was met.

flag User ID: 8***88 Hughesdale, Australia

student rating student rating student rating student rating student rating
24 Jan 2022

Assignment

Assignment: 8 Pages, Deadline: 12 days

Decent prices, live chat is a life saving and I have received my essay on time.Bonus, the last one had a very small similarity. I would never change i ...

flag User ID: 5***94 Nuneaton, Great Britain

student rating student rating student rating student rating student rating
24 Jan 2022

Maths

Home Work: 1 Page, Deadline: 5 days

I just want to thank the person who worked on this assignment, and let them know that I appreciate the care and detail they did on this assignment. I ...

flag User ID: 4***77 Nuneaton, United States

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?