Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled thefollowing information to assist in the budget preparation:a. The Marketing Department has estimated sales as follows for the remainder of the year (in units):31,500 October 21,500November 8,00073,000September 42,000 December 8,500JulyAugustThe selling price of the beach umbrellas is $12 per unit.b. All sales are on account. Based on past experience, sales are collected in the following pattern:30 in the month of sale65% in the month following sale5 uncollectibleSales for June totaled $264,000.c. The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at theend of June.d. Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires thatthe ending inventory of Gilden be equal to 50% of the following month's production needs. The inventory of Gilden on hand at thebeginning and end of the quarter will be: June 30September 3075,450 feet2 feete. 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 paidfor in the following month. The accounts payable on July 1 for purchases of Gilden during June will be $48,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.Complete this question by entering your answers in the tabs below.Req 1Req 2Req 3Required production in unitsReq 4 and 5Req 6Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October.JulyAugust September October

*Since you have posted multiple subparts. I can solve only 3 subparts at a time. So please post the…

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 31,500 October 21,500 73,000 November 8,000 8,500 September 42,000 December The selling price of the beach umbrellas is $12 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 $264,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:

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 31,500 October 21,500 73,000 November 8,000 8,500 September 42,000 December The selling price of the beach umbrellas is $12 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 $264,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:

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

[The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 9,000, 21,000, 23,000, and 24,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. c. The ending finished goods inventory equals 30% of the following month's unit sales. d. The ending raw materials inventory equals 20% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.70 per pound. e. Twenty percent of raw materials purchases are paid for in the month of purchase and 80% in the following month. f. The direct labor wage rate is $14 per hour. Each unit of finished goods requires two direct labor-hours. g.…
Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1st quarter budget: July, August, and September. Budgeted sales are as follows: Month Sales ($) Units Sold May 25,000 250 June 28,000 280 July 30,000 300 August 40,000 400 September 35,000 350 October 37,000 370 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Closing inventory must equal 50% of the next month’s sales. iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale. iv) The balance in the bank account as of 30 June is $10,000. Required (show your workings for each question): Prepare a purchases budget (in units and $) for the 1st…
Atlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,760 finished surfboards in inventory. Budgeted sales units July 4,400 August 5,500 September 3,300 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Budgeted sales units Add: Desired ending inventory Desired ending inventory units Total required units Units to be produced July 0 August 0
Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are planned for the year. Beginning Inventory Ending Inventory Finished goods (units) 26,000 76,000 Raw material (grams) 56,000 46,000 Each unit of finished goods requires 2 grams of raw material. The company plans to sell 730,000 units during the year. The number of units the company would have to manufacture during the year would be: 730,000 units 806,000 units 674,000 units 780,000 units
Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1st quarter budget: July, August, and September. Budgeted sales are as follows: Month Sales ($) Units Sold May 25,000 250 June 28,000 280 July 30,000 300 August 40,000 400 September 35,000 350 October 37,000 370 Additional information: i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase. ii) Closing inventory must equal 50% of the next month’s sales. iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale. iv) The balance in the bank account as of 30 June is $10,000. Required (show your workings for each question): Prepare the schedule of expected cash collections from…
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):05JulyAugustSeptember31,500 October73,000November42,000 December21,5008,0008,500The selling price of the beach umbrellas Is $12 per unit.b. All sales are on account. Based on past experience, sales are collected in the following pattern:30% in the month of sale65% in the month following sale5% uncollectibleSales for June totaled $264,000The company maintains finished goods inventories equal to 15% of the following month's sales. This requirement will be met at the end of JuneEach 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…
You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 100 units February, 95 units March, 102 units April, 107 units May, 114 units June, 122 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 90 units March, 102 units April, 102 units May, 104 units June, 117 units. In February of the current year, sales for the months March through June were reforecasted as follows: March, 97 units April, 102 units May, 99 units June, 117 units In March of the current year, sales for the months April through June were reforecasted as follows: April, 102 units May, 94 units June, 107 units In April of the current year, sales for the months May and June were reforecasted as follows: May, 84 units June, 102 units In May of the current year, sales for June were…
answer in text form please (without image)
Dolson Appliances makes coffee machines for offices and homes. For next year, the production budget is 141,000 units. Beginning inventories will be 18,000 units and the desired ending inventory will be 16,000 units. Required: What is the sales budget for the coming year for Dolson Appliances? Sales budget units
Magnolia Interior décor Industries manufactures wooden dining chairs. The selling price of the wooden dining chairs is $15 per unit. The company is preparing detailed budgets for the third quarter (Third quarter includes July, August and September) and fourth quarter (Fourth quarter includes October, November and December) and has assembled the following information to assist in the budget preparation (see below tables). Sales for June totaled $2,000. 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. Calculate the estimated quantity of wooden dining chairs that need to be produced in July. Estimated unit sales for the next several month Month Units July 100 August 200 September 300 October 200 November 200 300 December All sales are on account (i.e., on credit). These sales on account are usually collected in the following pattern: 65% in the month following sale 5% X 130 Correct Answer: 115…
Atlantic Surf manufactures surfboards. The company's budgeted sales units for the next three months is shown below. Company policy is to maintain finished goods Inventory equal (in units) to 40% of the next month's unit sales. As of June 30, the company has 1,600 finished surfboards In Inventory. Budgeted sales units July 4,000 August 5,500 September 4,200 Prepare the production budget for the months of July and August. ATLANTIC SURF Production Budget Desired ending inventory units Total required units Units to be produced July August