i need help with required 4-6
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 78,000 47,090 October November December 24,000 10, 500 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 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 3e 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 Gliden (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. Next > Prey 1 of 3 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 Complete this question by entering your answers in the tabs below. Reg 1 Reg2 Req 4 and 5 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter S. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter. (Round your Unit cost of raw materials to 2 decimal places.) September Quarter Total units of raw materials to be purchased Cost of raw materials to be purchased July 227.900 182 320s August 233,800 187040 S 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 78,000 47,000 October November December 24,000 10,500 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: 30x 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 material (Girondan oral or the total for the things and October 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 Answer is not complete. Complete this question by entering your answers in the tabs below. Reg 1 Regi Reg 2 Req3 Req 4 and 5 Req 4 and 5 Red 6 Reqs Calculate the estimated sales, by month and in total, for the third quarter. Budgeted sales July $ 374,000 August 3 850,000s September 517.000 Quarter 1.740,000 Check my work mode: This shows what is correct or incorrect for the work you hau 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 inventores 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 I 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 e produced in of the raw maternal needs to b Answer is not complete. Complete this question by entering your answers in the tabs below. Reg 1 Red Red 4 and 5 Calculate the expected cash collections, by month and in total, for the third quarter. July August September Total cash collections 305,250 500 500 712 800 550 Quarter 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 month and in to Calculate the quantity of quantity of beach Answer is not complete Complete this question by entering your answers in the tabs below. Regi Reg2 Reg 3 Reg4 and 5 Reg 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. (Round your Unit cost of raw materials to 2 decimal places.) July September Total units of raw materials to be purchased Quarter August 233,800 $ 187,040 227.000 $ 182 320 Cost of raw materials to be purchased 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 3e September 30 81,200 feet 2 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 Answer is not complete. Complete this question by entering your answers in the tabs below. Reg i Reg 3 Reg 4 and 5 Reg 6 Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter. July August September Quarter otal cash disbursement 48,080 184.6800 145.000 $476,640 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,009 78,000 47,000 October November December 24,000 10,500 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 inventores equal to end of June d. Each beach umbrella requires 4 feet of Gilden material the ending inventory of Gilden be equal to 50% of the follow beginning and end of the quarter will be he following months sales. This requirement will be met at the sometimes and to acquire heterore, the company requires that months production needs. The inventory or elden on hand at the June 30 September 30 e. Gilden costs $0.80 per foot one half of a month's purchases or Gilden is paid for in the month of purchase the remainder is pald w h ebuh payable only 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 reer that needs to be purchased by month and in total for the third quarter 5. Calculate the cost of the raw material (Silden 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
