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: 36,000 October 26,000 82,000 November 12,500 September 51,000 December 13,000 The selling price of the beach umbrellas is $15 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: July August 30% in the month of sale 65% in the month following sale 5% uncollectible Sales for June totaled $465,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 e. Gilden costs $0.60 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 $44,790. Required: 85,800 feet feet ? 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. Required 4 and 5 Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter. August September Quarter Required 1 Required 2 Total cash disbursements Required 3 July < Required 4 and 5 Required 6 Required 6 >
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: 36,000 October 26,000 82,000 November 12,500 September 51,000 December 13,000 The selling price of the beach umbrellas is $15 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: July August 30% in the month of sale 65% in the month following sale 5% uncollectible Sales for June totaled $465,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 e. Gilden costs $0.60 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 $44,790. Required: 85,800 feet feet ? 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. Required 4 and 5 Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter. August September Quarter Required 1 Required 2 Total cash disbursements Required 3 July < Required 4 and 5 Required 6 Required 6 >
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter2: Basic Cost Management Concepts
Section: Chapter Questions
Problem 21E: Ellerson Company provided the following information for the last calendar year: During the year,...
Related questions
Question
4,5, and 6 only
![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.
August
September
Total units of raw materials to be purchased
Cost of raw materials to be purchased
< Required 3
July
Required 6 >
Quarter](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6bcdff69-8e2f-4d70-9fa6-ce88ac327df5%2F71972cd1-e53f-4049-84a1-7a85df251225%2Fd7cwbln_processed.png&w=3840&q=75)
Transcribed Image Text: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.
August
September
Total units of raw materials to be purchased
Cost of raw materials to be purchased
< Required 3
July
Required 6 >
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:
36,000 October 26,000
82,000 November 12,500
September 51,000 December 13,000
The selling price of the beach umbrellas is $15 per unit.
b. All sales are on account. Based on past experience, sales are collected in the following pattern:
July
August
30% in the month of sale
65% in the month following sale
5% uncollectible
Sales for June totaled $465,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
85,800 feet
feet
?
e. Gilden costs $0.60 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 $44,790.
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.
Required 4
and 5
Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter.
August September Quarter
Required 1 Required 2 Required 3
Total cash disbursements
July
< Required 4 and 5
Required 6
Required 6 >](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6bcdff69-8e2f-4d70-9fa6-ce88ac327df5%2F71972cd1-e53f-4049-84a1-7a85df251225%2Fgm90vlu_processed.png&w=3840&q=75)
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:
36,000 October 26,000
82,000 November 12,500
September 51,000 December 13,000
The selling price of the beach umbrellas is $15 per unit.
b. All sales are on account. Based on past experience, sales are collected in the following pattern:
July
August
30% in the month of sale
65% in the month following sale
5% uncollectible
Sales for June totaled $465,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
85,800 feet
feet
?
e. Gilden costs $0.60 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 $44,790.
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.
Required 4
and 5
Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter.
August September Quarter
Required 1 Required 2 Required 3
Total cash disbursements
July
< Required 4 and 5
Required 6
Required 6 >
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
![Principles of Cost Accounting](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning