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 #2 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,500.00
		Table Leg	$400.00
		Drawer	$350.00
	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	$2,500.00
	b.	Rent for the factory per month	$1,100.00
	c.	Depreciation of factory equipment per month	$600.00
		Total Estimated manufacturing overhead	$4,200.00

Step 2	The first order you received was to manufacture a table using a table top and four legs. This is your Job #1.
Step 3	The customer that has ordered Job #2, wants a table that is the same as Job #1, but wants to also add a drawer to the table.

AutoSave) Hon ACC 2302 Jub Oide: Costing project Excel template- O Scarch Patrick Tran PI Filc Home Inscurt Pace: Layout Formulas Data: Rovi Vic Help Acrobat Share Comments X Cut Autosum General Y IL Copy Calibri 1 AA ==== ab wrap Text BIUDA ====Merge & Center WILL EH SI TEX Inser. Delele Formal Posle $ %) 28 Clear Conditional Formal da | Cell Fomatting Table Styles Sales Sort & Find & Filtar Salact Format Painter Analyze Data Clipboard -ort Alignment E Number CSI: Lditirs Analysis V20 B F G H i i M N P R S 1 2 3 Direct Materials: Job Cost Sheet Job Number 1 5 Dalu ile Date completed item ! 1 Dirndt labar Direct Mataras Amourt Manufacturing Chrad Hours Hate Amount Haurs Rate Amount 9 3 3 10 11 Cast Summary Dirart Materiais Dirert abor Manufacturing Lverhead Total Product Cost Unil Product Cos! 12 13 14 15 16 17 18 15 20 22 22 23 24 25 26 27 20 1111 General lournal Job #1 Cost Sheet nhe Cost Short T accounts General Treger) Schedule of COGM, COGS B Income + Feat B74 1023 PM 0 76F Clear F 7/12/2121 AutoSave H9 ACCT 2302 Job Older Costing project Excel template Scaren Patrick Tran PI DE - Filc : Home Inscurt Page Layout Formulas Data: Review Vic Help Acrobat Share Comments Calibri General WILL EH Y X Cut IL Copy Format Painter Clipboard TAA === a wrap Text UA ====Merge & Center Autosum Fill Clear Posle BIU $ %) 28 Insell Delele Formal Conditional Formal da Cell Formatting Table Sylns Z Sort & Find & Filtar Salact Analyze Data Anysis -ort Alignment E Number Sic Call: Lditirs H38 13 4 1 1 2 Direct Materials: Job Cost here Job Number 29 Irlated . TI 6 :- 7 Manufacture Direc: Mar Pull Tu. Tals Pull Hus 1: .. 9 . 3 Dres Made 4 Wannels Tata Predu 2 Jnit Product Co. ull 2: 11 32 13 31 35 19 General lournal lob #1 Cast Sheet Job #2 Cost Sheet Tacrourts General Irriger Schedule of COGM COGS & Income + Rasd 574 76F Clear 1023 PM 9,1221221