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
Subject: acounting
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!
Relevant 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…
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
- Solve this question with steps. The subject is Managerial Accounting.arrow_forwardProfessional Fees Earned 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 45,000 Partners 6,800 Tax Department: Staff 34,200 Partners 4,300 Small Business Accounting Department: Staff 6,300 Partners 900 The average billing rate for staff is $120 per hour, and the average billing rate for partners is $240 per hour. Prepare a professional fees earned budget for Rollins and Cohen, CPAS, for the year ending December 31, 20Y7. ROLLINS AND COHEN, CPAS Professional Fees Earned Budget For the Year Ending December 31, 20Y7 Billable Hourly Total Hours Rate Revenue Audit Department: Staff Partners Total $4 Tax Department: Staff Partners Total Small Business Accounting Department: Staff Partners Total $ Total professional fees earned $arrow_forwardProfessional Fees Earned Budget Day & Spieth, 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 March 31, 20Y6: Billable Hours Audit Department: Staff 28,100 Partners 4,200 Tax Department: Staff 21,100 Partners 2,600 Small Business Accounting Department: Staff 3,900 Partners 500 The average billing rate for staff is $110 per hour, and the average billing rate for partners is $230 per hour. Prepare a professional fees earned budget for Day & Spieth, CPAs, for the year ending March 31, 20Y6. DAY & SPIETH, CPAs Professional Fees Earned Budget For the Year Ending March 31, 20Y6 Billable Hours Hourly Rate Total Revenue Audit Department: Staff $ $ Partners Total $ Tax Department: Staff $ $ Partners Total $…arrow_forward
- Professional Labor Cost Budget Day & Spieth, 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 March 31, 20Y6: Billable Hours Audit Department: Staff 28,200 Partners 4,200 Tax Department: Staff 20,600 Partners 2,600 Small Business Accounting Department: Staff 3,400 Partners 500 Assume that the average compensation per hour for staff is $65 and for partners is $160. Prepare a professional labor cost budget for Day & Spieth, CPAs, for the year ending March 31, 20Y6. Enter all amounts as positive numbers. DAY & SPIETH, CPAs Professional Labor Cost Budget For the Year Ending March 31, 20Y6 Staff Partners Audit Department Hours fill in the blank 1 fill in the blank 2 Tax Department Hours fill in the blank 3 fill in the blank 4 Small Business Accounting…arrow_forwardProfessional Fees Earned Budget Day & Spieth, 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 March 31, 20Y6: Billable Hours Audit Department: Staff 36,000 Partners 5,400 Tax Department: Staff 27,700 Partners 3,500 Small Business Accounting Department: Staff 4,700 Partners 700 The average billing rate for staff is $145 per hour, and the average billing rate for partners is $265 per hour. Prepare a professional fees earned budget for Day & Spieth, CPAs, for the year ending March 31, 20Y6. DAY & SPIETH, CPAs Professional Fees Earned Budget For the Year Ending March 31, 20Y6 Billable Hours Hourly Rate Total Revenue Audit Department: Staff fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Partners fill in the blank 4 fill in the…arrow_forwardProfessional Fees Earned 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: Billable Hours Audit Department: Staff 25,000 Partners 6,000 Tax Department: Staff 40,000 Partners 8,500 Small Business Accounting Department: Staff 5,000 Partners 500 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 the year ending May 31, 20Y8. Lundquist & Fretwell, CPAs Professional Fees Earned Budget For the Year Ending May 31, 20Y8 Billable Hours Hourly Rate Total Revenue Audit Department: Staff Partners Total Tax Department:…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
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
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
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
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