Water Sporting matures a una personal water tube used for children aning to Management now preparing med budgets for the quartet July through Seeman hented the foowing information to The Marketing Department has stated sales as follows to the remainder of the year number of water tubes 104 2, 2,10 The pace of the websis 160 1. Menced on a perences were to become ta . The big cocina y te the company and one 20 of me tong motherhood will be 1320 awesome compound to prevertrages company would not compound on and the teach that the following productions Theory of the compound on and on were The 5400 per ogn Sportpays on porte puterem po merong mah The concorrer como 1700 1 gotow you to be reachedule of expected July August Quarter September Quarter Schedule of expected cash collections July August Accounts receivable beginning balance July sales Augusts September sales Totalcash collections 0 2. Prepare a production toget for each of the month uy trough October Production budget July August September October Budgeted salos (units) Total noods 0 0 0 Required production units) 0 Water Sport Incmanufactures a small personal water tube used for children learning to swim Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist The Marketing Department has estimated sales as follows for the remainder of the year (number of water tubes July At 5.100 Nov 4.10 December 3. 2.6 2.100 The selling price of the water tubes is $60 b. Al sales are on account Based on past experience, sales are expected to be collected in the following pattern in the month of sale the month og ale lectual The beginning accounts receivable balance excluding uncollectible amounts on July will be $160.500 The company maintains finished goods inventories equal to 20% of the following month's sales. The inventory of finished goods on July I will be 1320 units d Each water tube requires 3 grams of synthetic polyisoprene rubber compound. To prevent shortages, the company would like the inventory of synthetic rubber compound on hand at the end of each month to be equal to 20% of the following month's production needs. The inventory of synthetic rubber compound on hand on July 1 will be 3.780 The synthetic rubber compound costs $400 per kilogram. Water Sport pays for 70% of its purchases in the month of purchase, the remainder is paid for in the following month The accounts payable balance for synthetic rubber compound purchases will be 511700 on July 1 Lequired Presales budget, by month and in total, to the mad quartet Show your budget in both units of water tubes and dolar. Also prepare a schedule of expected cath collections, by month and into for the third quartet Sales budget August September Quarter Budgeted sales (units) Selling price per unit Tetal budgeted sales Schedule of expected cash collections July August Quant Water Sport ine manufactures a small personal water tube used for children leaming to swim Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following Information to assist a The Marketing Department has estimated sales as follows for the remainder of the year thumber of water tubes July August September 6,60 October 5. Loe Novaber 4. December 1.000 2.600 2.100 The selling price of the water tubes is 560 b. All sales are on account Based on past experience, sales are expected to be collected in the following pattern 50 in the month of sale in the month following sele uncollectible The beginning accounts receivable balance (excluding uncollectible amounts) on Juy will be $160,500 C. The company maintains finished goods Inventories equal to 20% of the following months sales. The inventory of finished goods on July I will be 1320 units Each water tube requires 3 kilograms of synthetic polyisoprene rubber compound To prevent shortages, the company would take the inventory of synthetic rubber compound on hand at the end of each mornith to be equal to 20% of the following months production needs. The Inventory of synthetic rubber compound on and on July we be 170 krograms e The synthetic rubber compound costs 54.00 per kilogram Water Sport pays for 70% of its purchases in the month of purchase the remainder is paid for in the following month The accounts payable balance for synthetic rubber compound purchases will be $11.700 on July 1 Required: 1. Prepare a sales budget by month and in total for the third quarter Show your budget in both units of water tubes and dollars) Also prepare a schedule of expected ca collections, by month and in total, for the third quarter Sales budget August July September Quarter Budgeted sales (units) Seilind nice per unit Prov 1 of 5 Next > o search o Water Sport inc manufactures a small personal water tube used for children learning to swim Management is now prep September and has assembled the following Information to assist a. The Marketing Department has estimated sales as follows for the remainder of the year (number of water tubes): July August september 6,620 October 5, 10 November 4,1ee December 3, eee 2,600 2,100 The selling price of the water tubes is $60 b. All sales are on account Based on past experience, sales are expected to be collected in the following pattern: 58% 45% in the month of sale in the month following sale uncollectible The beginning accounts receivable balance (excluding uncollectible amounts) on July 1 will be $160,500. The company maintains finished goods inventories equal to 20% of the following month's sates. The inventory of finish d Each water tube requires 3 kilograms of synthetic polyisoprene rubber compound. To prevent shortages, the company on hand at the end of each month to be equal to 20% of the following month's production needs. The inventory of syn kilograms e. The synthetic rubber compound costs $4.00 per kilogram. Water Sport pays for 70% of its purchases in the month of PL The accounts payable balance for synthetic rubber compound purchases will be $11.700 on July 1. Required: 1. Prepare a sales budget, by month and in total, for the third quarter. (Show your budget in both units of water tubes and de collections, by month and in total, for the third quarter Sales budget