Use the data below to calculate the labor efficiency variance assuming the actual and standard labor rate is $20 per hour. Overtime is paid at 1.5 times the standard rate and no overtime nor idle time was budgeted when the production standards were created.

Attribute Information:

01 date: Date in MM-DD-YYYY

02 day: Day of the Week

03 quarter: A portion of the month. A month was divided into four quarters

04 department: Associated department with the instance

05 team_no: Associted team number with the instance

06 no_of_workers: Number of workers in each team

07 no_of_style_change: Number of changes in the style of a particular product during a shift

08 targeted_productivity: Targeted productivity based on history for each team for each day. Target productivity is a % of standard and ideally should be 100% (or 1.00). Use this column to compare with actual_productivity, but you won't need to use it in a variance formula.

09 smv: Standard Minute Value , it is the allocated (or budgeted) minutes for one person to complete one unit in the related department.

10 Actual Production: # of units completed by the department

11 over_time: Represents the amount of overtime by each team in minutes. Overtime pay was budgeted to be zero and employees are paid 1.5x the normal rate for overtime.

12 incentive: Represents the amount of financial incentive (in BDT) that enables or motivates a particular course of action. Ignore this column.

13 idle_time: The amount of time when tge production was interrupted due to several reasons

14 idle_men: The number of workers who were idle due to production interruption

15 no_of_style_change: Represents how many times the production line was stopped to change styles, such as moving from sewing or finishing a t-shirt, to setting everything up top sew or finish a sweatshirt.

16 no_of_workers: The number of workers in the department, on that particular shift. A shift is 8 hours.

15 actual_productivity: The actual % of productivity that was delivered by the workers. It ranges from 0-1.