Performance metrics

Apples & Oranges Inc. is trying to become more efficient in shipping goods. It is experimenting with two new shipping procedure initiatives aimed at achieving this strategic objective. The company has provided the following data regarding the two procedures after one month of implementation:

Line Item Description Shipping Procedure A Shipping Procedure B

Number of shipping errors $75192$

Hours from ordered to shipped $15\mathrm{.}318\mathrm{.}2$

Shipping time $($hours from shipped to delivered$)6\mathrm{.}79\mathrm{.}5$

Pounds of goods shipped $850,000880,000$

Number of shipments $250400$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

Open spreadsheet

a$.$ Compute the following performance metrics for each program:

$(1)$ Average number of shipping errors per shipment, rounded to two decimal places.

Procedure A: fill in the blank $1$ of $2$

error per shipment

Procedure B: fill in the blank $2$ of $2$

error per shipment

$(2)$ Hours from ordered to delivered, rounded to one decimal place.

Procedure A: fill in the blank $1$ of $2$

hours from ordered to delivered

Procedure B: fill in the blank $2$ of $2$

hours from ordered to delivered

$(3)$ Average pounds of goods per shipment.

Procedure A: fill in the blank $1$ of $2$

lbs$.$ of goods per shipment

Procedure B: fill in the blank $2$ of $2$

lbs$.$ of goods per shipment