can you please help in making sale budget, direct material budget, total coat, income statement budget, cash budget

any provided the following information (EXCEL APPENDIX A). Q2 Oct-Dec 2023 Operating Projections Q2 03 Jan-Mar Apr-Jun 01 Jul-Sep Expected package sales 60,000 50,000 40,000 40,000 Unit selling price $10 $10 $10 $10 Staff costs Estimated to be 20% of sales Operating Expenses Estimated to be 30% of sales Depreciation expense $11.000 $11.000 $11.000 $11.000 Raw material cost per kilogram 56.60 56.60 $7.70 $7.70 Lotus purchases its coffee beans in cilogram quantities (1000 grams = 1 kilogram). Shipments from Vietnam can be unreliable, so Larry prefers to have as much raw material (uroasted beans) on hand as possible. He likes to maintain a balance of raw materials equal to approximately 60% of next quarter sales. All the roasted beans are sold in the same quarter they are made to maintain freshness. He expects sales for the first quarter in 2024 to be 65,000 packages. Larry plans to replace the roasting equipment in May 2023 with a brand-new machine that will produce even more aromatic coffee beans starting in the next fiscal year. The expected cost is approximately $100,000 and will be paid for in cash. The company needs to repay $12,000 per mouth on the long-term nou-kriterest-bearing loan from Larry's father. In addition, be pays himself dividends of 515,000 per month in lieu of salary Lotus Coffee has a $250,000 line of credit that can be drawn from for short-term financing Interest is paid quarterly, and it is calculated a 4.3% per year an the outstanding balance at the SIN a JT O ACCT-1071 Accounting fundamentals Group case study 2 end of the previous quarter. The line of credit balance is zero at the beginning of fiscal 2023. Any excess cash is immediately used to pay down the line of credit. Larry wants to see a complete sales budget, direct materials budget shown in kilograms and total cost, income statement budget, schedule of cash collections and cash budget for 2023 each by quarter and in total any provided the following information (EXCEL APPENDIX A). Q2 Oct-Dec 2023 Operating Projections Q2 03 Jan-Mar Apr-Jun 01 Jul-Sep Expected package sales 60,000 50,000 40,000 40,000 Unit selling price $10 $10 $10 $10 Staff costs Estimated to be 20% of sales Operating Expenses Estimated to be 30% of sales Depreciation expense $11.000 $11.000 $11.000 $11.000 Raw material cost per kilogram 56.60 56.60 $7.70 $7.70 Lotus purchases its coffee beans in cilogram quantities (1000 grams = 1 kilogram). Shipments from Vietnam can be unreliable, so Larry prefers to have as much raw material (uroasted beans) on hand as possible. He likes to maintain a balance of raw materials equal to approximately 60% of next quarter sales. All the roasted beans are sold in the same quarter they are made to maintain freshness. He expects sales for the first quarter in 2024 to be 65,000 packages. Larry plans to replace the roasting equipment in May 2023 with a brand-new machine that will produce even more aromatic coffee beans starting in the next fiscal year. The expected cost is approximately $100,000 and will be paid for in cash. The company needs to repay $12,000 per mouth on the long-term nou-kriterest-bearing loan from Larry's father. In addition, be pays himself dividends of 515,000 per month in lieu of salary Lotus Coffee has a $250,000 line of credit that can be drawn from for short-term financing Interest is paid quarterly, and it is calculated a 4.3% per year an the outstanding balance at the SIN a JT O ACCT-1071 Accounting fundamentals Group case study 2 end of the previous quarter. The line of credit balance is zero at the beginning of fiscal 2023. Any excess cash is immediately used to pay down the line of credit. Larry wants to see a complete sales budget, direct materials budget shown in kilograms and total cost, income statement budget, schedule of cash collections and cash budget for 2023 each by quarter and in total