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 (%).
이 연습은 강의의 일부입니다
Google Sheets로 하는 데이터 분석
연습 안내
- 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 ($).
