please explain step by step with fomulas, thoroughly

Mio Company manulactures beoch umbreiles. The company is preporing betaled budgets for the thicd quarter and has assenibled the following infommation to astist in the budget preparason. a. The Marketing Departmert tas estmated sales as follows for the remainder of the year in units' The seting price of the beach umtrelias as 511 per unit. b. All sales are on account Baised an past experience, sales are collected in the following oottern Wis in the month of iale ens in the month, fallowies wale it uncollectisle Sales for June totaled 5297000 c. The compary muirtains firiatied goods mventories equal to 15 s of the following moeth's sales. Thes requiremert wei pe met at the end of June d. Each beoch umbrela roquins 4 feet of Giden, a material that is sometimes hard to acquire. Therefore, the compary tequares that the endirg invertory of Cldee be equal to SOA of the following monthis production needs. The inventory of Giden on hand at the beginning and end of the quater will be Juse se -septenier me e. Gidden costs 5080 per foot. One half of a maintis purchases of Geden is pad for in the month of purchase, the remininder is bait for in the following monet. The accoures payabbe on Jly 1 for porchases of Gidien during lune wil be $54,920 Required: 1. Cdculbte the estimated sales, by morith and in total, for the third quarted, 2. Cabcilate the expected cash collections, by montei and in totad, for the thind quartec. 3. Calculate the eitimated puantiy af beach umbreitus that need to be produced in July, August, September, and octobet. Sales for June totaled sw97000. c. The company makrtaus finished gooos inventones equal to 15 of the following monthis sales. This requrement will be met at the end of Jane. d Each beach umbrelu requires a feen of Calden. mateoal that is someanes hard to acquire. Therefore, the comgany requires that the ending inventary of filfon be egkal to 50ot of the folowhy monthis production needs. The miventory of Cldenn on hand at the beginning and end of the quated wit be e. Giden costs 5080 per foot One-hail of a monthis puichases of Culden a paid for in the month of purchase, the remsindec 5 poid for an the fottowing month. The accourta payable on fuly 1 for purchases of Gilden during June wil be 554920 fequired: 1 Cofculate the estinsted sakes, by morth and in tutel for the thed quartec 2. Caleilate the copected canh collections, ty month and in total for the thind quartet. 3. Calciate the estimated quantily of beach umbreftas that need to be produced in July. August Septembet, and october. 4. Caicilate the quartity of Cloen on feet that needs to be purchased by morth and in fotal, for the thicd quarter. 5. Calculate the coit of the iaw matronal iCloten purchases by month and in fotal, for the thitd quarter. 6. Calcilase the erpected cash duburiements for raw materlal (Gildeni purchaset, by month and in total, for the third quartee? Conspleite this question try entering vour anowers in the talis below. for in the following month. The accounts payable on July 1 for purchases of Gilden during June wil be 554,920. Required: 1 Calculate the estimated sales, by month and in total, for the third quater. 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 Giden fin 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. Colcuitate the expected cosh disbursements for raw matersal (Gilden) purchases, by month and in fotal, for the third quarter Complete this question by entering your answers in the tabs below. Calcialate the expocted cash collections, by month and in total. for the third quarter. the ending inventory ot Gilden be equare to Sor. material inat sometimes hard to acqure Therefore, the compaty requires that beginning and end of the quarter will be: e. Giden 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. Colculate 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. Cakculate the estimated quantity of beach umbrellas that need to be produced in July. August, September, and Octobet. 4. Calculate the quartity 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 totai. for the third quarter. 6. Calculate the expected cash disbursements for raw matenial (Gilden) purchases, by month and in total, for the third quaitee 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. e. Gilden costs $0.80 per foot One-half of a month's purchases of Giden is paid for in the month of purchase; the remoinder 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. Caiculate 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 (Giden) 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. 4. Calculate the quantity of cilden (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. e. Geden costs $0.80 per foot: One half of a month's purchases of Giden 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 soles, by month and in total, for the third quartet. 2. Calculate the expected cash collections, by month and in total, for the third quarter. 3. Calculate the estimated quantily of beach umbrellas that need to be produced in July. August September, and October. 4. Calculate the quamify of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter 5. Cakculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter. 6 Calculate the expecied cash disbursements for raw material (Gilden) gurchases, by month and in total, for the third quater Complete this question by entering your answers in the tabk below