PLEASE INCLUDE ALL EXCELL FORMULAS!!!!!

5) Cash budget, by month and total

6)Prepare a budgeted budgeted income statement for the three months ending June 30, 2023. Use the contribution approach.

7) Prepare a budgeted balance sheet as of June 30, 2023.

You have just been assigned to a new manager who believes you have exceptional budgeting skills. Since you began your job last summer, you have been showing management your latest spreadsheets and how you use your new-found knowledge of Managerial Decision-Making to make sound business decisions. Your new manager is responsible for the nationwide distribution of the newly developed Self Protection Device (SPD), using an ultrasonic sound emission, DNA material capture via a retractable claw, and an amazing 250,000 lumen LED flashing light. Through multiple franchise agreements, sales have grown very rapidly and the timing is right for you to join her team and show your skills. You have just been given responsibility for all of the planning and budgeting of the entire division. Your first assignment is to prepare a master budget for the next three months, starting April 1, 2023. You accept this responsibility with enthusiasm. You are anxious to impress your new manager and the president of the parent company (Allteq Solutions) who has a very high regard for you. To commence your new role, you have assembled the following pertinent information: Note: The company desires a minimum ending cash balance each month of $12,000. The SPDs are sold to retailers for $30 each and they are flying off the shelves. Recent forecasted sales in units are provided below