NSU Printing, Inc. produces three types of textbooks: ACCT, BADM, and MIS. The textbooks have to go through three different departments: Printing, Binding, and Packaging. Since each textbook is different, the Printing department uses Job Costing to account for the costs of each type of textbook. Once the textbooks are printed, they are sent to the Binding department where all textbooks are bound as part of a continuous process. The Binding department uses the Weighted Average method of Process Costing as it is not interested in knowing the differences between current period and prior period costs. From the Binding Department, the textbooks are transferred to the Packaging department where they are packaged and prepared for bulk shipment to large bookstores. The Packaging department keeps track of its current period costs by separating them from the prior period costs and therefore uses First-In, First-Out method of Process Costing. Printing Department: At the start of September, the Printing department estimated total overhead costs of $500,000. Since each textbook consumes equal amount of printing overheads, the Printing department allocates the overhead costs using a predetermined overhead rate based on the number of textbooks printed. The estimated number of textbooks to be printed in September was set at 147,500 textbooks. The following data relates to the Printing department activities during September ACCT BADM MIS 84.000 42,000 Actual number of textbooks printed in September 14,000 Beginning Work-in-Process S 125,000 S - Direct Materials $ 170,847 S 42,712S 4,746 Direct Labor $ 177,240S 88,620 $ 29,540 Actual overheads for Printing department amounted to $412,124 during September. The Printing department allocates any under or over applied overheads to Cost of Goods Transferred Out if they are less than 10% of the Cost of Goods Transferred Out. If the under or over applied overheads are greater than 10% of Cost of Goods Transferred Out, then they are applied proportionally to Cost of Goods Transferred Out, Work-in- Process Inventory, and Finished Goods Inventory based on their balances at the end of the period. At the end of September, Cost of Goods Transferred Out, Work-in-Process Inventory, and Finished Goods Inventory had the following balances: Allocation of Under (Over) applied Overheads: Balance at the end of September Cost of Goods Transferred Out $ 592,969 Work-in-Process Inventory $ 98,828 Finished Goods Inventory $ 296,484 Prepare a Job Costing worksheet in MS Excel for the Printing department that calculates the following: Predetermined overhead rate Total costs of printing each type of textbook during September Total costs of Direct Materials, Direct Labor, and Applied Overhead incurred by the Printing department during September Printing cost per unit for each type of textbook printed during September Schedule for allocation of under (over) application of overheads See the sample Job Costing worksheet of InShape, Inc. from Chapter 7 attached to the dropbox Binding Department: At the start of October, the Binding department had work-in-process inventory of 24,000 textbooks made up of the following: Beginning Balances Amount Prior Department $169,420 Materials $16,942 Direct Labor $50,826 Overheads $101,652 During October, the Binding department received 84,000 units from the Printing department with a cost of $592,969. The Binding department added the following costs during October Amount Materials $59,297 Direct Labor $177,891 Overheads S355,781 At the end of October, the Binding department finished 100,000 textbooks and transferred them to the Packaging department. The degree of completion of the work-in- process inventory left unfinished at the end of October was as follows: Degree of Completion Materials Direct Labor Overheads 35% Prepare a production cost report in MS Excel using the weighted Average method consisting of the following: Units to be accounted for Units accounted for Costs to be accounted for Cost per equivalent units Costs accounted for See the sample production cost report of Kansas Supplies from Problem 8-48 of Chapter 8 attached to the dropbox. Packaging Department: At the start of November, the Packaging department had work-in-process inventory of 10,000 textbooks made up of the following: Degree of Completion Beginning Balances Amount 100% Prior Department $143.860 90% Materials $43,158 75% Direct Labor $14,386 60% Overheads $86,316 During November, the Binding department received 100,000 units from the Printing department with a cost of $1,438,595. The Binding department added the following costs: Amount Materials $431.579 Direct Labor $143,860 Overheads $863,157 At the end of November, the Packaging department finished 107,000 textbooks and transferred them to the Shipping department. The degree of completion of the work-in- process inventory left unfinished at the end of November was as follows: Degree of Completion Materials 80% Direct Labor 70% Overheads 45% Prepare a production cost report using the First-in. First-Out method consisting of the following: Units to be accounted for Units accounted for Costs to be accounted for Cost per equivalent units Costs accounted for See the sample production cost report of Kansas Supplies from Problem 8-49 of Chapter 8 attached to the dropbox. A template is provided (as an attachment to the dropbox) for your convenience. 2016 Debit Amoet 1 2017 Debit AccotD Accot Desaiption Credit Amt Creat 1,987.28 198,116.52 2275.23 557125.92 3,644,958.13 16,410,902.71 3545599.15 51515259.98 1250000 1,262,819.88 1239.009.75 18,825,215.24 67724527.5 3,012,000.00 845000 3424213.78 743,314.38 200,000.00 7,406.82 8540 117,000.00 623,905.92 433,217.10 117000 674313.92 2929197.13 163,500.00 609500 572,691.08 53,840.59 1998780.39 53840.59 4,633,118.09 1922095.91 29,470.32 1,318.69 583.99 6,033.01 8439.65 11414.99 118186.12 2,815.47 55106.86 10100 Cash on Hand 10200 Regular Checking Account 10300 Payrol Checking Account 10400 Savings Account 11000 Accounts Receivable 11400 Other Receivables 11500 Alowance for Doubtful Accounts 12000 lentory - Spotlight 12300 Reserve for hventory Obsolescence 14100 Prepaid Insurance 14200 Prepaid Rent 14300 Office Supplies 14400 Notes Receivable Cument 14700 Other Current Assets 15000 Land 15100 Buildings and Land Improvements 15200 Machinery, Equipment, Ofice Fumiture 17000 Accum. Depreciation 19000 Ivestments 19900 Other Noncurrent Assets 20000 Accounts Payable 23100 Sales Tax Payable 23200 Wages Payable 23300 FICA Employee Withholding 23350 Medicare Withholding 23400 Federal Payroll Taxes Payable 23500 FUTA Tax Payable 23600 State Payroll Taxes Payable 23700 SUTA Tax Payable 23800 FICA Employer Withhoking 23900 Medicare Employer Withholding 24100 Line of Credit 24200 Current Portion Long-Term Debt 24700 Other Current Liabilities 27000 Notes Payable Noncurrent 39013 Common Stock 39.014 Paid in Capital 39015 Retained Eamings 40000 Sales 41000 Sales Retums 42000 Warranty Expense 45000 Income from Investments 46000 hterest Income 47000 Miscellaneous Income 50100 Cost of Goods Sold 57500 Freight 60000 Advertising Expense 61000 Auto Expenses 62000 Research and Development 64000 Depreciation Expense 64500 Warehouse Salaries 65000 Property Tax Expense 66000 Legal and Professional Expense 67000 Bad Debt Expense 68000 Insurance Expense 700.00 Maintenance Expense 70100 Urties 70110 Phone 70120 Postal 71000 Miscellaneous Ofice Expense 72000 Payroll Tax Exp 7200 Pension Profi-Sharing Plan Ex 74000 Rent or Lease Expense 77500 Administrative Wages Expense 78000 Interest Expense 78500 Income Tax Expense - Federal 78510 Income Tax Expense - State 80000 Loss on Legal Settlement 1,318.69 583.99 10,000,000.00 8439.65 11414.99 44403000 8,105,000.00 7,423,000.00 2,219,620.65 246,172,918.44 12000000 8105CCD 7423000 6590983.64 242713452.9 4,497,583.20 1,100,281.48 11100220.89 1158128.47 204,312.81 1426189.31 131881.46 2166000 130196645.3 4240263.09 1036854.01 210502.8 528870.44 446000 4720715.56 99332.45 4913224.45 141,569,221.61 4,312,951.46 897,140.01 21:3.974.39 31,212,334.17 133,000.00 4,633,383.82 80,495.32 3,615,133.96 1,622,425.99 853,942.65 61,135.04 135,642.99 76,373.78 128,033.21 17,023.27 1,550,989.06 3,000,000.00 2,603,485.87 16,875,305.98 875,000.00 2,365,000.00 429,000.00 19,172,000.00 36106.92 X512.87 137332.18 52599.02 77803.61 24891.82 1577811.85 3310.000 1216574 16197225.43 2591736.5 890DDDD 3100000 283,238,404.03 283,238,404.03 #********* 329788915.2 KANSAS SUPPLES Proceso Costing (Weighted Average) October 30, 2017 Equivalent Unit ALOW OF PRODUCTION UNITS: * Physical Unit Prior * Department Complete Materiale Complete Labor Complete Overheado complete Units to be accoted for. Beginning WP inventory Units started this period Total units b account for Unite accounted for. Units completed and transferred out From beginning inventory Started and completed currently Total transferred out Units in ending inventory Total units accounted for Tot Cost. COSTS Costa to be accoted for. Costs in beginning WP inventory Current period costs Total costs b be accounted for Cost per equivalent it Prior department Materials Labar Overhead Costa accounted for Costs assigned bunits transferred out Prior department Materials Labor Overhead Total costs of units transferred out Costs assigned bending WP inventory Prior department Materials Labor Overhead Total ending WP inventory Total cost accounted for NSU Printing, Inc. produces three types of textbooks: ACCT, BADM, and MIS. The textbooks have to go through three different departments: Printing, Binding, and Packaging. Since each textbook is different, the Printing department uses Job Costing to account for the costs of each type of textbook. Once the textbooks are printed, they are sent to the Binding department where all textbooks are bound as part of a continuous process. The Binding department uses the Weighted Average method of Process Costing as it is not interested in knowing the differences between current period and prior period costs. From the Binding Department, the textbooks are transferred to the Packaging department where they are packaged and prepared for bulk shipment to large bookstores. The Packaging department keeps track of its current period costs by separating them from the prior period costs and therefore uses First-In, First-Out method of Process Costing. Printing Department: At the start of September, the Printing department estimated total overhead costs of $500,000. Since each textbook consumes equal amount of printing overheads, the Printing department allocates the overhead costs using a predetermined overhead rate based on the number of textbooks printed. The estimated number of textbooks to be printed in September was set at 147,500 textbooks. The following data relates to the Printing department activities during September ACCT BADM MIS 84.000 42,000 Actual number of textbooks printed in September 14,000 Beginning Work-in-Process S 125,000 S - Direct Materials $ 170,847 S 42,712S 4,746 Direct Labor $ 177,240S 88,620 $ 29,540 Actual overheads for Printing department amounted to $412,124 during September. The Printing department allocates any under or over applied overheads to Cost of Goods Transferred Out if they are less than 10% of the Cost of Goods Transferred Out. If the under or over applied overheads are greater than 10% of Cost of Goods Transferred Out, then they are applied proportionally to Cost of Goods Transferred Out, Work-in- Process Inventory, and Finished Goods Inventory based on their balances at the end of the period. At the end of September, Cost of Goods Transferred Out, Work-in-Process Inventory, and Finished Goods Inventory had the following balances: Allocation of Under (Over) applied Overheads: Balance at the end of September Cost of Goods Transferred Out $ 592,969 Work-in-Process Inventory $ 98,828 Finished Goods Inventory $ 296,484 Prepare a Job Costing worksheet in MS Excel for the Printing department that calculates the following: Predetermined overhead rate Total costs of printing each type of textbook during September Total costs of Direct Materials, Direct Labor, and Applied Overhead incurred by the Printing department during September Printing cost per unit for each type of textbook printed during September Schedule for allocation of under (over) application of overheads See the sample Job Costing worksheet of InShape, Inc. from Chapter 7 attached to the dropbox Binding Department: At the start of October, the Binding department had work-in-process inventory of 24,000 textbooks made up of the following: Beginning Balances Amount Prior Department $169,420 Materials $16,942 Direct Labor $50,826 Overheads $101,652 During October, the Binding department received 84,000 units from the Printing department with a cost of $592,969. The Binding department added the following costs during October Amount Materials $59,297 Direct Labor $177,891 Overheads S355,781 At the end of October, the Binding department finished 100,000 textbooks and transferred them to the Packaging department. The degree of completion of the work-in- process inventory left unfinished at the end of October was as follows: Degree of Completion Materials Direct Labor Overheads 35% Prepare a production cost report in MS Excel using the weighted Average method consisting of the following: Units to be accounted for Units accounted for Costs to be accounted for Cost per equivalent units Costs accounted for See the sample production cost report of Kansas Supplies from Problem 8-48 of Chapter 8 attached to the dropbox. Packaging Department: At the start of November, the Packaging department had work-in-process inventory of 10,000 textbooks made up of the following: Degree of Completion Beginning Balances Amount 100% Prior Department $143.860 90% Materials $43,158 75% Direct Labor $14,386 60% Overheads $86,316 During November, the Binding department received 100,000 units from the Printing department with a cost of $1,438,595. The Binding department added the following costs: Amount Materials $431.579 Direct Labor $143,860 Overheads $863,157 At the end of November, the Packaging department finished 107,000 textbooks and transferred them to the Shipping department. The degree of completion of the work-in- process inventory left unfinished at the end of November was as follows: Degree of Completion Materials 80% Direct Labor 70% Overheads 45% Prepare a production cost report using the First-in. First-Out method consisting of the following: Units to be accounted for Units accounted for Costs to be accounted for Cost per equivalent units Costs accounted for See the sample production cost report of Kansas Supplies from Problem 8-49 of Chapter 8 attached to the dropbox. A template is provided (as an attachment to the dropbox) for your convenience. 2016 Debit Amoet 1 2017 Debit AccotD Accot Desaiption Credit Amt Creat 1,987.28 198,116.52 2275.23 557125.92 3,644,958.13 16,410,902.71 3545599.15 51515259.98 1250000 1,262,819.88 1239.009.75 18,825,215.24 67724527.5 3,012,000.00 845000 3424213.78 743,314.38 200,000.00 7,406.82 8540 117,000.00 623,905.92 433,217.10 117000 674313.92 2929197.13 163,500.00 609500 572,691.08 53,840.59 1998780.39 53840.59 4,633,118.09 1922095.91 29,470.32 1,318.69 583.99 6,033.01 8439.65 11414.99 118186.12 2,815.47 55106.86 10100 Cash on Hand 10200 Regular Checking Account 10300 Payrol Checking Account 10400 Savings Account 11000 Accounts Receivable 11400 Other Receivables 11500 Alowance for Doubtful Accounts 12000 lentory - Spotlight 12300 Reserve for hventory Obsolescence 14100 Prepaid Insurance 14200 Prepaid Rent 14300 Office Supplies 14400 Notes Receivable Cument 14700 Other Current Assets 15000 Land 15100 Buildings and Land Improvements 15200 Machinery, Equipment, Ofice Fumiture 17000 Accum. Depreciation 19000 Ivestments 19900 Other Noncurrent Assets 20000 Accounts Payable 23100 Sales Tax Payable 23200 Wages Payable 23300 FICA Employee Withholding 23350 Medicare Withholding 23400 Federal Payroll Taxes Payable 23500 FUTA Tax Payable 23600 State Payroll Taxes Payable 23700 SUTA Tax Payable 23800 FICA Employer Withhoking 23900 Medicare Employer Withholding 24100 Line of Credit 24200 Current Portion Long-Term Debt 24700 Other Current Liabilities 27000 Notes Payable Noncurrent 39013 Common Stock 39.014 Paid in Capital 39015 Retained Eamings 40000 Sales 41000 Sales Retums 42000 Warranty Expense 45000 Income from Investments 46000 hterest Income 47000 Miscellaneous Income 50100 Cost of Goods Sold 57500 Freight 60000 Advertising Expense 61000 Auto Expenses 62000 Research and Development 64000 Depreciation Expense 64500 Warehouse Salaries 65000 Property Tax Expense 66000 Legal and Professional Expense 67000 Bad Debt Expense 68000 Insurance Expense 700.00 Maintenance Expense 70100 Urties 70110 Phone 70120 Postal 71000 Miscellaneous Ofice Expense 72000 Payroll Tax Exp 7200 Pension Profi-Sharing Plan Ex 74000 Rent or Lease Expense 77500 Administrative Wages Expense 78000 Interest Expense 78500 Income Tax Expense - Federal 78510 Income Tax Expense - State 80000 Loss on Legal Settlement 1,318.69 583.99 10,000,000.00 8439.65 11414.99 44403000 8,105,000.00 7,423,000.00 2,219,620.65 246,172,918.44 12000000 8105CCD 7423000 6590983.64 242713452.9 4,497,583.20 1,100,281.48 11100220.89 1158128.47 204,312.81 1426189.31 131881.46 2166000 130196645.3 4240263.09 1036854.01 210502.8 528870.44 446000 4720715.56 99332.45 4913224.45 141,569,221.61 4,312,951.46 897,140.01 21:3.974.39 31,212,334.17 133,000.00 4,633,383.82 80,495.32 3,615,133.96 1,622,425.99 853,942.65 61,135.04 135,642.99 76,373.78 128,033.21 17,023.27 1,550,989.06 3,000,000.00 2,603,485.87 16,875,305.98 875,000.00 2,365,000.00 429,000.00 19,172,000.00 36106.92 X512.87 137332.18 52599.02 77803.61 24891.82 1577811.85 3310.000 1216574 16197225.43 2591736.5 890DDDD 3100000 283,238,404.03 283,238,404.03 #********* 329788915.2 KANSAS SUPPLES Proceso Costing (Weighted Average) October 30, 2017 Equivalent Unit ALOW OF PRODUCTION UNITS: * Physical Unit Prior * Department Complete Materiale Complete Labor Complete Overheado complete Units to be accoted for. Beginning WP inventory Units started this period Total units b account for Unite accounted for. Units completed and transferred out From beginning inventory Started and completed currently Total transferred out Units in ending inventory Total units accounted for Tot Cost. COSTS Costa to be accoted for. Costs in beginning WP inventory Current period costs Total costs b be accounted for Cost per equivalent it Prior department Materials Labar Overhead Costa accounted for Costs assigned bunits transferred out Prior department Materials Labor Overhead Total costs of units transferred out Costs assigned bending WP inventory Prior department Materials Labor Overhead Total ending WP inventory Total cost accounted for