Question
Unique Ltd. developed the following data for the month of October. Cash balance, October 1st$92,250Cash sales in October450,000Credit sales for the month of:August300,000September225,000October375,000Purchases for the
Unique Ltd. developed the following data for the month of October.
Cash balance, October 1st$92,250Cash sales in October450,000Credit sales for the month of:August300,000September225,000October375,000Purchases for the month of:September337,500October300,000Other expenses in October:Salaries243,750Utilities24,750Depreciation75,000
70% of credit sales are collected in the month of sale, 15% in the following month, and 10% in the second month following the sale.
25% of purchases are paid in the month of purchase and the remaining 75% in the following month.
100% of other expenses are paid in the month recorded.
Required:
Prepare a cash collections and cash payment schedule as well as a cash budget for the month.
Total cash sales and collections on account for the month are $____________.
Total cash available for the month is $_______________.
Payments for purchases during the month are $______________.
Payments for other expenses during the month are $___________ .
The ending cash balance for the month is $__________________.
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