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.
- 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
ekkarill92 answered 1 year agoRelated 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
Latest Questions
- You are tasked with assessing the health department’s intervention program in preventing recurrence of acute alcohol...
- Compare the MOSFET, JFET , and BJT and identify the reasons these devices behave differently. What...
- How would you use SAS Enterprise Miner to create a neural network model of your example?
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
ADVERTISEMENT