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
-
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....
-
Outline the internal changes a company may need to make when introducing e-business.
-
1. What impact do you think Brenda's tweeting will have on her leadership effectiveness? 2. What do you think of the political effectiveness of sending the same tweet to several workers? 3. What...
-
The equilibrium constant for the reaction \(A ightarrow B\) is doubled when temperature is changed from \(25^{\circ} \mathrm{C}\) to \(35^{\circ} \mathrm{C}\). Calculate the enthalpy of reaction.
-
Uhura Company has decided to expand its operations. The bookkeeper recently completed the balance sheet presented below in order to obtain additional funds for expansion. Uhura Company Balance Sheet...
-
The system call sbrk (0) returns program crash, if it does? 1 2 3 4 6 7 8 } T-W21-DPe current value of brk. When will the f #include int main() { char *c; c = sbrk (0) - 1; *C= k'; c = sbrk (0) + 1;...
-
Golden Gate CPA firm leases tax software from Low Tax Software Company to prepare federal and state income tax returns. The lease agreement calls for a base charge of $5,000 per year plus $100 per...
-
What part of an excess judgment is the insured liable for?
-
True Or False Arbitration is usually required in most policies in the event of a dispute regarding the amount of the insureds damages with respect to UM, UIM, and medical payment coverage.
-
____________ ____________ coverage provides coverage when an uninsured motorist is unable to pay the insureds damages.
-
What is the purpose of no-fault insurance? a. What can and cannot be recovered with no-fault insurance? b. What limits are often established with no-fault insurance, and on what are these limits...
-
What are the characteristics of an adhesion contract?
-
Hamilton, Inc. manufactures units in two processes: Production and Finishing. All direct materials are added at the beginning of the Production process, while conversion costs are incurred evenly...
-
According to a recent survey, 40% of millennials (those born in the 1980s or 1990s) view themselves more as spenders than savers. The survey also reveals that 75% of millennials view social...
-
Is wavelike motion an example of conservative or diffusive motion?
-
Often a linearly sloped beach is not a good model. Waves coming from deep water up a gradually shelving beach are better approximated by assuming a parabolic shape like that shown in Figure P7.6...
-
For an unbounded fluid, the speed of sound is a thermodynamic property. What is its definition?
Study smarter with the SolutionInn App