Please work the solution in excel with formulas.

Gibbs Corporation produces industrial robots for high-precision manufacturing. The following information is given for Gibbs Corporation.

Per Unit	Total
Direct materials	$390
Direct labor	$340
Variable manufacturing overhead	$74
Fixed manufacturing overhead		$1,624,000
Variable selling and administrative expenses	$57
Fixed selling and administrative expenses		$532,000

The company has a desired ROI of 24%. It has invested assets of $53,290,000. It anticipates production of 2,800 units per year.

(a)

Compute the cost per unit of the fixed manufacturing overhead and the fixed selling and administrative expenses.

Fixed manufacturing overhead	$	per unit
Fixed selling and administrative expenses	$	per unit

(b)

Compute the desired ROI per unit.(Round answer to 0 decimal places, e.g. 125.)

Desired ROI

$

per unit

(c)

Compute the markup percentage and target selling price using absorption-cost pricing.(Round the markup percentage to 3 decimal places, e.g. 2.250% and the target selling price to 0 decimal places, e.g. 125.)

Markup percentage		%
Target selling price	$

(d)

Compute the markup percentage and target selling price using variable-cost pricing.(Round the markup percentage to 3 decimal places, e.g. 2.250% and the target selling price to 0 decimal places, e.g. 125.)

Markup percentage

%Target selling price$

Gibbs Corporation produces industriai robots for high-precision manufacturing. 111e foilowing information is given for Gibbs Corporation. Direct materials 5390 Direct labor $340 Variable manufacturing overhead 3 74 Fixed manufacturing overhead $1,624,000 Variable selling and admin'nrtrative expenses 3 5? Fixed selling and admin'e'trative expenss $ 532,000 111e company has a desired ROI of 24%. It has invested assets of $53,290,000. [t anticipates production of 2,800 units per year. lal Compute the cost per unit ofthe xed manufacturing overhead and the xed seliing and administrative expenses. Fixed manufacturing overhead $ per unit Fixed selling and administrative apensa $ per unit lb} Compute the desired ROI per unit. {Round answer to 0 decimal places, tag. 125.) Desired ROI $ per unit [Cl Compute the markup percentage and target seiling price using absorption-cost pricing. (Round the markup percentage to 3 decimalplaces, e.g. 2.250% and the targetseing price to l] decimafplaces, eg. 125.) Markup percentage IN: Target selling price 5 id} Compute the markup percentage and target seiling price using variabie-cost pricing. (Round the markup percentage to 3 decimafpfaces, e.g. 2.250% and the targetseing price to l] decimafplaces, e.g. 125.) Markup percentage % Target selling price 3