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