HOW TO DO THIS? PLEASE SHOW FORMULAS FOR EACH COLUMN PLEASE! THANKS!

Consider the supply chain of cellphone company that has following functional groups with corresponding profit share percentages: Supplier 20%) Manufacturing (459) Transportation (8%) C Distributor (12%) Retailer (15%) When the phone was launched in the month of January, the total cost of one unit of cellphone for the entire supply chain was $900. Each unit of the phone was sold in the retail store at a price of $1000. In the month of January 1000 units of the cellphone were sold. The company took some initiatives to make its supply chain more efficient and thus reduce the total supply chain cost pen unit. The monthly data is provided below: a) Month = January. Retail Price $1000, Cost per-unit- $900. Units sold - 1000 b) Month = February, Retail Price $1000, Cost per-unit- $850. Units sold - 1000 c) Month - March, Retail Price $1000, Cost per-unit. $800. Units sold - 1000 d) Month = April, Retail Price- $1000, Cost per-unit- $750, Units sold 1000 e) Month = May, Retail Price= $1000, Cost per-unit-- $700. Units sold 1000 **Using the above data for each month, please use Excel to calculate the total supply chain surplus and profit for each functional group (taking into account the total number of units sold) in form of a table as shown below: (25 points) Month Supply Chain Surplus Supplier Profit Manufacturing Transportation Distributor Retailer Profit Profit Profit Profit January February March April May