What is the cost of goods? Please explain using an excel formula.

Model to Estimate Number of Units by Year Assumption 9% annual growth in number of stores from Year 2 to Year 3 and each year after, for all three cha Year Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 85 110 Number of Stores by Channel Convenience Stores Grocery Stores Mass Stores 101 77 65 84 131 100 38 25 30 32. Units by Channel Convenience Stores Grocery Stores Mass Stores 157,500 105,000 17,500 382,500 227,500 87,500 416,925 247,975 95,375 454,448 270,293 103,959 495,349 294,619 113,315 539,930 321,135 123,513 588,524 350,037 134,630 Total Units Across the Three Channels 280,000 697,500 760,275 828,700 903,283 984,578 1,073,190 Annual Units per Store by Channel 4,500 3,500 3,500 Year Year Year Year 2 3 Year 4 121,275 5 Year 6 133,706 Year 7 140,391 Operating costs Estimates $ 60,000 $ 110,000 $ 115,500 $ $ 127,339 $ $ Financial Model Year Year Year Year Year Year Year 6 1 Total Units Wholesale Price 1 280000 $0.35 697500 $0.35 760275 $0.35 828700 $0.35 903283 $0.35 984578 $0.35 1073190 $0.35 $98,000 $244,125 $266,096 $290,045 $316,149 $344,602 $375,617 Revenue Cost of Goods Operating Costs Operating Income (= Revenue-Cost of Goods-Operating Costs) $60,000 $38,000 $110,000 $134,125 $115,500 $150,596 $121,275 $168,770 $127,339 $188,810 $133,706 $210,897 $140,391 $235,226 Price Wholesale Price 0.35 per unit This is the amount that the company making the product receives from the retail stores that will sell it to consumers. Per Unit Cost For the first 500,000 units annually For additional units in a vear, the cost is 0.21 per unit 0.13 per unit Model to Estimate Number of Units by Year Assumption 9% annual growth in number of stores from Year 2 to Year 3 and each year after, for all three cha Year Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 85 110 Number of Stores by Channel Convenience Stores Grocery Stores Mass Stores 101 77 65 84 131 100 38 25 30 32. Units by Channel Convenience Stores Grocery Stores Mass Stores 157,500 105,000 17,500 382,500 227,500 87,500 416,925 247,975 95,375 454,448 270,293 103,959 495,349 294,619 113,315 539,930 321,135 123,513 588,524 350,037 134,630 Total Units Across the Three Channels 280,000 697,500 760,275 828,700 903,283 984,578 1,073,190 Annual Units per Store by Channel 4,500 3,500 3,500 Year Year Year Year 2 3 Year 4 121,275 5 Year 6 133,706 Year 7 140,391 Operating costs Estimates $ 60,000 $ 110,000 $ 115,500 $ $ 127,339 $ $ Financial Model Year Year Year Year Year Year Year 6 1 Total Units Wholesale Price 1 280000 $0.35 697500 $0.35 760275 $0.35 828700 $0.35 903283 $0.35 984578 $0.35 1073190 $0.35 $98,000 $244,125 $266,096 $290,045 $316,149 $344,602 $375,617 Revenue Cost of Goods Operating Costs Operating Income (= Revenue-Cost of Goods-Operating Costs) $60,000 $38,000 $110,000 $134,125 $115,500 $150,596 $121,275 $168,770 $127,339 $188,810 $133,706 $210,897 $140,391 $235,226 Price Wholesale Price 0.35 per unit This is the amount that the company making the product receives from the retail stores that will sell it to consumers. Per Unit Cost For the first 500,000 units annually For additional units in a vear, the cost is 0.21 per unit 0.13 per unit