Answered step by step
Verified Expert Solution
Question
1 Approved Answer
indicated by a minus sign. begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} hline multirow[b]{2}{*}{ Collections and purchases worksheet } & multicolumn{2}{|r|}{ July } & multicolumn{3}{|c|}{ August September } & multirow[t]{2}{*}{ October
indicated by a minus sign. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Collections and purchases worksheet } & \multicolumn{2}{|r|}{ July } & \multicolumn{3}{|c|}{ August September } & \multirow[t]{2}{*}{ October } & \multicolumn{2}{|r|}{ November } & December \\ \hline & & & & & & & & & \\ \hline Sales (gross) & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ Collections } \\ \hline During month of sale & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ During 1st month after sale } \\ \hline \multicolumn{10}{|l|}{ During 2nd month after sale } \\ \hline Total collections & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ Purchases } \\ \hline Labor and raw materials & $ & $ & $ & $ & $ & & $ & & \\ \hline \begin{tabular}{l} Payments for labor and raw \\ materials \end{tabular} & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ Cash gain or loss for month } \\ \hline Collections & $ & $ & $ & $ & $ & & $ & & \\ \hline \begin{tabular}{l} Payments for labor and raw \\ materials \end{tabular} & $ & $ & & $ & $ & & $ & & \\ \hline General and administrative salaries & & & & & & & & & \\ \hline Lease payments & & & & & & & & & \\ \hline Miscellaneous expenses & & & & & & & & & \\ \hline Income tax payments & & & & & & & & & \\ \hline Design studio payment & & & & & & & & & \\ \hline Total payments & $ & $ & $ & $ & $ & & $ & & \\ \hline Net cash gain (loss) during month & $ & $ & $ & $ & $ & & $ & & \\ \hline \end{tabular} Loan requirement or cash surplus Cash at start of month Cumulative cash Target cash balance Cumulative surplus cash or loans outstanding to maintain $90,000 target cash balance \begin{tabular}{|c|c|c|c|c|c|} \hline$ & $ & $ & $ & $ & $ \\ \hline$ & $ & $ & $ & $ & $ \\ \hline \end{tabular} indicated by a minus sign. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multirow[b]{2}{*}{ Collections and purchases worksheet } & \multicolumn{2}{|r|}{ July } & \multicolumn{3}{|c|}{ August September } & \multirow[t]{2}{*}{ October } & \multicolumn{2}{|r|}{ November } & December \\ \hline & & & & & & & & & \\ \hline Sales (gross) & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ Collections } \\ \hline During month of sale & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ During 1st month after sale } \\ \hline \multicolumn{10}{|l|}{ During 2nd month after sale } \\ \hline Total collections & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ Purchases } \\ \hline Labor and raw materials & $ & $ & $ & $ & $ & & $ & & \\ \hline \begin{tabular}{l} Payments for labor and raw \\ materials \end{tabular} & $ & $ & $ & $ & $ & & $ & & \\ \hline \multicolumn{10}{|l|}{ Cash gain or loss for month } \\ \hline Collections & $ & $ & $ & $ & $ & & $ & & \\ \hline \begin{tabular}{l} Payments for labor and raw \\ materials \end{tabular} & $ & $ & & $ & $ & & $ & & \\ \hline General and administrative salaries & & & & & & & & & \\ \hline Lease payments & & & & & & & & & \\ \hline Miscellaneous expenses & & & & & & & & & \\ \hline Income tax payments & & & & & & & & & \\ \hline Design studio payment & & & & & & & & & \\ \hline Total payments & $ & $ & $ & $ & $ & & $ & & \\ \hline Net cash gain (loss) during month & $ & $ & $ & $ & $ & & $ & & \\ \hline \end{tabular} Loan requirement or cash surplus Cash at start of month Cumulative cash Target cash balance Cumulative surplus cash or loans outstanding to maintain $90,000 target cash balance \begin{tabular}{|c|c|c|c|c|c|} \hline$ & $ & $ & $ & $ & $ \\ \hline$ & $ & $ & $ & $ & $ \\ \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