This website uses cookies to ensure you have the best experience. Learn more

Budget Essay

1765 words - 8 pages

Personal Budget Exercise – MS Excel
For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then on the title Personal Budget (Excel) click on Show Rubrics if the rubric is not already displayed.
Creating a spreadsheet to track personal expenses is an excellent use of Microsoft Excel. For this exercise, you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $3,500
Here are suggested budget categories if you are not using a real budget. At a minimum, you must have 9 budget categories:
Housing (mortgage or ...view middle of the document...

A minimum of 9 categories is required. | 0.25 | Text format is Arial 10 point, Normal. Align text Left in the cell. |
6 | Format all cells containing numeric data to Currency, using two decimal places. If you have this set up correctly MS Excel will automatically insert a "$" in front of the amounts that you enter. | 0.25 | I will be able to tell if you simply typed in the "$." This will result in zero (0) points for this item. If any other format is used besides Currency, the score will be zero (0) for this component. |
7 | In the column under your PROJECTED COSTS label, enter a monthly budget goal amount for each BUDGET ITEM category. This would be the limit of what you want to spend on each category in one month's time. | 0.25 | Arial 10 pointBoldAlign text Right in column |
8 | Enter the label "PROJECTED BUDGET TOTAL:" in the next row in the BUDGET ITEM column.Use the SUM function to calculate the total amount of the PROJECTED COSTS column in the cell to the right of this label (under the PROJECTED COSTS values). (This amount should equal your income amount of $3,500.)
Note: do not enter each cell in the column individually when using the SUM function | 0.35 | Use the following formats:Arial 10 pointBoldBlueAlign text Right in the cell |
9 | Under the heading for each Month, enter an actual expense amount for that item for that month. (For example, in the winter months, your utility bills might be higher). While some items might be the same from month to month, DO NOT enter the same amount for all items across the months. In each month you want to be close to you monthly income number but do not always have to match it exactly. | 0.5 | Use the following text format:Arial 10 pointNormalAlign text Right in the cell |
10 | In the next row in the BUDGET ITEM column (under the PROJECTED BUDGET TOTAL label) enter the label "Total Monthly Expenses." | 0.1 | Use the following text format:
Arial 10 point
Bold
Green
Align text Right in the cell |
11 | For the cells in this Total Monthly Expenses row, insert a formula that will calculate the total actual expenses for each month. Use the SUM function to add the amounts in each column and show the result.
Note: do not enter each cell in the column individually when using the SUM function | 0.5 | |
12 | In the next row under the “Total Monthly Expenses” label put the label “Projected versus Actuals.”` | 0.1 | Use the following text format:
Arial 10 point
Bold
Align text Right in the cell |
13 | Then in the cell under the Total Monthly Expenses for each month, use a formula that will subtract the actual total expenses for the month from the projected budget total (the target amount in the PROJECTED BUDGET TOTAL column). You must use Absolute Reference in your formulaIf the result of your calculation is a positive number, then you are under budget for the month. (You have money left over). If the number is negative, then you are over budget for the month. (You didn’t have...

Other Papers Like Budget

Ma- Sales Budget Essay

1306 words - 6 pages Sales Budget Victoria MA’s Secret focus on two kinds of customers which are youthful girls- active, colorful, fresh and mature women- charming, successful, fashionable with 12 stores around Vietnam and online shopping model selling lingeries, bikinis and other underwears. V-MA-S is growing and is making significant long-term investments in order to ensure sustainable development. Our objective is always to exceed our customers’ expectations

Biden Reports Progress On Budget Deal

478 words - 2 pages This article is about the budget deal that’s currently being debated about that would cut federal spending by as much as 33 billion dollars and dodge a government shutdown. As of right now, there is a difference in what should be included in it and not included in the budget. If the deal were to be approved, the deal would be the largest single year budget cut in U.S. history. The government would be funded through the current fiscal year, which

Assignment 4 Fiscal Budget Project Analysis

291 words - 2 pages November 18, 2012 PAD 500 Inez Blair Assignment 3 The payback period for Option A is 7.9 years, well over the critical acceptance level of 2.75 years. The payback period for Option B is 5 years, which is a somewhat closer to the critical acceptance level. The net present value for Option A is $2,115,031.84 and the net value for Option B is $2,987,257.56. The internal rate of return for Project A is 24% while the internal rate of return

Analyse The Reasons Why Costs Need To Be Controlled To Budget

1318 words - 6 pages Unit 5 Introduction to Accounting D1 L & S Ltd When experiencing cash flow problems there are a few recommendations to make, these problems include: • Being overdrawn on consecutive months. • Having too much money • Difficulty in predicting costs When being overdrawn on consecutive months you should look to cut back on immediate expenses such as insurance, suppliers, rent and employees. You could also increase product

Exam Accounting

274 words - 2 pages 1._____ models are mathematical models of the master budget that can react to any set of assumption about sales, costs, and product mix. A. Budgeting analysis B. Accounting C. Futuring D. Financial planning 2.A sales forecast is _____. A. a prediction of sales under a given set of conditions B. the same as a sales budget that will generate a desired level of sales C. all of these answers are correct D. the result of decisions

Week 8 Uop Axia

300 words - 2 pages A flexible budget is defined as a projection of budget data from various levels of activity. The budget recognizes the difference in cost behavior namely fixed and variable costs in relations to fluctuations in output or turnover. This budget is designed to change appropriately with such fluctuation. The steps to develop a flexible budget, management should first identify the activity index and the relevant range of activity. Secondly, they

Week 3 Assignment

700 words - 3 pages ------------------------------------------------- 10.22 Community College Copy Center A. Static budget: Variable Costs | $7 per student 800 students | $ 5,600 | Fixed Costs | | 40,000 | Total Costs | | $45,600 | B. Static budget variance: | Static Budget | Actual | Variance | | Variable Costs | $ 5,600 | $ 3,650 | $1,950 | Favorable | Fixed Costs | 40,000 | 42,000 | 2,000 | Unfavorable | Total Costs

Budgeting

290 words - 2 pages A budget is a document that projects the financial goals and results of a company for a particular time frame. It can include everything from a basic income statement to results and financial position of a company for one or more future periods. This paper will review the various types of budgets including master, sales, cash, and production as well as there potential impact on decision making. Type of Budget/Use | Included Information

Citibank

413 words - 2 pages According to the conditions described in the case, I still can not give a certain suggestion to deal with Mistri’s dilemma, because there are no details about the budget accomplishment in 1983. Since a bottom-up budgeting process at Citibank brought more participation of lower level managers, manager’s incentive compensation was closely combined with budget-related performance, and inexperience staff was a big issue due to high turnover

Eco372 Week 4 Reflection

918 words - 4 pages learned in regard to deficits, surpluses, debt, and the health of the economy. Budget Deficits Budget deficits occur when government expenditures exceed the amount of revenue coming into the economy through income and taxes. A deficit is a summary of how the economy measures the state of using and accounting procedures. Since World War II, the United States government has run a large amount of deficits, as opposed to surpluses. A deficit can be good

Boston Creamery Inc. Recommendation

253 words - 2 pages RECOMMENDATIONS For 1974 budget planning, managers should get together and do a better job in preparing the budget. It would be a good idea to classify costs as controllable or uncontrollable and also to adjust the budget for these uncontrollable events when they happen or at least before the variance is calculated. Also in this case it is unclear whether the departments are cost centers or profit centers. If the marketing department is a

Related Essays

Budget Essay

9430 words - 38 pages 1. Introduction and Background of Budget The Capital Budget of the public sector or sometimes also known as Public Budget concerns how the government plans its revenues and expenditures at the Federal level, State level, and Local government level, to carter for the needs of its development programs and projects. In a democratic society, the division of resources between the public and private sectors is roughly determined by the desires of the

Operational Budget Essay

1439 words - 6 pages Phase 4 DB HCM410-1303B-02 September 14, 2013 Operational Budget with addition of 4 new areas Introduction The Krona Community Hospital, established in 1977, is a 60-bed, acute care hospital located in Banconota County. They currently offer a full range of health care services and maintain a staff of almost 100 physicians and specialists, 400 employees, as well as numerous volunteers. They are currently fully accredited by The Joint

Budget Management Analysis

1281 words - 6 pages Budget Management Analysis Budget management is an important concern for organizations, especially today with the economic strain on businesses. The strategies to manage budgets and possible variances will be addressed within the context of this paper. A comparison of five expense results with the budgetary expectations and reasons for possible variances will be presented. Benchmarking techniques that may improve budget accuracy in future

Budget Case Study

1043 words - 5 pages Fiscal Concerns Case Study: Unit Budget Analysis Mindy Cashman Thomas Edison State College Abstract A budget is the most basic financial document needed to manage and plan for income and expenses throughout the year. The process of planning the budget is an ongoing process that requires adjustments throughout the year as needed to meet the goals of the organization it supports. When preparing a budget for an acute care unit in a hospital