Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do you do f? * Item Part Number No. Units On Hand Per Unit Manufacturing Cost Per Unit Price order Price Less than $2
How do you do f?
* Item Part Number No. Units On Hand Per Unit Manufacturing Cost Per Unit Price order Price Less than $2 NA NA 50 $1.25 46 89 89 12 12 53 19165 19166 19167 19168 19169 19170 19171 19172 19173 19174 19175 19176 53 6 0 6 $0.35 $3.15 $2.49 $5.25 $1.95 $1.55 $5.75 $3.95 $4.25 S0.75 $1.19 $1.65 $0.50 $2.65 $3.60 $3.00 $2.95 $1.10 $7.45 $2.35 $5.75 $0.85 $1.65 NA 31 31 98 a) Use an Excel function to determine the greatest quantity on hand among all the parts stocked in the inventory. 98 MAX(B4:B15) b) Use an Excel function to determine the average quantity on hand across all parts 37.83333333 AVERAGE(B4:B15) c) Use Excel equations to calculate the total dollar amount tied up in inventory, in terms of manufacturing cost? 1364.58 SUMPRODUCT(B4:B15,C4:015) 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) e) Use an Excel formula to determine how many parts have a unit price that is less than $2.00. IF(D4>2,B5,"NA") 7 COUNT(E4:E15) f) Use Excel equations to determine how many parts have a unit price less than manufacturing cost =COUNTIF(D4D151"<15 countif criteria na ina minimum stock level maximum for items manufacturing cost g create a column to display an order quantity based on the following rules. if hand is less than mi>15>Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started