I just need to know how I can calculate the cost per unit for i-donut using this excel file? I know you guys can not calculate it directly as you do not have the file and there is no feature on coursehero to send excel files but I just want to know the process of how to calculate it.

15 Share Comments File Page Layout X16 fix Inputs Results Units Sold Costs Marketing Activity Pricing Sales Is Retweets Fbook Likes Instagram shares loe Cream Price Donut Price I-Donut Price Ice Cream Sales Donut Sales I-Donut Sales Total Revenue loe Cream Units Donut Units I-Donut Units Ice Cream Cost Donut Cost I-Donut Cost Total Cost Ice Cream Profit Donut Profit I-Donut Profit Total Profit $431.20 $136.00 $242.55 $140.00 $1.00 $1.25 $2.0 $272.00 475 $712.50 $1,192. 70 $195.30 $237.50 250 $1.00 $2.00 266.00 538 $807.00 $1,285.40 $269.00 $597.60 250 250 250 $1,00 $1.25 $2.0 $535.00 $1,076.00 278 $622.50 $1,099. 10 $139.00 $207.50 $536.40 250 250 $1.00 $1.25 $278.00 398 490 $318.40 $735.00 $1,204.40 $151.00 245.00 250 250 250 250 $1,00 $1.25 $2.0 $302.00 $497.50 $980.00 $1,779.50 308.00 $1,096.00 308 392 548 $313.60 $822.00 $1,289.60 274.00 250 250 250 250 $1.00 $1.25 2.0 $490.00 $1,154.00 $1,952.00 392 $313.60 $154.00 $176.40 $288.50 $618.90 250 250 250 $1.00 $1.25 $148.00 $280.50 250 250 $1.00 2.00 296.00 $505.00 $1,923.00 $841.50 $1,312.70 371 530 $296.80 $795.00 $1,256.30 $164.50 $166.95 265.00 $596.45 250 250 $1.00 $1.25 $2.0 329.00 $1,060.00 $311.20 $681.00 $1,147.70 $155.50 $175.05 $227.00 250 250 250 250 $2.00 $1,705.25 380 651.00 $1,115.00 $171.00 217.00 $548.00 250 250 250 250 $2.0 $320.00 1,663.00 320 $167.50 $811.50 $1,271.00 $167.50 $164.25 300 300 200 $2.00 $335.00 $150,85 247.50 30 300 200 200 $2.0 $990.00 $1,778.25 353 $742.50 $1,198.40 530 $272.80 $795.00 $1,247.30 $153.45 $265.00 30 300 200 $2.00 1008 $263.20 $148.05 $50.40 200 $1.55 $187.00 300 200 $1,00 $1.55 $374.00 $407.50 $1,751.50 326 1130 $45.75 $378.40 $1.00 $1.55 #353.00 $1,418.25 $179.50 $378.80 300 200 $1.00 $1.55 $359.00 $2,206.6 314 943 $251.20 $141.30 $381.45 200 $1.00 $1.55 $386.00 $1,461.65 $251.20 $193.00 $43.30 $377.60 $1.00 $1.55 386.00 $392.50 $1,342.30 $2,120.80 $1,55 $407.00 $1,670.90 1078 $51.55 400 $1.00 $388.75 $1,598.05 $248.80 $1.00 $377.50 $1,997.95 398 302 $241.60 64.45 $229.60 $1,621.50 $2,057.60 $206.50 $129.15 $54.05 $1.00 120 $220.00 $180.00 $1.00 $3.00 $3.00 $498.00 401 166 $239.20 $249.00 $134.55 $249.00 $1.00 $234.4 $243.00 $1.00 $3.00 407 $355.00 416 $201.00 $1.00 $3.0 126 $206.50 $229.60 $189.00 $1.00 $1.00 $3.0 $244.00 $226.50 $226.50 $1.00 $3.00 $1.00 $1,201.50 $222.40 $216.00 $3.00 100 0.75 $3.00 $579.56 0.75 $1.25 $3.00 175 Robot Robot Donut 50 ReadyWhat is the cost per unit of the i-donut? 0 It's variable