Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in all green CraftWorld - Inventory Listing Total Categories = Artist Canvas Inventory Costing Method Comparison CraftWorld Bank Reconciliation January 31, 2020 Beginning Bank
Fill in all green
CraftWorld - Inventory Listing Total Categories = Artist Canvas Inventory Costing Method Comparison CraftWorld Bank Reconciliation January 31, 2020 Beginning Bank Balance: Add: Deposits in Transit Deduct: Outstanding Checks Adjusted Bank Balance \$ 18,300 Beginning Book Balance: Add: Notes Receivable Deduct: NSF Check Bank Charges Check Error Adjusted Book Balance CraftWorld Depreciation Schedule \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{16}{|c|}{ Payroll Register } \\ \hline \begin{tabular}{l} Pay Period \\ Pay Date \end{tabular} & \multicolumn{15}{|l|}{2/3/20201/31/2020} \\ \hline & \multicolumn{7}{|c|}{ Earnings } & \multicolumn{6}{|c|}{ Deductions } & \multirow[b]{2}{*}{\begin{tabular}{l} Check \\ Number \end{tabular}} & \multirow[b]{2}{*}{ Net Pay } \\ \hline Employee Name & Regular Hours & \begin{tabular}{|c|} \begin{tabular}{c} Regular \\ Rate \end{tabular} \\ \end{tabular} & \begin{tabular}{l} Regular \\ Earnings \end{tabular} & \begin{tabular}{c} Overtime \\ Hours \end{tabular} & \begin{tabular}{|c|} \begin{tabular}{c} Overtime \\ Rate \end{tabular} \\ \end{tabular} & \begin{tabular}{l} Overtime \\ Earnings \end{tabular} & Total Earnings & FWT & SWT & social Security & Medicare & \begin{tabular}{l} Hospital \\ Donation \end{tabular} & Med. Plan & & \\ \hline Alarcon, G & 40 & \begin{tabular}{ll} & 13.20 \\ \end{tabular} & 5528.00 & 4 & \begin{tabular}{|ll|} s & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Foreman, B & 40 & \begin{tabular}{|l|l|} & 13.20 \\ \end{tabular} & 528.00 & 0 & \begin{tabular}{|ll|} s & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Salinger, F & 40 & \begin{tabular}{ll} & 13.20 \\ \end{tabular} & \begin{tabular}{l} 528.00 \\ \end{tabular} & 1 & \begin{tabular}{|ll|} & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Owens, T & 40 & \begin{tabular}{|l|l|} & 13.20 \\ \end{tabular} & 528.00 & 6 & \begin{tabular}{|l|l|} & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Willis,s & 40 & \begin{tabular}{|l|l|} & 13.20 \\ \end{tabular} & 528.00 & 10 & \begin{tabular}{|ll|} s & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & \\ \hline Totals: & & & \begin{tabular}{l} 52,640.00 \\ \end{tabular} & & & & & & & & & & & & \\ \hline \begin{tabular}{|l|} Total Earnings \\ \end{tabular} & Hosp. Don. & Med. Plan & & & & & & & & 55% & Medicare \% & & & & \\ \hline 5500 & 0.8% & 0.3% & & & & & & & & 6.20% & 1.45% & & & & \\ \hline 550 & 1.1% & 0.6% & & & & & & & & \begin{tabular}{|l|} SS Wage Base \\ \end{tabular} & & & & & \\ \hline 600 & 1.4% & 0.9% & & & & & & & & \begin{tabular}{|lr|} s & 137,700 \\ \end{tabular} & & & & & \\ \hline 650 & 1.7% & 1.2% & & & & & & & & & & & & & \\ \hline 700 & 2.0% & 1.5% & & & & & & & & & & & & & \\ \hline Name & \begin{tabular}{|l|} Prior Earnings \\ \end{tabular} & & & & & & & & & & & & & & \\ \hline Alarcon, G & & & & & & & & & & & & & & & \\ \hline Foreman, B & 81,300 & & & & & & & & & & & & & & \\ \hline Salinger, F & 54,000 & & & & & & & & & & & & & & \\ \hline Owens, T & 151,800 & & & & & & & & & & & & & & \\ \hline Willis, s & & & & & & & & & & & & & & & \\ \hline \end{tabular} CraftWorld - Inventory Listing Total Categories = Artist Canvas Inventory Costing Method Comparison CraftWorld Bank Reconciliation January 31, 2020 Beginning Bank Balance: Add: Deposits in Transit Deduct: Outstanding Checks Adjusted Bank Balance \$ 18,300 Beginning Book Balance: Add: Notes Receivable Deduct: NSF Check Bank Charges Check Error Adjusted Book Balance CraftWorld Depreciation Schedule \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{16}{|c|}{ Payroll Register } \\ \hline \begin{tabular}{l} Pay Period \\ Pay Date \end{tabular} & \multicolumn{15}{|l|}{2/3/20201/31/2020} \\ \hline & \multicolumn{7}{|c|}{ Earnings } & \multicolumn{6}{|c|}{ Deductions } & \multirow[b]{2}{*}{\begin{tabular}{l} Check \\ Number \end{tabular}} & \multirow[b]{2}{*}{ Net Pay } \\ \hline Employee Name & Regular Hours & \begin{tabular}{|c|} \begin{tabular}{c} Regular \\ Rate \end{tabular} \\ \end{tabular} & \begin{tabular}{l} Regular \\ Earnings \end{tabular} & \begin{tabular}{c} Overtime \\ Hours \end{tabular} & \begin{tabular}{|c|} \begin{tabular}{c} Overtime \\ Rate \end{tabular} \\ \end{tabular} & \begin{tabular}{l} Overtime \\ Earnings \end{tabular} & Total Earnings & FWT & SWT & social Security & Medicare & \begin{tabular}{l} Hospital \\ Donation \end{tabular} & Med. Plan & & \\ \hline Alarcon, G & 40 & \begin{tabular}{ll} & 13.20 \\ \end{tabular} & 5528.00 & 4 & \begin{tabular}{|ll|} s & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Foreman, B & 40 & \begin{tabular}{|l|l|} & 13.20 \\ \end{tabular} & 528.00 & 0 & \begin{tabular}{|ll|} s & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Salinger, F & 40 & \begin{tabular}{ll} & 13.20 \\ \end{tabular} & \begin{tabular}{l} 528.00 \\ \end{tabular} & 1 & \begin{tabular}{|ll|} & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Owens, T & 40 & \begin{tabular}{|l|l|} & 13.20 \\ \end{tabular} & 528.00 & 6 & \begin{tabular}{|l|l|} & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Willis,s & 40 & \begin{tabular}{|l|l|} & 13.20 \\ \end{tabular} & 528.00 & 10 & \begin{tabular}{|ll|} s & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & \\ \hline Totals: & & & \begin{tabular}{l} 52,640.00 \\ \end{tabular} & & & & & & & & & & & & \\ \hline \begin{tabular}{|l|} Total Earnings \\ \end{tabular} & Hosp. Don. & Med. Plan & & & & & & & & 55% & Medicare \% & & & & \\ \hline 5500 & 0.8% & 0.3% & & & & & & & & 6.20% & 1.45% & & & & \\ \hline 550 & 1.1% & 0.6% & & & & & & & & \begin{tabular}{|l|} SS Wage Base \\ \end{tabular} & & & & & \\ \hline 600 & 1.4% & 0.9% & & & & & & & & \begin{tabular}{|lr|} s & 137,700 \\ \end{tabular} & & & & & \\ \hline 650 & 1.7% & 1.2% & & & & & & & & & & & & & \\ \hline 700 & 2.0% & 1.5% & & & & & & & & & & & & & \\ \hline Name & \begin{tabular}{|l|} Prior Earnings \\ \end{tabular} & & & & & & & & & & & & & & \\ \hline Alarcon, G & & & & & & & & & & & & & & & \\ \hline Foreman, B & 81,300 & & & & & & & & & & & & & & \\ \hline Salinger, F & 54,000 & & & & & & & & & & & & & & \\ \hline Owens, T & 151,800 & & & & & & & & & & & & & & \\ \hline Willis, s & & & & & & & & & & & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started