Question

Lawson and Company has estimated the following forecasted sales for the next 3-month period: Month and...

Lawson and Company has estimated the following forecasted sales for the next 3-month period:

Month and Estimated sales

June- 41,000

July- 27,000

August- 35,000

On average, 55% of sales are collected in the month of sale, 44% in the following month, and the remaining 1% is never collected. Determine the budgeted cash receipts for July?

Options:

$32,890

$31,110

$29,000

$29,100

Homework Answers

Answer #1

Computation of total cash receipt for July is:

Total cash receipt for July = Cash receipt in July of June month + Cash receipt in July of July month

= $18,040 + $14,850

= $32,890

Hence, the total cash receipt for July is $32,890, that is, the first option is correct.

Working Notes:

Step – 1:

Computation of cash receipt in July of June month is:

Cash receipt in July of June month = Value of sales for June * Percentage of following month

= $41,000 * 0.44

= $18,040

Hence, the cash receipt in July of June month is $18,040.

Step – 2:

Computation of cash receipt for July of July month is:

Cash receipt in July of July month = Value of sales for July * Percentage of same month

= $27,000 * 0.55

= $14,850

Hence, the cash receipt in July of June month is $14,850.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales...
Towing Company has budgeted sales for the next six months as follows: Sales for Cash Sales on Account May $42,000 $257,000 June $37,000 $243,000 July $29,000 $238,000 August $48,000 $296,000 September $52,000 $251,000 October $45,000 $263,000 On average, 32% of the sales on account are collected in the month of sale, 40% are collected in the month following sale, 16% are collected in the second month following sale, 8% are collected in the third month following sale, and the remaining...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May...
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 13,000 units April 27,000 units May 34,000 units June 10,000 units July 48,000 units August 69,000 units ABC Company sells its inventory to customers for $21 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June...
The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $130,000 June 150,000 July 200,000 August 130,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding the cash collection of sales: 60 percent in the month of sale. 20 percent in the month following sale. 15 percent in the second month following sale. 5 percent uncollectible. The company gives a 2 percent...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March...............................        $35,000 April.................................          41,000 May..................................          30,000 June.................................          39,000 July...................................          47,000 August..............................          49,000 Sales in January and February were $38,000 and $37,000, respectively. Experience has shown that of total sales, 10 percent 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. Prepare a monthly cash receipts schedule for the firm...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month Unit Sales...
Lubriderm Corporation has the following budgeted unit sales for the next six-month period: Month Unit Sales June 130,000 July 100,000 August 160,000 September 200,000 October 140,000 November 180,000 There were 26,000 units of finished goods in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. Five pounds of materials are required for each unit produced. Each pound of material costs $20. Raw material...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...
ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 13,000 units April 28,000 units May 36,000 units June 12,000 units July 42,000 units August 69,000 units ABC Company sells its inventory to customers for $20 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are...
Watt’s Lighting Stores made the following sales projection for the next six months. All sales are credit sales. March $43,000 June $47,000 April 49,000 July 55,000 May 38,000 August 57,000 Sales in January and February were $46,000 and $45,000, respectively. Experience has shown that of total sales, 10 percent are uncollectible, 35 percent are collected in the month of sale, 45 percent are collected in the following month, and 10 percent are collected two months after sale. a. Prepare a...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for...
Shown below are the budgeted sales for ABC Company for the next six months: Sales for Cash Sales on Account January $27,000 $226,000 February $33,000 $299,000 March $21,000 $273,000 April $24,000 $241,000 May $38,000 $213,000 June $19,000 $201,000 On average, 14% of the sales on account are collected in the month of sale, 38% are collected in the month following sale, 43% are collected in the second month following sale, and the remaining 5% is collected three months after the...
Felix Co. expects June sales to be $29,000, July sales to be $35,000, August sales to...
Felix Co. expects June sales to be $29,000, July sales to be $35,000, August sales to be $32,000, and September sales to be 33,000. 40% of sales are cash sales and remaining 60% are credit sales. Collection of credit sales are 50% in the month of sale, 40% in the month following sale and 5% two months following sale. The remaining 5% is uncollectible. What is the expected total cash collections in August?