Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Create DPIs master budget for the coming year using the information provided in the data input page of the file provided by your instructor. Your
Create DPI’s master budget for the coming year using the information provided in the data input page of the file provided by your instructor. Your budget should be broken down so that the different forms appear on the tabs of the template provided. When you open the template, you should start by examining the data input tab. This tab of the DPI template has been locked so you can’t move or change most of the numbers. These are the amounts and policies that you would have accumulated by speaking with various department heads, the controller, etc. There are two sections in the data input page that are shaded. The first one is projected sales for the quarter. These three cells will be used in the second part of the project. The second area is the mortgage amortization area.You will need to complete the mortgage amortization table before completing the first part of the assignment. Now look through the rest of the budget. On the various budget tabs, some of the rows and columns are highlighted pale gold. These rows and columns are provided for calculations, proofs, and to bring in information from prior budget tabs for ease of creating formulas.However, most of those who use a budget won’t want to see these calculations and redundant numbers.Therefore, unless told otherwise by your instructor, these columns and rows should be hidden once your master budget is complete. You will also notice, as you go through the template, that there are many cells that are shaded pale green. Each of these cells should have data when you complete your budget. Cells that are not highlighted should not have data. You must start your project with the template in D2L called “DPI Template.” When you save this file to your computer, please title it “DPI {yourname} Part 1.” The instructions on how to create a multi-tab flow-through budget are in the sixStrategic Finance articles you can access through D2L.There is also a complete budget called “Bob’s Bicycles” that goes with those articles that you can download and study. Have the spreadsheet show most dollar amounts as whole dollars (in some cases, such as the price of an ingredient at $0.15 it won’t make sense to do so – use judgment). Similarly, use judgment on how many decimals to display and what format to use ($ or % for example) in each cell. Remember, that the calculations will still be accurate as Excel uses the decimal part of the number even if it isn’t showing. Also, a good use of bold, italics, and borders makes the spreadsheet more visually appealing and, if used correctly, easier to understand and use. DO NOT type in numbers in your budget tabs – link everything to the data input sheet. Flow through is a significant portion of your grade and if you have hard-coded numbers it will affect your flow through. DO NOT copy or share anyone else’s work.You can collaborate in terms of figuring out how something should work and compare numbers and your work with classmates – but each person should do their own work on their own workbook.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started