The LaGrange Corporation had the following budgeted sales for the first half of the current year:...
The LaGrange Corporation had the following budgeted sales for the first half of the current year: Cash Sales Credit Sales January $ 60,000 $ 160,000 February $ 65,000 $ 180,000 March $ 50,000 $ 140,000 April $ 45,000 $ 130,000 May $ 55,000 $ 210,000 June $ 90,000 $ 240,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: Cash Sales Credit Sales January $ 40,000 $ 140,000 February $ 45,000 $ 160,000 March $ 39,000 $ 120,000 April $ 34,000 $ 119,000 May $ 44,000 $ 190,000 June $ 70,000 $ 130,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: 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 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...
Please Solve for multiple choice in image. Explain. The LaGrange Corporation had the following budgeted sales for the first half of the current year. January February March April May June Cash Credit Sales Sales $ 20,000 $120,000 $ 25,000 $140,000 $37,000 $100,000 $32,000 $117,000 $ 42,000 $170,000 $50,000 $110,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...
Provide formula, process in Excel QUESTION 2 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,...
Richards Corporation has the following budgeted sales for the first half of next year: Credit Sales Cash Sales $40,000 $45,000 $140,000 January February $160,000 $120,000 $40,000 $45,000 $55,000 $70,000 March April May $140,000 $190,000 $300,000 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 credit sales: 40% In month of sales 45% In month of following sales...
15. The LaGrange Corporation had the following budgeted sales for the first half of the current year S 70,000 S 50,000 $ 40,000 S 340,000 S 190,000 S 135,000 January February March S 120,000 S 160,000 S 140,000 S 35,000 $ 45,000 S 40,000 April 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 60%...
Mitchell Company had the following budgeted sales for the first half of next year: January February March April May June Cash Sales $40.000 $45,000 $47.000 $52,000 $62.000 $70,000 Credit Sales $140.000 $160,000 $120,000 $147,000 $190.000 $370,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 credit sales: 30% in month of sales 135% in month of following sales...