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.
Take the data below and visualize it using Tableau. Are you seeing any trends? Is there a more productive team? Is there a day of the week or department that is more productive? Is there any efficiency trend for teams that had to change the number of styles they worked on during the shift? How does idle time work into your evaluation? Send your Tableau file to me as a packaged workbook (if you do not send the file in this format, I will automatically deduct 1 point). Create a one-page memo discussing what you found. What would you do if all of these teams/individuals reported to you? Each spelling or grammar error is worth 1 point. It is possible to have zero points awarded on this project due to errors.
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 : Associated 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 the history of each team for each day. Targeted 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 the 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 that 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.
