Total sales in November 2007 = 40000 / 10% = 400000
Total sales in December 2007 = 180000 / 40% = 450000
Cash collections in first quarter 2008 calculations:
January | February | March | Total | |
Budgeted sales | 500000 | 700000 | 1800000 | 3000000 |
Collection details: | ||||
60% collection in the month of sale | 300000 | 420000 | 1080000 | 1800000 |
30% in month following sale | 135000 | 150000 | 210000 | 495000 |
8% in second month following sale | 32000 | 36000 | 40000 | 108000 |
Cash discount given on 60% collection | -6000 | -8400 | -21600 | -36000 |
Total Collections during the first quarter of 2008 | 461000 | 597600 | 1308400 | 2367000 |
4 /4 139% Tools Comment Greenup, Inc., manufactures a product that has peak sales in March...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: Sales budget January February March $212,000 $232,000 $255,000 Credit sales are collected as follows: 70 percent in the month of the sale 15 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $96,000 ($66,000 of which was uncollected December sales). a. Calculate the sales for November....
Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150.000 June 175,000 July 160,000 August 200.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 La Grange Corporation had the following budgeted sales for the first half of the current year: January February March April Cash Credit Sales Sales $40,000 $140,000 $ 45,000 $160,000 $ 42,000 $120,000 $37,000 $122,000 $ 47,000 $190,000 $70,000 $160,000 May June The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections on sales: 30% in month of sale 35%...
January February March April May June Cash Credit Sales Sales $ 80,000 $180,000 $ 85,000 $200,000 $ 48,000 $160,000 $ 43,000 $128,000 $ 53,000 $230,000 $110,000 $220,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections on sales: 50% in month of sale 40% in month following sale 10% in second month following sale The accounts receivable balance on...
January February March Sales budget $ 202,000 $ 222,000 $ 245,000 Credit sales are collected as follows: 60 percent in the month of the sale. 30 percent in the month after the sale. 10 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $86,000 ($56,000 of which was uncollected December sales). a. Calculate the sales for November. (Do not round intermediate calculations and round your...
The following is the sales budget for Shleifer, Inc., for the first quarter of 2017: January February March Sales budget $ 216,000 $ 236,000 $ 259,000 Credit sales are collected as follows: 65 percent in the month of the sale. 30 percent in the month after the sale. 5 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $100,000 ($70,000 of which was uncollected December sales)....
The following is the sales budget for Shleifer, Inc., for the first quarter of 2019: Sales budget January February March $208,000 $228,000 $251,000 Credit sales are collected as follows: 55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $92,000 ($62,000 of which were uncollected December sales). a. Calculate the sales for November....
Cash Receipts The sales budget for Perrier Inc. is forecasted as follows: Month Sales Revenue May $140,000 June 140,000 July 180,000 August 120,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 1...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 50,000 $ 150,000 February $ 55,000 $ 170,000 March $ 43,000 $ 130,000 April $ 38,000 $ 123,000 May $ 48,000 $ 200,000 June $ 80,000 $ 170,000 The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: 3 Cash Credit Sales $ 80,000 $180,000 $ 85,000 $200,000 $ 46,000 $160,000 $ 41,000 $126,000 51,000 $230,000 $110,000 $200,000 Sales January February March April points une Skipped The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled eBook Print Collections on sales 45% in...