IdeasCuriosas - Every Question Deserves an Answer Logo

In Business / High School | 2025-07-08

1. An employee works on regular days from 7:00 AM to 7:00 PM with a daily rate of Php675. Using MS Excel, how much did he (WAGE) earn that day? OT/hr = Hourly Rate x 125%. | | A | B | C | D | E | |---|-------|------------|--------------------|----------------|-------| | 1 | | DAILY RATE | TOTAL HOURS WORKED | OVERTIME (HRS) | WAGE | | 2 | DAVID | 675 | 12 | 4 | | a. 1,096.88 b. 1,275.20 c. 1,346.70 d. 1,410.20

Asked by ashled6688

Answer (1)

To calculate the wage that an employee earns in a day when working from 7:00 AM to 7:00 PM, we need to consider both the regular hours and overtime hours. Here, the employee's workday is 12 hours long.

Daily Rate and Hourly Rate : The employee's daily rate is Php 675 for a regular workday of 8 hours. To find the hourly rate, we divide the daily rate by 8: Hourly Rate = 8 675 ​ = 84.375 Php per hour

Overtime Rate : Overtime is paid at 125% of the hourly rate. So the overtime hourly rate would be: Overtime Rate = 84.375 × 1.25 = 105.46875 Php per hour

Regular Hours Calculation : The regular work hours are 8 hours. Regular Pay = 8 × 84.375 = 675 Php

Overtime Hours Calculation : The remaining 4 hours are considered overtime. Overtime Pay = 4 × 105.46875 = 421.875 Php

Total Wage Calculation : Add the regular pay and the overtime pay together to find the total daily wage. Total Wage = 675 + 421.875 = 1 , 096.875 Php


Rounding this off to two decimal places gives us Php 1,096.88.
Thus, the wage David earns for the day is a. 1,096.88 .

Answered by EmmaGraceJohnson | 2025-07-21

Related Questions in Business

[Answered] When the yield to maturity of a bond goes up, the price typically: A. is determined by market factors B. goes down C. does not change D. goes up

[Answered] A type of life insurance policy that requires premiums only for a specified number of years or to a specific age is called a: A. term life policy B. limited pay policy C. key man insurance policy D. split dollar policy

[Answered] Which of the following correctly explains how the concept of demand affects the change in use of credit? Select the two correct answers. A. High interest rates yield low demand for credit. B. Low interest rates yield high demand for credit. C. High interest rates yield high demand for credit. D. Low interest rates yield low demand for credit. E. Both low and high interest rates yield low demand for credit because consumers see it as an indicator that the market is not in equilibrium. Demand is highest when rates are neither too high nor too low.

[Answered] A company is researching mining at four different land areas using different types of equipment. The table below shows the costs of land, equipment, mining, and reclamation for the four locations: | Locations | Cost of land | Cost of equipment | Cost of mining and reclamation | Time taken to mine the area | | --------- | ------------ | ----------------- | -------------------------------- | --------------------------- | | 1 | $100,000 | $10,000 | $5,000 per day | 30 days | | 2 | $35,000 | $6,000 | $4,500 per day | 45 days | | 3 | $30,000 | $7,500 | $3,500 per day | 120 days | | 4 | $40,500 | $8,000 | $7,000 per day | 65 days | Considering all costs, which location will cost the least for the company to mine? A. Location 1 B. Location 2 C. Location 3 D. Location 4

[Answered] Internal-operational communications are messages that A. are circulated both inside and outside a business B. get an organization's work done C. are sent between competing organizations within the same industry D. employees send to discuss strictly personal matters