Help 4 Mio Company manufactures beach us The company reangelegenhed following information to in the budget preparation 20 2. The Marketing Department has estas fotos formance of the year 30.000, 70.000 15.000 Tepe 10, The goce of the beach umbres is $12 per unit D. Alles we on account. ned on past experience, sales are collected in the owing to 34 is the In the til Sales for June stated 5.300.000 The company maintain forned goods moes out to of the towing on this moment will be mettre end of d. Each beach med fet a meal that is sometimes hard tour Therefore, the company get the ending way of de beton of the following more production. They Giden onhanh beginning and end of the tribe 18 Gidenco perfoot Onte cases of Gendine month purchased for in the wing mot the contents of dende 176.000 4 the ending Inventory of Gliden 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 . Ondya 20 pont June 10 September 30 72.000 feet e Gilden costs 50-80 per foot One-half of a monte'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 one will be $75,000 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 que 3. Calculate the estimated quantity of beach umbrellas that need to be produced in May, August September and October 4 Calculate the quantity of Gliden fin feel that needs to be purchased by month and in total for the third quarter 5 Calculate the cost of the raw material (Giiden purchases by month and in total, for the third quarter 6. Calculate the expected cash disbursements for raw material (Gider) purchases by month and in total, for the third quarter Complete this question by entering your answers in the tabs below. Red 2 Reg Hes Calculate the estimated sales, by month and in total, for the third quarter July August Budged 23 www 4 - Cheday . www the ending Inventory of Gilden be equal to 50% of the following month's production needs. The inventory of Giden on hand at the beginning and end of the quarter wil be: 20 points June 30 Beptember 30 72,000 feet 7 feet book e. Gilden 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 $76,000. Pro 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 quartet 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 quarte Complete this question by entering your answers in the tabs below. Het Heg2 Reg 3 Reg4 and 5 Rogo Calculate the expected cash collections, by month and in total, for the third quarter Apust Quarter Total cash collections Raga 4 Chad my work 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 20 points June 30 September 10 72,000 feet I fout e Gilden costs $0 B0 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 for purchases of Gilden during June will be $76.000 ht Required: Calculate the estimated sales, 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 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 (Gilder purchases by month and in total, for the third quarter 6. Calculate the expected cash disbursements for raw material Giden purchases, by month and in total, for the third quartet Complete this question by entering your answers in the tabs below. 4 and Calculate the estimated quantity of beach umbrellas the need to be produced in August, see and October July August Belumber One Reproduction CH Ryan Help Sere Check my work 4 30 42.000 tot 20 po Giden costs $0 B0 per foot One-half of a month's purchases of Gilden is paid for in the month of purchase the remainder is paid to in the following month. The accounts payable on July for purchases of Giden during one will be 576,000 Required 1. Calculate the estimated ses, by month and in total, for the third quartet 2. Calculate the expected cash collections, by month and in total for the third quartet 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 on feet that needs to be purchased by month and in tots for the third quarter 5. Calculate the cost of the raw material Gilden purchases by month and in total, for the third quartet 6. Calculate the expected cash disbursements for raw materiale purchases, by month and in total, for the third Quartet Complete this question by entering your answers in the tabs below. Calculate the quantity of that made to be purchased by month and inte, for the Calow the cost of the material (de) Pure by month and into for the ound your cost of raw matemala July Tweets