Need explanations and answers in excel format 2 3 E13.2-Using Excel to Evaluate Data for Time on

Need explanations and answers in excel format

Transcribed Image Text:

2 3 E13.2-Using Excel to Evaluate Data for Time on Task 4 PROBLEM 5 You are a management accountant for a frozen foods shipping company, 6 Navia Inc. The company receives frozen foods from vendors, packages orders, 7 loads them onto trucks, and ships them out. You have been brainstorming 8 with your colleagues to find a way to shorten the process from receiving to 9 trucking so that employees spend less time working in a frozen room. Below 10 is data from 20 different transactions. 11 12 23 Receiving Time for Time for 13 Packaging Time for Quality Control Time for Trucking 14 41 21 15 70 15 36 26 9 45 16 42 59 12 48 17 25 49 14 38 18 15 36 13 75 19 15 20 9 46 20 30 50 8 70 21 30 39 11 68 22 36 61 15 56 23 21 35 8 62 22 24 42 63 13 64 25 24 52 13 49 26 25 40 10 35 27 41 44 14 53 28 17 50 11 58 29 43 43 13 30 27 53 31 34 57 15 32 37 23 14 3954 30 51 75 55 33 34 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. What is the average time that each process takes? Average time for receiving Average time for packaging Average time for quality control Average time for trucking Which process consistently takes longer than the other processes? Longest time for a process The process taking longest time is 2 3 E13.2-Using Excel to Evaluate Data for Time on Task 4 PROBLEM 5 You are a management accountant for a frozen foods shipping company, 6 Navia Inc. The company receives frozen foods from vendors, packages orders, 7 loads them onto trucks, and ships them out. You have been brainstorming 8 with your colleagues to find a way to shorten the process from receiving to 9 trucking so that employees spend less time working in a frozen room. Below 10 is data from 20 different transactions. 11 12 23 Receiving Time for Time for 13 Packaging Time for Quality Control Time for Trucking 14 41 21 15 70 15 36 26 9 45 16 42 59 12 48 17 25 49 14 38 18 15 36 13 75 19 15 20 9 46 20 30 50 8 70 21 30 39 11 68 22 36 61 15 56 23 21 35 8 62 22 24 42 63 13 64 25 24 52 13 49 26 25 40 10 35 27 41 44 14 53 28 17 50 11 58 29 43 43 13 30 27 53 31 34 57 15 32 37 23 14 3954 30 51 75 55 33 34 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. What is the average time that each process takes? Average time for receiving Average time for packaging Average time for quality control Average time for trucking Which process consistently takes longer than the other processes? Longest time for a process The process taking longest time is