please and thank you! I rate.

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 Depattment 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. All sales are on account. Based on past experience, sales are collected in the following pattern: 308 in the aonth of sale 65x in the month following sale 5V uncollectible Sales for June totaled $645.000 E. The company maintains finished goods inventories equal to 15% of the following manth's sales. This requitement will be met at the end of June d. Each beach umbrella requires 4 feet of Gilden. a material that is sometimes hard to ocquire Thet efore, the company requites thot 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 Septenber 3099,600 feet 2 feet e. Gilden costs $080 per foot One half of a monthis purchases of Giden is poid for in the month at purchape, the remoinder is paid for in the following manth The accounte payable on July 1 for purchases of Giden darng Jane will be $74,120. Required: 1. Calculote the estimated soles, by month and in totol for the thisd quarter 2 Colculate the expected cash collections, by manth and in tefor, for the third quarter. 3 Colculote the estimated quantzy of beach umbrellas that need to be produced in duly Augum. Seprenber and Octobe: 4 Colculote the quantity of Gidien (n feem) that needs to be purchased by month and in total for the thigd quater 5 Calculate the cast of the taw material isiden) purchoses by month and in total for the third quarter 6 Colculate the expected cash disbursements for taw materisl (Gitden purchoses, by month and in laral for the third quarer. Complete this question by entering your answers in the tals below