Project #$1$

Traditional Job Costing in Excel or Accounting Software

Due in Class or Canvas by Friday, September $20,11$:$50$ a$.$m$.$

Job costing, journal entries. Hamilton Transport assembles prestige manufactured homes. Its

job$-$costing system has two direct$-$cost categories $($direct materials and direct manufacturing labor$)$

and one indirect$-$cost pool $($manufacturing overhead allocated at a budgeted $$32$ per machine$-$hour

in $2017).$ The following data $($in millions$)$ show operation costs for $2017$:

Required, complete only parts $2$ and $3$ either in Excel or Accounting Software:

Prepare journal entries necessary based on the above information. Number your entries for

feedback purposes. Explanations for each entry may be omitted. Post to T$-$accounts for all

involved accounts using the power of Excel. What is the ending balance of Work$-$in$-$Process

Control?

Show the journal entry for disposing of under$-$ or overallocated manufacturing overhead

directly as a year$-$end write$-$off to Cost of Goods Sold. Post the entry to the relevant T$-$accounts.