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,500 October 3,900 6,000 September5,000 November 3,500 December 3,000 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% in the month following sale 5% uncollectible The beginning accounts receivable balance (excluding uncollectible amounts) on July 1 will be $165,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,500 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,320 kilograms. e. The synthetic rubber compound costs $3.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 $14,400 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. (20 marks) 2. Prepare a production budget for each of the months July through October. (10 marks) 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. (20 marks) 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,500 October 3,900 6,000 September5,000 November 3,500 December 3,000 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% in the month following sale 5% uncollectible The beginning accounts receivable balance (excluding uncollectible amounts) on July 1 will be $165,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,500 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,320 kilograms. e. The synthetic rubber compound costs $3.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 $14,400 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. (20 marks) 2. Prepare a production budget for each of the months July through October. (10 marks) 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. (20 marks)
Expert Answer:
Answer rating: 100% (QA)
1 Sales Budget July 7500 water tubes x 60 450000 August 6000 water tubes x 60 360000 September 5000 water tubes x 60 300000 Total sales for the third ... 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...
-
Crydon 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...
-
Stenback Exercise Equipment, Inc. reported the following financial statements for 2016: Requirements 1. Compute the amount of Stenback Exercises acquisition of plant assets. Assume the acquisition...
-
Subsequent data indicated that life expectancy grew to 73.2 years for males born during 1995-2000 and to 74.3 years for males born during 2000-2005. Add the points (15,73.2) and (20,74.3) to the data...
-
Prepare a memo that (1) summarizes relevant professional standards (standard and paragraph should be cited) related to each of the 4 issues and (2) proposes any journal entries for all misstatements...
-
Provide examples for sequential access, both real and virtual.
-
For the month of April, Tom and Lynda had forecasted gym membership at 950 members. Tom and Lynda expect to collect $100 as the monthly fee from each member and to spend $35 in variable costs per...
-
Image transcription text Solving nonlinear equations 1. Programming: In this problem you will implement the 3 basic root?nding algo- rithms discussed in class. For all three methods, your function...
-
B) Consider the below graph with '1' as the source vertex, Dijkstra's algorithm for single source shortest path is implemented to find the shortest path. There is a debate between 3 students: Aruna...
-
A thin \(0.50-\mathrm{kg}\) ring of radius \(R=0.10 \mathrm{~m}\) hangs vertically from a horizontal knife-edge pivot about which the ring can oscillate freely. If the amplitude of the motion is kept...
-
The oscillations of a thin rod can be used to determine the value of the acceleration due to gravity. A rod that is \(0.800 \mathrm{~m}\) long and suspended from one end is observed to complete 100...
-
Express, as a function of \(\tau\), the time interval needed for the amplitude of an oscillation to reduce to half of its initial value.
-
If a person is \(20 \%\) shorter than average, what is the ratio of his walking pace (that is, the frequency \(f\) of his motion) to the walking pace of a person of average height? Assume that a...
-
The maximum angle from the vertical reached by a simple pendulum of length \(\ell\) is \(\vartheta_{\max }\). What is the linear speed \(v\) of the bob for any angle \(\vartheta\) from the vertical?
-
Given the following marginal tax schedule, what would be the tax on $70,000 of taxable income? (5 points) $0 to 50,000 15% 50,001 to 75,000 25% 75,001 to 100,000 34%
-
Maria Castigliani is head of the purchasing department of Ambrosiana Merceti, a medium-sized construction company. One morning she walked into the office and said, The main problem in this office is...
-
Action Quest Games adjusts its accounts annually. The following information is available for the year ended December 31, 2025. 1. Purchased a 1-year insurance policy on June 1 for $1,800 cash. 2....
-
Why is carbon such a special atom?
-
With each pass of a comet about the Sun, the comets mass (a) remains virtually unchanged. (b) actually increases. (c) is appreciably reduced.
Study smarter with the SolutionInn App