Can you kindly make sales budget, direct materials budget, budegted income statement, cash budget and balance budget

01 Oct-Dec 2023 Operating Projections 02 03 Jan-Mar Apr-Jun 04 Jul-Sep 60,000 SIO 40,000 SIO Expected package sales Unit selling price Staff costs Operating Expenses Depreciation expense Raw material cost per kilogram 30.000 40.000 SIO SIO Estimated to be 20% of sales Estimated to be 30% of sales $11,000 $11.000 $11,000 $11,000 S6.60) $6.60 57.70 $7.20 LIST ZA qual to apprecimately 60% of next Lotus purchases its coffee bean in kilogram quantities (1000 grams = 1 kilogram) Shipments from Vietnam can be unreliable, so Larry prefers to have as much raw material unroasted beans) on hand as possible. He likes to maintain a balance of raw materials equal to quarter sales. All the roasted beans are sold in the same quarter they are made to maintain freshwess. He expects sales for the first quarter in 2004 to be 65,000 packages. Lanty 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 month on the long-term non-interest-bearing loan from Larry's father. In addition, he pays himself dividends of S15,000 per month in licu 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 as 4,5% per year on the outstanding balance at the 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 bekget direct material badiget stwwn in kilograms and total cost, income statement budget, schedule of cash collections and cash budget for 2023 each by quarter and in total Larry is also curious about financial ratios. He would like you to explain the concept of each of the three main categories of ratios. He has provided a set of comparative financial statements and tabo calculations from the 2021 results (EXCEL APPENDIX B). From the 2022 financial statements, Larry would like you to calculate the 2022 ratios for each ratio listed from 2021. Larry wants to know how Lotus Coffee is doing compared to the previous year including any recommendations for improvement. He is particularly interested in a conclusion of how Lotus Coffee is doing under cach category of ratio As this is a huge undertaking with the few of your friends from a 01 Oct-Dec 2023 Operating Projections 02 03 Jan-Mar Apr-Jun 04 Jul-Sep 60,000 SIO 40,000 SIO Expected package sales Unit selling price Staff costs Operating Expenses Depreciation expense Raw material cost per kilogram 30.000 40.000 SIO SIO Estimated to be 20% of sales Estimated to be 30% of sales $11,000 $11.000 $11,000 $11,000 S6.60) $6.60 57.70 $7.20 LIST ZA qual to apprecimately 60% of next Lotus purchases its coffee bean in kilogram quantities (1000 grams = 1 kilogram) Shipments from Vietnam can be unreliable, so Larry prefers to have as much raw material unroasted beans) on hand as possible. He likes to maintain a balance of raw materials equal to quarter sales. All the roasted beans are sold in the same quarter they are made to maintain freshwess. He expects sales for the first quarter in 2004 to be 65,000 packages. Lanty 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 month on the long-term non-interest-bearing loan from Larry's father. In addition, he pays himself dividends of S15,000 per month in licu 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 as 4,5% per year on the outstanding balance at the 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 bekget direct material badiget stwwn in kilograms and total cost, income statement budget, schedule of cash collections and cash budget for 2023 each by quarter and in total Larry is also curious about financial ratios. He would like you to explain the concept of each of the three main categories of ratios. He has provided a set of comparative financial statements and tabo calculations from the 2021 results (EXCEL APPENDIX B). From the 2022 financial statements, Larry would like you to calculate the 2022 ratios for each ratio listed from 2021. Larry wants to know how Lotus Coffee is doing compared to the previous year including any recommendations for improvement. He is particularly interested in a conclusion of how Lotus Coffee is doing under cach category of ratio As this is a huge undertaking with the few of your friends from a