Prepare for "cash budget for the month of the $4$ months of $2023.$

I know their is the answer by the expert but that one is $2022.$ I want $2023$

$1.$ To prepare you for this assignment, read the module $5$ content, review all additional resources provided and complete the learning activity $5\mathrm{.}1.$

Assignment Tasks:

For this assignment, you will read the following scenario and familiarize yourself with Bluepanda Inc.$$s finances. Once you have a good understanding of the financial undertakings, use the information provided in the scenario to complete the cash budgeting tasks below:

Bluepanda Inc. sells electronic parts for equipment used mainly in the construction industry. The company has faced some issues in managing its working capital and has recently lost some key suppliers due to mismanagement of cash and delay in vendor payments. Bluepanda has hired you as a financial consultant to look into this matter and provide a comprehensive perspective. Management would like to maintain a cash balance of more than $$15,000$ each month as financial prudence.

After considering all the information provided, you decided that having a cash budget would be the first step to understand the shortfall$/$surplus of cash and will aid in working capital management.

You arranged a meeting with the marketing team and gathered the following information:

Sales Forecast

Month$-$ year Sales

November $2022$ $$50,000$

December $2022$ $$60,000$

January $2023$ $$60,000$

February $2023$ $$70,000$

March $2023$ $$75,000$

April $2023$ $$80,000$

The accounts management team provided the following information:

$80\%$ of revenue is on a cash basis.

$20\%$ is collected after $30$ days.

$$ Cost of sales, which is $50\%$ of revenue, is incurred in the month in which the sales are made.

$$ These goods are paid for $30(1$ month$)$ days after the purchases are made.

Monthly selling and administrative expenses are as follows:

Wages $$12,000$

Financing Cost $$2,500$

Rental Cost $$800$

Depreciation $$3,000$

Communication and Promotion expense $$1,000$

Provision for future losses $$2,000$

Other budgeted expenses are as follows:

$$ Taxes: $$10,000$ in February, $$10,000$ in April, and $$10,000$ in September

$$ Purchase of assets: $$3,000$ in January, $$12,000$ in February, $$20,000$ in March, and $$3,000$ in April

$$ Cash balance on January $1,2023,$ is $$3,000$

Use the above information to complete the following tasks:

$-$ Prepare a cash budget for the months of January $2023,$ February $2023,$ March $2023$ and April $2023.$

$-$ Based on the cash budget, provide recommendation to the management of Bluepanda on cash management and any suggestions to improve cash management.

$-$ Provide comments on their ability to maintain the desired cash balance of $$15,000$ each month.

Note: Please submit an excel file and try to use excel formula$/$linking wherever feasible.

Assignment Submission:

$$ Your assignment is to be submitted in EXCEL format. It should be submitted with the following guidelines:

o Include a cover page with the course code and course name, the assignment number, the title of your assignment, your student ID$,$ your name, the instructor$$s name, and the date the assignment is created.

o Ensure the first page of your assignment has the title at the top of the page and the sections of your report have headings and subheadings to chunk your assignment into sections for each of the topics you are writing about.

o Font should be Arial $12$ or Calibri $12.$ Text must be double spaced but table may be single spaced.

o You must cite all your sources of information using APA formatting.