Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A completed Personnel Budget (Table 6-33) Follow the instructions on page 353 to calculate the new salary for each position. Ensure the raise that goes
- A completed Personnel Budget (Table 6-33)
- Follow the instructions on page 353 to calculate the new salary for each position. Ensure the raise that goes into effect in October is factored into the salaries. Since the fiscal year starts on July 1st, the raise itself would not be applied across the entire year, only from October - June.
- Fringe benefits and overtime should be included at the bottom of the table, as indicated in the book.
- A completed Operational Budget (Table 6-34)
- Most of this is already provided. You will need to total the expenses so they can be allocated appropriately across the months in your comprehensive budget next week.
- A completed Capital Equipment Budget (Table 6-35)
- The line item stating "Depreciation over five years" should actually only include ONE year of depreciation to show how much it will depreciate each year over the next five years.
- Use the straight line depreciation method and assume a depreciation time of five years.
- Follow the instructions on page 353 to calculate the new salary for each position. Ensure the raise that goes into effect in October is factored into the salaries. Since the fiscal year starts on July 1st, the raise itself would not be applied across the entire year, only from October - June.
- Fringe benefits and overtime should be included at the bottom of the table, as indicated in the book.
- Most of this is already provided. You will need to total the expenses so they can be allocated appropriately across the months in your comprehensive budget next week.
- The line item stating "Depreciation over five years" should actually only include ONE year of depreciation to show how much it will depreciate each year over the next five years.
- Use the straight line depreciation method and assume a depreciation time of five years.
My suggestion for formatting would be to create an Excel spreadsheet with separate tabs for each requirement.
***Be sure to show ALL formulas within Excel***
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started