Creating Your Personal BudgetFor this assignment, you will apply what you have learned in this unit to a small business. To get the business’s finances under control, you need to prepare a budget. You may consider items from your personal finances and cash flow to help you identify possible expense items for the small business budget. Research the CSU Online Library or the Internet for steps to creating a personal budget. Monthly expenses might include rent, utility costs, personal loans, car loans, credit cards, groceries, childcare, vehicle maintenance costs and insurance, phone charges, and cable or streaming costs. Cash flow considerations might include monthly salaries, commissions, and allowances. You can use any budget format that you are comfortable with, or you may select a free template. Your budget should be completed using Excel. Once you have completed your budget, in a separate Word document, address the information below. How can the use of the budget be used in the planning process? How can this financial information influence short-term and long-term decisions? Based on your personal budget, what are your static expenses? What are your flexible expenses? As an accountant, reflect on how you can use what you have learned in this activity in the workplace. Your submission should include one Excel document, which contains your budget, and a one-page Word document, which contains your responses to the prompts above. You should include at least two resources to support your responses. Adhere to APA Style when creating citations and references for this assignment.

Betty Malloy, owner of the Eagle Tavern in Pittsburgh, is preparing for Super Bowl Sunday, and she must determine how much beer to stock. Betty stocks three brands of beer- Yodel, Shotz, and Rainwater. The cost per gallon (to the tavern owner) of each brand is as follows: Brand Cost/Gallon Yodel $1.50 Shotz 0.90 Rainwater 0.50 The tavern has a budget of $2,000 for beer for Super Bowl Sunday. Betty sells Yodel at a rate of $3.00 per gallon, Shotz at $2.50 per gallon, and Rainwater at $1.75 per gallon. Based on past football games, Betty has determined the maximum customer demand to be 400 gallons of Yodel, 500 gallons of shotz, and 300 gallons of Rainwater. The tavern has the capacity to stock 1,000 gallons of beer; Betty wants to stock up completely. Betty wants to determine the number of gallons of each brand of beer to order so as to maximize profit. a. Formulate a linear programming model for this problem. b. Solve the model by using the computer. 2. As result of a recently passed bill, a congressman’s district has been allocated $3 million for programs and projects. It is up to the congressman to decide how to distribute the money. The congressman has decide to allocate the money to four ongoing programs because of their importance to his district- a job training program, a parks project, a sanitation project, and a mobile library. However, the congressman wants to distribute the money in a manner that will please the most voters, or, in other words, gain him the most votes in the upcoming election. His staff’s estimates of the number of votes gained per dollar spent for the various programs are as follows