Question: please show the steps in finding the 4 solutions. please show them in excel format. example of this is: =(C3+B15)*D4 thanks in advance. will vote

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. 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.) \begin{tabular}{|l|r|r|} \hline 7 & Direct labor & 40 \\ \hline 8 & Overhead & 25 \\ \hline 9 & Selling, general and administrative & 15 \\ \hline 10 & & \\ \hline 11 & & \\ \hline 12 & Overhead & \\ \hline 13 & Selling, general and administrative & $590,000 \\ \hline 14 & & \\ \hline 15 & Units produced & 20,000 \\ \hline 16 & Targeted profit & $300,000 \\ \hline 17 & & \\ \hline 18 & Required: & \\ \hline 19 & 1. Compute the total variable cost and the markup percentage. \\ \hline 20 & 2. Compute the dollar markup per unit on variable cost. \\ \hline 21 & 3. Compute the selling price per unit. \\ \hline 22 & & \\ \hline 23 & (Use cells A2 to B16 from the given information and the cells beld \\ \hline 24 & & \\ \hline 25 & 1. Total variable costs & $3,000,000 \\ \hline 26 & 1. Markup percentage & \multicolumn{2}{|c|}{52%} \\ \hline 27 & 2. Markup per unit \\ \hline 28 & 3. Selling price per unit \\ \hline 20 & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
