Check my work 1 03:50:33 Milo Company manufactures beach umbrellas. The company is preparing detailed budgets...
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/664899be4dd78_981664899bdd476c.jpg)
Transcribed Image Text:
Check my work 1 03:50:33 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): 40 points July August October 35,000 25,000 80,000 November 11,500 September 49,000 December 12,000 eBook The selling price of the beach umbrellas is $13 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: Print 30% in the month of sale 65% in the month following sale 5% uncollectible Sales for June totaled $377,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 83,500 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 $42,990. 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. Req 1 Req 2 Req 3 Req 4 and 5 Req 6 Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October. July August September October Check my work 1 03:50:33 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): 40 points July August October 35,000 25,000 80,000 November 11,500 September 49,000 December 12,000 eBook The selling price of the beach umbrellas is $13 per unit. b. All sales are on account. Based on past experience, sales are collected in the following pattern: Print 30% in the month of sale 65% in the month following sale 5% uncollectible Sales for June totaled $377,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 83,500 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 $42,990. 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. Req 1 Req 2 Req 3 Req 4 and 5 Req 6 Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October. July August September October
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
You want to conduct a study on commuters in NYC and how muchtime they spend traveling to and from work every day. You decide towait outside the subway stations from Monday to Friday, 9am to 5pm,and...
-
Presented below are selected ratios for four firms: Firm A is a distiller, Firm B is a jewelry retailer, Firm C is an airline, and Firm D is a hotel chain. Required: 1. Explain why the long-term...
-
Money magazine listed top career opportunities for work that is enjoyable, pays well, and will still be around 10 years from now (Money, November 2009). Shown below are 20 top career opportunities,...
-
Using the above data, calculate the operatingcash-flow-to-capital-expenditures ratio for Evans \& Sons. The following information for Evans \& Sons relates Cash flow from operating activities......
-
Cycle Business manufactures and sells road and mountain bikes through a network of retail outlets in western Canada. Below is a partial list of expense items incurred in the most recent month...
-
6 When using a process costing system, costs classified as work-in-process inventory are categorized according to the associated: 1 point Input Output Activity Job
-
When pricing a product for export, what factors are to be considered when setting the price? Should it be higher, lower or the same. Finally, when quoting a price, what needs to be considered?
-
In the real world, the notification management system consists of two parts, one is to allow clients to subscribe/unsubscribe the notification, and another part is to facilitate administrator(s) to...
-
A single-phase full-bridge inverter feeds a resistive load of R = 50 at nominal voltage 220V/50Hz from 400V DC supply. If unipolar SPWM technique is used and the carrier frequency is 5KHz, answer the...
-
Explain how a company could benefit from the net present value (NPV) method and the internal rate-of-return (IRR) method. What are the main shortcomings of the NPV and IRR methods? Explain the...
-
When the market value of an investment in debt securities exceeds its amortized cost, how should each of the following assets be reported at the end of the year?
-
On Monday morning in June 2021, CEO of DDM Labs Ivan Novak just adjourned the management board meeting at DDM Labs. The motivation of the management team was somewhat down. The profit generated in...
-
December 31 :Un Jamueray 1.9019 Morggam ComPany acquos $ 300,000 of Nicklaus, mc., Proice of $278,384. The Jateest is Payabe each Derember 31, and the bonds mature De cember 31, 2021, The Investmart...
-
Reichenbach Co., organized in 2018, has set up a single account for all intangible assets. The following summary discloses the debit entries that have been recorded during 2018 and 2019. Instructions...
-
Preferred stock that may be converted into common stock has which of the following characteristics? a. Call feature b. Cumulative feature c. Participation feature d. Convertible feature
-
A dividend that is paid every quarter or every year is called? a. Regular dividend b. Special dividend c. Property dividend d. Stock dividend
-
What is the meaning of each of the following terms: corporation, articles of incorporation, corporate charter, board of directors, corporate officers, and organization costs?
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App