Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Modern Auditing And Assurance Services

Authors: Philomena Leung, Paul Coram, Barry J. Cooper, Peter Richardson

6th Edition

1118615247, 9781118615249

More Books

Students also viewed these Accounting questions

Question

Convert each polar equation to a rectangular equation. 1 + cos 0

Answered: 1 week ago