Per Unit Price Less than Per Unit Price order Manufacturing Cost S2 $1.25 S1.65 NA a)...

 

Transcribed Image Text:

Per Unit Price Less than Per Unit Price order Manufacturing Cost S2 $1.25 S1.65 NA a) Use an Excel function to determine the greatest quantity on hand among all the parts stocked in the inventory. S0.35 S0.50 NA 98 МAX(B4:B15) $3.15 $2.65 89 b) Use an Excel function to determine the average quantity on hand across all parts. S2.49 $3.60 12 37.83333333 AVERAGE(B4:B15) $5.25 $3.00 53 c) Use Excel equations to calculate the total dollar amount tied up in inventory, in terms of manufacturing cost? $1.95 S2.95 6 1364.58 SUMPRODUCT(B4:B15,C4:C15) S1.55 $1.10 NA d) Use Excel equations to determine the average manufacturing cost per unit for the total inventory on hand. 3.005682819 SUMPRODUCT(B4:B15,C4:C15)/SUM(B4:B15) S5.75 $7.45 31 $3.95 $2.35 98 e) Use an Excel formula to detemine how many parts have a unit price that is less than $2.00. IF(D4>2,B5,"NA") 7 COUNT(E4:E15) Use Excel equations to determine how many parts have a unit price less than manufacturing cost $4.25 $5.75 19 S0.75 SO.85 NA $1.19 $1.65 NA f) =COUNTIF(C4:D15,"<C4:15") 110 Per Unit Price Less than Per Unit Price order Manufacturing Cost S2 $1.25 S1.65 NA a) Use an Excel function to determine the greatest quantity on hand among all the parts stocked in the inventory. S0.35 S0.50 NA 98 МAX(B4:B15) $3.15 $2.65 89 b) Use an Excel function to determine the average quantity on hand across all parts. S2.49 $3.60 12 37.83333333 AVERAGE(B4:B15) $5.25 $3.00 53 c) Use Excel equations to calculate the total dollar amount tied up in inventory, in terms of manufacturing cost? $1.95 S2.95 6 1364.58 SUMPRODUCT(B4:B15,C4:C15) S1.55 $1.10 NA d) Use Excel equations to determine the average manufacturing cost per unit for the total inventory on hand. 3.005682819 SUMPRODUCT(B4:B15,C4:C15)/SUM(B4:B15) S5.75 $7.45 31 $3.95 $2.35 98 e) Use an Excel formula to detemine how many parts have a unit price that is less than $2.00. IF(D4>2,B5,"NA") 7 COUNT(E4:E15) Use Excel equations to determine how many parts have a unit price less than manufacturing cost $4.25 $5.75 19 S0.75 SO.85 NA $1.19 $1.65 NA f) =COUNTIF(C4:D15,"<C4:15") 110

Answer rating: 100% (QA)

According to your question How many values from one column is less than values from another column a... View the full answer