please help

me with this

ACC 310F. Group Assignment ou must have between 3-6 grous members per team List alphabeticaly by last name: last name, first nam The Natural reSpring Corporation buys water reclamation and filtration systems then resells them for $1.000 per unit, but plans to lower that price by $50 in June. The company had the following sales forecast available: April 1,300 units, May 1,400 units, June 1,600 units and July 1.200 units. All sales are paid for in full when customers place their order The company purchases its product for S800 perunit and pays for 90% of purchases in the monito purchase is made and pays for the remaining 10% in the month following the purchase. As of March 31, the company owed suppliers $95,000 for purchases made in a previous month. The company wants to maintain ending inventory equal to 25% of the next month's unit sales and had 260 units in inventory on March 31st The company's advertising is fixed at $3,500 per month, has other administrative costs of $85,000 per month and salaries of $110,000 per month; all selling and administrative expenses are pald in full each month. The company plans to give its employees a 10% pay raise in May. The company's goal is to purchase $150,000 of equipment in June while borrowing no more than $65,000 from a bank in May to help do so. The company's cash balance on April 1s is $55,000. Required the information above, prepare a sales budget, purchases budget, budgeted income statement, cash budget and a budgeted balance sheet (for cash, inventory, equipment, accounts payable and notes payable) for April, May and June. iven your results, briefly explain whether you think the company will achieve its goal and describe three pecific actions the company could take to improve its planned results