Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
please show the steps in finding the 4 solutions. please show them in excel format. example of this is: =(C3+B15)*D4
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} thanks in advance. will vote positively if steps are shown in excel format and are correct.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started