H$5.$

Data file: Purchase Orders.

Convert the database file to an Excel table. Do filtering and answer the questions below:

$($a$)$ Total cost of all orders is: $$2,471,760.$

$($b$)$ Total quantity of airframe fasteners purchased is:

$($c$)$ Total cost of all orders placed with supplier Manley Valve is:

#$12.$

Data file: Purchase Orders.

Use Excel's filtering capability to extract records and answer the following questions.

$($a$)$ Extract all the orders for item control panels,

Total number of units of control panels is:

Average number of units in an order for control panels is:

$($b$)$ Extract all the orders for order quantities less than $500$ units per order.

Total number of such orders is

Total cost of these orders is:

$($c$)$ Extract all the orders for control panels with quantities of less than $500$ units,

Total number of such orders is:

Total cost of these orders is: