I need help please.Data is in excel

Data Formulas Review View Help Home Draw File Insert Page Layout General X Cut Wrap Text Calibri 11 ' ' 11 lili O Copy ilil OA Merge & Center Paste $%98- BIU G Format Painter Clipboard Number Font 27 Alignment fy B25 F G H H - B D E 1 2 3 Sum of Total_Hours Average of Hourly_Rate 2,389,088 4 239682 9.967741935 5 6 7 2,389,088 8 480,000 Budget standart cost in labor 9 2,389,088 Actual 10 (1,909,088) Unfaborable Labeor spending variance 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Chart Title 26 27 28 29 Pivot 1 Pivot 2 Payroll HR Data Template + File Home Insert Uraw General 11 = = Calibri ' 2 Wrap Text Merge & Center $ % X Cut [B Copy Format Painter Clipboard Paste BIU a.A. Nur Font Alignment is C25 f E D F G G H B Sum of Total_Hours Average of Hourly_Rate 46302 10.25 48450 10.00 38400 11.00 57780 9.00 48750 10.00 239682 9.967741935 1 2 3 Row Labels 4 Plant 1 5 Plant 2 6 Plant 3 7 Plant 4 8 Plant 5 9 (blank) 10 Grand Total 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 Pivot 1 Pivot 2 Payroll HR Data Template Ready li ill 11 - 3 Cells Number Styles Alignment L M N N K G H SR Location Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 AH 46302 48450 38400 57780 48750 AR 10.25 10.00 11.00 9.00 10.00 SH 48000 48000 48000 48000 48000 10 10 10 10 10 AH (AR-SR) SR (AH-SH) Labor Rate Var Labor Efficiency Var 11,576 (16,980) 4,500 38,400 (96,000) (57,780) 97,800 7,500 17,805) (3,180) Font 5 Es Clipboard Alignment XV fx 034 F G G H A B D E 13 14 Row Labe Sum of To Average of Hourly_Rate 15 Plant 1 46302 10.25 16 Plant 2 48450 10.00 17 Plant 3 38400 11.00 18 Plant 4 57780 9.00 19 Plant 5 48750 10.00 20 (blank) 21 Grand Total 239682 9.967741935 22 23 24 25 Labor Rate Var 26 60,000 27 28 38,400 40,000 29 30 20,000 11,576 31 Plot Area 32 33 (20,000) 34 (40,000) 35 36 (60,000) 37 (80,000) 38 Plant 1 Plant 2 Plant 3 39 40 41 Pivot 1 Pivot 2 Payroll HR Data Tem + (1 (15 (57,780) Plant 4 Chart Area Ready Type here to search O BI CI Wrap Text General 11 - A A OA Insert Delete Tomat Sort Merge Center $ % 8.99 Clear Conditional Formatas Cell Formatting Table Styles styles 5 Number Cell Aligt for Loting 19 f N O P Q M R 5 U T V H 9.00 10.00 1 48000 48000 L (57,780) 10 10 97800 7,500 (3,180) AR VS SR (7,805) 12.00 3000 6.00 ITUT 400 200 Chart Title 000 Pant! PO Plant 150,000 ant ISR 300.000 50.000 (50.00 1100.000 (1 Ps Plant laborate officient Payroll HR Data Tem File forUnemploym. Course Home elers EDGE Pro A Read aloud Add text Draw Highl + ID Page view Introduction Wingo's Widgets is a large privately held company headquartered in Lincoln, Nebraska that provides specialty widgets to companies all over the world. The company was founded in 1960 by Wingo Tillman as a family business employing 5 employees. As of yearend 2020 the company employs over 850 employees. The current CEO of the company is Charles Tillman, Wingo's grandson. Relevant Personnel Tonya Griff was hired by Charles Tillman in 2015 as a consultant. The company had been experiencing a period of growing pains leading to order shortfalls and lost revenues. The company lacked the capacity to keep up with thriving demand. Charles was impressed with Tonya's vision to decentralize production to five strategically placed plants near the company's headquarters. Each of the five locations were in similar working-class localities. This would allow the company to expand operations and enhance distribution channels. All five plants were operational by the end of 2017. Tonya was promoted to AVP of Production and was put in charge of managing the plants. Charles gave Tonya permission to hire additional personnel as needed to support operations. For several months Tonya tried to manage all five plants herself, but quickly realized she was in over her head. It was too difficult managing the day-to-day operation of the five plants when she was physically located at headquarters. In April of 2018 Tonya hired five production managers to oversee each of the five locations. As shown in Figure 1, Gregs. Sarah, Lisa, Armando, and Isiah each report directly to Tonya Labor Standards and expectations While Tonya was skilled at growing the business, dealing with human resource and compensation related items were not in her wheelhouse. She confided in a few of her mentors in similar industries for advice on how to manage her new direct reports. It was recommended that she construct standard labor efficiency and standard labor rates to serve as overall guidance for the plant managers. These standards would serve as benchmarks to help guide each of the managers. Tonya recommended that each manager follow the standards developed, however she allowed each of the managers the flexibility to deviate from standards as they deemed appropriate. Hitting the production target was all that Tonya cared about. For 2020, Tonya informed each manager that they were responsible for processing 20,000 widgets per month (240,000 for the year). Based on the standards, the expected labor cott for each plant would be $480,000 for the year. See Table 1 for the standards developed by Tonya OBE Course Home Scholarship Finder | D Job Finder | Jobs ScieMe link How do Travelers EDGE Pro File for unemploym... ID Page view A Read aloud 1 Add text + 2 Draw Highlight Labor Standards and Expectations While Tonya was skilled at growing the business, dealing with human resource and compensation related items were not in her wheelhouse. She confided in a few of her mentors in similar industries for advice on how to manage her new direct reports. It was recommended that she construct standard labor efficiency and standard labor rates to serve as overall guidance for the plant managers. These standards would serve as benchmarks to help guide each of the managers. Tonya recommended that each manager follow the standards developed, however she allowed each of the managers the flexibility to deviate from standards as they deemed appropriate. Hitting the production target was all that Tonya cared about. For 2020, Tonya informed each manager that they were responsible for processing 20,000 widgets per month (240,000 for the year). Based on the standards, the expected labor cost for each plant would be $180,000 for the year. See Table 1 for the standards developed by Tonya and her calculation of total labor expense. Bonus Allocations Wingo's Widgets had a profitable 2020. In January of 2021, Charles met with Tonya and informed her that there was $50,000 available in the bonus pool specifically for the five production managers, Tonya was responsible for allocating the bonuses as she saw fit. Tonya recalled that each manager successfully met the goal of processing the 240,000 units requested, so she deemed it fair to reward each of the managers equally. She also looked at the spending variance report and noted that direct labor was slightly a favorable variance. In her mind, each manager must have been on par with the others, and it wasn't worth digging into given the small variance that existed. Tonya sent an email to the managers to inform them they would each betting a check for $10,000. See Table 2 for the O i File forUnemploym... Course Home Scholarship Finder | Job Finder | Jobs IC. ScieMe link How do Travelers EDGE PIO. L Page view A Read aloud 1 Add text Draw + 9 Highlight Labor Standards and Expectations While Tonya was skilled at growing the business, dealing with human resource and compensation related items were not in her wheelhouse. She confided in a few of her mentors in similar industries for advice on how to manage her new direct reports. It was recommended that she construct standard labor efficiency and standard labor rates to serve as overall guidance for the plant managers. These standards would serve as benchmarks to help guide each of the managers. Tonya recommended that each manager follow the standards developed, however she allowed each of the managers the flexibility to deviate from standards as they deemed appropriate. Hitting the production target was all that Tonya cared about. For 2020, Tonya informed each manager that they were responsible for processing 20,000 widgets per month (240,000 for the year). Based on the standards, the expected labor cost for each plant would be $480,000 for the year. See Table 1 for the standards developed by Tonya and her calculation of total labor expense. Bonus Allocations Wingo's Widgets had a profitable 2020. In January of 2021, Charles met with Tonya and informed her that there was $50,000 available in the bonus pool specifically for the five production managers. Tonya was responsible for allocating the bonuses as she saw fit. Tonya recalled that each manager successfully met the goal of processing the 240,000 units requested, so she deemed it fair to reward each of the managers equally. She also looked at the spending variance report and noted that direct labor was slightly a favorable variance. In her mind, each manager must have been on par with the others, and it wasn't worth digging into given the small variance that existed. Tonya sent an email to the managers to inform them they would each be getting a check for $10,000. See Table 2 for the a proiectoa ktop/ac%20301%20project.pdf Course Home Scholarship Finder... Job Finder Jobs CD scieMce link D How did Native Am File forunemploym.. avelers EDGE Pro Highlight Erase ID Page view A Read aloud to Add textDraw + the managers to inform them they would each be getting a check for $10,000. See Table 2 for the Spending Variance report. The next morning, Tonya got a call from Armando, the plant manager of Plant 4. After exchanging pleasantries, Armando shared with Tonya that he had some concerns about his bonus. The conversation went as follows: Armando: Tonya, I was pleasantly surprised that we would be receiving a bonus this year. That said, I was a little surprised that the money was equally split amongst the five of us. I don't want to come across as ungrateful, but would you be able to provide some detail as to how you landed on the equal split? Tonya: You and the other plant managers worked really hard throughout the year. The bonus was earned and I'm grateful to have you all on my team! I don't see your question as being ungrateful You know that I try to be as transparent as possible with you. Regarding the allocation, I felt that since each of you met the overall output target, and the overall direct labor variance was slightly favorable, all five of you were performing on par with your peers. Armando: Tonya, I can appreciate what you said about hitting output targets, and I'm glad each of us were able to do that. However, isce a big issue with how you interpretated the favorable labor variance. The report that you are using is an aggregate of all five locations. It's extremely likely in this case that a favorable variance by one location is hiding the unfavorable variance by another Tonya: Hmm.. what exactly do you mean? Can you be more specific? Armando: Well, I made changes this year in my plant. Rather than using the standard hourly wage rate of $10, I am only paying my employees $9 per hour. This $1 decrease from the standard had to have a positive impact on my plants total labor cost, and I believe is responsible for the positive variance you are seeing. In fact, the variance should probably be much higher...which means there are probably issues at other plants that you are missing. For this reason, I think my bonus should be higher than my peers. I found a way to save the company money! Tonya: Armando, I didn't realize you are paying your employees less than the $10 per hour standard rate and i can see how that might impact the total labor cost associated with your plant. I think this warrants a deeper dive into the numbers to better understand performance across each of the plants. Thank you for bringing this to my attention. I'm going to reach out to one of the financial analysts to do a deeper dive into the labor variance: O 1 project.pdf Ektop/ac%20301%20project.pdf avelers EDGE Pro... File forUnemploym... Course Home Scholarship Finder Job Finder | Jobs |C. ScieMce link How did + DE D Page view A Read aloud Add text Draw Highlight Armando: Well, I made changes this year in my plant. Rather than using the standard hourly wage rate of $10, I am only paying my employees $9 per hour. This $1 decrease from the standard had to have a positive impact on my plants total labor cost, and I believe is responsible for the positive variance you are seeing. In fact, the variance should probably be much higher... which means there are probably issues at other plants that you are missing. For this reason, I think my bonus should be higher than my peers. I found a way to save the company money! Tonya: Armando, I didn't realize you are paying your employees less than the $10 per hour standard rate and can see how that might impact the total labor cost associated with your plant. I think this warrants a deeper dive into the numbers to better understand performance across each of the plants. Thank you for bringing this to my attention. I'm going to reach out to one of the financial analysts to do a deeper dive into the labor variance. Tonya and Armando ended the call. Tonya called Chip Witherspoon, one of the company's leading financial analysts, and explained to him the situation. Tonya provided Chip with a full dataset of all of the payroll and relevant information needed for him to perform his analysis. avelers EDGE Pro File forUnemploym. Course Home Scholarship Finder - Job Finder | Jobs CD scieMice link How did Native Am + D Page view A Read aloud Erase 0 Add textDraw Highlight Armando: Well, I made changes this year in my plant. Rather than using the standard hourly wage rate of $10, I am only paying my employees 59 per hour. This $1 decrease from the standard had to have a positive impact on my plants total labor cost, and I believe is responsible for the positive variance you are seeing. In fact, the variance should probably be much higher, which means there are probably issues at other plants that you are missing. For this reason, I think my bonus should be higher than my peers. I found a way to save the company money! Tonya: Armando, I didn't realize you are paying your employees less than the $10 per hour standard rate and lcan see how that might impact the total labor cost associated with your plant. I think this warrants a deeper dive into the numbers to better understand performance across each of the plants. Thank you for bringing this to my attention. I'm going to reach out to one of the financial analysts to do a deeper dive into the labor variance. Tonya and Armando ended the call. Tonya called Chip Witherspoon, one of the company's leading financial analysts, and explained to him the situation. Tonya provided Chip with a full dataset of all of the payroll and relevant information needed for him to perform his analysis. Figure 1: Org. Chart Tonya Git AVP Operations Gregg Production Manager Plant 1 Sarah Production Manager Plant 2 Produktion Manager Plant Armando Production Manager Plant 4 Ilahi Production Manager Plants Table 1: 0.2 Standards: Standard Labor Rate per Hour $10 Standard Hours Per Widget Expectations: 20,000 Widgets processed per month by each location Calculations Widgets Processed (20K x 12 months) Standard Hours Per Widget Total Standard Hours Standard Labor Rate Total Standard Labor Cost per Location Locations Total Standard Labor Cost 240,000 02 48,000 10 480,000 2,400,000 599/Desktop/a%20301%20project.pdf Travelers EDGE Pro File forUnemploym... Course Home Scholarship Finder | Job Finder Jobs CD scieMce link How did Natiu ID Page view A Read aloud Add text Draw Highlight Table 2: Wingo's Widgets Production Department Spending Variances For Year Ended December 31, 2020 (in thousands) Actual Results 1,200 Flexible Spending Budget Variances 1.200 Items Processed: Expenses: Direct Materials Direct Labor Overhead Electricity Rent Insurance Misc Total Expenses: 3.450 2,400 1,600 55 3,489 2,389 1.545 47 350 80 14 2.914 (39) U 11 F 55 F 8 F (25) U (210 11 11 325 78 11 7.925 The expense variances are labeled favorable (unfavorable) when the actual expense is less than caveater than the * 301 project par 99/Desktop/ac%20301%20project.pdf Course Home Scholarship Finder | Job Finder Jobs ScieMce link How did Nat Travelers EDGE Pro. File forUnemploym... Page view A Read aloud Add text V Draw Highlight Discussion Questions: 1. Looking at Exhibit 1, which of the overall revenue and spending variances do you believe warrant further investigation by Tim? What criteria did you use to come to that decision? 2. Use the information in the included excel file and the information provided by Tonya to calculate the overall labor spending variance for the company. 3. Additionally, you should also calculate the labor rate and labor efficiency variances 4. To gain further insight into the activities of each plant, calculate the overall labor spending variance, labor rate, and labor efficiency variances by plant. Provide a visualization that best portrays your findings 5. What are the positives and negatives of paying all managers the same bonus? 6. What are some advantages and disadvantages of using a spending variance as a mechanism for performance evaluation? 7. Describe the ethical issues present in the case. What ethical issues may come to light if the bonus is paid entirely based on the overall labor spending variance? What about if it's based on the labor rate variance alone? How might management overcome the potential for people to act unethically? 8. Based on your thorough analysis of labor, what recommendations do you have for management surrounding the distribution of the bonuses? Summarize your conclusions in a memorandum addressed to Tim in the memo, you must clearly communicate your recommendation, while considering the advantages and disadvantages of your recommendation and any ethical Implications 9. As a result of investigating the direct labor rate and efficiency variances for ABC Corp, what has this exercise taught you about the importance of responsibility accounting in budgeting and variance analysis? Learning Objectives: After completing this activity, students should be able to: 1. Calculate and interpret the overall labor spending variance, labor rate variance, and labor efficiency variance 2. Use (a) Excel. (b) Tableau, and/or (c) Power BI to analyze a large data set and create a data 1 + + bonus is paid entirely based on the overall labor spending variance? What about if it's based on the labor rate variance alone? How might management overcome the potential for people to act unethically? 8. Based on your thorough analysis of labor, what recommendations do you have for management surrounding the distribution of the bonuses? Summarize your conclusions in a memorandum addressed to Tim. In the memo, you must clearly communicate your recommendation, while considering the advantages and disadvantages of your recommendation and any ethical Implications 9. As a result of investigating the direct labor rate and efficiency variances for ABC Corp, what has this exercise taught you about the importance of responsibility accounting in budgeting and variance analysis? Learning Objectives: After completing this activity, students should be able to: 1. Calculate and interpret the overall labor spending variance, labor rate variance, and labor efficiency variance 2. Use (a) Excel. (b) Tableau, and/or (c) Power BI to analyze a large data set and create a data visualization that effectively communicates the findings 3. Think critically about accounting and managerial decisions 4. Analyze the potential for management decisions to incentivize unethical behavior and develop suggestions for management to reduce the likelihood of unethical behavior, 5. Communicate the results of an analysis clearly and effectively. 6. Understand the importance of responsibility accounting. Data Formulas Review View Help Home Draw File Insert Page Layout General X Cut Wrap Text Calibri 11 ' ' 11 lili O Copy ilil OA Merge & Center Paste $%98- BIU G Format Painter Clipboard Number Font 27 Alignment fy B25 F G H H - B D E 1 2 3 Sum of Total_Hours Average of Hourly_Rate 2,389,088 4 239682 9.967741935 5 6 7 2,389,088 8 480,000 Budget standart cost in labor 9 2,389,088 Actual 10 (1,909,088) Unfaborable Labeor spending variance 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Chart Title 26 27 28 29 Pivot 1 Pivot 2 Payroll HR Data Template + File Home Insert Uraw General 11 = = Calibri ' 2 Wrap Text Merge & Center $ % X Cut [B Copy Format Painter Clipboard Paste BIU a.A. Nur Font Alignment is C25 f E D F G G H B Sum of Total_Hours Average of Hourly_Rate 46302 10.25 48450 10.00 38400 11.00 57780 9.00 48750 10.00 239682 9.967741935 1 2 3 Row Labels 4 Plant 1 5 Plant 2 6 Plant 3 7 Plant 4 8 Plant 5 9 (blank) 10 Grand Total 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 29 Pivot 1 Pivot 2 Payroll HR Data Template Ready li ill 11 - 3 Cells Number Styles Alignment L M N N K G H SR Location Plant 1 Plant 2 Plant 3 Plant 4 Plant 5 AH 46302 48450 38400 57780 48750 AR 10.25 10.00 11.00 9.00 10.00 SH 48000 48000 48000 48000 48000 10 10 10 10 10 AH (AR-SR) SR (AH-SH) Labor Rate Var Labor Efficiency Var 11,576 (16,980) 4,500 38,400 (96,000) (57,780) 97,800 7,500 17,805) (3,180) Font 5 Es Clipboard Alignment XV fx 034 F G G H A B D E 13 14 Row Labe Sum of To Average of Hourly_Rate 15 Plant 1 46302 10.25 16 Plant 2 48450 10.00 17 Plant 3 38400 11.00 18 Plant 4 57780 9.00 19 Plant 5 48750 10.00 20 (blank) 21 Grand Total 239682 9.967741935 22 23 24 25 Labor Rate Var 26 60,000 27 28 38,400 40,000 29 30 20,000 11,576 31 Plot Area 32 33 (20,000) 34 (40,000) 35 36 (60,000) 37 (80,000) 38 Plant 1 Plant 2 Plant 3 39 40 41 Pivot 1 Pivot 2 Payroll HR Data Tem + (1 (15 (57,780) Plant 4 Chart Area Ready Type here to search O BI CI Wrap Text General 11 - A A OA Insert Delete Tomat Sort Merge Center $ % 8.99 Clear Conditional Formatas Cell Formatting Table Styles styles 5 Number Cell Aligt for Loting 19 f N O P Q M R 5 U T V H 9.00 10.00 1 48000 48000 L (57,780) 10 10 97800 7,500 (3,180) AR VS SR (7,805) 12.00 3000 6.00 ITUT 400 200 Chart Title 000 Pant! PO Plant 150,000 ant ISR 300.000 50.000 (50.00 1100.000 (1 Ps Plant laborate officient Payroll HR Data Tem File forUnemploym. Course Home elers EDGE Pro A Read aloud Add text Draw Highl + ID Page view Introduction Wingo's Widgets is a large privately held company headquartered in Lincoln, Nebraska that provides specialty widgets to companies all over the world. The company was founded in 1960 by Wingo Tillman as a family business employing 5 employees. As of yearend 2020 the company employs over 850 employees. The current CEO of the company is Charles Tillman, Wingo's grandson. Relevant Personnel Tonya Griff was hired by Charles Tillman in 2015 as a consultant. The company had been experiencing a period of growing pains leading to order shortfalls and lost revenues. The company lacked the capacity to keep up with thriving demand. Charles was impressed with Tonya's vision to decentralize production to five strategically placed plants near the company's headquarters. Each of the five locations were in similar working-class localities. This would allow the company to expand operations and enhance distribution channels. All five plants were operational by the end of 2017. Tonya was promoted to AVP of Production and was put in charge of managing the plants. Charles gave Tonya permission to hire additional personnel as needed to support operations. For several months Tonya tried to manage all five plants herself, but quickly realized she was in over her head. It was too difficult managing the day-to-day operation of the five plants when she was physically located at headquarters. In April of 2018 Tonya hired five production managers to oversee each of the five locations. As shown in Figure 1, Gregs. Sarah, Lisa, Armando, and Isiah each report directly to Tonya Labor Standards and expectations While Tonya was skilled at growing the business, dealing with human resource and compensation related items were not in her wheelhouse. She confided in a few of her mentors in similar industries for advice on how to manage her new direct reports. It was recommended that she construct standard labor efficiency and standard labor rates to serve as overall guidance for the plant managers. These standards would serve as benchmarks to help guide each of the managers. Tonya recommended that each manager follow the standards developed, however she allowed each of the managers the flexibility to deviate from standards as they deemed appropriate. Hitting the production target was all that Tonya cared about. For 2020, Tonya informed each manager that they were responsible for processing 20,000 widgets per month (240,000 for the year). Based on the standards, the expected labor cott for each plant would be $480,000 for the year. See Table 1 for the standards developed by Tonya OBE Course Home Scholarship Finder | D Job Finder | Jobs ScieMe link How do Travelers EDGE Pro File for unemploym... ID Page view A Read aloud 1 Add text + 2 Draw Highlight Labor Standards and Expectations While Tonya was skilled at growing the business, dealing with human resource and compensation related items were not in her wheelhouse. She confided in a few of her mentors in similar industries for advice on how to manage her new direct reports. It was recommended that she construct standard labor efficiency and standard labor rates to serve as overall guidance for the plant managers. These standards would serve as benchmarks to help guide each of the managers. Tonya recommended that each manager follow the standards developed, however she allowed each of the managers the flexibility to deviate from standards as they deemed appropriate. Hitting the production target was all that Tonya cared about. For 2020, Tonya informed each manager that they were responsible for processing 20,000 widgets per month (240,000 for the year). Based on the standards, the expected labor cost for each plant would be $180,000 for the year. See Table 1 for the standards developed by Tonya and her calculation of total labor expense. Bonus Allocations Wingo's Widgets had a profitable 2020. In January of 2021, Charles met with Tonya and informed her that there was $50,000 available in the bonus pool specifically for the five production managers, Tonya was responsible for allocating the bonuses as she saw fit. Tonya recalled that each manager successfully met the goal of processing the 240,000 units requested, so she deemed it fair to reward each of the managers equally. She also looked at the spending variance report and noted that direct labor was slightly a favorable variance. In her mind, each manager must have been on par with the others, and it wasn't worth digging into given the small variance that existed. Tonya sent an email to the managers to inform them they would each betting a check for $10,000. See Table 2 for the O i File forUnemploym... Course Home Scholarship Finder | Job Finder | Jobs IC. ScieMe link How do Travelers EDGE PIO. L Page view A Read aloud 1 Add text Draw + 9 Highlight Labor Standards and Expectations While Tonya was skilled at growing the business, dealing with human resource and compensation related items were not in her wheelhouse. She confided in a few of her mentors in similar industries for advice on how to manage her new direct reports. It was recommended that she construct standard labor efficiency and standard labor rates to serve as overall guidance for the plant managers. These standards would serve as benchmarks to help guide each of the managers. Tonya recommended that each manager follow the standards developed, however she allowed each of the managers the flexibility to deviate from standards as they deemed appropriate. Hitting the production target was all that Tonya cared about. For 2020, Tonya informed each manager that they were responsible for processing 20,000 widgets per month (240,000 for the year). Based on the standards, the expected labor cost for each plant would be $480,000 for the year. See Table 1 for the standards developed by Tonya and her calculation of total labor expense. Bonus Allocations Wingo's Widgets had a profitable 2020. In January of 2021, Charles met with Tonya and informed her that there was $50,000 available in the bonus pool specifically for the five production managers. Tonya was responsible for allocating the bonuses as she saw fit. Tonya recalled that each manager successfully met the goal of processing the 240,000 units requested, so she deemed it fair to reward each of the managers equally. She also looked at the spending variance report and noted that direct labor was slightly a favorable variance. In her mind, each manager must have been on par with the others, and it wasn't worth digging into given the small variance that existed. Tonya sent an email to the managers to inform them they would each be getting a check for $10,000. See Table 2 for the a proiectoa ktop/ac%20301%20project.pdf Course Home Scholarship Finder... Job Finder Jobs CD scieMce link D How did Native Am File forunemploym.. avelers EDGE Pro Highlight Erase ID Page view A Read aloud to Add textDraw + the managers to inform them they would each be getting a check for $10,000. See Table 2 for the Spending Variance report. The next morning, Tonya got a call from Armando, the plant manager of Plant 4. After exchanging pleasantries, Armando shared with Tonya that he had some concerns about his bonus. The conversation went as follows: Armando: Tonya, I was pleasantly surprised that we would be receiving a bonus this year. That said, I was a little surprised that the money was equally split amongst the five of us. I don't want to come across as ungrateful, but would you be able to provide some detail as to how you landed on the equal split? Tonya: You and the other plant managers worked really hard throughout the year. The bonus was earned and I'm grateful to have you all on my team! I don't see your question as being ungrateful You know that I try to be as transparent as possible with you. Regarding the allocation, I felt that since each of you met the overall output target, and the overall direct labor variance was slightly favorable, all five of you were performing on par with your peers. Armando: Tonya, I can appreciate what you said about hitting output targets, and I'm glad each of us were able to do that. However, isce a big issue with how you interpretated the favorable labor variance. The report that you are using is an aggregate of all five locations. It's extremely likely in this case that a favorable variance by one location is hiding the unfavorable variance by another Tonya: Hmm.. what exactly do you mean? Can you be more specific? Armando: Well, I made changes this year in my plant. Rather than using the standard hourly wage rate of $10, I am only paying my employees $9 per hour. This $1 decrease from the standard had to have a positive impact on my plants total labor cost, and I believe is responsible for the positive variance you are seeing. In fact, the variance should probably be much higher...which means there are probably issues at other plants that you are missing. For this reason, I think my bonus should be higher than my peers. I found a way to save the company money! Tonya: Armando, I didn't realize you are paying your employees less than the $10 per hour standard rate and i can see how that might impact the total labor cost associated with your plant. I think this warrants a deeper dive into the numbers to better understand performance across each of the plants. Thank you for bringing this to my attention. I'm going to reach out to one of the financial analysts to do a deeper dive into the labor variance: O 1 project.pdf Ektop/ac%20301%20project.pdf avelers EDGE Pro... File forUnemploym... Course Home Scholarship Finder Job Finder | Jobs |C. ScieMce link How did + DE D Page view A Read aloud Add text Draw Highlight Armando: Well, I made changes this year in my plant. Rather than using the standard hourly wage rate of $10, I am only paying my employees $9 per hour. This $1 decrease from the standard had to have a positive impact on my plants total labor cost, and I believe is responsible for the positive variance you are seeing. In fact, the variance should probably be much higher... which means there are probably issues at other plants that you are missing. For this reason, I think my bonus should be higher than my peers. I found a way to save the company money! Tonya: Armando, I didn't realize you are paying your employees less than the $10 per hour standard rate and can see how that might impact the total labor cost associated with your plant. I think this warrants a deeper dive into the numbers to better understand performance across each of the plants. Thank you for bringing this to my attention. I'm going to reach out to one of the financial analysts to do a deeper dive into the labor variance. Tonya and Armando ended the call. Tonya called Chip Witherspoon, one of the company's leading financial analysts, and explained to him the situation. Tonya provided Chip with a full dataset of all of the payroll and relevant information needed for him to perform his analysis. avelers EDGE Pro File forUnemploym. Course Home Scholarship Finder - Job Finder | Jobs CD scieMice link How did Native Am + D Page view A Read aloud Erase 0 Add textDraw Highlight Armando: Well, I made changes this year in my plant. Rather than using the standard hourly wage rate of $10, I am only paying my employees 59 per hour. This $1 decrease from the standard had to have a positive impact on my plants total labor cost, and I believe is responsible for the positive variance you are seeing. In fact, the variance should probably be much higher, which means there are probably issues at other plants that you are missing. For this reason, I think my bonus should be higher than my peers. I found a way to save the company money! Tonya: Armando, I didn't realize you are paying your employees less than the $10 per hour standard rate and lcan see how that might impact the total labor cost associated with your plant. I think this warrants a deeper dive into the numbers to better understand performance across each of the plants. Thank you for bringing this to my attention. I'm going to reach out to one of the financial analysts to do a deeper dive into the labor variance. Tonya and Armando ended the call. Tonya called Chip Witherspoon, one of the company's leading financial analysts, and explained to him the situation. Tonya provided Chip with a full dataset of all of the payroll and relevant information needed for him to perform his analysis. Figure 1: Org. Chart Tonya Git AVP Operations Gregg Production Manager Plant 1 Sarah Production Manager Plant 2 Produktion Manager Plant Armando Production Manager Plant 4 Ilahi Production Manager Plants Table 1: 0.2 Standards: Standard Labor Rate per Hour $10 Standard Hours Per Widget Expectations: 20,000 Widgets processed per month by each location Calculations Widgets Processed (20K x 12 months) Standard Hours Per Widget Total Standard Hours Standard Labor Rate Total Standard Labor Cost per Location Locations Total Standard Labor Cost 240,000 02 48,000 10 480,000 2,400,000 599/Desktop/a%20301%20project.pdf Travelers EDGE Pro File forUnemploym... Course Home Scholarship Finder | Job Finder Jobs CD scieMce link How did Natiu ID Page view A Read aloud Add text Draw Highlight Table 2: Wingo's Widgets Production Department Spending Variances For Year Ended December 31, 2020 (in thousands) Actual Results 1,200 Flexible Spending Budget Variances 1.200 Items Processed: Expenses: Direct Materials Direct Labor Overhead Electricity Rent Insurance Misc Total Expenses: 3.450 2,400 1,600 55 3,489 2,389 1.545 47 350 80 14 2.914 (39) U 11 F 55 F 8 F (25) U (210 11 11 325 78 11 7.925 The expense variances are labeled favorable (unfavorable) when the actual expense is less than caveater than the * 301 project par 99/Desktop/ac%20301%20project.pdf Course Home Scholarship Finder | Job Finder Jobs ScieMce link How did Nat Travelers EDGE Pro. File forUnemploym... Page view A Read aloud Add text V Draw Highlight Discussion Questions: 1. Looking at Exhibit 1, which of the overall revenue and spending variances do you believe warrant further investigation by Tim? What criteria did you use to come to that decision? 2. Use the information in the included excel file and the information provided by Tonya to calculate the overall labor spending variance for the company. 3. Additionally, you should also calculate the labor rate and labor efficiency variances 4. To gain further insight into the activities of each plant, calculate the overall labor spending variance, labor rate, and labor efficiency variances by plant. Provide a visualization that best portrays your findings 5. What are the positives and negatives of paying all managers the same bonus? 6. What are some advantages and disadvantages of using a spending variance as a mechanism for performance evaluation? 7. Describe the ethical issues present in the case. What ethical issues may come to light if the bonus is paid entirely based on the overall labor spending variance? What about if it's based on the labor rate variance alone? How might management overcome the potential for people to act unethically? 8. Based on your thorough analysis of labor, what recommendations do you have for management surrounding the distribution of the bonuses? Summarize your conclusions in a memorandum addressed to Tim in the memo, you must clearly communicate your recommendation, while considering the advantages and disadvantages of your recommendation and any ethical Implications 9. As a result of investigating the direct labor rate and efficiency variances for ABC Corp, what has this exercise taught you about the importance of responsibility accounting in budgeting and variance analysis? Learning Objectives: After completing this activity, students should be able to: 1. Calculate and interpret the overall labor spending variance, labor rate variance, and labor efficiency variance 2. Use (a) Excel. (b) Tableau, and/or (c) Power BI to analyze a large data set and create a data 1 + + bonus is paid entirely based on the overall labor spending variance? What about if it's based on the labor rate variance alone? How might management overcome the potential for people to act unethically? 8. Based on your thorough analysis of labor, what recommendations do you have for management surrounding the distribution of the bonuses? Summarize your conclusions in a memorandum addressed to Tim. In the memo, you must clearly communicate your recommendation, while considering the advantages and disadvantages of your recommendation and any ethical Implications 9. As a result of investigating the direct labor rate and efficiency variances for ABC Corp, what has this exercise taught you about the importance of responsibility accounting in budgeting and variance analysis? Learning Objectives: After completing this activity, students should be able to: 1. Calculate and interpret the overall labor spending variance, labor rate variance, and labor efficiency variance 2. Use (a) Excel. (b) Tableau, and/or (c) Power BI to analyze a large data set and create a data visualization that effectively communicates the findings 3. Think critically about accounting and managerial decisions 4. Analyze the potential for management decisions to incentivize unethical behavior and develop suggestions for management to reduce the likelihood of unethical behavior, 5. Communicate the results of an analysis clearly and effectively. 6. Understand the importance of responsibility accounting