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 30,000 August 70,000 September 50,000 October 20,000 November 10,000 December 10,000 The selling price of the beach umbrellas is $12 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 Page 400 Sales for June totaled $300,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 72,000 feet September 30 7 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 $76,000. Required: 1. Calculate the estimated sales, by month and in total, for the third quarter (Hint: Refer to Schedule 1 for guidance). 2. Calculate the expected cash collections, by month and in total, for the third quarter (Hint: Refer to Schedule 1 for guidance). 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October (Hint: Refer to Schedule 2 for guidance). 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter (Hint: Refer to Schedule 3 for guidance). 5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter (Hint Refer to Schedule 3 for guidance). 6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter (Hint: Refer to Schedule 3 for guidance). 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 30,000 August 70,000 September 50,000 October 20,000 November 10,000 December 10,000 The selling price of the beach umbrellas is $12 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 Page 400 Sales for June totaled $300,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 72,000 feet September 30 7 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 $76,000. Required: 1. Calculate the estimated sales, by month and in total, for the third quarter (Hint: Refer to Schedule 1 for guidance). 2. Calculate the expected cash collections, by month and in total, for the third quarter (Hint: Refer to Schedule 1 for guidance). 3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October (Hint: Refer to Schedule 2 for guidance). 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter (Hint: Refer to Schedule 3 for guidance). 5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter (Hint Refer to Schedule 3 for guidance). 6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter (Hint: Refer to Schedule 3 for guidance).
Expert Answer:
Answer rating: 100% (QA)
1 Estimated Sales for the Third Quarter July 30000 units August 70000 units September 50000 units Oc... 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
-
A classified balance sheet (LO5 C5): Pregunta 34Respuesta a. Provides detailed information on the company's revenue streams b. Separates assets and liabilities into current and long-term categories...
-
Read the following link and support the questions with evidence from the provided text Assume service scores for the area you manage, Harrah's Metropolis hotel housekeeping, have declined over the...
-
QUESTION 9 The Bending moment diagram corresponding to the loading shown in Figure Q9 is: X 20 KN 10 kN/m 30 KN (m) 0 1. 4. 6. 8. 10. 0.00 a) 0.00 -20.00 -20.00 -50.00 -50.00 -90.00 (m) c) 80.00 0.00...
-
Steve and Linda Hom live in Bartlesville, Oklahoma. Two years ago, they visited Thailand. Linda, a professional chef, was impressed with the cooking methods and the spices used in the Thai food....
-
Summarize the differences between adoption of Internet access for consumers and businesses and give reasons for these differences.
-
L. R. Updike owns a department store that has a $50,000 balance in Accounts Receivable and a $2,500 credit balance in Allowance for Doubtful Accounts. 1. Determine the net realizable value of the...
-
Learner Corporation issued 16,000 shares of its $1 par value common stock in exchange for land that had a fair market value of $100,000. Prepare in journal form the entries necessary to record the...
-
A January 31 announcement to shareholders of Premier Financial, a California savings and loan company, stated that the company had good news for stockholders. The announcement went on to explain that...
-
Can you please help me solve 29, 31, 32, 34? Thanks so much! :) \f\f
-
The net present value of a proposed project is a positive $56,000 at a discount rate of 10% and a negative $28,000 at 20%. What is the internal rate of return of the project, to the nearest whole...
-
SQL JOINS If you are unfamiliar with the JOIN concepts, please take a moment to review the content on this page and access the links provided for a better understanding before you attempt the...
-
Sql Q2 0.5 Points Consider the following table, named icecream. ID Flavor | Color | Price 1 strawberry pink | 3.55 2 chocolate | light brown | 4.75 3 chocolate dark brown | 5.25 4 strawberry pink...
-
1. Explain why, in the traditional view of inventory, carrying costs increase as ordering cost decrease. 2. Discuss the traditional reasons for carrying inventory. 3. How safety stock is used to deal...
-
Product launch failing to comply to regulations or standards Brief product description & company descriptions Detailed explanation of situation and which regulations were in question. why did the...
-
Kristen has a major medical insurance policy with a $500 calendar-year deductible, a $5,000 out-of-pocket limit, and 80-20 coinsurance. Kristen was hospitalized for a surgical procedure in March, her...
-
Suppose a country wanted to increase the rate of growth of itsper capita real GDP. It could do this by A.decreasing the growth rate of real GDP and decreasing thepopulation growth rate. B.decreasing...
-
A stock has had returns of 8 percent, 26 percent, 14 percent, 17 percent, 31 percent, and 1 percent over the last six years. What are the arithmetic and geometric average returns for the stock?
-
Define a business transaction in the broad sense and give examples of the two different kinds of transactions.
-
What two equalities in accounting must be maintained in transaction analysis?
-
What is a T-account? What is its purpose?
Study smarter with the SolutionInn App