Question

In: Accounting

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.

  1. 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.
  2. 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.
  3. 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


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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT