Accounting 2020
Excel Budget Problem
I was assigned to complete a Master budget for Wasatch Manufacturing to demonstrate my understanding of the importance of making a budget when planning for the future. It is important in obtaining goals and plans by putting strategies in place that make financial sense. Making a budget helps them do just those things by knowing how to do things like increase margins through improving productivity, or increasing customer satisfaction by planning, directing and controlling operations. Using the instructions I was given a data set to complete the comprehensive budget problem for this company using excel. I was to use formulas and link the budgets wherever possible so if I needed to make a change to one cell it would reflect the changes in all the other parts of the budget. By competing the budget problem in the excel document to the left, I have learned how management uses budgeting to express their plans and how to asses reaching their goals. I have a better understanding of how companies plan for the future by designing key strategies that reflect long-term expectations. Therefore, the master budget is an important tool in all types of businesses, organazations, governments and even individuals.
The Master Budget
|
ACCT 2020 Excel Budget Problem Student Template_JulieWoodward.xlsx Size : 17.332 Kb Type : xlsx |
Reflection
After completing this assignment of the Master budget problem I was glad to gain real life experience of how an management uses budgeting to plan for the future. Using excel and having to calculate each of the different areas of the sales budget using the numbers the company had projected gave me a greater understanding of why these budgets are so important and how putting just one number wrong would skew the rest of the numbers. By using a budget companies can plan for the future and control revenues and expenses related to their plans. For example, by a company budgeting s set amount of finances towards research and development it can lead to the production of more products and expansion therefore leading the company towards its goals. once these goals are set, strategies are made which lead to the improvement of production and expansion of the company. Through both reading the chapter and doing this assignment I have increased my understanding and knowledge of the uses and importance of the Master budget.