Calculating product costs
Now it's time to dig into the cost of manufacturing these products!
You'll calculate the Total Cost ($), which comprise of the Cost ($) of raw materials per manufactured product, and the employee's wages. Recall that employees are payed more on weekends, a sum which is calculated by multiplying the Hourly Rate ($) by the Weekend Multiplier (%).
Este exercício faz parte do curso
Data Analysis in Google Sheets
Instruções do exercício
- Calculate the
Wage Cost ($)each day using theHours,Hourly Rate ($),Weekend, andWeekend Multipliercolumns. - Calculate the
Product Cost ($)each day by multiplying the number of products finished each day by theCost ($)of each product. - Calculate the
Total Cost ($)each day by summing theWage Cost ($)and theProduct Cost ($).
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
Começar o exercício