Abruzzi Olive Oil Company is a small producer of premium olive oil. Cheryl Sounders, the owner, is interested in developing a budget spreadsheet to explore the impact of various sales goals on production. In 2022 , the company had monthly sales as follows: At a planning meeting, the marketing manager, Jay Peters, told Cheryl he expected sales to increase 10 to 15% in 2023 . As a general rule, Cheryl likes to have beginning inventory equal to 15% of the next month's budgeted sales. Required: Using Microsoft Excel, create a monthly production budget for 2023 assuming two scenarios: Scenario 1: sales increase 10% from 2022 figures. Scenario 2: sales increase 15% from 2022 figures. Assume Abruzzi ended 2022 with 1,500 gallons of olive oil. In order to calculate ending inventory at the end of December 2023, assume January 2024 sales will be the same as December 2023 sales. Your spreadsheet should require you to only input the budgeted sales figures, in gallons----the spreadsheet will automatically calculate everything else. Remember! The formula/outline for a production budget is: Budgeted sales, in units + Desired Ending Inventory = Total Needs - Beginning Inventory = Required Production, in units