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:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648b671d2193_3296648b6715f83b.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6648b6725cb2d_3306648b6720b65a.jpg)
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 24,000 78,000 November 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. Req 1 Req 2 Req 3 Req 4 and 5 Req 6 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. Total units of raw materials to be purchased Cost of raw materials to be purchased July August September 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 24,000 78,000 November 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. Req 1 Req 2 Req 3 Req 4 and 5 Req 6 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. Total units of raw materials to be purchased Cost of raw materials to be purchased July August September Quarter
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
What is the difference between a Type I error and a Type II error?
-
List any errors you can find in the following partial balancesheet. Mishkie Company Balance Sheet December 31, 2007 Assets Current assets: Cash Notes receivable $400,000 24,000 $529,200 42,000...
-
Can a manager use tools and techniques from several different perspectives at the same time? For example, can a manager use both classical and behavioral perspectives? Give an example of a time when...
-
We have steady-state diffusion of ammonia in air across a \(0.033 \mathrm{~mm}\) thick film. On one side of the film ammonia concentration is \(0.000180 \mathrm{kmol} / \mathrm{m}^{3}\), and on the...
-
Malcolm Company sold $6,000,000, 7%, 15-year bonds on January 1, 2017. The bonds were dated January 1, 2017, and pay interest on December 31. The bonds were sold at 98. Instructions (a) Prepare the...
-
Topgun Records and several movie studios have decided to sign a revenue-sharing contract for CDs. Each CD costs the studio $2 to produce. The CD will be sold to Topgun for $3. Topgun, in turn, prices...
-
Bonita Industries reported cost of goods sold as follows. 2022 2021 Beginning inventory $ 30,230 $ 18,000 Cost of goods purchased 183,920 163,730 Cost of goods available for sale 214,150 181,730...
-
The following are transactions for the Sky Blue Corporation: a. Collected $5,400 rent for the period October 1 to December 31, which was credited to Deferred Revenue on October 1. b. Paid $3,600 for...
-
Two skaters of equal mass skate toward each other, each moving at 4 m/s. Their lines of motion are separated by a perpendicular distance of 2.5 m. Just as they pass each other (still 2.5 m apart),...
-
Use this information about Mocha Company to answer the question that follows. Mocha Company manufactures a single product by a continuous process, involving three production departments. The records...
-
Develop at least two research questions and two hypotheses directly related to Veteran Homelessness and Mental illness. When constructing your questions and hypotheses, consider the guidelines stated...
-
College graduation does improve a person's income prospects. But all graduates aren't treate equally: What you majored in counts for a lot. Annual salary surveys by PayScale, Inc., confirm that...
-
The following selected data for the Food Factory Corporation were gathered by the accountants for the year ended December 31, 2017, who are responsible for preparing the financial statements: Cost of...
-
Evaluate each logarithm to four decimal places. log 0.257
-
Information from Razure Adventures Companys financial statements for the current year are provided in the Working Papers. Work independently to complete the following problem. 1. Calculate the...
-
Baycom Corporation's comparative income statement is provided in the Working Papers. Your instructor will guide you through the following examples. 1. Complete the partial income statement using...
-
Baycom Corporation's comparative balance sheet is provided in the Working Papers. Work independently to complete the following problem. 1. Complete the comparative balance sheet using trend analysis....
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App