Milo Company manufactures beach umbrellas. The company is preparing budgets for the third quarter and assembled...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Milo Company manufactures beach umbrellas. The company is preparing budgets for the third quarter and assembled the following information: a. The Marketing Department estimated unit sales as follows for the remainder of the year: July August September 41,500 October 31,500 93,000 November 18,000 62,000 December 18,500 The selling price of the beach umbrellas is $14 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 $588,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 ending inventory of Gilden 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 98,450 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 $72,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 budgets for the third quarter and assembled the following information: a. The Marketing Department estimated unit sales as follows for the remainder of the year: July August September 41,500 October 31,500 93,000 November 18,000 62,000 December 18,500 The selling price of the beach umbrellas is $14 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 $588,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 ending inventory of Gilden 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 98,450 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 $72,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:
Answer rating: 100% (QA)
Answer Lets break down each requirement 1 Estimated Sales for the Third Quarter July 41508 units Aug... 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 finance questions
-
You are currently a managing partner at Innovative Marketing Solutions (IMS) a social media marketing start-up. The firm occupies a modern office space at the London Roundhouse (a hub for tech...
-
The data on the lengths of anacondas on the front piece of the chapter yield a 95% confidence interval for the population mean length of all anaconda snakes in the area of the study. (a) Is the...
-
Consider the following polymer: From which two monomers is the polymer made? OCH,CH,OCCH,CH,COCH,CH,OCCH,CH,C
-
Discuss why a nurse is not only a nurse, but also a patient advocate.
-
Paul Adams owns a health club in downtown Los Angeles. He charges his customers an annual fee of $500 and has an existing customer base of 600. Paul plans to raise the annual fee by 6 percent every...
-
Over 5 periods, the arithmetic average return of a portfolio is 1.4%, the geometric average return is 1.012%, and the dollar-weighted average return is 0.577%. What might explain why the...
-
Mara and Christina each have an income of $900 which they spend entirely on jeans and pairs of shoes. They exclusively buy a brand of jeans that sells for $75 a pair and shoes that sell for $50 a...
-
The brain makes use of a phenomenon known as ____________________, or the difference in the images the two eyes see, to give three dimensions to sight.
-
What are the varieties of sexual behavior?
-
Are there different kinds of memory?
-
On June 10, 20X6, Dar Al Fatina purchased material supplies on account for $35,000. Which of the journal entries for this transaction in the table below is correct. A Date June 10, 20X6 Cash Accounts...
-
__________theory assumes that language acquisition is based on principles of conditioning and shaping.
-
On July 1, 2014, Joe, Kline, and Lama began a partnership in which Joe and Kline each contributed cash of $200,000; and Lama contributed property with a fair value of $100,000 and a tax basis...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
Show that the Fourier transform of a conjugate antisymmetric sequence is imaginary.
-
Solve Exercise 1.22 using the concept of the transfer function. Exercise 1.22 Compute the inverse Fourier transform of \[X\left(\mathrm{e}^{\mathrm{j} \omega} ight)=\frac{1}{1-\mathrm{e}^{-\mathrm{j}...
-
We define the even and odd parts of a complex sequence \(x(n)\) as \[\mathcal{E}\{x(n)\}=\frac{x(n)+x^{*}(-n)}{2} \quad \text { and } \quad \mathcal{O}\{x(n)\}=\frac{x(n)-x^{*}(-n)}{2}\]...
Study smarter with the SolutionInn App