question archive Calculate the net annual salary (excluding any commissions earned) for each employee for the 2013 year based on the following criteria: i

Calculate the net annual salary (excluding any commissions earned) for each employee for the 2013 year based on the following criteria: i

Subject:AccountingPrice: Bought3

Calculate the net annual salary (excluding any commissions earned) for each employee for the 2013 year based on the following criteria: i. 2013 starts on a Tuesday (January 1, 2013) and ends on a Tuesday (December 31, 2013). It has a total of 365 days in the year including both weekdays and weekends. There are 104 weekend days (counting every Saturday and Sunday in the year), and 261 weekdays (Monday through Friday). Employees work on a normal 8 hour day on every weekday and don't work any overtime on the weekends, which accumulates a total of 2,088 hours over the 2013 year. ii. Tax rate is a fix rate of 30% for all employees and there are no other deductions. iii. Show only two decimals in your calculations for precision and use appropriate formatting for each cell. Task 5. How can you test your formulas and functions to confirm output meets task requirements? Task 6. Format your worksheet, preview, adjust and print in one A4 page. ormat your worksheet where required. jubmit two outputs: 1. Formula View: Output Showing Formulaes and Functions Column B Column C Values 10 20 Total: =B3+C3 Sum: =SUM(B3:C3) Figure 2: Formula View: output showing Formulas/Functions

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE