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 35,000 October 25,000 80,000 September 49,000 November 11,500 December 12,000 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: 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 83,500 feet September 30 ? 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 Req3 Req 4 and 5 Req 6 Calculate the estimated sales, by month and in total, for the third quarter. Budgeted sales July August September Quarter Req 1 Req 2 > 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 35,000 October 25,000 80,000 September 49,000 November 11,500 December 12,000 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: 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 83,500 feet September 30 ? 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 Req3 Req 4 and 5 Req 6 Calculate the estimated sales, by month and in total, for the third quarter. Budgeted sales July August September Quarter Req 1 Req 2 >
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations requested 1 Estimated sales for the third quarter July 35000 units x 13unit 455000 August 80000 units x 13unit 1040000 September 49000 units x 13unit 637000 Quarter total 455... 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 accounting questions
-
In programming challenge 8 of chapter 3, you created an application that converts celsius temperatures to fahrenheit. recall that the formula for performing this conversion isf = 1.8 * c + 32in the...
-
As a way of studying the spread of a plant disease known as creeping rot, a field of cabbage plants was divided into 270 quadrats, each quadrat containing the same number of plants. The following...
-
The following trial balance of Scarlatti Corporation does not balance. An examination of the ledger shows these errors. 1. Cash received from a customer on account was recorded (both debit and...
-
Fill in the Blank. The use of close tolerances and better surface finish for machine parts tends to make a machine ____________ susceptible to vibration.
-
Balanced scorecard (H. Kaplan, adapted) Caltex, Inc., refines gasoline and sells it through its own Caltex l3as Stations. On the basis of market research, Caltex determines that 60% of the overall...
-
What are the typical measurements included in the statistics of a workplace wellness program?
-
It is Jan. 1, 2023. You make $50,000/year. You open a 401K on Jan. 1, 2023 and start investing 6% of your salary. Here are the details: Vests 20% per year, (beginning with 20% vested) the day you...
-
Nina is able to select her weekly work hours. When a new bridge opens up, it cuts one hour off Ninas total daily commute to work. If both leisure and income are normal goods, what is the effect of...
-
Some courts have applied the voluntary- undertaking doctrine even when the plaintiff did not rely on the defendants services. True False
-
A landlord must be given reasonable time to make repairs after being notified of the condition needing repair. True False
-
To frequent trespassers who use only a limited area of their land, possessors owe 1. no duty of care. 2. a limited duty of care. 3. the same care they owe an invitee. 4. none of the above.
-
Suppose that prisons historically have required inmates to perform, without pay, various cleaning and food preparation jobs within the prison. Now, suppose that prisoners are offered paid work in...
-
1. What is the definition of a leader in your own opinion and what type of characteristics/traits should a leader have? 2. Why are some managers only managers and not true leaders? 3. Do you feel...
-
Bonus shares can be issued out of revenue reserves. True/False?
-
The regression shown in column (2) was estimated again, this time using data from 1992 (4000 observations selected at random from the March 1993 Current Population Survey, converted into 2015 dollars...
-
Evaluate the following statement: "In all of the regressions, the coefficient on Female is negative, large, and statistically significant. This provides strong statistical evidence of sex...
-
Referring to Table 7.1 in the text: a. Calculate the \(R^{2}\) for each of the regressions. b. Calculate the homoskedasticity-only \(F\)-statistic for testing \(\beta_{3}=\beta_{4}=0\) in the...
Study smarter with the SolutionInn App