Required:
September | $89,458 |
October | $88,674 |
November | $87,023 |
Working:
September | October | November | |
Cash collection from July sales | $5,934 (98,900*6%) | - | - |
Cash collection from August sales | $51,548 (105,200*49%) | $6,312 (105,200*6%) | - |
Cash collection from September sales | $31,976 (114,200*28%) | $55,958 (114,200*49%) | $6,852 (114,200*6%) |
Cash collection from October sales | - | $26,404 (94,300*28%) | $46,207 (94,300*49%) |
Cash collection from November sales | $33,964 (121,300*28%) | ||
Estimated cash receipt | $89,458 | $88,674 | $87,023 |
Scottsdale Co. has actual sales for July and August and forecast sales for September October, November,...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...
Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,100 August 105,100 Forecast: September 114,200 October 94,500 November 121,900 December 107,000 Based on past experience, it is estimated that 24% of a month’s sales are collected in the month of sale, 46% are collected in the month following the sale, and 5% are collected in the second month following the sale. Required: Calculate the estimated cash...
The following sales and purchases forecast information pertains to Palermo Corporation: Month July August September October November December Sales $13,000 16,000 18,000 23,000 22,500 28,400 Purchases $6,000 5,700 7,500 8,300 9,200 10,100 Based on past experience cash is typically collected from customers in the following manner: Collected within 10 days of sale so receive a 10% cash discount 25% Collected after 10 days but in the month of sale 10% Collected in the month following the sale 40% Collected in...
Osage Inc. has actual sales for May and June and forecast sales for July August September, and October as follows: 5,910 units 6,280 units Actual: May June Forecast: July August September October 5,970 units 6,840 units 5,580 units 5,330 units Required: a. The firm's policy is to have finished goods Inventory on hand at the end of the month that is equal to 75% of the next month's sales. It is currently estimated that there will be 4,478 units on...
Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows: September $50,000 (actual) Fourth Quarter October 40,000 November 35,000 December 60,000 Experience has shown 20 percent of sales are collected in the month of sale, 70 percent are collected in the following month, and 10 percent are never collected. Prepare a cash receipts schedule for Power Ridge Corporation covering the fourth quarter (October through December). Power Ridge Corporation Cash Receipts Schedule September October November...
J. Lo's Clothiers has forecast credit sales for the fourth quarter of the year: September (actual) $ 53,000 Fourth Quarter October $ 43,000 November 38,000 December 63,000 Experience has shown that 25 percent of sales are collected in the month of sale, 60 percent are collected in the following month, and 15 percent are never collected. Prepare a schedule of cash receipts for J. Lo's Clothiers covering the fourth quarter (October through December). J. Lo's Clothiers September October November December...
Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows: September (actual Fourth Quarter October November December $58.000 53,000 78,000 Experience has shown 40 percent of sales are collected in the month of sale, 50 percent are collected in the following month, and percent are never collected. Prepare a cash receipts schedule for Power Ridge Corporation covering the fourth quarter (October through December) Power ridge corporation Cash Receipt Schedule September october Sales Collections of...
J. Lo’s Clothiers has forecast credit sales for the fourth
quarter of the year:
September (actual) $59,000
Fourth Quarter
October $49,000
November 44,000
December 69,000
Experience has shown that 25 percent of sales are collected in
the month of sale, 65 percent are collected in the following month,
and 10 percent are never collected.
Prepare a schedule of cash receipts for J. Lo’s Clothiers covering
the fourth quarter (October through December).
Experience has shown that 25 percent of sales are...
3) The following information pertains to Amigo Corporation: Month July August September October November December Sales $30,000 34,000 38,000 42,000 48,000 60,000 Purchases $10,000 12,000 14,000 16,000 18,000 20,000 Cash is collected from customers in the following manner: Month of sale 40% Month following sale 40% Two months following sale 20% • 60% of purchases are paid for in cash in the month of purchase, and the other 40% is paid the following month. Required: Complete the cash budget for...
Wells Company reports the following sales forecast: September, $60,000; October, $75,000; and November, $90,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November. WELLS COMPANY Budgeted Cash Receipts For Month Ended November 30 Cash receipts from November...