Calculate the cash receipts expected for the month of March. Collection patterns indicate 75% of the month's sales will be collected in the month of the sale, 20% in the following month, and 2 % two months after the sale. Sales forecasts are $250,000 in January, $325,000 in February, and $285,000 in March.
Answer: Cash receipts fr the month of march is $283,750
January sales = 250,000 * 75% = $187,5000 which is collected in the same month
250,000 * 20% = $50,000 which is collected in the following month i.e February month
250,000 * 2% = $5000 which is collected from two moths of sales i.e march month
February sales = 325,000 * 75% = $243,750 in the same month
= 325,000 * 20% = $65,000 in the month of march
March sales = 285,000 * 75% = $213,750 in the same month.
Total of bold area is march month cash collection i.e 5000 + 65,000 + 213,750 =$283,750
Calculate the cash receipts expected for the month of March. Collection patterns indicate 75% of the...
A) Need help with this chart
B) Find March credit sales, collection of March sales in
April
Accounts Receivable balance, March 31: March-Credit sales, collection of March sales in April Marcel Company projects the following sales for the first three months of the year: $12,600 in January: $10,200 in February; and $11,100 in March. The company expects 70% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the...
Requirement 2. Prepare a revised schedule of cash receipts
from sales in account are 60% in the month of the sale, 30% in the
month following the sale, and 10% in the second month following the
sale. What is the balance in Accounts Receivable on March 31?
Requirement 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale. 30 blank, do not enter "0".) Cash Receipts from Customers...
a. Prepare a schedule of monthly cash receipts for January,
February, and March.
b. Prepare a schedule of monthly cash payments for January,
February, and March.
c. Prepare a monthly cash budget with borrowings and repayments
for January, February, and March. (Negative amounts should be
indicated by a minus sign. Assume the January beginning loan
balance is $0.)
Harry's Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to...
Lannister Company: Cash Receipts and Payments Lannister Company wishes to forecast its cash receipts and cash disbursements for the first quarter of 2020. The following data have been assembled: a. Actual sales for November and December of 2019 and forecasted sales data for the first four months of 2020 are as follows: November (actual) S450,000 December (actual) 750,000 January (estimate) 150,000 February (estimate) 75.000 March (estimate) 300,000 April (estimate) 500,000 b. C. Lannister pays for 20% of its inventory purchases...
Shown below are the expected sales for ABC Company: January February March April Sales for Cash $22,000 $19,000 $26,000 $21,000 Sales on Account $118,000 $146,000 $133,000 $127,000 On average, 65% of the sales on account are collected in the month of sale, 27% are collected in the month following sale, and the remaining 8% are collected two months after the month of sale. Calculate ABC Company's budgeted accounts receivable at April 30.
Its collection history indicates that credit sales are collected as follows Gem Service anticipates the following sales revenue over a five-month period: (Click the icon to view the sales data.) i Click the icon to view the collections data.) The company's sales are 20 % cash and 80 % credit How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in...
Topaz Service anticipates the following sales revenue over a five-month period: 3: (Click the icon to view the sales data.) The company's sales are 40% cash and 60% credit. Its collection history indicates that credit sales are collected as follows: i (Click the icon to view the collections data.) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January,...
Ed’s Waterbeds has made the following sales projections for the next six months. All sales are credit sales. March $ 32,000 June $ 36,000 April 38,000 July 44,000 May 27,000 August 46,000 Sales in January and February were $35,000 and $34,000 respectively. Experience has shown that 10 percent of total sales are uncollectible, 30 percent are collected in the month of sale, 40 percent are collected in the following month, and 20 percent are collected two months after sale. a....
Garnet Service anticipates the following sales revenue over a five-month period E Click the icon to view the sales data) The company's sales are 40% cash and 60% credit For the Months of January through March Its collection history indicates that credit sales are collected as folows: (Click the icon to view the collections data) How much cash will be collected in January? In February in March? For the quarter info Quarter Cash sales Collection of credt sales: 25% Month...
Emerald Service anticipates the following sales revenue over a five-month period: Click the icon to view the sales data.) The company's sales are 40% cash and 60% credit its collection history indicates that credit sales are collected as follows: (Click the icon to view the collections data) How much cash will be collected in January? In February? In March? For the quarter in total? Complete the cash budget to determine how much cash will be collected in January February March...