90.2K

Verified Solution

Link Copied!

Castor Incorporated is preparing its master budget. Budgeted sales and cash payments for merchandise purchases for the next three months follow.

Budgeted April May June

Sales $ $36,800$ $ $46,000$ $ $27,600$

Cash payments for merchandise purchases $23,23019,32019,780$

Sales are $50\%$ cash and $50\%$ on credit. Sales in March were $$27,600.$ All credit sales are collected in the month following the sale. The March $31$ balance sheet includes balances of $$13,800$ in cash and $$2,300$ in loans payable. A minimum cash balance of $$13,800$ is required. Loans are obtained at the end of any month when the preliminary cash balance is below $$13,800.$ Interest is $1\%$ per month based on the beginning$-$of$-$the$-$month loan balance and is paid at each month$-$end. If a preliminary cash balance above $$13,800$ at month$-$end exists, loans are repaid from the excess. Expenses are paid in the month incurred and include sales commissions $(10\%$ of sales$),$ shipping $(2\%$ of sales$),$ office salaries $($$$5,750$ per month$),$ and rent $($$$3,450$ per month$).$

$($a$)$ Prepare a schedule of cash receipts from sales for April, May, and June. $($b$)$ Prepare a cash budget for each of April, May, and June. $($Negative balances and Loan repayment amounts $($if any$)$ should be indicated with minus sign. Round your final answers to the nearest whole dollar.$)$

Answer & Explanation Solved by verified expert

See Answer