Water Sport Inc. manufactures a small personal water tube used for children learning to swim. Management...

Water Sport Inc. manufactures 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:

a. The Marketing Department has estimated sales as follows for the remainder of the year (number of water tubes):


July	8,400	October	4,800
August	6,900	November	4,400
September	5,900	December	3,900

The selling price of the water tubes is $50.

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
45	%	in the month following sale
5	%	uncollectible

The beginning accounts receivable balance (excluding uncollectible amounts) on July 1 will be $169,500.

The company maintains finished goods inventories equal to 20% of the following month’s sales. The inventory of finished goods on July 1 will be 1,680 units.
Each water tube requires 4 kilograms 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 6,480 kilograms.
The synthetic rubber compound costs $2.50 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 $17,100 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 cash collections, by month and in total, for the third quarter.

2. Prepare a production budget for each of the months July through October.

3. Prepare a direct materials purchases budget for synthetic rubber compound, by month and in total, for the third quarter. Also prepare a schedule of expected cash disbursements for synthetic rubber compound, by month and in total, for the third quarter.

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets...

Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget: a. The Marketing Department has estimated sales as follows for the remainder of the year (in pairs of swim fins). The selling price of the swim fins is $13 per pair. July 5,600 October 3,600 August 6,600 November 2,600 September 4,600 December 2,600 b. All...

Omar Inc. manufactures an advanced swim fin for scurba divers. Management is now preparing detailed budgets...

Omar Inc. manufactures an advanced swim fin for scurba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget. The marketing department has estimated sales in units as follows for the remainder of the year. June 6,500 July 5,400 August 7,200 September 4,600 October 3,800 1. The selling price of the swim fins is $35 per pair. 2. All sales are on account. Based...

Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets...

Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget: a. The Marketing Department has estimated sales as follows for the remainder of the year (in pairs of swim fins). The selling price of the swim fins is $17 per pair. July 6,000 October 4,000 August 7,000 November 3,000 September 5,000 December 3,000 b. All...

Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets...

Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget: a. The Marketing Department has estimated sales as follows for the remainder of the year (in pairs of swim fins). The selling price of the swim fins is $21 per pair. July 6,400 October 4,400 August 7,400 November 3,400 September 5,400 December 3,400 b. All...

A water-to-water system is used to test the effects of changing tube length, baffle spacing, tube...

A water-to-water system is used to test the effects of changing tube length, baffle spacing, tube pitch, pitch layout, and tube diameter. Cold water at 25°C and 100,000 kg/hr is heated by hot water at 100°C , also at 100,000 kg/hr. The exchanger has a 31 in. ID shell. Perform calculations on this 1–2 shell-and-tube heat exchanger for the following conditions, as outlined in the examples, and put together an overall comparison chart. a. 3/4 in. OD tubes, 12 BWG...

A shell-and-tube heat exchanger is to used to heat water (in the tube side) from 30...

A shell-and-tube heat exchanger is to used to heat water (in the tube side) from 30 deg C to 40 deg C at a mass flow rate of 4 kg/s. The fluid used for heating (shell side) is water entering at 90 deg C with a mass flow rate of 2 kg/s. A 1-2 STHE is used and the overall heat transfer coefficient based on the inside area is 1390 W/m2-K. The tubes are 1.875 in diameter (inside) and require...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as home computers. Results for the first three years of operations were as follows (absorption costing basis): Year 1 Year 2 Year 3 Sales $ 1,040,000 $ 882,000 $ 1,040,000 Cost of goods sold 880,000 720,000 924,000 Gross margin 160,000 162,000 116,000 Selling and administrative expenses 150,000 ...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as home computers. Results for the first three years of operations were as follows (absorption costing basis): Year 1 Year 2 Year 3 Sales $ 1,000,000 $ 780,000 $ 1,000,000 Cost of goods sold 740,000 520,000 785,000 Gross margin 260,000 260,000 215,000 Selling and administrative expenses 230,000 200,000 230,000 Net operating income (loss) $ 30,000 $ 60,000 $ (15,000 ) In the latter part...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as home computers. Results for the first three years of operations were as follows (absorption costing basis): Year 1 Year 2 Year 3 Sales $ 1,000,000 $ 780,000 $ 1,000,000 Cost of goods sold 740,000 520,000 785,000 Gross margin 260,000 260,000 215,000 Selling and administrative expenses 230,000 200,000 230,000 Net operating income (loss) $ 30,000 $ 60,000 $ (15,000 ) In the latter part...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as...

Starfax, Inc., manufactures a small part that is widely used in various electronic products such as home computers. Results for the first three years of operations were as follows (absorption costing basis): Year 1 Year 2 Year 3 Sales $ 1,000,000 $ 730,000 $ 1,000,000 Cost of goods sold 760,000 512,000 788,500 Gross margin 240,000 218,000 211,500 Selling and administrative expenses 230,000 198,000 230,000 Net operating income (loss) $ 10,000 $ 20,000 $ (18,500 ) In the latter part...

Subjects