please help

ancolictibli Recuired Required For all quarterly budgets, report monthly amounts as well as the total for the quarter. a. Prepare the sales forecast and corresponding cash receipts budget for Eugene Corp. for its second quarter. b. Prepare Eugene Corpi's production budget and DM purchases budget for the second quartor. c. Prepare Eugene Corpis cash disbursements budget for the DM purchases for the second quarter. File Home insert Dagelayout Formalas Dath Revien View Automate Help A18 f \begin{tabular}{|l|} \hline 2 \\ \hline 3 \\ 4 \\ 5 \\ 6 \\ 7 \\ \hline 8 \\ \hline 9 \\ 10 \\ 11 \\ 12 \\ 11 \\ 14 \\ 15 \\ 16 \\ \hline \end{tabular} 17 Cash Collections April May : June Quarter 19 20 \begin{tabular}{|l|} \hline 2 \\ \hline 3 \\ \hline 4 \\ \hline 5 \\ 6 \\ \hline 7 \\ \hline 8 \\ \hline 9 \\ 10 \\ 11 \\ 12 \\ 13 \\ 14 \\ 15 \\ 16 \\ 17 \\ \hline \end{tabular} DM Budget April May June Quarter B. Assumplichs A) EudgetedSelling Priceperunits Ei Soles Volume Assumpion Units Marah24,500Aoril21,000May23,000June25,300Wij24,000Aupust23700 C) Cashsalestate D) Credit Sales Collectionrate % E1 FGhuentog Goul as peioenepe of next monchsales 108 F) Faw Mareidgoal as percent of cient monthneeds (5) Pow materias perurut Ho Faw Maneials cos perpound 10.20 11) Acocuns: Poyable Polor Cumen NeiaMonth Poprnentrive 35%65% (3) Purchas budgelioe March 16.000 P6.4 (LO. 2. 2, 1). AF Excel The accounting team at Eugene Corp. plans to get a fump-start on its budget for the second quarter since the first quarter is going well. Team members want to malse nure to denermine the cash effects of the company's sales as well as its biggent prodlaction-related cash expenditure, direct materials. The team has gathered the following information. 1. The bodqued selling grice for the year in 52.90 per unit. Sales volumes are budgeted as follows for the last month of euarter 1, for alli of quarter 2 and for part of quarter 3. ancolectibla 3. Mansgement weis its ending FG Inventory moal at 10 of of the following month's tales volume. The accounting team expects this policy will be met at the beeinhing of the sacond quarten 4. The target ending inventory for Eugene's primary direct material is 2016 of the following menth's production needs, since its not ununual for suppliers to stock out of this key resoarce. Each completed unit requires 4 pounds of DM at an experted cost of sozo per pound. 5. Eugene pas for 35% of its purchases in the menth of purchase and 659 the month afer purchase. Total budgeted purchases in March are 510.000 Required Por all quarterly budsets, repont monthly anounts av well as the total for the quartef: a. Prepare the sales forecast and correaponding cath receipts budint for Bagene Corp. for lts second puarter. b. Prepare fugene Corpio prodaction budget and DM purshases budget for the second quarwen. c. Prepare Eugene Corp's eash diabursaments budgen for the DM parchases for the sevend quarte: 4. List the bifer main categaries of cash distursemens tha Fugase Cerp. weild siil need to estimate before completing its cash hudget for the becond quarter per ueit is avallable to cover DL and NOH couts? f. If company managers budgeted for 4 pounds of DM per usit but actualy lenose thay can wet the fob dose wath 3.6 pounds of DM, could this hurt the company? Could it help the compary? Explain. ancolictibli Recuired Required For all quarterly budgets, report monthly amounts as well as the total for the quarter. a. Prepare the sales forecast and corresponding cash receipts budget for Eugene Corp. for its second quarter. b. Prepare Eugene Corpi's production budget and DM purchases budget for the second quartor. c. Prepare Eugene Corpis cash disbursements budget for the DM purchases for the second quarter. File Home insert Dagelayout Formalas Dath Revien View Automate Help A18 f \begin{tabular}{|l|} \hline 2 \\ \hline 3 \\ 4 \\ 5 \\ 6 \\ 7 \\ \hline 8 \\ \hline 9 \\ 10 \\ 11 \\ 12 \\ 11 \\ 14 \\ 15 \\ 16 \\ \hline \end{tabular} 17 Cash Collections April May : June Quarter 19 20 \begin{tabular}{|l|} \hline 2 \\ \hline 3 \\ \hline 4 \\ \hline 5 \\ 6 \\ \hline 7 \\ \hline 8 \\ \hline 9 \\ 10 \\ 11 \\ 12 \\ 13 \\ 14 \\ 15 \\ 16 \\ 17 \\ \hline \end{tabular} DM Budget April May June Quarter B. Assumplichs A) EudgetedSelling Priceperunits Ei Soles Volume Assumpion Units Marah24,500Aoril21,000May23,000June25,300Wij24,000Aupust23700 C) Cashsalestate D) Credit Sales Collectionrate % E1 FGhuentog Goul as peioenepe of next monchsales 108 F) Faw Mareidgoal as percent of cient monthneeds (5) Pow materias perurut Ho Faw Maneials cos perpound 10.20 11) Acocuns: Poyable Polor Cumen NeiaMonth Poprnentrive 35%65% (3) Purchas budgelioe March 16.000 P6.4 (LO. 2. 2, 1). AF Excel The accounting team at Eugene Corp. plans to get a fump-start on its budget for the second quarter since the first quarter is going well. Team members want to malse nure to denermine the cash effects of the company's sales as well as its biggent prodlaction-related cash expenditure, direct materials. The team has gathered the following information. 1. The bodqued selling grice for the year in 52.90 per unit. Sales volumes are budgeted as follows for the last month of euarter 1, for alli of quarter 2 and for part of quarter 3. ancolectibla 3. Mansgement weis its ending FG Inventory moal at 10 of of the following month's tales volume. The accounting team expects this policy will be met at the beeinhing of the sacond quarten 4. The target ending inventory for Eugene's primary direct material is 2016 of the following menth's production needs, since its not ununual for suppliers to stock out of this key resoarce. Each completed unit requires 4 pounds of DM at an experted cost of sozo per pound. 5. Eugene pas for 35% of its purchases in the menth of purchase and 659 the month afer purchase. Total budgeted purchases in March are 510.000 Required Por all quarterly budsets, repont monthly anounts av well as the total for the quartef: a. Prepare the sales forecast and correaponding cath receipts budint for Bagene Corp. for lts second puarter. b. Prepare fugene Corpio prodaction budget and DM purshases budget for the second quarwen. c. Prepare Eugene Corp's eash diabursaments budgen for the DM parchases for the sevend quarte: 4. List the bifer main categaries of cash distursemens tha Fugase Cerp. weild siil need to estimate before completing its cash hudget for the becond quarter per ueit is avallable to cover DL and NOH couts? f. If company managers budgeted for 4 pounds of DM per usit but actualy lenose thay can wet the fob dose wath 3.6 pounds of DM, could this hurt the company? Could it help the compary? Explain