Background: Acme has four facilities scattered throughout the Midwest producing tennis rackets and accessories. Each facility is approximately $20,000$ GSF with half of the square footage of each building being dedicated to a production environment and half to office space to support Acme$$s sales staff. Enthusiasm for tennis has lagged up until recently. Over the past two years, Acme has seen product sales increase $5\%$ a year and is considering leasing or constructing a fifth plant in the near future.

During the years that sales were flat or declining, the Facility Manager$$s $($Fred Maintainer$)$ budget took a hit due to market conditions. For example, Fred had $8$ Full Time Equivalent $($FTE$)$ staff and now he has only $6.$ He has had to economize in other areas as well. But now, things are looking brighter. Fred has developed a great working relationship with the CFO, and he has been asked to attend important business$-$wide discussions on the future direction of the company$$s $$10$ million operation. One of the decisions made was the construction of another production line to manufacture both racquetball and pickleball rackets$/$paddles$.$ Of the $$10$ million in total company sales, Fred$$s budget is $$2$ million so he plays an important role in shaping how and where Acme will spend its valuable resources. Let's assume in $2023$ sales increased $5\%$ and the next two years $(2024$ & $2025)$ are expected to see the same growth $(5\%$ per year$)$ to include a new facility coming online at the beginning of $2025.$Assignment

Based on our work so far, develop hypothetical operating budgets for $2024$ and $2025$ based on the above information and assumptions in an Excel spreadsheet. Please add notes giving your assumptions on revenue and cost changes from year to year. For instance, make sure you take into account additional resources$/$expenses $($staff$,$ utilities, etc.$)$ and an increase in sales revenue as a result of the new facility $($in $2025)$ in your budget. Use all available resources either in your textbook, lecture notes or in additional readings to put your plan together. I have started the budget for you by providing some $2023$ actual costs assuming a $$2\mathrm{.}0$M budget and $$1\mathrm{.}850$M in expenses.