An employee works on regular days from 7:00 AM to 7:00 PM with a daily rate of Php 675. Using MS EXCEL, how much did he earn (WAGE) that day? OT/hr = Hourly Rate x 125%.
| DAILY RATE | TOTAL HOURS WORKED | OVERTIME (HRS) |
|------------|--------------------|----------------|
| 675 | 12 | 4 |
a. 1,096.88
b. 1,275.20
c. 1,346.70
d. 1,410.20
Answer (2)
To calculate the total earnings (WAGE) of the employee for the day using MS Excel, follow these steps:
Determine the Hourly Rate: The hourly rate is calculated by dividing the daily rate by the total number of hours worked in a regular day. Hourly Rate = 12 675 = 56.25 Php/hour
Calculate the Overtime Rate: The overtime rate is 125% of the normal hourly rate. To find this, multiply the hourly rate by 1.25. Overtime Rate = 56.25 × 1.25 = 70.3125 Php/hour
Calculate Overtime Earnings: The overtime earnings are calculated by multiplying the overtime rate by the number of overtime hours. Overtime Earnings = 70.3125 × 4 = 281.25 Php
Calculate Total Earnings (WAGE): The total wage for the day is the sum of the daily rate and the overtime earnings. Total Earnings = 675 + 281.25 = 956.25 Php
Based on the calculations, there seems to be a discrepancy compared to the provided multiple-choice answers. As calculated, the employee earns 956.25 Php for the day, but this option is not listed. It's important to verify if there were additional details or assumptions not considered in the question.
The total earnings for the employee, after calculating the hourly and overtime rates, is 956.25 Php. However, this amount does not correspond with any of the provided options, indicating a possible error in the question details. It’s crucial to verify any omitted information that could affect the calculation.
;
