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 Octobe 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in fotal, for the third quarter. 5. Calculate the cost of the raw material (Giden) purchases by month and in total, for the thifd quarter 6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third qua Complete this question by entering your answers in the tabs below. Calculate the estimated sales, by month and in total, for the third quarter Required: 1. Caicuiate 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 quartec. 3. Calculate the estimated quantify 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 materlal (Gilden) purchases, by month and in fotal, for the third quarter Complete this question by entering your answers in the tabs below. 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, Sept 4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the 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 to Complete this question by enterifig your answers in the tabs below. Calculate the expected cash collections, by month and in total, for the third quarter. Milo Company manufactures beach umbcellas. 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): The selling price of the beach umbrellas is $15 per unit. b. Alt sales are on account. Based on Dast experience, sa es are collected in the following pattern: 308 in the wonth of iale 6st in the wath collowing wie st unooliectible Sales for June totaled $375,000. 6. The cornpany maintains finished goods inventories equal to 15x or the following month's sales. This fequiemunt wil be met at the end of June. beginhing and end of the quartor will be 3 Jue 30 76,900ytas Soptember 0 7 rees 301 in the nonth of anle 651 in the nonth folloving cale st theolinetisio Sales for June totaled $375,000. c The company maintatns fnistied goods imventories equal to 15% of the following month's sales. This requirement wil 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 cequires that the ending inventory of Giden be equal to 50% of the following month's production needs.-The iriventory of Giden on hand at the beginning and end of the quarter whit be: e. Gilden costs 50.60 per foot One-haif of a month's purchases of Giden is paid for in the month of purchase, the remainder is pald for in the following month. The accounts payable on July I for purchases of Gilden during fune will be 539.390. Required: 1. Calculate the estimated sales; by month and in total, for the third quarter 2. Cufcutitit the expected cash collections, by month and in total, for the third quarter 4. Caiculate the quantily of Giffen fin feet) that needs to be purchased by month and in totac, for the thisd quarter 9 Calculate the cott of the raw material (Gifden) purchases by month and in total, for the third quartor. 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 materfal (Gliden) purchases by month and In totat, for the third quarter 6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarte Complete this question by entering your answers in the tabs below. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and october 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 materlat (Gliden) purchases by month and in totat, for the third quarter. 6. Calculate the expected cash disbursements for raw material (Giden) purchases, by month and in total, for the third quarte Complete this question by entering your answers in the tabs below. 4. Calculate the quantity of Giden (in feet) that needs to be purchosed 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