Plaase solve showing Execl Formulas

Alse, indicated is the cost per unit of each component and the fined cost of onderine. A discount of 10% is applicable it the quantity ordered is above a threshold quantity. The company needs to place an order for all the components. Calculate the total cost of ordering the four different components. ABC Company Parameters Component iD Irventery On-Hand Order Up to Point Cost per unit 1 Fixed Cost per Order Minimum Order size for Dikcount of 10% Discounted to Model Componen ID Order Quantity Price of Goods Cost of Goods Total Number of Onders Total Fined Costs Total Cost of Goods Total Cost