Balder-Dash Inc.

docs.google.com C https://metrostate-bb.blackboard.com/bbcswebdav/pid-10186094-dt-content-rid-. balder-dash - Google Sheets Community College of Denver HelpNow - Online Tutoring balder-dash * Share h File Edit View Insert Format Data Tools Add-ons Help Last edit was 47 minutes ago 100% * $ % .0 .00 123 Arial 10 B ISA D BE I HV V C + Y - E. fx B C D E F G H 1 K L M Balder - Dash Value Item Computed Answers you should get with your calculations $5.00 Selling price/part $6.70 Outsourced cost/part 10,000 Part demand/year $500,000 Electric bill $5.00 Computed indirect overhead cost/sq.ft $5.00 $150,000 Other utilities $850,000 Maintenance cost 300,000 Site sq. footage 10 1,000 Sq. ft required to make part $40,000 Annual direct labor cost 12 $60,000 Supervisor salary $120 Annual indirect labor cost $12,000 13 20% % of supervisor salary allocated to this part 14 $1.00 Raw material cost/kg 15 $0.25 Price/kg of drops $0.19 Value per kg of scrap raw material $0.19 16 0.75 kg/drop 17 20% G&A and R&D costs as % of manufactured goods 18 Analysis of Cost/Unit 19 Cost item Apparent Solution Actual In-house Outsourced Stop offering 20 Direct material 21 Direct labor 22 Indirect labor (supervision) 1.2 23 Indirect overhead 0.5 24 Total manufacturing cost 6.7 25 G&A and R&D costs 1.34 26 Total revenues 5 27 Unit profit 3.04 28 29 -3.04 -2.23 5.85 -6.85 + Sheet1 - + Explore