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 (%).
Acest exercițiu face parte din cursul
Analiza datelor în Google Sheets
Instrucțiuni pentru exercițiu
- 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 ($).
Exercițiu interactiv practic
Transformă teoria în practică cu unul dintre exercițiile noastre interactive
Începe exercițiul