Answered step by step
Verified Expert Solution
Link Copied!

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
thanks in advance. will vote positively if steps are shown in excel format and are correct.
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions