Cost terms and Purposes Worksheet Solutions from Live Class

We are a car manufacturing company - we make cars. Our cost object is a car, i.e. we are trying to assign cost The car is being built in a factory and uses 20 machine hours. Based on the cost of the car, we will come up w sure we recover the costs and earn our desired return. Direct Manufacturing Costs EXAMPLE Direct Materials (DM) Tires, transmission, engine, metal, upholstery, lights, Direct Manufacturing Labour (DML or DL) Mechanic, welder, assembler, any wage based (like pe MANUFACTURING OVERHEAD (MOH) = INDIRECT MANUFACTURING COSTS Indirect Materials (IDM) Glue, supplies, oil, paint, rags, lubricants Indirect Manufacturing Labour (IDL) Manufacturing supervisors, sanitation salaries, inspec Other indirect costs Plant insurance, depreciation, factory rent, property t EXAMPLE DIRECT MATERIALS (DM) MANUFAC Quantity Cost per item Total Cost Manufactu Metal 500 $6 $3,000 Sanitation Engine 1 $4,000 $4,000 Indirect ma Seats 5 $200 $1,000 Plant insur Panes of glass 8 $125 $1,000 depreciatio radio 1 $1,000 $1,000 Property ta tires 4 $100 $400 Utilities $10,400 Plant repai Inspection DIRECT LABOUR (DL) Hours Wage Total Cost Driver is m Welder 10 $50 $500 Assembler 20 $50 $1,000 Mechanic 20 $65 $1,300 $2,800 In other wo every mach MANUFACTURING OVERHEAD (MOH) the MOH. Machine hours 20 MOH Allocation rate $100 MOH Allocated $2,000 TOTAL COST OF CAR DM $10,400 DL $2,800 MOH Allocated $2,000 Total Cost of car $15,200 TARGET MARKUP (100%) $15,200 We mark up cars 100% in order t FINAL PRICE $30,400

Gross Profit margin 50.0% ACCURATE COSTING leads to acc Imagine if we did NOT include M we would be underrecovering th PRODUCT VS PERIOD COSTS PRODUCT COSTS = INVENTORIABLE COSTS = MANUFACTURING COSTS = DM + DML + MOH PERIOD COSTS = nonproduct costs = nonmanufacturing costs = SG&A = operating expenses TYPES OF INVENTORY FOR MANUFACTURING COMPANITES TYPE EXAMPLE RM/DM Raw/Direct Materials steel, glass, etc. raw materials that are in the STORAGE WIP Work in Process/Progress Products that are 1% complete to 99% complete, unfin FG Finished Goods 100% complete products.

curate pricing to recover costs and get a target return. MOH, we would not be getting the desired return as he costs needed to make the car. E ROOM nished products in the WORKSHOP/FACTORY

Prepare a schedule of cost of goods manufactured in good form. Only input in the YELLOW cells. The following costs relate to one month’s activity for Terrace Inc. Indirect materials $ 300 Rent on factory building $ 500 Maintenance of equipment $ 50 Direct material used $ 1,200 Utilities on factory $ 250 Direct labour $ 1,500 Selling expense $ 500 Administrative expense $ 300 Work-in-process inventory, beginning $ 600 Work-in-process inventory, ending $ 800 Finished goods inventory, beginning $ 500 Finished goods inventory, ending $ 250 Direct Materials used $1,200 Direct Labour $1,500 Manufacturing Overhead: Utilities on Factory $250 Rent on Factory Building $500 Indirect Materials $300 Maintenance of Equipment $50 Total Manufacturing Costs $3,800 Add: WIP Beginning $600 Less: WIP end -$800 Make sure Cost of Goods Manufactured $3,600 Add: Beg FG Inventory $ 500 Less: Ending FG Inventory $ (250) Cost of Goods Sold $3,850

ng DM WIP y

Classify th Place an

of preparing the financial statements for the bank. DM + DML + MOH Nonproduct costs = SG&A Product Cost (Inventoriable) Period Cost (Expensed) X X X X X X X X X X X X X X X

Sales Revenue $ 3,200,000 *Cost of Goods Sold $ (2,510,000) This is calculated below. Gross Profit $ 690,000 Selling Expense $ (110,000) Make sure this cell is negative (all costs are negative) Admin Expense $ (470,000) Make sure this cell is negative (all costs are negative) Operating Income $ 110,000 *COGS Calculation: BI + P - EI = COGS Beginning Inventory $ 140,000 Purchases $ 2,550,000 Less: Ending Inventory $ (180,000) Make sure this cell is NEGATIVE. COGS $ 2,510,000 Last month, Decathlon, a global sporting goods retailer, had total sales of $3,200,000, selling expenses of $110, expenses of $470,000. The company had beginning merchandise inventory of $140,000, purchased additional m $2,550,000, and had ending merchandise inventory of $180,000. Prepare an income statement for the company for the month. Only input in the YELLOW cells!

Consider the following account balances (in thousands) for the SunLight Company Direct Materials (DM) Inventory Work-in-process (WIP) Inventory Finished Goods (FG) Inventory Purchase of Direct Materials Direct Manufacturing Labour (DL) Indirect Manufacturing Labour (IDL) Plant Insurance Depreciation - Plant building & equipment Repairs & Maintenance - Plant Marketing, distribution, and customer service costs General & Administrative (G&A) Costs Required: 1. Prepare a schedule of costs of goods manufactured for 2019. 2. Revenues in 2019 were $300M. Prepare the 2019 statement of comprehensive inco Only fill-in the YELLOW cells! ANSWER PART 1 SunLight Company Calculation of Cost of Goods Manufactured For the Year ended Dec 31, 2019 In Thousands Direct Materials Costs: BEG DM Inventory Purchases of DM DM Available to Use Less: Ending DM Inventory Direct Materials Used DL Utilized Indirect Manufacturing Costs: IDL Costs Plant Insurance Depreciation - Plant building & equipment Repairs & Maintenance - Plant Total Indirect Manufacturing Costs (MOH) 2019 Total Manufacturing Costs Add: Beginning WIP Inventory Total Manufacturing Costs to account for Less: Ending WIP Inventory Cost of Goods Manufactured (COGM) Part 2 SunLight Company

Statement of Comprehensive Income For the Year ended Dec 31, 2019 In Thousands Revenue Cost of Goods Sold: Beginning FG Inventory COGM Cost of Goods Available for Sale (COGAS) Less: Ending FG Inventory Cost of Goods Sold Gross Margin Operating Expenses: Marketing, distribution, and customer service costs General & Administrative (G&A) Costs Total Operating Expenses Operating Income

$300,000 $18,000 $136,000 $154,000 $23,000 STEP 4: Calculate Cost of Goods Sold $131,000 COGS = Beg FG Inventory + COGM - Ending FG Inventory $169,000 $93,000 $29,000 $122,000 $47,000

RM Raw Materials WIP Work-in-Process FG Finished Goods DM used = Beg DM Inventory + Purchases of DM - Ending DM COGM = Manufacturing Costs Incurred + Beg WIP - End WIP MC Incurred = Direct Materials used + Direct Manufacturing Labour + Manufacturing Overhead MC incurred = DM Used + DML + MOH COGS = Beg FG Inventory + COGM - Ending FG Inventory COGS = COGAS - Ending FG Inventory