Water Sport Inc. manufactures a small personal water tube used for children learning to swim. Management...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 August 7,100 5,600 November October 3,500 3,100 September 4,600 December 2,600 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: 50% in the month of sale 45% 5% in the month following sale uncollectible The beginning accounts receivable balance (excluding uncollectible.amounts) on July 1 will be $163,000. c. 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,420 units. d. Each water tube requires 3 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 4,080 kilograms. e. The synthetic rubber compound costs $4.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 $13,200 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. Sales budget July August September Quarter Budgeted sales (units) Selling price per unit Total budgeted sales 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 August 7,100 5,600 November October 3,500 3,100 September 4,600 December 2,600 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: 50% in the month of sale 45% 5% in the month following sale uncollectible The beginning accounts receivable balance (excluding uncollectible.amounts) on July 1 will be $163,000. c. 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,420 units. d. Each water tube requires 3 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 4,080 kilograms. e. The synthetic rubber compound costs $4.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 $13,200 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. Sales budget July August September Quarter Budgeted sales (units) Selling price per unit Total budgeted sales
Expert Answer:
Answer rating: 100% (QA)
Answer 1 Sales Budget for the Third Quarter July Budgeted sales units 7100 Selling price per unit 60 ... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1259024900
9th canadian edition
Authors: Ray Garrison, Theresa Libby, Alan Webb
Posted Date:
Students also viewed these accounting questions
-
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...
-
A curve C in three dimensions is given parametrically by (x(t), y(t), z(t)), where t is a real parameter, with a t b. Show that the equation of the tangent line at a point P on this curve where t...
-
Recall that opening weekend box office revenue data (in millions of dollars) were collected for a sample of 24 recent movies. In addition to each movie's tweet rate, i.e., the average number of...
-
Financial information for Robinson Inc. follows: Additional information: Ordinary shares were redeemed during the year at their book value. The face value of the bonds is $400,000; they pay a...
-
Suppose a trader buys a European Put on a share for \(\$ 4\). The stock price is \(\$ 53\) and the strike price is \(\$ 49\). (a) Under what circumstances will the trader make a profit? (b) Under...
-
Describe the differences between general-use software and generalized audit software. How might you use spreadsheet software, database software, and word processing software in conducting an audit of...
-
Chong, Inc. provides advice to art enthusiast interested in purchasing art at Sotheby's annual art auctions. On December 31, 2012, Chong's account balances are shown below in the Adjusted Trial...
-
(20 Pts) A long steel pipe (Ksteel = 15 W m K-) transports water at T1 = 50C. The pipe has inner radius r = 10 mm and is 2 mm wall thickness. The heat transfer coefficient inside the pipe to the...
-
A ship travels 4 km east, 5 km northeast, and then 6 km north. Use tail-to-tip method to determine the final displacement of the ship.
-
If a set of vectors laid tail to head forms a closed polygon, the resultant is zero. Is this statement true? Discuss. A rock is dropped at the same instant as a ball, at the same initial elevation,...
-
A constant force, F = (4.03, -2.10, 3.59) N, acts on an object of mass 18.1 kg, causing a displacement of that object by 7 == (3.95, 3.91, (expression error)) m. What is the total work done by this...
-
Assume the interest rates in Singapore is 9.60% and 11.48% in the United States. A US dollar (USD) currently sells for 1.3893 Singapore dollars (SGD). The one-year forward rate is 1.3199 Singapore...
-
For this discussion we had a choice to discuss about Publix or pick a store we use in our community, and I decided to pick Kroger. The reason I picked Kroger is because I go shopping there more than...
-
Assess the businesss database needs with respect to the proposed expansion into online sales, and lay out possible solutions for meeting the needs you identified. Specifically, you should address the...
-
The executor of Gina Purcells estate has recorded the following information: Assets discovered at death (at fair value): Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
What other solutions could you see be effective at improving employee motivation and reducing the turnover rate? Why do you believe these solutions would be useful?
-
Should the whole team have decided on the team members schedule accommodations collectively? Why or why not?
-
In what ways do you believe providing special work arrangements or accommodations for employees impacts employee motivation? How does it help? How does it hurt?
Study smarter with the SolutionInn App