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 receipts for September, October, and
November.
We need at least 10 more requests to produce the answer.
0 / 10 have requested this problem solution
The more requests, the faster the answer.
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: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...
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...
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...
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...
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...
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...
K.Hi Fashion has forecast credit sales for the fourth quarter of the year as: October November December Fourth Quarter $60,000 $55,000 $80,000 September actual credit sales were $70,0000. Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent in the following month, and 10 percent never collected. Prepare a schedule of cash receipts for K.Hi Clothiers covering the 4th quarter.
J.Lo's Clothiers has forecast credit sales for the fourth quarter of the year: September $ 55,000 (actual) Fourth Quarter October $ 45,000 November 40,000 December 65,000 Experience has shown that 35 percent of sales are collected in the month of sale, 55 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). J. Lo's Clothiers September October November December Credit sales...
Harrti Corporation has budgeted for the following sales: July August September October November December $448,000 $583,000 $616,500 $891,500 $ 745,000 $705,000 Sales are collected as follows: 10% in the month of sale; 60% in the month following the sale; and the remaining 30% in the second month following the sale. In Harrti's budgeted balance sheet at December 31, at what amoun will accounts receivable be shown?
The Handel Company has obtained the following sales forecast data: July August September October Cash sales ..... $ 80,000 $ 70,000 $ 50,000 $ 60,000 Credit sales ... $260,000 $220,000 $200,000 $220,000 The regular pattern of collection of credit sales is 20% in the month of sale, 70% in the month following the month of sale, and the remainder (10%) in the second month following the month of sale. There are no bad debts. The budgeted accounts receivable balance on...