please help!
Mila Company marufoctus es beach umbrelos. The company is preparing deteled budgets for the third quarter and has ossented the following information to assist in the buigget preparation. a The Marketing Department has estimated walos as follows for the remainder of the year (jin units) The seding price of the beach umbrellas is 511 per unit 6. All soles bre on fecount pared or part erperience, soles are collected in the following pottern aes in the month of cale 6ss, in the month folfouirs saln it incellectisle Soles foe June vonaled $297,000. end of Jine. d. Each vench umbreile requires 4 feet of Gilden, e moserial that is sometimes hard to acquire, Theceloce, the company reauires thiant the ending imversory of Gilden be oqual to 50% of the following month's production needs. The imvency of Gilden on hand at the beginning ond end of the quarter will be June 30 21,260 feet 7 feet e. Giden costs $080 per foot. One bulf of a momh's purchases of Glden is poid for int the month of purchase; the remainder is paid for in the following morth. The accounss payabie on July 1 for purchases of cliden during June will be 554,920. Hequired: 1. Colculate the estimoted sales, by mooth and in totot, for the thitd cuartea 2 Calculate the expected cash collections, by month and in totol, for the third quarter. 3. Calculate the extimased quancly of bach umbrellas that need to be produced in July, Aygust, Sepsember, and October 4. Calculate the qusntity of Cidden firs feet that needs to be purchased by monet and in fotal, for the third quarter. 5. Calculete the cost of the raw materidi (Gilden) purchases ky month and in total, for the third cuartec. 6. Colculate the expected cosh disburbements for raw nuteriat (Ciderv) purchasos, by month and in totat, for the third quarter. Complete this questien by entering your answers in the tabs below. Calculate the esomated cales, by manch and in total, for the third quarter