All Night Beanery Company needs a cash budget. Your manager asks you to prepare it based on the information below. - Sales for January, February, and March are expected to be $100,000,$90,000, and $110,000, respectively. - Cash from sales are expected to be collected 60 percent in the month of the sale and 40 percent in the following month. - Raw materials are ordered and paid for one month before being used. All other cash purchases and expenses are paid for as incurred. Activities for the first quarter are expected to be: Required: a) Using the information above, prepare a cash budget for February (just for the one month) in an organized, clear, logical format. Show all calculations. b) Company policy is to maintain a cash reserve of at least 25% of monthly cash disbursements, to protect against cash shortages. Calculate the cash reserve needed based on the February cash budget. Show the calculation. c) At the end of February, it was determined that actual cash receipts were 10% lower than expected, raw materials costs were 15% higher due to supply chain problems, and salaries were 10% higher than budgeted due to a workforce shortage requiring pay increases to retain staff. All other costs were exactly as budgeted. Provide a brief analysis to your supervisor of realistic actions you believe the company should undertake based on this information. Write in complete sentences and be as specific as you can. You may include in your analysis additional information you would want in order to complete the analysis but again, the additional information you request should be as specific as you can describe it. Vague analysis and general additional information you'd request is not as useful to the analysis (or exam grades) as specific information and questions