Please help me with this question. I have a project that I am working on in another class and cant devote the brain power to figure it out. Thanks.

Use the background information presented below to prepare and analyze elements of a 3-page cash budget, recommend budget adjustment measures, and discuss how management uses information for budgeting purposes. Background Spicer Corporation would like to prepare a cash budget in order to determine the company's financing needs for the upcoming year. The beginning cash balance is $161,250. The sales for the upcoming year: Spicer CorporationSales Budget for the Year Ending December 31, 20XX First Quarter Second Quarter Third Quarter Fourth Quarter Projected Units to Be Sold 1,525 1,675 1,775 1,550 Sales Price Per Unit $275 $275 $275 $275 Projected Revenue $419,375 $460,625 $488,125 $426,250 All sales are on account. It is reported that accounts receivable are collected 65 percent in the quarter of the sale and 35% in the quarter after sale. The beginning accounts receivable is $142,000. All purchases are made on account. The company pays 100 percent of the accounts payable each quarter. The purchases are related to the inventory needed to sell each month. On average the inventory costs $195 per unit to produce. It is estimated that enough inventory is purchased each quarter to cover the projected quarterly sales only. The beginning Accounts Payable is $0. Additional quarterly expenses include the following: Operating Expenses for the Year Ending December 31, 20XX First Quarter Second Quarter Third Quarter Fourth Quarter Sales and Wages $55,625 $55,450 $54,675 $56,285 Advertising $1,200 $1,500 $900 $2,000 Utilities $2,700 $2,700 $2,700 $2,700 Operating Expenses for the Year Ending December 31, 20XX First Quarter Second Quarter Third Quarter Fourth Quarter Rent $6,000 $6,000 $6,000 $6,000 Total $65,525 $65,650 $72,375 $66,985 On the balance sheet, Spicer Corporation reports a note payable of $165,000. The principal plus interest is due on April 30. Until then interest payments are made each month. The note has an annual interest rate of 6%. It is projected that in October of the current year, Spicer will need to purchase a new machine in order to replace an outdated machine. The new machine will cost $50,000. The purchase is expected to be made with cash. Spicer Corporation currently has a line of credit of $1 million that can be used to cover any deficiencies. The line of credit has a 4% annual interest rate. Interest payments must be made at the end of each quarter when there is a balance outstanding. Borrowings must be made in increments of $10,000. It is standard practice that line of credit will be paid when there is surplus of the minimum cash balance in increments of $5,000. Complete the Following Prepare your analysis in two parts. Part A Assume management wants to maintain a minimum cash balance of $50,000. Prepare a cash budget for Spicer Corporation for the upcoming year. (Note: It may be helpful to create a supplemental schedule for cash receipts.) Part B After completing and analyzing the cash budget, Spicer's management felt confident that the financing requirements and short-term goals could be met. Unfortunately, due to a declining economy, the budgeted sales were not met. The actual sales were 5% lower than budgeted for 2nd Quarter, 10% lower than budgeted for the 3rd Quarter and 20% lower than budgeted for the 4th Quarter. The declining economy also impacted many customers' ability to pay on their accounts in a timely manner. As a result, management reported that the actual cash collections for the third and fourth quarter were 45% in the quarter of the sale and 50% in the quarter after the sale, with the remaining 5% uncollected. The outdated machine, which the company planned to replace in October, had to be replaced in March due to a broken part. Management determined that it was better to move forward with the purchase of the new machine rather than fix the broken part. Based on these changes prepare a memo to top management that accomplishes the following: Explain the differences between the cash budget amount and the actual amounts. Outline budget adjustments that need to be made (if any) to maintain the minimum required cash balance? Explain. Recommend measures management should have taken to respond to these changes during the year to adjust their budget. Describe how management should use the above analysis to prepare the next year's cash budget