E6 In B22, using the tax rate in GB, calculate the state tax incurred for the sales volume in BB. If the profit was zero or below, the calculation should return 0 but do NOT just type 0 as the volumes can change. Adjust the cell referencing so the formula can be dragged down to 323 and then across to 623 and return the correct answers. (Full marks awarded only if cell referencing and solutions correct). E7 In row 26 work out the profit for each sales volume as a percentage of the total sales value. Strata Bikes - Profit Volume Forecast Unit Volume Increments Sales Volume in Units Total Sales Value Variable Costs State Tax: 10% 50 Federal Tax: 5% 50 100 150 200 250 300 $ 2,500.00 $ 5,000.00 $ 7,500.00 $ 10,000.00 $ 12,500.00 15,000.00 11 Direct Labor $ 1,822.60 1 Direct Material $ 1,548.82 1; Factory Overhead $ 126.48 1; Other Vary-with-Unit Costs $ 3,190.00 1iSales Commissions $ 112.50 15 Other Vary-with-Revenue Costs :5 37.50 16 Total Variable Costs $ 6,837.90 $ - $ - $ - $ - - 17 Contribution Margin Contribution Margin - Fixed Costs 20 E State Tax 23 Federal Tax _ 2i Total Income Tax $ - $ - $ - $ - $ - - 25 26 % Prot of Sales Value 28 Break-Even Analysis Line Chart Data Sales Volume in Units Fixed Costs Total Costs Total Sales Value