Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CREATE PIVOT TABLE AND CHART, HOW TO DO IT? Artist Canvas Inventory Costing Method Comparison 9/25/2023 CraftWorld Bank Reconciliation January 31,2020 begin{tabular}{|c|c|c|} hline begin{tabular}{l} Beginning
CREATE PIVOT TABLE AND CHART, HOW TO DO IT?
Artist Canvas Inventory Costing Method Comparison 9/25/2023 CraftWorld Bank Reconciliation January 31,2020 \begin{tabular}{|c|c|c|} \hline \begin{tabular}{l} Beginning Bank Balance: \\ Add: \end{tabular} & $18,300 & \begin{tabular}{l} Beginning Book Balance: \\ Add: \end{tabular} \\ \hline \multirow[t]{2}{*}{ Deposits in Transit } & & Notes Receivable \\ \hline & & Deduct: \\ \hline Deduct: & & NSF Check \\ \hline \multirow[t]{2}{*}{ Outstanding Checks } & & Bank Charges \\ \hline & & Check Error \\ \hline Adjusted Bank Balance & & Adjusted Book Balance \\ \hline \end{tabular} 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 Pay Period & \multicolumn{15}{|l|}{1/31/2020} \\ \hline Pay Date & \multicolumn{15}{|l|}{2/3/2020} \\ \hline & \multicolumn{7}{|c|}{ Earnings } & \multicolumn{6}{|c|}{ Deductions } & \multirow{3}{*}{\begin{tabular}{c} Check \\ Number \end{tabular}} & \multirow[b]{2}{*}{ Net Pay } \\ \hline Employee Nome & Regulor Hours & \begin{tabular}{c} Regulor \\ Rote \end{tabular} & \begin{tabular}{l} Regular \\ Eornings \end{tabular} & \begin{tabular}{c} Overtime \\ Hours \end{tabular} & \begin{tabular}{|c|} \begin{tabular}{c} Overtime \\ Rote \end{tabular} \\ \end{tabular} & \begin{tabular}{l} Overtime \\ Eornings \end{tabular} & Totol Eornings & FWT & SWT & Social Security & Medicore & \begin{tabular}{l} Hospital \\ Donotion \end{tabular} & Med. Plon & & \\ \hline Alarcon, G & 40 & \begin{tabular}{|ll|} 5 & 13.20 \\ \end{tabular} & 528.00 & 4 & \begin{tabular}{|ll|} 5 & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Foreman, B & 40 & \begin{tabular}{|ll} 5 & 13.20 \\ \end{tabular} & 528.00 & 0 & \begin{tabular}{|ll|} 5 & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Salinger, F & 40 & \begin{tabular}{|ll} 5 & 13.20 \end{tabular} & 528.00 & 1 & \begin{tabular}{|ll|} 5 & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Owens, T & 40 & \begin{tabular}{|ll|} 5 & 13.20 \\ \end{tabular} & 528.00 & 6 & \begin{tabular}{|ll|} 5 & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline Willis, S & 40 & \begin{tabular}{|ll} $ & 13.20 \end{tabular} & 528.00 & 10 & \begin{tabular}{|ll|} 5 & 19.80 \\ \end{tabular} & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & \\ \hline Totals: & & & 52,640.00 & & & & & & & & & & & & \\ \hline Total Earnings & Hosp. Don. & Med. Plan & & & & & & & & SS\% & Medicare % & & & & \\ \hline 500 & 0.8% & 0.3% & & & & & & & & 6.20% & 1.4596 & & & & \\ \hline 550 & 1.1% & 0.6% & & & & & & & & \begin{tabular}{|l|} SS Wage Base \\ \end{tabular} & & & & & \\ \hline 600 & 1.4% & 0.9% & & & & & & & & 5137,700 & & & & & \\ \hline 650 & 1.7% & 1.2% & & & & & & & & & & & & & \\ \hline 700 & 2.0% & 1.5% & & & & & & & & & & & & & \\ \hline Name & Prior Earnings & & & & & & & & & & & & & & \\ \hline Alarcon, G & S 137,500 & & & & & & & & & & & & & & \\ \hline Foreman, B & 81,300 & & & & & & & & & & & & & & \\ \hline Salinger, F & 54,000 & & & & & & & & & & & & & & \\ \hline Owens, T & 151,800 & & & & & & & & & & & & & & \\ \hline Willis, S & 104,200 & & & & & & & & & & & & & & \\ \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