1.
Schedule of Expected Cash Collection | ||||
April ($) | May ($) | June ($) | Quarter | |
Cash
Sale in each month (20% of total sales) |
120,000 | 180,000 | 100,000 | 400,000 |
Collection from on Account Sales (See Working Notes) | 248,000 | 456,000 | 640,000 | 1,344,000 |
368,000.00 | 636,000.00 | 740,000.00 | 1,744,000.00 |
Working Note -1 | ||
Collection in the month of April | ||
10% of April's on Account Sale | =(600000*80%)*10% | 48000 |
70% of March's on Account Sale | =(300000*80%)*70% | 168000 |
20% of Feb's on account Sale | =(200000*80%)*20% | 32000 |
248000 |
Working Note -2 | ||
Collection in the month of May | ||
10% of May's on Account Sale | =(900000*80%)*10% | 72000 |
70% of April's on Account Sale | =(600000*80%)*70% | 336000 |
20% of March's on account Sale | =(300000*80%)*20% | 48000 |
456000 |
Working Note -2 | ||
Collection in the month of June | ||
10% of June's on Account Sale | =(500000*80%)*10% | 40000 |
70% of May's on Account Sale | =(900000*80%)*70% | 504000 |
20% of April's on account Sale | =(600000*80%)*20% | 96000 |
640000 |
PROBLEM 8-24 Cash Budget with Supporting Schedules [LO2, LO4, LO8) Garden Sales, Inc., sells garden supplies....
Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May $ 600,000 $900,000 420,000...
Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 540,000...
Problem 8-24 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April $ 600,000 420,000 180,000 May...
Problem 8-24 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 680,000...
Check my 2 Problem 8-24 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist. 100 points preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: еВok April...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: Budgeted monthly absorption costing income statements for April–July are: April May June July Sales $ 600,000 $ 900,000 $ 500,000 $ 400,000 Cost of goods sold...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May $ 550,000 $750,000 385,000 525,000 165,000 225,000 June $ 450,000 315,000 135,000 July $ 350,000 245,000...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support pealk sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are April June July Sales Cost of goods sold Gross margin Selling and administrative expenses $650,000 820,000...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 530,000 $ 730,000 $ 430,000 $ 330,000 371,000 511,000 301,000 231,000...
Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 550,000 $ 750,000 $ 450,000 $ 350,000 385,000 525,000 315,000 245,000...