Question
DA11.1 Data analytics can be used to compare process department production results. Sweet Pete produces vegan chocolate brownies in three processesmixing, baking, and packaging. Due
DA11.1 Data analytics can be used to compare process department production results. Sweet Pete produces vegan chocolate brownies in three processesmixing, baking, and packaging. Due to the increasing popularity of the brownies, the company has multiple departments running the same processes each under different production supervisors. There are three mixing, four baking, and one packaging process departments. For the last several months, the production cost reports have indicated some overruns in the costs generated by the mixing departments. The production cost reports reflect combined activity of all three mixing departments and upper management is unable to determine if the costs overruns are due to one department in particular or all three mixing departments. Data containing unit materials and conversion costs incurred by each of the three mixing departments for the month of March are provided here. Unit costs for March by date and department Date Mixing Department Number Materials Cost per Equivalent Unit Conversion Cost per Equivalent Unit 3/1 M1 $2.00 $3.07 3/1 M2 2.06 3.08 3/1 M3 2.05 3.03 3/2 M1 1.98 3.04 3/2 M2 1.95 2.93 3/2 M3 2.02 3.00 3/3 M1 2.02 3.03 3/3 M2 1.97 2.95 3/3 M3 1.95 2.93 3/4 M1 2.01 3.05 3/4 M2 1.99 2.89 3/4 M3 2.07 3.08 3/5 M1 2.05 3.03 3/5 M2 1.98 2.96 3/5 M3 1.95 2.93 3/6 M1 2.02 3.00 3/6 M2 2.02 3.00 3/6 M3 1.97 2.95 3/7 M1 1.95 2.93 3/7 M2 2.01 2.99 3/7 M3 1.96 2.89 3/8 M1 2.05 3.03 3/8 M2 2.06 2.96 3/8 M3 1.95 2.93 3/9 M1 2.02 3.00 3/9 M2 2.02 3.00 3/9 M3 1.96 2.95 3/10 M1 1.95 3.04 3/10 M2 2.06 2.99 3/10 M3 2.05 2.89 3/11 M1 2.01 3.04 3/11 M2 1.98 2.98 3/11 M3 2.04 3.06 3/12 M1 2.03 3.01 3/12 M2 2.06 2.94 3/12 M3 1.93 2.91 3/13 M1 2.00 3.04 3/13 M2 2.00 2.98 3/13 M3 1.95 2.93 3/14 M1 1.93 2.91 3/14 M2 2.06 2.97 3/14 M3 1.97 2.87 3/15 M1 2.05 3.06 3/15 M2 2.03 3.01 3/15 M3 1.96 2.94 3/16 M1 1.93 3.04 3/16 M2 2.06 3.01 3/16 M3 2.03 3.01 3/17 M1 1.98 3.07 3/17 M2 1.96 2.94 3/17 M3 2.02 3.00 3/18 M1 1.97 3.02 3/18 M2 2.06 3.04 3/18 M3 1.99 2.97 3/19 M1 1.96 3.04 3/19 M2 2.05 3.01 3/19 M3 2.03 3.01 3/20 M1 1.97 3.02 3/20 M2 1.96 2.94 3/20 M3 1.97 3.00 3/21 M1 2.09 2.90 3/21 M2 2.02 3.00 3/21 M3 1.97 2.97 3/22 M1 2.03 3.05 3/22 M2 2.02 3.00 3/22 M3 1.95 2.93 3/23 M1 1.92 3.06 3/23 M2 2.08 2.97 3/23 M3 1.99 2.97 3/24 M1 1.94 2.92 3/24 M2 2.04 2.90 3/24 M3 1.98 2.96 3/25 M1 2.05 2.86 3/25 M2 2.04 3.05 3/25 M3 2.02 3.00 3/26 M1 2.04 2.93 3/26 M2 1.92 2.90 3/26 M3 1.99 2.97 3/27 M1 1.99 2.97 3/27 M2 1.96 2.94 3/27 M3 1.94 2.92 3/28 M1 2.00 2.98 3/28 M2 1.95 2.88 3/28 M3 2.04 3.02 3/29 M1 1.97 2.95 3/29 M2 1.94 2.92 3/29 M3 2.01 2.99 3/30 M1 2.01 2.99 3/30 M2 1.95 2.94 3/30 M3 1.94 2.92 3/31 M1 1.95 2.98 3/31 M2 2.04 2.88 3/31 M3 2.00 2.98
Instructions There are two parts to this problem. Use Excel to perform the following: a. Create a pivot table that shows the daily cost, average cost, maximum cost, and minimum cost by department. b. Which department, if any, is the cause of cost overruns? Support your answer. Hint: Add average, min, and max to your field settings.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started