Accounting
27th Edition
ISBN: 9781337272094
Author: WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem 22.5CP
Static budget for a service company
A bank manager of City Savings Bank Inc. uses the
| Resources | Budget | Actual |
| Salaries | $200,000 | $200,000 |
| Benefits | 30.000 | 30,000 |
| Supplies | 45,000 | 42,000 |
| Travel | 20,000 | 30,000 |
| Training | 25,000 | 35,000 |
| Overtime | 25,000 | 20,000 |
| Total | $345,000 | $357,000 |
| Excess of actual over budget | $ 12,000 |
- a. What information is provided by the budget? Specifically, what questions can the bank manager ask of the Operations Department manager?
- b. What information does the static budget fail to provide? Specifically, could the budget information be presented differently to provide even more insight for the bank manager?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Algebraic method
Prosperous Bank has three support areas (administration, human resources, and accounting) and three revenue-generating areas (checking accounts, savings accounts, and loans).
Monthly direct costs and the interdepartmental support structure are shown below:
Percentage of Service Used by
Department Direct Costs Admin. Human Resources Accounting Checking Savings Loans
Administration
$540,000
40
10
20
30
20
20
Human resources
Accounting
Checking
Savings
Loans
360,000
300,000
630,000
337,500
675,000
Checking $
Savings
Loans
Total
10
10
$ 2,842,500
10
10
10
10
Compute the total cost for each revenue-generating area of the bank using the algbraic method.
Note: Do not round proportions in your calculations; round your final answer to the nearest whole dollar.
Note: Round your final answers below to the nearest 100; for example, round 8,668 to 8,700.
0 x
0 x
0 x
✓
30
30
40
Step methodProsperous Bank has three support areas (administration, human resources, and accounting) and three revenue-generating areas (checking accounts, savings accounts, and loans). Monthly direct costs and the interdepartmental support structure are shown in the following benefits-provided ranking:
Percentage of Service Used by
Department
Direct Costs
Admin.
Human Resources
Accounting
Checking
Savings
Loans
Administration
$540,000
10
10
30
40
10
Human resources
360,000
10
10
30
20
30
Accounting
300,000
10
10
40
20
20
Checking
630,000
Savings
337,500
Loans
675,000
Compute the total cost for each revenue-generating area of the bank using the step-method of cost allocation.
Note: Do not round proportions in your calculations; round your final answer to the nearest whole dollar.
Checking
Answer
Savings
Answer
Loans
Answer
Total
Answer
Please show all work step by step calculations! Thank you!
Professional Labor Cost Budget for a Service Company
Rollins and Cohen, CPAs, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending December 31, 20Y7:
Billable Hours
Audit Department:
Staff
22,400
Partners
7,900
Tax Department:
Staff
13,200
Partners
5,500
Small Business Accounting Department:
Staff
3,000
Partners
600
Based on the data provided above and assuming that the average compensation per hour for staff is $45 and for partners is $140, prepare a professional labor cost budget for each department for Rollins and Cohen, CPAs, for the year ending December 31, 20Y7.
Rollins and Cohen, CPAs
Professional Labor Cost Budget
For the Year Ending December 31, 20Y7
Staff
Partners
Audit department hours
Tax department hours
Small business accounting department hours…
Chapter 22 Solutions
Accounting
Ch. 22 - Prob. 22.1DQCh. 22 - Briefly describe the type of human behavior...Ch. 22 - What behavioral problems are associated with...Ch. 22 - What behavioral problems are associated with...Ch. 22 - Under what circumstances is a static budget...Ch. 22 - How do computerized budgeting systems aid firms in...Ch. 22 - Why should the production requirements set forth...Ch. 22 - Why should the timing of direct materials...Ch. 22 - a. Discuss the purpose of the cash budget. b. If...Ch. 22 - Prob. 22.10DQ
Ch. 22 - Flexible budgeting At the beginning of the period,...Ch. 22 - Flexible budgeting At the beginning of the period,...Ch. 22 - Production budget Daybook Inc. projected sales of...Ch. 22 - Prob. 22.2BPECh. 22 - Direct materials purchases budget Daybook Inc....Ch. 22 - Direct materials purchases budget Magnolia Candle...Ch. 22 - Direct labor cost budget Daybook Inc. budgeted...Ch. 22 - Direct labor cost budget Magnolia Candle Inc....Ch. 22 - Cost of goods sold budget Prepare a cost of goods...Ch. 22 - Cost of goods sold budget Prepare a cost of goods...Ch. 22 - Cash budget Daybook Inc. collects 30% of its sales...Ch. 22 - Cash budget Magnolia Candle Inc. pays 10% of its...Ch. 22 - Personal budget At the beginning of the school...Ch. 22 - Flexible budget for selling and administrative...Ch. 22 - Static budget versus flexible budget The...Ch. 22 - Flexible budget for Assembly Department Steelcase...Ch. 22 - Production budget Weightless Inc. produces a small...Ch. 22 - Sales and production budgets Sonic Inc....Ch. 22 - Professional fees earned budget for a service...Ch. 22 - Professional labor cost budget for a service...Ch. 22 - Direct materials purchases budget Lorenzo's Frozen...Ch. 22 - Prob. 22.10EXCh. 22 - Direct materials purchases budget Anticipated...Ch. 22 - Direct labor cost budget MatchPoint Racket Company...Ch. 22 - Direct labor budget for a service business...Ch. 22 - Production and direct labor cost budgets Levi...Ch. 22 - Factory overhead cost budget Sweet Tooth Candy...Ch. 22 - Cost of goods sold budget Wilmington Chemical...Ch. 22 - Cost of goods sold budget The controller of...Ch. 22 - Schedule of cash collections of accounts...Ch. 22 - Schedule of cash collections of accounts...Ch. 22 - Schedule of cash payments for a service company...Ch. 22 - Schedule of cash payments for a service company...Ch. 22 - Capital expenditures budget On January 1, 20Y2,...Ch. 22 - Forecast sales volume and sales budget For 20Y6,...Ch. 22 - Sales, production, direct materials purchases, and...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Cash budget The controller of Sonoma Housewares...Ch. 22 - Budgeted income statement and balance sheet As a...Ch. 22 - Forecast sales volume and sales budget Sentinel...Ch. 22 - Sales, production, direct materials purchases, and...Ch. 22 - Budgeted income statement and supporting budgets...Ch. 22 - Cash budget The controller of Mercury Shoes Inc....Ch. 22 - Budgeted income statement and balance sheet As a...Ch. 22 - Prob. 22.1CPCh. 22 - Communication The city of Milton has an annual...Ch. 22 - Prob. 22.4CPCh. 22 - Static budget for a service company A bank manager...Ch. 22 - Objectives of the master budget Dominos Pizza...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardStatic budget for a service company A bank manager of City Savings bank Inc. uses the managerial accounting system to track the costs of operating the various departments within the bank. The departments include Cash Management, Trust, Commercial Loans, Mortgage Loans, Operations, Credit Card, and Branch Services. The static budget and actual results for the Operations Department are as follows: Resources Budget Actual Salaries 200,000 200,000 Benefits 30,000 30,000 Supplies 45,000 42,000 Travel 20,000 30,000 Training 25,000 35,000 Overtime 25,000 20,000 Total 345.000 357,000 Excess of actual over budget 12,000 a. What information is provided by the budget? Specifically, what questions can the bank manager ask of the Operations Department manager? b. What information does the static budget fail to provide? Specifically, could the budget information be presented differently to provide even more insight for the bank manager?arrow_forwardA company has prepared the operating budget and the cash budget. It is now preparing the budgeted balance sheet. Identify the document that contains each of these balances. A. cash B. accounts receivable C. finished goods inventory D. accounts payable E. equipment purchasesarrow_forward
- Professional foes earned budget for a service company LundquistFret well. CPAs, offer three types of services to clents: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending May 31. 20Y8: The average billing rate for staff is 140 per hour, and the average billing rate for partners is 450 per hour. Prepare a professional fees earned budget for Lundquist Fretwell, CPAs, for theyear ending May 31, 20Y8, using the following column headings and showing the estimated professional fees by type of service rendered:arrow_forwardBudgeted income statement and supporting budgets The budget director of Gold Medal Athletic Co., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for March: Estimated sales for March: Estimated inventories at March 1: Desired inventories at March 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for March: Estimated operating expenses for March: Estimated other revenue and expense for March: Estimated tax rate: 30% Instructions Prepare a sales budget for March. Prepare a production budget for March. Prepare a direct materials purchases budget for March. Prepare a direct labor cost budget for March. Prepare a factory overhead cost budget for March. Prepare a cost of goods sold budget for March. Work in process at the beginning of March is estimated to be 15,300, and work in process at the end of March is desired to be 14,800. Prepare a selling and administrative expenses budget for March. Prepare a budgeted income statement for March.arrow_forwardBudgeted income statement and supporting budgets The budget director of Birding Homes Feeders Inc., with the assistance of the controller, treasurer, production manager, and sales manager, has gathered the following data for use in developing the budgeted income statement for January: Estimated sales for January: Estimated inventories at January 1: Desired inventories at January 31: Direct materials used in production: Anticipated cost of purchases and beginning and ending inventory of direct materials: Direct labor requirements: Estimated factory overhead costs for January: Estimated operating expenses for January: Estimated other revenue and expense for January: Estimated tax rate: 25% Instructions Prepare a sales budget for January. Prepare a production budget for January. Prepare a direct materials purchases budget for January. Prepare a direct labor cost budget for January. Prepare a factory overhead cost budget for January. Prepare a cost of goods sold budget for January. Work in process at the beginning of January is estimated to be 9,000, and work in process at the end of January is estimated to be 10,500. Prepare a selling and administrative expenses budget for January. Prepare a budgeted income statement for January.arrow_forward
- Professional Labor Cost Budget for a Service Company Rollins and Cohen, CPAS, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending December 31, 20Y7: Billable Hours Audit Department: Staff 37,500 Partners 5,600 Tax Department: Staff 27,400 Partners 3,400 Small Business Accounting Department: Staff 4,900 Partners 700 Based on the data provided above and assuming that the average compensation per hour for staff is $45 and for partners is $140, prepare a professional labor cost budget for each department for Rollins and Cohen, CPAS, for the year ending December 31, 20Y7. Rollins and Cohen, CPAS Professional Labor Cost Budget For the Year Ending December 31, 20Y7 Staff Partners Audit department hours Tax department hours Small business accounting department hours Total hours Average compensation per hour X $ Total professional labor cost $arrow_forwardRelevant data from the Poster Company's operating budgets are: Sales Direct material purchases Direct labor Manufacturing overhead Selling and administrative expenses Depreciation included in selling and administrative Collections from customers Quarter 1 Quarter 2 Beginning Cash Balance Add: Cash Receipts Collections from Customers $208,480 $211,540 115,300 120,832 75,205 73,298 25,300 23,400 33,400 33,500 1,500 900 Cash payments for purchases Additional data: Capital assets were sold in January for $10,000 and $4,400 in May. Dividends of $4,000 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $39,000. 215,392 240,154 114,290 119,254 Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. Other Collections Total Receipts Total Available Cash Less: Cash Payments Purchase of Direct Material Direct Labor Manufacturing Overhead Selling and…arrow_forwardTuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department. The bank has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments' output for the year is as follows: Provider of Service HR 0 Computing 15% 15% 0 60% 55% 25% 30% User of Service HR Computing Deposit Loan The budgeted costs in the two service departments for the year are as follows: HR Computing Required: $ 499,000 728,500 Use the reciprocal-services method to allocate the budgeted costs of the HR and Computing departments to the Deposit and Loan departments. Note: Do not round your Intermediate calculations and round final answers to the nearest dollar amount. Provider of Service Allocation of HR Department costs Allocation of Computing Department costs Total costs allocated to each department Deposit Loanarrow_forward
- Professional Labor Cost Budget for a Service Company Lundquist & Fretwell, CPAS, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending May 31, 20Y8: Audit Department: Staff Partners Tax Department: Staff Partners Small Business Accounting Department: Staff Partners Billable Hours Audit Department hours Tax Department hours Small Business Accounting Department hours Total hours Average compensation per hour Total professional labor cost 25,000 6,000 Based on the data provided above and assuming that the average compensation per hour for staff is $40 and for partners is $175, prepare a professional labor cost budget for each department for Lundquist & Fretwell, CPAS, for the year ending May 31, 20Y8. 40,000 8,500 Lundquist & Fretwell, CPAS Professional Labor Cost Budget For the Year Ending December 31, 20Y8 Staff Partners X $ 5,000 500 x $arrow_forwardBudget Performance Report for a Cost Center Funderburk Tech Inc. sells electronics over the Internet. The Consumer Products Division is organized as a cost center. The budget for the Consumer Products Division for the month ended January 31 is as follows: Customer service salaries $628,870 Insurance and property taxes 131,860 Distribution salaries 1,003,190 Marketing salaries 1,182,630 Engineer salaries 962,380 Warehouse wages 674,030 Equipment depreciation 211,360 Total $4,794,320 During January, the costs incurred in the Consumer Products Division were as follows: Customer service salaries $692,700 Insurance and property taxes 126,780 Distribution salaries 990,380 Marketing salaries 1,248,010 Engineer salaries 943,010 Warehouse wages 647,030 Equipment depreciation 211,150 Total $4,859,060 Required: 1. Prepare a budget performance report for the director of the Consumer Products Division for the month of January. If an…arrow_forwardTuscaloosa National Bank has two service departments, the Human Resources (HR) Department and the Computing Department. The bank has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments' output for the year is as follows: User of Service HR Computing Deposit Loan Provider of Service HR Computing 15% 20% 50% 50% 30% 35% The budgeted costs in the two service departments for the year are as follows: HR Computing $158,000 238,000 Required: Use the direct method to allocate the budgeted costs of the HR and Computing departments to the Deposit and Loan departments. (Do not round intermediate calculations.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Financial & Managerial AccountingAccountingISBN:9781285866307Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Accounting (Text Only)AccountingISBN:9781285743615Author:Carl Warren, James M. Reeve, Jonathan DuchacPublisher:Cengage Learning
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Financial & Managerial Accounting
Accounting
ISBN:9781285866307
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Accounting (Text Only)
Accounting
ISBN:9781285743615
Author:Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:Cengage Learning
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY