Can someone help with the below question?
P13.3 (L03, 4), AP Excel 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 material 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_ID: a unique identifier for each product. - Standard_usage: the standard usage of materials for a specific product. - Online Marketplace Price data set. - Standard_price: the standard purchasing price for one unit of each raw material. - Material_ID: a unique identifier for each material. - Grade_main: the grade level of the material. (Note: The company only keeps 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 material. Required Use the Online Marketplace data sets available in Wiley Course Resources to answer the following questions about the online marketplace: a. If the company had purchased all of its materials from the online marketplace, what inventory cost would be shown for all materials on hand based on the average transaction price? Is that value higher or lower than the value of all materials if using their standard price? b. If the company can freely choose the lower of the standard price or the average price in the online marketplace, what is the lowest possible inventory cost of all materials on hand? c. Is there a particular marketplace vendor that always sells at a price lower than the standard price? d. Based on your observations in (a) and (b), can you explain why the competitors are switching to the online marketplace? What would you recommend to your company
