please please help me!
Complete this question by entering your answers in the tabs below. Milo Company manufactures beach umbrelias. The company is preparing detailed budgets for the third quarter and has assembled the following informetion to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units) The seiling price of the beach umbrellas is $10 per unit. b. All soles ore on account Bosed on past experience, soles are collected in the following pattern Soles for June toteled $200,000 c. 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. d. Each beach umbrella requires 4 feet of Giden, a materiol that is sometimes herd to acquire. Therefore, the company requires that the ending imventory 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 will be: e. Giden costs 50.60 per foot One-half of o month's purcheses of Gilden is paid for in the month of purchase, the remainder is peid for in the following month. The accounts payable on July 1 for purchases of Giden duning June will be $34,890 Required: 1. Calculate the estimated sales, by month and in total, for the third quarter. 2. Colculate the expected cash collections, by month and in total, for the third quarter 3 Calculate the estimated quantify of beach umbrellas that need to be produced in July. August. September, and October 4 Colculate the quantity of Giden (in feet) that needs to be purchased by month and in total, for the third querter. 5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter. 6 Calculate the expected cash disbursements for raw moterial (Gilden) purchoses, by month ond in total, for the third querter, Complete this question by entering your answers in the tabs below. Cakculate the estimated sales, by month and in total, for the third quarter. \begin{tabular}{|c|c|c|c|c|} \hline Reg1 & Reg2 & Reg3 & Req 4 and 5 & Reg \( \left[\begin{tabular}{l} 5 ight. \) \\ \end{tabular} \\ \hline \end{tabular} Calculate the expected cash disbursements for raw material (Gilden) porchases, by month and in total, for the third guarter. \begin{tabular}{|c|c|c|c|c|} \hline & Joly & August & september & Ouarter \\ \hline Toesi cash entoursoments & & & & \\ \hline \end{tabular} Reg 4 and 5 Complete this question by entering your answers in the tabs below. Calculite the quantity of Giden (in feet) that needs to be purchased by month and in total, for the third quarter. Calculate the cont of the raw material (Gilden) purchases by month and in total, for the third quarter. (Round your Unit cost of raw matetials to 2 decimal places.) Complete this question by entering your answers in the tabs below. Calculate the espected cash collections, by month and in total, for the third quarter
