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 September 30,500 71,000 October November 20,500 7,000 40,000 December 7,500 The selling price of the beach umbrellas is $10 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 $200,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 73,150 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 $34,890. 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 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 30,500 71,000 October November 20,500 7,000 40,000 December 7,500 The selling price of the beach umbrellas is $10 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 $200,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 73,150 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 $34,890. 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:
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
-
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...
-
The curve described by the cable of the suspension bridge shown in Figure 8.70 is given by where x is the distance measured from one end of the bridge. What is the length of the cable (see Example...
-
The following times (in minutes) to process hot-rolled steel are observed for a random sample of size 10 as follows: (a) Find the mean, median, and mode of the processing times. Interpret the...
-
What organizational stakeholder must be considered in any serious discussion about how a firm can better fulfill its obligations for sustainable development? (a) owners or investors (b) customers (c)...
-
The complete combustion of \(\mathrm{C}_{2} \mathrm{H}_{4}\) in air yields: (a) \(\mathrm{C}_{2} \mathrm{H}_{4}\) and \(\mathrm{H}_{2}\) (b) \(\mathrm{CO}\) and \(\mathrm{H}_{2} \mathrm{O}\) (c)...
-
The Summit Petroleum Corporation will purchase an asset that qualifies for three-year MACRS depreciation. The cost is $160,000 and the asset will provide the following stream of earnings before...
-
Program for Read name, address, email and phone number of a person through keyboard and print the details.
-
The Generation Alpha market is so small that most firms ignore this consumer group. Why?
-
need a help with magazine article on topic video gaming, evolution of video games, and growth thru the covid - 19 pandemic (around one thousand eight hundred words) NO citations or quotes
-
A 5-ounce bag of rice noodles makes 6 servings. At that rate, find how many ounces of noodles are needed for 13 servings, to the nearest ounce.
-
LING101 - University of New England NSW Can you please help me with this question! Topic 7 - Structure across time There is seemingly no part of a language that can't be subject to change over time....
-
What philosophical perspectives, such as virtue ethics and existentialism, shed light on the ethical dimensions of emotional intelligence and its role in promoting human flourishing and well-being in...
-
To what extent does emotional intelligence intersect with moral reasoning and ethical decision-making, and how can individuals integrate emotional awareness with principles of integrity and social...
-
Assign one or more levels of the hierarchy of needs and the motives described the following products: Life insurance, Cosmetics, The Wall Street Journal, and Hamburgers.
-
The MIT Sloan School of Management is one of the leading business schools in the U.S. The following table contains the tuition data for the masters program in the Sloan School of Management. a. Use...
-
Suppose an investment pays off $800 or $1,600 with equal probability per $1,000 invested. What is the maximum leverage ratio you could have and still have enough to repay the loan in the event the...
-
The imposition of new trade tariffs has resulted in tensions between the United States and some of its major trading partners. Suppose you are a small business owner in the United States. a. How...
-
Suppose you identify 10 possible investments whose payoffs are completely independent of one another. All the investments have the same expected value and standard deviation. You have $1,000 to...
Study smarter with the SolutionInn App