excel 3: Colt Company produces two skateboard models. Machine time per unit for Hero is two hours and for Flip is one hour. The machine's capacity is 1,600 hours per year. Colt can sell up to 500 units of Hero and 900 units of Flip per year. Selling prices and variable costs follow. Hero 17 $150 50 2 500 Selling price per unit Variable costs per unit O Machine hours per unit 1 Maximum units sold per year 2 3 Machine capacity 4 5 Required: 16 (a) Compute the contribution margin per machine hour for each product. Flip $95 55 1 900 1,600 hours per year

Colt Company produces two skateboard models. Machine time per unit for Hero is wo hours and for Flip is one hour. The machine's capacity is 1,600 hours per year. Colt can sell up to 500 units of Hero and 900 units of Flip per year. Selling prices and variable costs follow. (b) Determine the best sales mix of products. Units produced and sold for most profitable sales mix Hours required to produce most profitable sales mix (c) Compute the total contribution margin for the best sales mix. \begin{tabular}{|l|l|l|l|} \hline Units produced for most profitable sales mix \\ Contribution margin per unit \\ Total contribution margin \end{tabular}