Question

Step 1 You work for Thunderduck Custom Tables Inc. This is the first month of operations. The company designs and manufactures specialty tables. Each table is specially customized for the customer. This month, you have been asked to develop and manufacture two new tables for customers. You will design and build the tables. This is a no nail, no screw, and no glue manufacturing (no indirect materials used). You will be keeping track of the costs incurred to manufacture the tables using Job #1 Cost Sheet and Job W2 Cost Sheet The cost of the direct materials that can be used to manufacture the table are as follows. These cost are on a per unit basis. Table Top $1,600.00 Table Leg $450.00 $360.00 Drawer The company uses a job order costing system and applies manufacturing overhead to jobs based on direct labor hours. The company estimates that there will be 12 direct labor hours worked during the month The estimated manufacturing overhead cost for the month is: a. Factory supervisor salary per month b. Rent for the factory per month c Depreciation of factory equipment per month Total Estimated manufacturing overhead $3,000.00 $1,200.00 $600.00 $4,800.00 What is the predetermined manufacturing overhead rate? 400 The first order you received was to manufacture a table using a table top and four legs. This is your job 1. The customer that has ordered Job 22, wants a table that is the same as Job #1, but wants to also add a drawer to the table. Step 2 Step 3 Step 4 The following is a list of transactions that need to be recorded for the company for activity in the month of December. Record those in the General Journal' tab of the excel file using the proper format. Please use the following accounts: Accounts Receivables, Raw materials, Work in process, Finished goods, Accumulated depreciation, Accounts payable, Salaries and wages payable, Sales revenue, Manufacturing overhead, Cost of goods sold, Salaries and wages expense, Advertising expenses, and Depreciation expense. 1-Dec Raw Materials purchased on account, 516,000. 5-Dec 10-Dec All Raw Materials needed for Job #1 were requisitioned from the material storage for use during the month. Assume all materials are direct. (After you journalize this entry please enter the information into Job #1 Cost Sheet) The following employee costs were incurred but not paid during the month: There are three assembly employees that spend 2 hours each, $30 per hour to make the table for Job #1. (After you journalize this entry please enter the information into Job 81 Cost Sheet) Salary for supervisor of the factory $3,500. Administrative Salary $2,000.

Answer 1

Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back Table Top Predetermined Overhead Rate $4,800/12 Hours $ 400 Estimated Overhead/Allocation Base Date Account Debit Credit $ 16,000 Dec 1 Dec 1 Raw Material Accounts Payable (Purchase of Raw Material) $ 16,000 $ 3,400 Dec 5 Dec 5 Work in Process Inventory $1,600+($450*4) Raw Material Inventory (Requisition of direct and indirect mat) $ 3,400 Actual 180 Dec 10 Dec 10 Dec 10 Dec 10 Work in Process Inventory (3*2*$30) Manufacturing Overhead Salaries and Wages Expense Salaries and Wages Payable (being labor cost recorded - direct and indirect) $ $ $ 3,500 2,000 Actual $ 5,680 Dec 15 $ 3,760 Work in Process Inventory $1,600+($450*4)+$360 Raw Material Inventory (Requisition of direct and indirect mat) $ 3,760 Dec 16 $ 1,200 Manufacturing Overhead Accounts Payable $ 1,200 Dec 17 $ 1,200 Advertising Expense Accounts Payable $ 1,200 Dec 20 Dec 20 Dec 20 $ $ 150 600 Actual Manufacturing Overhead Depreciation Expense Accumulated Depreciation (being ACTUAL overhead recorded) $ 750 $ 2,400 Dec 22 Dec 22 $ 2,400 Work in Process Inventory $400*6 Manufacturing Overhead (Overhead applied) (Predetermined Overhead Rate*Allocation Base) Applied $ 5,980 Dec 26 Dec 26 Finished Goods Inventory Work in Process Inventory $ 5,980 Cost of Goods Manufactured

$ 21,000 Dec 28 Dec 28 Accounts Receivable Sale S 21,000 $ 5,980 Dec 28 Dec 28 Cost of goods sold Finished Goods Inventory $ 5,980 Cost of Goods Sold $ 90 Dec 31 Dec 31 Work in Process Inventory (3*1*$30) Salaries and Wages Payable (To record labor cost recorded - direct and indirect) $ 90 $ 1,200 Dec 31 Dec 31 $ 1,200 Work in Process Inventory $400*3 Manufacturing Overhead (Overhead applied) (Predetermined Overhead Rate*Allocation Base) Applied $ 1,250 Dec 31 Dec 31 Cost of Goods Sold Manufacturing Overhead (To record underapplied overheads) $ 1,250 What is the ending balance for raw materials? $ 8,840 a What is the ending balance for work in process? $ 5,050b What is the ending balance for finished goods? $ с What is the actual manufacturing overhead cost incurred d $ 4,850 d What is the total applied manufacturing overhead cost du $ 3,600 e What is the unadjusted cost of goods sold? $ 5,980 f. Was the manufacturing overhead for the month of Sepem Under Applied What is the amount of Manufacturing overhead overappli $ 1,250 h What is the adjusted cost of goods sold? $ 7,230 i=f+h What is gross margin? $ 13,770 What is the total prime cost for Job#1? $ 3,580 k=$3,400+$180 What is the total conversion cost for job #1? $ 2,580 1=$180+$2,400 What is the total product cost for job#1? $ 5,980 m=$3,400+$180+$2,400 What was the period cost incurred for the month of Seper $ 3,800 n What is the total variable cost incurred for Job #1 $ 3,580 O $3,400+$180 What is the contribution margin for Job #1 $ 17,420 p=Sale- What would be the actual (not applied) total fixed manufd $ 4,850 Break up: Salary of Supervisor $ 3,500 Rent of Factory Building $ 1,200 Depreciation of Equipment $ 150 From RM T-Account From WIP T account From Finished Goods T Account From Manufacturing Overhead T Account From Manufacturing Overhead T Account Cost of Goods Sold T Account Since Applied overheads are less than actual Actual-Applied Unadjusted COGS+ovh adjusted Sale-Adjusted COGS RM+Labor Labor+Overheads RM+Labor+Overheads Salary+Dep+Advertising RM+Labor Sale-Variable Cost Since it is fixed for the month, it will remain

Predetermined Overhead Rate Estimated Overhead/Allocation Base Raw Material Debit Credit $ 16,000 Dec 5 $ 3,400 Dec 15 $ 3,760 Dec 1 Job Cost Sheet for Job No 1 Direct Material Direct Labor Rate Manufaturing Overhead Amount Hours Rate Amount Hours $ 3,400 Ending $ 8,840 6 $ 400 $ 2,400 Date 12/5 Date 12/10 Date 12/22 Cost Summary Direct Material Direct Labor Manufacturing Overhead Total Product Cost Unit Product Cost 30 $ 180 6 $ Units Shipped No Balance Date Work in Process Debit Credit Dec 5 $ 3,400 Dec 26 $ Dec 10 $ 180 Dec 15 $ 3,760 Dec 22 $ 2,400 Dec 31 $ 90 Dec 31 $ 1,200 Ending $ 5,050 5,980 $ $ $ $ $ 3,400 180 2,400 5,980 5,980 Job Cost Sheet for Job No 2 Direct Material Finished Goods Debit Credit Dec 26 $ 5,980 Dec 28 $ 5,980 Direct Labor Rate Manufaturing Overhead Amount Hours Rate Amount Hours $ 3,760 3 $ 30 $ 90 3 $ 400 $ 1,200 Date 12/15 Date 12/31 Date 12/31 Cost Summary Direct Material Direct Labor Manufacturing Overhead Total Product Cost Unit Product Cost Units Shipped No Date Balance Ending $ $ $ $ $ 3,760 90 1,200 5,050 5,050 Manufacturing Overhead Debit Credit Dec 10 $ 3,500 Dec 22 $ Dec 16 $ 1,200 Dec 31 $ Dec 20 $ 150 Dec 31 $ 2,400 1,200 1,250 Cost of Goods Sold Debit Credit $ 5,980 $ 1,250 Dec 28 Dec 31

Cost of Goods Manufactured: $ $ $ $ $ $ 16,000 16,000 -8,840 7,160 270 3,600 $ Finished goods inventory, beginning Work in process inventory, beginning Direct materials: Direct materials inventory, beginning Direct materials purchases Cost of direct materials available for use Direct materials inventory, ending Cost of direct materials placed in production Direct labor Factory overhead Applied Total manufacturing costs Total work in process during period Work in process inventory, ending Cost of goods manufactured Cost of finished goods available for sale Finished goods inventory, ending Cost of goods sold-Unadjusted Underapplied/(overapplied overhead) Cost of goods sold-Adjusted S $ $ S 11,030 11,030 -5,050 $ 5,980 5,980 $ $ $ $ $ $ 5,980 1,250 7,230 $ 21,000 Incme Statement: Sales Revenue Less: Cost of Goods Sold: COGS $ 7,230 $ 7,230 $ 13,770 Gross Margin Less: Selling and Admin: Salary Dep Advertising $ $ $ 2,000 600 1,200 $ $ 3,800 9,970