Question

Please help answer the following question, you will need to use the information below.

.

Grand Prix Touring Phoenix Touring Pike's Peak Mountain Himalaya Mountain Waistliner Stationary Total Percent Percent Percent Percent Percent Units Selling Price per Unit 675454 $75 498524 $95 984386 $135 233412 $299 100.00% 182441 $188 100.00% 100.00% 100.00% 100.00% Total Sales Revenue $335,000,036 $50,659,050 $ 47,359,780 $132,892,110 $34, 298,908 $69,790,188 Cost per Unit: Materials Labor Overhead $15 $11 $25 $20 $14 $32 $25 $19 $47 $39 $18 $64 $57 $40 $112 Total Cost of Goods Sold $227,788,333 $51 $34,448,154 $66 $32,902,584 $91 $89,579, 126 $121 $22,075,361 $209 $48,783, 108 $107,211,703 $16, 210,896 $14,457,196 $43,312,984 $12,223,547 $21,007,080 20x8 Grand Prix Touring Phoenix Touring Pike's Peak Mountain Himalaya Mountain Waistliner Stationary Total Percent Percent Percent Percent Percent Units Selling Price per Unit 524759 $72 423112 $92 878009 $131 158437 $183 202314 $293 100.00% 100.00% 100.00% 100.00% 100.00% Total Sales Revenue $280,000,104 $37,782,648 $38,926,304 $115,019,179 $28,993,971 $59, 278,002 Cost per Unit: Materials Labor Overhead $18 $9 $28 25.00% 12.50% 38.89% $21 $15 $35 22.83% 16.30% 38.042 $30 $20 $51 22.90% 15.27% 38.93% $42 $25 $71 22.95% 13.66% 38.80% $66 $47 $115 22.53% 16.04% 39.25% 76.39% 77.17% 77.102 75.41% Total Cost of Goods Sold $71 $30,040,952 $55 $28,861,745 $101 $88,678,909 77.82% $138 $21,864,306 $215,573,504 $228 $46,127,592 $64,426,600 $8,920,903 $8,885,352 $26,340, 270 $7,129,665 $13,150, 410 =============

            b. Using the “Sales and Cost of Goods Sold - By Product Line” data in WP A.2, prepare a common-sized cost per unit calculation as a percentage of sales price for 20X9 by product line.

           

Answer 1

Answer:

2019 Pike's Peak Grand Prix Himalaya Waistliner Phoenix Touring Percent Touring Percent Stationary Total Percent Mountain Percent Mountain Percent 984386 182441 233412 Units 675454 498524 $75 100.00% $95 100.00% $135 100.00% $188 100.00% $299 100.00% Selling Price per Unit $335,000,036 $50,659,050 $34,298,908 $69,790,188 Total Sales Revenue $47,359,780 $132,892,110 Cost per Unit: $15 $20 $25 $39 $57 19.06% Material 20.00% 21.05% 18.52% 20.74% $1 $14 $19 $18 $40 Labor 14.67% 14.74% 14.07% 9.57% 13.38% $25 $32 33.68% $47 $4 $112 37.46% Overhead 33.33% 34.81% 34.04% $51 $66 $91 $121 $209 69.90% 68.00% 69.47% 67.41% 64.36% Total Cost of Goods Sold $227,788,333 $34,448,154 $32,902,584 $89,579,126 $22,075,361 $48,783,108 ---------------- $107,211,703 $16,210,896 $14,457,196 $43,312,984 $12,223,547 $21,007,080 =========== =========== =========== =========== =========== ===========

The above excel with 'show formula' is as follows:

A D Н K 2019 2 ---- ------ -------- -- Himalaya Waistliner 3 Grand Prix Phoenix Pike's Peak Touring Mountain 4 Total Touring Percent Mountain Percent Stationary Percent Percent Percent 5 675454 6 Units 498524 984386 182441 233412 7 Selling Price per Unit =17/17 =K7/K7 =C7/C7 =E7/E7 =G7/G7 75 95 135 188 299 ---- - ------------- ----------- 9 Total Sales Revenue =16*17 =C6*C7 =E6*E7 =G6*G7 ЕК6*к7 =C9+E9+G9+19+K9 10 11 Cost per Unit: 12 Material =C12/$C$7 =E12/ŞE$7 =G12/$G$7 =112/$I$7 =K12/$K$7 15 25 39 57 =C13/$C$7 =E13/$E$7 =E14/ŞE$7 =G13/$G$7 13 Labor =113/$I$7 =K13/$K$7 11 14 19 18 40 =G14/$G$7 =K14/SK$7 14 Overhead =C14/$C$7 =114/ŞI$7 25 32 47 64 112 15 - -------- --------- ----- --------- ------ --------------- 16 =SUM(C12:C15) =SUM(D12:D15) =SUM(E12:E15) =SUM(F12:F15) =SUM(G12:G15) =SUM(H12:H15) =SUM(112:115) =SUM(J12:J15) =SUM(K12:K15) =SUM(L12:L15) 17 Total Cost of Goods Sold =C17+E17+G17+117+K17 =C16*C6 =E16*E6 =G16*G6 =116*16 =K16*K6 18 -------- -------- ------- ---------------- 19 =89-B17 =C9-C17 =E9-E17 =G9-G17 =19-117 =K9-K17 20 =========== ========== ========== ========== ========== =========== 21