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 34,000 October 78,000 November 24,000 10,500 47,000 December 11,000 The selling price of the beach umbrellas is $11 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 $297,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 September 30 81,200 feet ? 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 $54.920. 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. 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 34,000 October 78,000 November 24,000 10,500 47,000 December 11,000 The selling price of the beach umbrellas is $11 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 $297,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 September 30 81,200 feet ? 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 $54.920. 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.
Expert 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
-
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...
-
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: The...
-
After reviewing the definition of Behavior Leadership Theory, explain what effect behavioral leadership theory has on traditional police in their role as a chief or any other leadership role in law...
-
Let {x1, x2,..., xk} be a spanning set for a vector space V. (a) If we add an additional vector xk+1 to the set, will we still have a spanning set? Explain. (b) If we delete one of the vectors, say...
-
Solve the given inequalities. Graph each solution. 4|2 5x| 6
-
Many researchers are interested in the transcription of protein-encoding genes in eukaryotes. Such researchers want to study mRNA. One method that is used to isolate mRNA is column chromatography....
-
Capital budgeting with uneven cash flows, no income taxes. Southern Cola is considering the purchase of a special-purpose bottling machine for $23,000. It is expected to have a useful life of 4 years...
-
Why would you perform a silent installation? What is the purpose of a password complexity policy? Oracle offers a free download of all editions of the Oracle Database. How does the company derive...
-
Problem A Geneva mechanism Disk S P B 1= 2R- R = 50 mm = 135 Disk D Disk D rotates with a cst ccw angular velocity Pin P is attached to disk D and slides along one of several slots in disk S The...
-
The luxury goods market is incredibly lucrative. Most studies on counterfeiting have tended to focus on the supply side. In recent years, however, there has been greater interest in studies...
-
Though it might be a challenge, employing individuals with autism is beneficial. According to Britains National Autistic Society, only 15 percent of adults with autism have fulltime employment, while...
-
In India, only about 20 cities out of 87 have organized transport and fewer can lay claim to a mass rapid transit system. A collaboration between Indias Tata Motors and Brazils Marcopolo, it...
-
After a meeting at Creed & Dibbs CPA, Eduardo inadvertently leaves his smartphone in the firms conference room. With respect to the smartphone, this is a. an involuntary bailment. b. not a bailment...
-
Hector sells his Microsoft Xbox to Paul and Amy. Each takes a one-half interest in it. Paul and Amy are not married. Nothing is said about the form of the buyers ownership. They own the system as a....
-
According to the Wall Street Journal article in the text, all of the following are possible causes of a surplus in the copper market except: a) An increase in mining of lower grade materials. b)...
-
Choose a company from the SEC EDGAR Web site for your Key Assignment to evaluate for the impact of convergence to IFRS. Review the financial reports and notes of the company you have chosen from the...
-
When translating Acceletrons fi nancial statements into US dollars, Redline is least likely to use an exchange rate of USD per SGD: A . 0.671. B . 0.588. C . 0.654.
-
Yus determination regarding Transaction 2 should be based on the currency of the: A . loan. B . bank. C . borrower.
-
In response to the boards fourth question, the balance sheet exposure (in C$ millions) would be closest to: A . 19. B . 148. C . 400.
Study smarter with the SolutionInn App