Determine the total standard quantity of each common material identified in part (a). Compare these total standard quantities to the quantity of each of these materials that is currently on hand. Is there any common pattern when comparing each raw material's total standard quantity to the actual quantity on hand? You recently overheard that your company's competitors have started to purchase their materials from an online marketplace. You identify your company's top three products and collect information about their materiat usage, their standard costs, and the average costs you find from the sellers on the online marketplace at the end of December 2020 . Here are the definitions of the fields. - Online Marketplace Material usage data set. - Material_ID: a unique identifier for each raw material. - Product_JD: a unique identifier for each product. - Standard usage: the standard usage of materials for a specific product. - Online Marketplace Price data set. - Standard sorice; the standard purchasing price for one unit of each raw material. - Material JD: a unique identifier for each material. - Grade main, the grade level of the material. (Note. The company only heeps materials with grade level "A:? - Quantity on hand, the number of units of the raw material on hand in inventory. - Marketplace vendor: vendor for raw materials on the online marketplace. - Avgtransactionprice: average transaction price per unit for a specific vendor and a specific raw muterial, Determine the total standard quantity of each common material identified in part (a). Compare these total standard quantities to the quantity of each of these materials that is currently on hand. Is there any common pattern when comparing each raw material's total standard quantity to the actual quantity on hand? You recently overheard that your company's competitors have started to purchase their materials from an online marketplace. You identify your company's top three products and collect information about their materiat usage, their standard costs, and the average costs you find from the sellers on the online marketplace at the end of December 2020 . Here are the definitions of the fields. - Online Marketplace Material usage data set. - Material_ID: a unique identifier for each raw material. - Product_JD: a unique identifier for each product. - Standard usage: the standard usage of materials for a specific product. - Online Marketplace Price data set. - Standard sorice; the standard purchasing price for one unit of each raw material. - Material JD: a unique identifier for each material. - Grade main, the grade level of the material. (Note. The company only heeps materials with grade level "A:? - Quantity on hand, the number of units of the raw material on hand in inventory. - Marketplace vendor: vendor for raw materials on the online marketplace. - Avgtransactionprice: average transaction price per unit for a specific vendor and a specific raw muterial
