Use the data below to analyze the financial attractiveness of the channels planned seasonal promotions.

I want to incorporate the promotional data given into the excel sheet. I don't know how to present it and what categories to add to show. I don't need the whole sheet done, just one channel (Rachio) and the functions. Below is what I'm trying to figure out. And also, how to find marketing expense for the promotion and what terms to use like revenue or net income/ profit (they have ??? next to them). Thank you

D E F G H Normal Per Unit Rachio $230.00 Sale Price $230.00 A Memorial Day Week Rachio Sale Price $230.00 MSRP discount per unit -$25.00 New Sale price $205.00 Less: Variable Expenses COGS $70.00 Marketing ??? Shipping $15.00 $230.00 -$25.00 =sum(D3:04) $70.00 ? $15.00 Less: Variable Expenses COGS $70.00 Marketing $40.00 Shipping $15.00 $70.00 $40.00 $15.00 $145.00 Contribution Margin per unit Contribution Margin Ratio MRIO 63.04% Contribution Margin per unit Contribution Margin Ratio MRIO $105.00 45.65% 162.50% =(13-sum(17:19)) =111/13 =(111-18Y/18 =(D3-sum(D7:09)) =D11/D3 =(D11-D8y/D8 900 900 =D14+D15 #VALUE! 900 900 1800 Average weekly unit sales in Spring without discount promotion Expected incremental sales due to discount promotion Total Sales 900 Revenue??? =115.13 Less: Variable Expeneses COGS Marketing Shipping Average weekly unit sales in Spring without discount promotion 900 Revenue??? $207,000.00 Less: Variable Expeneses COGS $7,350.00 Marketing $4,200.00 Shipping $1,575.00 =17"$H$11 =18$H$11 =19'$H$11 Net Income ? Net Income??? Net Income??? $193,875.00 =(119-sum(121:123)) D E F G H Normal Per Unit Rachio $230.00 Sale Price $230.00 A Memorial Day Week Rachio Sale Price $230.00 MSRP discount per unit -$25.00 New Sale price $205.00 Less: Variable Expenses COGS $70.00 Marketing ??? Shipping $15.00 $230.00 -$25.00 =sum(D3:04) $70.00 ? $15.00 Less: Variable Expenses COGS $70.00 Marketing $40.00 Shipping $15.00 $70.00 $40.00 $15.00 $145.00 Contribution Margin per unit Contribution Margin Ratio MRIO 63.04% Contribution Margin per unit Contribution Margin Ratio MRIO $105.00 45.65% 162.50% =(13-sum(17:19)) =111/13 =(111-18Y/18 =(D3-sum(D7:09)) =D11/D3 =(D11-D8y/D8 900 900 =D14+D15 #VALUE! 900 900 1800 Average weekly unit sales in Spring without discount promotion Expected incremental sales due to discount promotion Total Sales 900 Revenue??? =115.13 Less: Variable Expeneses COGS Marketing Shipping Average weekly unit sales in Spring without discount promotion 900 Revenue??? $207,000.00 Less: Variable Expeneses COGS $7,350.00 Marketing $4,200.00 Shipping $1,575.00 =17"$H$11 =18$H$11 =19'$H$11 Net Income ? Net Income??? Net Income??? $193,875.00 =(119-sum(121:123))