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 :` & . The Marketing Department has Estimated sales as follow's for the remainder of the year fin units *\\ JULY* October* 23, 000 AUGUST HOVETIBET* 5 , 500 SELLEIDEL{ DECEMBER* 10 , 000 The selling price of the beach umbrellas is $75 per unit . `_ All sales are on account . Based on past Experience , Sales are collected in the following pattern ? JOE in the month of Bale* $5{ in the month following BALE* 5{ uncollectible* Sales for JUNE totaled $ 375,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 .` `. 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 TH, $10 Feet SEPTEMber 10 { FEET { . Gilden costs $0. 50 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 $35, 390. Required . . 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 .* 5. Calculate the Expected cash disbursements for raw material ( Gil den ; purchases , by month and in total , for the third quarter