Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I fill out the schedule of expected cash disbursements with this information? d) Accounts Payable & Inventory: Purchases are paid for as follows:
How do I fill out the schedule of expected cash disbursements with this information?
d) Accounts Payable \& Inventory: Purchases are paid for as follows: \begin{tabular}{|c|c|c|} \hline Purchases Pald In the month of purchase & \begin{tabular}{c} Purchases Paid in the month following the \\ purchase \end{tabular} & June 30th Accounts Payable Balance \\ \hline 50% & 50% & $15,000 \\ \hline \end{tabular} \begin{tabular}{l} \hline e) The inventory levels based on company policy are as follows: \\ \begin{tabular}{|c|c|} \hline \begin{tabular}{c} Ending Inventory based on next month's \\ coGS \end{tabular} & Inventory at June 30th \\ \hline 75% & $19,000 \\ \hline \end{tabular} \end{tabular} \begin{tabular}{|c|c|c|c|} \hline \multicolumn{4}{|c|}{ Merchandise Purchases Budget (\$) } \\ \hline & July & August & September \\ \hline Budgeted Cost of Goods Sold & $24,800,00 & $40,800,00 & $30,800.00 \\ \hline Add: Desired ending inventory (S) & $30,600.00 & $23,100.00 & $20,850.00 \\ \hline Total needs & $55,400,00 & $63,900.00 & $51,650.00 \\ \hline Less: Beginning Inventory & $19,000,00 & $30,600.00 & $23,100.00 \\ \hline Inventory Purchases required (\$) & $36,400.00 & $33,300.00 & $28,550.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Schedule of Expected Cash Disbursements } \\ \hline 91 & & July & August & September & Quarter Total \\ \hline 92 & Accounts Payble, June 30 & $15,000.00 & & & \\ \hline 93 & July Purchases & & & & \\ \hline 94 & August Purchases & & & & \\ \hline 95 & September Purchases & & & & \\ \hline 96 & Total Cash Disbursements & & & & \\ \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