X AutoSave ( Off - ACCT_2302_Project_David_Colunga . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share & Cut Calibri 11 ap Wrap Text General 2 AutoSum Normal Bad Good AY Paste Copy B I Merge & Center % " :08 Conditional Format as Neutral Calculation Check Cell nsert Delete Format Fill Sort & Find & Add-ins Analyze Format Painter Formatting Table Clear Filter * Select Data Clipboard Font Alignment Number Styles cells Editing Add-ins E15 M O P Q R V W General Journal Date Description Debit Credit W N 1-Dec Raw Materials 5 24,000 The Excel template is formatted to help with the journal entries. The description of the journal entry is Accounts Payable $ 24,000 below the journal entry itself. The first joumal entry should be entered in the first two rows. Record raw materials purchased on account 5-Dec Work In Process $ 5,800 Dec 1 Raw Materials ##### Raw Materials Accounts Payable ##### Requistion of raw materials Job #1 Record purchase of Raw Materialson Acct. 10-Dec Work In Process S 120 Manufacturing Overhead 2,700 salaries and Wages Expense 1,700 Salaries and Wages Payable 4,400 Record salaries and wages incurred 12-Dec Manufacturing Overhead $ 3,900 Salaries and Wages Payable 3,900 Record the application of Manufacturing Overhead to Job #1 Requistion of raw materials Job #2 Record the factory rent for the month Record advertising costs Record depreciation for the month Record property insurance for the month 36 Record the transfer of Job #1 to Finished Goods 27 General Journal Job #1 Cost Sheet Job #2 Cost Sheet | T-accounts (General Ledger) Schedule of COGM, COGS & Income + Ready Accessibility: Investigate 100% Type here to search W 1:20 PM 9/21/2024 27X AutoSave ( Off) - ACCT_2302_Project_David_Colunga . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share & Cut 2 AutoSum Calibri ap Wrap Text Accounting Accent4 Accent5 Accent6 AY O Paste Copy Conditional Format as nsert Delete Add-ins comma [0] Format Fill Currency Sort & Find & Analyze B I A Merge & Center 9% Comma Table Filter ~ Select Data Format Painter Formatting Clear ~ Clipboard Font Alignment Number Styles Cells Editing Add-ins F18 : X V fx Job Cost Sheet Direct Materials: Job Number 1 Date Initiated 1-Dec Item Table Date completed Direct Matarials Direct Labor Manufacturing Overhead Amount Hours Rate Amount Hours Rate Amount 5,800 60 45 2700 60 $65.00 $3,900.00 Cost Summary Direct Materials $ 5,800.00 Direct Labor $ 2,700.00 Manufacturing Overhead $ 3,900.00 Total Product Cost $ 12,400.00 Unit Product Cost $ 12,400.00 General Journal Job #1 Cost Sheet Job #2 Cost Sheet | T-accounts (General Ledger) Schedule of COGM, COGS & Income + Ready x Accessibility: Investigate 70% 1:20 PM Type here to search W 9/21/2024 527X AutoSave ( Off) - ACCT_2302_Project_David_Colunga . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share & Cut Calibri 11 ap Wrap Text General 2 AutoSum Normal Bad Good AY O Fill Paste Copy B I Av Merge & Center % " Conditional Format as Neutral Calculation Check Cell nsert Delete Format Sort & Find & Add-ins Analyze Format Painter Formatting Table Clear ~ Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Add-ins F38 N N - Job Cost Sheet Direct Materials: Job Number Date Initiated Item Date completed Direct Matarials Direct Labor Manufacturing Overhead Amount Hours Rate Amount Hours Rate Amount Cost Summary Direct Materials Direct Labor Manufacturing Overhead Total Product Cost Unit Product Cost General Journal Job #1 Cost Sheet Job #2 Cost Sheet T-accounts (General Ledger) Schedule of COGM, COGS & Income + Ready 1x Accessibility: Investigate 67% Type here to search W 1:20 PM 9/21/2024 527X AutoSave ( Off - ACCT_2302_Project_David_Colunga . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share & Cut Calibri 11 ap Wrap Text Custom Accent6 2 AutoSum Accent4 Accent5 AY O Paste Copy Conditional Format as nsert Delete Format Fill B I Merge & Center % Comma Analyze Format Painter Table comma [0] Currency Sort & Find & Add-Ins Formatting Clear ~ Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Add-ins B40 iXVfx v D G M W AA AB AC AD AE Accounts Receivable Accounts Payable Sales Revenue S 24,000 1-Dec Raw Materials Salaries and Wages Payable 1-Dec $ 24,000 2,700 10-Dec 1,700 10-Dec Cost of Goods Sold Work In Process 1-Dec $ 6,240 Salaries and Wages Expense 10-Dec $ 2,700 10-Dec $ 1,700 Finished Goods Advertising Expense Depreciation Expense Manufacturing Overhead 40 41 General Journal Job #1 Cost Sheet Job #2 Cost Sheet T-accounts (General Ledger) Schedule of COGM, COGS & Income + Ready Accessibility: Investigate 90% W 1:20 PM Type here to search 9/21/2024 527X AutoSave ( Off) - ACCT_2302_Project_David_Colunga . Saved to this PC v Search File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share & Cut Calibri 11 ap Wrap Text General 2 AutoSum Normal Bad Good AY Paste Copy Merge & Center % " :08 Conditional Format as Neutral nsert Delete Format Fill Sort & Find & Add-ins Calculation Check Cell Analyze B I Format Painter Formatting Table Clear ~ Filter * Select Data Clipboard Font Alignment Number Styles Cells Editing Add-ins A22 : XVfav B D H M O P Q R U W Thunderduck Custom Tables, Inc. Thunderduck Custom Tables, Inc. Thunderduck Custom Tables, Inc. Schedule of cost of goods manufactured Cost of goods sold Income Statement For the month Ended December 31, 20XX For the month Ended December 31, 20XX For the month Ended December 31, 20XX General Journal Job #1 Cost Sheet Job #2 Cost Sheet | T-accounts (General Ledger) Schedule of COGM, COGS & Income + Ready 1x Accessibility: Investigate + 100% 1:20 PM Type here to search W 9/21/2024 27