B C D F Colt Company produces two skateboard models. Machine time per unit for Hero is 3 two hours and for Flip is one hour. The machine's capacity is 1,600 hours per year. 4 Colt can sell up to 500 units of Hero and 900 units of Flip per year. Selling prices and 5 variable costs follow. \begin{tabular}{|c|l|r|r|} \hline 6 & & \multicolumn{1}{|c|}{} \\ \hline 7 & & \multicolumn{1}{|c|}{ Hero } & \multicolumn{1}{c|}{ Flip } \\ \hline 8 & Selling price per unit & $150 & 595 \\ \hline 9 & Variable costs per unit & 50 & 55 \\ \hline 10 & Machine hours per unit & 2 & 1 \\ \hline 11 & Maximum units sold per year & 500 & 900 \\ \hline 12 & & & \\ \hline 13 & Machine capacity & 1,600 & hours per year \\ \hline 13 & & \end{tabular} Required: (a) Compute the contribution margin per machine hour for each product. (Use cells A2 to 13 from the given information to complete this question. Negative amounts or amounts to be deducted should be input and displayed as negative values.) (b) Determine the best sales mix of products. Units produced and sold for most profitable sales mix 32 Hours required to produce most profitable sales mix (c) Compute the total contribution margin for the best sales mix. \begin{tabular}{llll|l|} \hline & Uero & Flip & Total \\ \hline Units produced for most profitable sales mix & Hersion & & \\ Contribution margin per unit. \\ Total contribution margin & & & \\ \hline \end{tabular} Graded Worksheet + Rios Company makes drones and uses the variable cost method in setting product price. Its costs for producing 20,000 units follow. The company targets a profit of $300,000 on this product. 18 Required: 1. Compute the total variable cost and the markup percentage. 2. Compute the dollar markup per unit on variable cost. 3. Compute the selling price per unit. (Use cells A2 to B16 from the given information and the cells below to complete this question.) 1. Compute the total variable cost and the markup percentage. 2. Compute the dollar markup per unit on variable cost. 3. Compute the selling price per unit. (Use cells A2 to B16 from the given information and the cells below to complete this question.) 1. Total variable costs 1. Markup percentage 2. Markup per unit 3. Selling price per unit B C D F Colt Company produces two skateboard models. Machine time per unit for Hero is 3 two hours and for Flip is one hour. The machine's capacity is 1,600 hours per year. 4 Colt can sell up to 500 units of Hero and 900 units of Flip per year. Selling prices and 5 variable costs follow. \begin{tabular}{|c|l|r|r|} \hline 6 & & \multicolumn{1}{|c|}{} \\ \hline 7 & & \multicolumn{1}{|c|}{ Hero } & \multicolumn{1}{c|}{ Flip } \\ \hline 8 & Selling price per unit & $150 & 595 \\ \hline 9 & Variable costs per unit & 50 & 55 \\ \hline 10 & Machine hours per unit & 2 & 1 \\ \hline 11 & Maximum units sold per year & 500 & 900 \\ \hline 12 & & & \\ \hline 13 & Machine capacity & 1,600 & hours per year \\ \hline 13 & & \end{tabular} Required: (a) Compute the contribution margin per machine hour for each product. (Use cells A2 to 13 from the given information to complete this question. Negative amounts or amounts to be deducted should be input and displayed as negative values.) (b) Determine the best sales mix of products. Units produced and sold for most profitable sales mix 32 Hours required to produce most profitable sales mix (c) Compute the total contribution margin for the best sales mix. \begin{tabular}{llll|l|} \hline & Uero & Flip & Total \\ \hline Units produced for most profitable sales mix & Hersion & & \\ Contribution margin per unit. \\ Total contribution margin & & & \\ \hline \end{tabular} Graded Worksheet + Rios Company makes drones and uses the variable cost method in setting product price. Its costs for producing 20,000 units follow. The company targets a profit of $300,000 on this product. 18 Required: 1. Compute the total variable cost and the markup percentage. 2. Compute the dollar markup per unit on variable cost. 3. Compute the selling price per unit. (Use cells A2 to B16 from the given information and the cells below to complete this question.) 1. Compute the total variable cost and the markup percentage. 2. Compute the dollar markup per unit on variable cost. 3. Compute the selling price per unit. (Use cells A2 to B16 from the given information and the cells below to complete this question.) 1. Total variable costs 1. Markup percentage 2. Markup per unit 3. Selling price per unit
