ABI-WE1 - ABI-WE 1 Better Battery Inc Business Issue TOPIC Cost of Goods Sold and Cost Classifications(CH 2-3 Kelly Rodriquez owner of Better

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
ABI-WE 1: Better Battery, Inc. Business Issue TOPIC: Cost of Goods Sold and Cost Classifications (CH 2-3) DATA for the Electric Car (EC) battery only: 2011 2010 2009 Number of units sold: 22650 21100 20100 Following data are in $ (rounded to whole dollars): Direct materials purchased 73613 68575 65325 Indirect labor 72000 72000 72000 Direct materials inventory, Jan 1 11915 10143 8694 Direct materials inventory, Dec 31 14015 11915 10143 Factory depreciation 42000 42000 42000 Factory insurance 5000 5000 5000 Direct labor 96263 89675 85425 Sales 588900 548600 522600 58000 58000 58000 Sel ing expenses 80000 80000 80000 Administrative expenses 65000 65000 65000 Work in process inventory, Jan 1 28800 28300 27500 Work in process inventory, Dec 31 30000 28800 28300 Finished goods inventory, Jan 1 66000 56000 54000 Finished goods inventory, Dec 31 80000 70000 60000 Additional Information about manufacturing costs for ALL three product lines: Product Account name 2011 2010 2009 HG Direct Materials Used 67430 56804 49266 IF Direct Materials Used 38750 37661 35100 EC Direct Materials Used 71513 66803 63876 HG Direct Labor 53131 50457 47917 IF Direct Labor 25089 24777 23896 EC Direct Labor 93925 89675 85425 HG Manufacturing Overhead 185223 175036 165638 IF Manufacturing Overhead 122675 119876 108955 EC Manufacturing Overhead 177000 177000 177000 REQUIRED: 1=Reference cel s-link data Type ' =" fol owed by "worksheetname"!cel label 2=Group data Select rows, then Data-Outline-Group-Group 3=Creat a pivot table Select data with headers, then Insert-Tables-Pivot Table 8=Insert header and footer 9=Format font, currency, %, units Home-Number-$ and right arrow to decrease decimals 10=Merge cel s 11=Wrap text Home-Alignment-Wrap Text 12=Align at top/left of cel Home-Alignment-Align Text Left or Align Text Top 14=Borders Home-Font-Borders 15=Indent data Home-Alignment-Increase Indent 21=Sum Formula-Function Library-Auto Sum-Sum 23=Formula auditing Formulas-Formula Auditing-Show Formulas 35=Print landscape Page Layout-Page Setup-Orientation-Landscape
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/04/2011 for the course ACC 202 taught by Professor Sue during the Spring '10 term at Michigan State University.

Ask a homework question - tutors are online