Functions: AVERAGE; MAX; Cell Referencing

E$13\mathrm{.}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 the required mathematical formulas or functions with cell references to the Problem area or work area as indicated.

You are a management accountant for a frozen foods shipping company, Navia Inc. The company receives frozen foods from vendors, packages orders, 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 is data from $20$ different transactions.

What is the average time that each process takes?

Average time for receiving

Time for Receiving Time for Packaging Time for Quality Control Time for Trucking Average time for packaging

Average time for quality control

$41211570$ Average time for trucking

$3626945$

$42591248$ Which process consistently takes longer than the other processes?

$25491438$

$15361375$ Longest time for a process

$1520946$

$3050870$ The process taking longest time is $.$

$30391168$

$36611556$

$2135862$

$42631364$

$24521349$

$25401035$

$41441453$

$17501158$

$43431330$

$2753951$

$34571575$

$37231455$