Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): July August September 32,000 October 74,000 22,000 November 8,500 43,000 December 9,000 The selling price of the beach umbrellas is $13 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: 30% in the month of sale 65% in the month following sale 5 uncollectible Sales for June totaled $299,000. c. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June. d. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month's production needs. The inventory of Gilden on hand at the beginning and end of the quarter will be: June 30 76,600 feet September 30 ? feet e. Gilden costs $0.80 per foot. One-half of a month's purchases of Gilden is paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable on July 1 for purchases of Gilden during June will be $50,120, Required: < Prev 11 of 11 Next > Required: 1. Calculate the estimated sales, by month and in total, for the third quarter. 2. Calculate the expected cash collections, by month and in total, for the third quarter. 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October. 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter. 5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter. 6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter. Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 and 5 Req 6 Calculate the estimated sales, by month and in total, for the third quarter. Budgeted sales July August September Quarter Req 1 Req 2 > Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): July August September 32,000 October 74,000 22,000 November 8,500 43,000 December 9,000 The selling price of the beach umbrellas is $13 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: 30% in the month of sale 65% in the month following sale 5 uncollectible Sales for June totaled $299,000. c. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of June. d. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month's production needs. The inventory of Gilden on hand at the beginning and end of the quarter will be: June 30 76,600 feet September 30 ? feet e. Gilden costs $0.80 per foot. One-half of a month's purchases of Gilden is paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable on July 1 for purchases of Gilden during June will be $50,120, Required: < Prev 11 of 11 Next > Required: 1. Calculate the estimated sales, by month and in total, for the third quarter. 2. Calculate the expected cash collections, by month and in total, for the third quarter. 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October. 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter. 5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter. 6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter. Complete this question by entering your answers in the tabs below. Req 1 Req 2 Req 3 Req 4 and 5 Req 6 Calculate the estimated sales, by month and in total, for the third quarter. Budgeted sales July August September Quarter Req 1 Req 2 >
Expert Answer:
Answer rating: 100% (QA)
1 Calculate the estimated sales by month and in total for the third quarter July 32000 units x 13 41... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
Head movement evaluations are important because disabled individuals may be able to operate communications aids using head motion. The paper Constancy of Head Turning Recorded in Healthy Young Humans...
-
As the United States has struggled with the growing obesity of its citizens, diets have become big business. Among the many competing regimens for those seeking weight reduction are the Atkins and...
-
At the end of 2019, Sorter plc has accounts receivable of 900,000 and an allowance for doubtful accounts of 40,000. On January 16, 2020, Sorter determined that its receivable from Ordonez Orchards...
-
Find the first two natural frequencies of vibration in the vertical direction of the floor of the suspension bridge shown in Fig. 8.27 under the following assumptions: 1. The floor can be considered...
-
Your company has a travel policy that reimburses employees for the ordinary and necessary costs of business travel. Employees often mix a business trip with pleasure by either extending the time at...
-
What is at stake? Describe what you think is at stake with the issue of outsourcing ?
-
Depreciation by Three Methods; Partial Years Perdue Company purchased equipment on April 1, 2014, for $270,000. The equipment was expected to have a useful life of three years, or 18,000 operating...
-
What is the output if the solveMystery() method is applied to a Properties object loaded from mystery.properties? A. bag ? trick B. bag ? null C. bag null null D. bag null trick E. The code does not...
-
Suppose a box is filled with 25 white balls and 32 red halts. Find the probability of drawing six red balls and four white balls in 10 draws without replacement.
-
Fill in the blank with the option that allows the code snippet to compile and print a message without throwing an exception at runtime. A. f.formatDate(x) B. f.formatDate(y) C. f.format(x) D....
-
What is the output if the launch() method is applied to a Properties object loaded from scifi.properties? A. saturn5 null ? B. saturn5 null null C. null null ? D. saturn5 ? ? E. The code does not...
-
Assuming the Forest.properties file is the only resource file available, what is the output of calling the hike() method? A. trees B. trees pretty C. trees {0} D. trees null E. The code does not...
-
1. Write a brief note on the person I want to be? 2. Brief also Leadership traits.
-
Smthe Co. makes furniture. The following data are taken from its production plans for the year. Required: 1. Determine the hazardous waste disposal cost per unit for chairs and for tables if costs...
-
Frosting of evaporator tubes results in (a) increased heat transfer rate (b) decreased heat transfer rate (c) increased compressor pressure (d) decreased compressor pressure
-
The chemical formula of R-12 is (a) CCl2F (b) CClF3 (c) CCl2F2 (d) CHClF2
-
The use of chlorofluoro carbon refrigerants is banned because these react with (a) water vapours and cause acid rain (b) plants and cause green house effect (c) oxygen and cause its depletion (d)...
Study smarter with the SolutionInn App