4. A Cashier worked on December 25, Sunday from 6:00 AM to 9:00 PM. His daily rate is Php600. Her total earnings Php3334.5 was computed using MS Excel. See table below. First 8 hours = Daily rate x 260%. Regular Holiday/Rest Day OT Pay = Hours of OT x 260% x 130% x hourly rate. What is the correct formula used in getting the earnings of the cashier? | | A | B | C | D | E | F | G | |---|---------|-----------|--------------------|----------------------|----------|------------|------------| | 1 | | DAILY RATE| TOTAL HOURS WORKED | REGULAR WORKING HOURS | OT HOURS | REGULAR PAY| DAILY WAGE | | 2 | CASHIER | 600 | 15 | 8 | 7 | 1560 | 3334.5 | a. =F2+E2*2.6*1.3*(B2*8) b. =F2+E2*260*130*(B2/8) c. =F2*E2*2.6*1.3*(B2/8) d. =F2+E2*2.6%*1.3*(B2/8)
Answer (1)
To compute the earnings of the cashier accurately, we need to consider two components of her pay: the regular hours and the overtime hours on a regular holiday/rest day.
Regular Hours Pay :
The first 8 hours are considered regular working hours. The cashier worked from 6:00 AM to 9:00 PM, totaling 15 hours. For the first 8 hours, the formula for the regular pay is:
R e gu l a r P a y = D ai l y R a t e × 260%
R e gu l a r P a y = 600 × 2.6 = 1560
This matches the 8-hour pay of Php1560 given in the table.
Overtime Pay :
The overtime (OT) hours are the hours worked beyond the regular 8 hours. The cashier worked 15 hours, so the OT hours are 15 − 8 = 7 h o u rs .
The formula for overtime on a regular holiday/rest day is:
OT P a y = OT Ho u rs × 260% × 130% × ( Ho u r l y R a t e )
The hourly rate can be found by dividing the daily rate by 8:
Ho u r l y R a t e = 8 600
Now calculate the OT pay:
OT P a y = 7 × 2.6 × 1.3 × ( 8 600 )
Compute the final earnings:
T o t a l E a r nin g s = R e gu l a r P a y + OT P a y
Given the choices, option a. =F2 + E2 * 2.6 * 1.3 * (B2/8) fits the formula correctly because it adds the regular pay to the correctly calculated overtime pay.
