need help finding the total contribution margin at the end

3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 24 25 26 27 28 29 30 31 32 33 Selling price per unit Variable cost per unit Product A Product B 40 $ 32 24 $ 12 Identify the product that should be produced or sold under each of the following constraints. Consider each constraint separately. One unit of Product A requires 2 hours of labor to produce, and one unit of Product B requires 4 hours of labor to produce. Due to labor constraints, demand is higher than the company's capacity to make both products. The products are sold to the public in retail stores. The company has limited floor space and cannot stock as many products as it would like. Display space is available for only one of the two products. Expected sales of Product A and Product B are 8,000 units and 9,000 units, respectively. 2 8,000 The maximum number of machine hours available is 40,000. Product A uses 2.50 machine hours, and Product B uses 4 machine hours. The company can sell all the products it produces. 40,000 4 9,000 2.50 4 Required Complete the, Spreadsheet. Selling price per unit Variable cost per unit Contribution margin per unit Scarce resource is labor 23 Contribution margin per labor hour Scarce resource is floor space Total contribution margin Scarce resource is machine hours Contribution margin per machine hour Number of machine hours Total contribution margin S Product A 40.00 24.00 16.00 2 hours 8.00 8,000 units 128,000 2.5 hours 6.40 40,000 128,024 Product 32.00 12.00 20.00 Product that shoul -be uced roduct A 4 5.00 9,000 180,000 4 5.00 40,000 180 025 hours units Product B hours roduct A