Question: using the formula, compute the monthly overhead coast for each sold unit AutoSave 2018 Final Workbook Data Group C Rev3 (21xx - Excel File Data

using the formula, compute the monthly overhead coast for each sold unit
 using the formula, compute the monthly overhead coast for each sold

AutoSave 2018 Final Workbook Data Group C Rev3 (21xx - Excel File Data Review View Help Search Home Insert Draw Page Layout Formules 12 HAAR . BTV - BA Number Parte Wed Mage & Co $ % Condronal Format as co Formatting Table Style Clipboard rt Alignment Number Styles ABS - f O Overhead per unit A D G 2 Products Material Labor Shipping Annual labor Unit Unit Labor Unit of 3 Costs Hours Cost/Uni Units/Sold Cost Cost Cost Sales 4 Cap Gamma Rays $860.75 25 $18.00 475 $1,612.50 $2,491,25 64.73% 1.8696% 5 Boom Machine $1,550,50 35 $25.00 47 $2,257.50 $3,833.00 58 90% 0.1850 6 Anvils $960.00 22 $95.00 60 $1,419.00 $2,474.00 5736% 0.2362% 7 Traffic Lights $750.45 5 $65.00 700 $322.50 $1 137.95 28.34% 2.7553% 8 Jet Motor $233.13 10 $45.00 300 $645.00 $923.13 69.87% 1.1808% 9 Roller Skates $25.00 2 $5.00 5000 $129.00 $159.00 81.13% 19.6804% 10 Dehydrated Boulders $46.10 4 $2.00 150 $258.00 $306.10 84.29% 0.5904% 11 Rockets $811.25 15 $75.00 324 $967.50 $1,853.75 52.19% 1.2753% 12 Out Board Motor $345.00 12 $35.00 500 $774.00 $1,154.00 67.07% 2.3616% 13 Detonator $15.00 3.5 $1.20 350 $225.75 $241.95 93.30 1.3776% 14 Explosive Tennis Ball $13.00 1 $0.75 7500 $64.50 $78.25 82.43% 29.5200% 15 Disintegrating Pistol $78.15 $4.30 188 $277.35 $359.80 0,7400% 16 Jet Propelled Unicycle $346.10 23 $75.00 157 $1.483.50 $1,904,60 77.89% 0.61HOX 17 Giant Rubber Band $1.50 0.75 $0.55 9000 $48.38 $50.43 95.93 35.4247% 18 TNT $455.00 83 $375.00 555 $5.353 5056,183.50 86.58% 2.1845% 19 Totals S6,490.93 245.55 $821.80 25 406 $15,837,98 $23,150.71 100,0000 20 21 $5,403.00 22 Overhead Cost/month $64.50 23 Labor Rate/hour Sheet1 Sheet2 Sheet3 Sheet Edit be to search O Down esc DIE 2 3 5 6 7 8 ob W E R . Y U ps lock AS D F G H

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!