Eployees Salary Details Employee Total Hours Overtime our Income Tas Other Peyour Overtime Grees Pay Net Pay Name Worked Deductibles ours Ahmad SAM $552.00 $240.00 130 $2.000.0 S145 120 le atima $411.00 S.00 S4.000 S1.7.3 $250 20 $4.202.00 S.2L.00 The employee with the max net salary isatima 1. Build the table shown above exactly the same, (pay attention to the styling ex.Merged cells, Borders and alignment). 2- Name the worksheet as " Payroll". 3- Calculate the Gross Pay using the formula: ( Total hours worked pay/hours + total overtime hours * overtime/hour) 4- Calculate the income tax using the formula ( income tax percentage * gross pay → 0.12*gross pay). 5- Add the other deductibles column as it is. 6- Calculate the net pay by using the formula ( gross pay - (income tax + other deductibles). 7. Merge the cells B10:E11) as shown. 8- Find the maximum and minimum values in net pay column and highlight them. 9- Find the average values for the columns as shown. 10- Draw a column chart that shows the gross pay and the net pay for each employee. 11- Protect the worksheet using the password " 1234"
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Step by step
Solved in 3 steps with 2 images