Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Complete Case 9-46 in the textbook Cases9-46 should be prepared in a Word document with embedded Excel spreadsheets for relevant calculations and supporting schedules. You

Complete Case 9-46 in the textbook

Cases9-46 should be prepared in a Word document with embedded Excel spreadsheets for relevant calculations and supporting schedules. You still need to post your Excel worksheet to show support for your calculations. Note, you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail. Suggestion: To complete all parts of the problems correctly you should start each assignment with preparing an Excel workbook. The response should be between 250-500 words.

PLEASE show me how to do this in excel - all other answers i have found do not have any sort of calculations, and those are required for this assignment to have full credit.

image text in transcribed

CMA, adapted Case 9-46 Participative Budgeting (LO 9-2, 9-3, 9-9) Patricia Eklund, controller in the division of social services for the state, recognizes the importance of the budgetary process for planning, control, and motivational purposes. She believes that a properly implemented participative budgetary process for planning purposes and an evaluation procedure will motivate the managers to improve productivity within their particular departments. Based upon this philosophy, Eklund has implemented the following budgetary procedures. An appropriation target figure is given to each department manager. This amount is the maximum funding that each department can expect to receive in the next year. Department managers develop their individual budgets within the following spending constraints as directed by the controller's staff. Chapter 9 Financial Planning and Analysis: The Master Budget 413 Expenditure requests cannot exceed the appropriation target. All fixed expenditures should be included in the budget. Fixed expenditures would include such items as contracts and salaries at current levels. All government projects directed by higher authority should be included in the budget in their entirety. The controller's staff consolidates the budget requests from the various departments into a master budget submission for the entire division. Upon final budget approval by the legislature, the controller's staff allocates the appropriation to the various departments on instructions from the division manager. However, a specified percentage of each department's appropriation is held back in anticipation of potential budget cuts and special funding needs. The amount and use of this contingency fund is left to the discretion of the division manager. Each department is allowed to adjust its budget when necessary to operate within the reduced appropriation level. However, as stated in the original directive, specific projects authorized by higher authority must remain intact. The final budget is used as the basis of control. Excessive expenditures by account for each depart- ment are highlighted on a monthly basis. Department managers are expected to account for all expenditures over budget. Fiscal responsibility is an important factor in the overall performance evaluation of department managers. Eklund believes her policy of allowing the department managers to participate in the budgetary process and then holding them accountable for their performance is essential, especially during times of limited resources. She further believes that the department managers will be positively motivated to increase the efficiency and effectiveness of their departments because they have provided input into the initial budgetary process and are required to justify any unfavorable performances. Required: 1. Describe several operational and behavioral benefits that are generally attributed to a participative budgetary process. 2. Identify at least four deficiencies in Patricia Eklund's participative policy for planning and perfor- mance evaluation purposes. For each deficiency identified, recommend how it can be corrected. CMA, adapted Case 9-46 Participative Budgeting (LO 9-2, 9-3, 9-9) Patricia Eklund, controller in the division of social services for the state, recognizes the importance of the budgetary process for planning, control, and motivational purposes. She believes that a properly implemented participative budgetary process for planning purposes and an evaluation procedure will motivate the managers to improve productivity within their particular departments. Based upon this philosophy, Eklund has implemented the following budgetary procedures. An appropriation target figure is given to each department manager. This amount is the maximum funding that each department can expect to receive in the next year. Department managers develop their individual budgets within the following spending constraints as directed by the controller's staff. Chapter 9 Financial Planning and Analysis: The Master Budget 413 Expenditure requests cannot exceed the appropriation target. All fixed expenditures should be included in the budget. Fixed expenditures would include such items as contracts and salaries at current levels. All government projects directed by higher authority should be included in the budget in their entirety. The controller's staff consolidates the budget requests from the various departments into a master budget submission for the entire division. Upon final budget approval by the legislature, the controller's staff allocates the appropriation to the various departments on instructions from the division manager. However, a specified percentage of each department's appropriation is held back in anticipation of potential budget cuts and special funding needs. The amount and use of this contingency fund is left to the discretion of the division manager. Each department is allowed to adjust its budget when necessary to operate within the reduced appropriation level. However, as stated in the original directive, specific projects authorized by higher authority must remain intact. The final budget is used as the basis of control. Excessive expenditures by account for each depart- ment are highlighted on a monthly basis. Department managers are expected to account for all expenditures over budget. Fiscal responsibility is an important factor in the overall performance evaluation of department managers. Eklund believes her policy of allowing the department managers to participate in the budgetary process and then holding them accountable for their performance is essential, especially during times of limited resources. She further believes that the department managers will be positively motivated to increase the efficiency and effectiveness of their departments because they have provided input into the initial budgetary process and are required to justify any unfavorable performances. Required: 1. Describe several operational and behavioral benefits that are generally attributed to a participative budgetary process. 2. Identify at least four deficiencies in Patricia Eklund's participative policy for planning and perfor- mance evaluation purposes. For each deficiency identified, recommend how it can be corrected

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Jeff Madura

6th Edition

0324162618, 978-0324162615

More Books

Students also viewed these Finance questions