Calculate the Commissions paid for each product type. Please show the formulas being used.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Product Type Cost of G Commission Fixed Costs Employees Salary (per Arena Fee Product Ty Expected Sa Cost of G Gross Profit Product Ty c Programs 20% $5,000.00 0.05% $50.00 100 000.00 D Model Inputs Food 10% $10,000.00 0.20% Merchandise 5% $20,000.00 0.03% Event Profitability Analysis Gross Profit Programs Food Merchandise $90,401.00 $185,427.07 $486,488.13 $36,160.40 $111,256.24 $340,541.69 $54,240.60 $74,170.83 145 946.44 Operating Expenses Programs Food Merchandise Salary Expenses Commissions Fixed Costs Total Operating Expenses Profit before Arena Fee Number of Employees Item Profit Summary Total Total Expected Sales Total Gross Profit Total Operating Expenses Profit before Arena Fee Arena Fee Net Profit