Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 3.5 to Lab 3.5 Alt Data.xlsx to perform cost driver analysis for the service call center at Thrustmaster. Thrustmaster is a fictitious company that sells game controllers, joysticks, steering wheels for PC's, and XBOX, Nintendo, and PlayStation consoles. Thrustmaster is trying to understand its overhead allocation for the call center that supports its sales. It believes that by understanding the overhead costs and their respective cost drivers, the company will be in a better position to allocate overhead to the various products that require more service. Management is considering these four potential cost drivers: 1. Customer call minutes 2. Customer complaints 3. Average workers 4. Company sales Required: 1. Using regression analysis and choosing from several potential cost drivers, derive the cost drivers that are significant predictors of overall overhead costs and can be used to help allocate overhead. Set alpha to 5%, or 0.05. 2. Derive the formula for allocating overhead (the regression line equation). 3. Compare the estimated overhead per month to actual overhead per month using a scatterplot. Data: Alt Lab 3.5 Data.xlsx Specify the Question: How can we use regression analysis to find cost drivers and derive a formula for allocating overhead? Obtain the Data: This lab uses the data in Alt Lab 3.5 Data.xlsx. This dataset contains information for potential cost drivers. Answer the following questions based on the details computed. Question 1. For upcoming customer service months, the company will apply overhead using which formula? 2. How many months are we using to estimate overhead costs for the service center? 3. The dependent variable in the regression in our cost driver analysis is which of the following? 4. If the number of customer complaints for a month is 10 and the average workers is 30, what is the estimated overhead cost per month for Thrustmaster (using the final regression results with only two cost drivers)? Enter your answer rounded to the nearest dollar. 5. If the number of customer complaints for a month is 60 and the average workers is 80, what is the estimated overhead cost per month for Thrustmaster (using the final regression results with only two cost drivers)? Enter your answer rounded to the nearest dollar. Answer OPTIONS: OPTIONS: ($222.211 x Customer Complaints) + ($1,052.086 x Average Workers) ($223.201 x Customer Complaints) + ($1,058.172 x Average Workers) $13,139.189 + ($222.211 x Customer Complaints) + ($1,052.086 x Average Workers) $14,396.291 + ($223.201 x Customer Complaints) + ($1,058.172 x Average Workers) Company sales Total overhead cost for the entire period of time Total overhead cost per month 2 Part 1 of 2 Lab Insight: Using either Excel or Tableau, apply the same steps in Lab 3.2 to the Alt Lab 3.2 Data.xlsx dataset. Required: 1. Visualize the dispersion of values using a box plot. 2. Add summary statistics. Data: Alt Lab 3.2 Data.xlsx Analyze the Data: Refer to lab 3.2 in your text for additional instructions and steps. 5 points Skipped Answer the following questions based on the details computed. Question eBook 1. How many outliers does the in-person set of sales transaction include? Print 2. Is the median higher for online or for in-person sales transactions? References 3. What is the lowest value of the entire dataset (taking into account both in-person and online sales?) (Round to 2 decimal places.) 4. What is the value of the outlier for in-person sales transactions? Enter your answer rounded to the nearest dollar. 5. Which of the following statements accurately describes the skew of the two datasets? Answer Both datasets are skewed negatively. Both datasets are skewed positively. The in-person dataset is skewed negatively, the online dataset is skewed positively. The online dataset is skewed positively, the in- person dataset is skewed negatively. 3 Part 2 of 2 Required information [The following information applies to the questions displayed below.] Lab Insight: Using either Excel or Tableau, apply the same steps in Lab 3.2 to the Alt Lab 3.2 Data.xlsx dataset. Required: 1. Visualize the dispersion of values using a box plot. 2. Add summary statistics. Data: Alt Lab 3.2 Data.xlsx Analyze the Data: Refer to lab 3.2 in your text for additional instructions and steps. 5 points Skipped eBook Print References Note: Submit your answers for the following Analysis Questions in the text entry field below. 1. Write two or three sentences summarizing the results of your findings (make sure to not only list the statistics, but to analyze the values). 2. What additional analysis would help provide a more in-depth understanding of online and in-person sales? Essay Toolbar navigation BIU S Ка 三 A Ky ! Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 3.5 to Lab 3.5 Alt Data.xlsx to perform cost driver analysis for the service call center at Thrustmaster. Thrustmaster is a fictitious company that sells game controllers, joysticks, steering wheels for PC's, and XBOX, Nintendo, and PlayStation consoles. Thrustmaster is trying to understand its overhead allocation for the call center that supports its sales. It believes that by understanding the overhead costs and their respective cost drivers, the company will be in a better position to allocate overhead to the various products that require more service. Management is considering these four potential cost drivers: 1. Customer call minutes 2. Customer complaints 3. Average workers 4. Company sales Required: 1. Using regression analysis and choosing from several potential cost drivers, derive the cost drivers that are significant predictors of overall overhead costs and can be used to help allocate overhead. Set alpha to 5%, or 0.05. 2. Derive the formula for allocating overhead (the regression line equation). 3. Compare the estimated overhead per month to actual overhead per month using a scatterplot. Data: Alt Lab 3.5 Data.xlsx Specify the Question: How can we use regression analysis to find cost drivers and derive a formula for allocating overhead? Obtain the Data: This lab uses the data in Alt Lab 3.5 Data.xlsx. This dataset contains information for potential cost drivers. Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format. Take a screenshot of your first regression output, copy it into a Word document named "Alt Lab 3.5 Excel Submission.docx", and label the screenshot Submission 1. Take a screenshot of your second regression output, copy it into the same Word document, and label the screenshot Submission 2. Take a screenshot of the scatterplot, copy it into the same Word document, and label the screenshot Submission 3. upload a response file (15MB max) Choose File no file selected save