Fundamentals Of Cost Accounting (6th Edition)
6th Edition
ISBN: 9781259969478
Author: WILLIAM LANEN, Shannon Anderson, Michael Maher
Publisher: McGraw Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 17, Problem 56P
Flexible Budget
Oak Hill Township operates a motor pool with 20 vehicles. The motor pool furnishes gasoline, oil, and other supplies for the cars and hires one mechanic who does routine maintenance and minor repairs. Major repairs are done at a nearby commercial garage. A supervisor manages the operations.
Each year, the supervisor prepares a
The following schedule presents the master budget for the year and for the month of July.
The annual budget was based on the following assumptions:
- 1. Automobiles in the pool: 20.
- 2. Miles per year per automobile: 45,000.
- 3. Miles per gallon per automobile: 20.
- 4. Gas per gallon: $1.80.
- 5. Oil, minor repairs, parts, and supplies per mile: $0,008.
- 6. Outside repairs per automobile per year: $270.
The supervisor is unhappy with the monthly report, claiming that it unfairly presents his performance for July. His previous employer used flexible budgeting to compare actual costs to budgeted amounts.
Required
- a. What is the gasoline monthly flexible budget and the resulting amount over-or under-budget? (Use miles as the activity base.)
- b. What is the monthly flexible budget for the oil, minor repairs, parts, and supplies and the amount over-or underbudget? (Use miles as the activity base.)
- c. What is the monthly flexible budget for salaries and benefits and the resulting amount over-or underbudget?
- d. What is the major reason for the cost per mile to decrease from S0.2427 budgeted to $0.2121 actual?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Tri-County Social Service Agency is a not-for-profit organization in the Midwest. Use the following information to complete the cash budget for the year ending December 31.
The Board of Trustees requires that Tri-County maintain a minimum cash balance of $8,000.
If cash is short, the agency may borrow from an endowment fund the amount required to maintain the $8,000 minimum.
It is anticipated that the year will begin with an $11,000 cash balance.
Contract revenue is received evenly during the year.
Mental health income is expected to grow by $5,000 in the second and third quarters; no change is expected in the fourth quarter.
Required:
2. Complete the cash budget for each quarter and the year as a whole.
3. Determine the amount that the agency will owe the endowment fund at year-end.
owa Imaging Center provided the financial information in Exhibit 5.15 below. Prepare a cash budget for the quarter ending March 20X1. For Blackboard you will enter your ENDING cash balance for the months of January 20X1, February 20X1, March 20X1, and the Quarter ending March 20X1. I want you to submit your work for this problem by email so I can review the entire document.
Exhibit 5-15 Iowa Imaging Center
Givens
Revenues and Expenses
Patient Revenues, 20X0
Estimated Patient Revenues, 20X1
Given 1
October
$4,000,000
Given 2
January
$4,300,000
November
$4,200,000
February
$4,350,000
December
$4,300,000
March
$4,400,000
Other Revenues, 20X1
Estimated Cash Outflows, 20X1a
Given 3
January
$90,000
Given 4
January
$4,250,000…
As a courtesy, the Stratton County Parks Department (the Department) bills school districts
that use the parks. The table below is the operating budget for the Nature tours at the Stratton
Valley Golf Course. Individuals pay for tours the day they go on them. School District 1 pays
50% of the amount billed the month after receiving the bill and pays the remainder two
months after receiving the bill. School District 2 pays 50% the month it is billed, 50% one
month after receiving a bill. Prepare a cash collections budget for the Nature Tour Operations
for the month of June. Nature Tours Operating Budget April May June Families $145 $175 $
200 School District 1 $170 $120 $185 School District 2 $125 $115 $175 Total Tour Revenue $
440 $410 $560
Chapter 17 Solutions
Fundamentals Of Cost Accounting (6th Edition)
Ch. 17 - What complication arises in variance analysis when...Ch. 17 - Variance analysis can be useful in a manufacturing...Ch. 17 - How would you recommend accounting for variances...Ch. 17 - What does a manager learn by computing an industry...Ch. 17 - Why is there no efficiency variance for revenues?Ch. 17 - For what decisions would a manager want to know...Ch. 17 - If the sales activity or materials efficiency...Ch. 17 - Prob. 8RQCh. 17 - Prob. 9RQCh. 17 - What is the advantage of recognizing materials...
Ch. 17 - How could a professional sports firm use the mix...Ch. 17 - Prob. 12CADQCh. 17 - How could a hospital firm use the mix variance to...Ch. 17 - Prob. 14CADQCh. 17 - There is no reason to investigate favorable...Ch. 17 - Prob. 16CADQCh. 17 - Consider a firm in the sharing economy, such as...Ch. 17 - Prob. 18ECh. 17 - Prob. 19ECh. 17 - Prob. 20ECh. 17 - Variable Cost Variances: Materials Purchased and...Ch. 17 - Prob. 22ECh. 17 - Industry Volume and Market Share Variances DB Ice...Ch. 17 - Olive Tree Products sold 72,000 units during the...Ch. 17 - Prob. 25ECh. 17 - Sales Mix and Quantity Variances A-Zone Media...Ch. 17 - Prob. 27ECh. 17 - Sales Mix and Quantity Variances The restaurant at...Ch. 17 - Sales Mix and Quantity Variances Chow-4-Hounds...Ch. 17 - Materials Mix and Yield Variances Stacy, Inc.,...Ch. 17 - Materials Mix and Yield Variances Johns...Ch. 17 - Labor Mix and Yield Variances Matts Eat N Run has...Ch. 17 - Flexible Budgeting, Service Organization KB is a...Ch. 17 - Prob. 34ECh. 17 - Prob. 35ECh. 17 - Sales Price and Activity Variances EZ-Tax is a tax...Ch. 17 - Write a memo to the senior manager of EZ-Tax...Ch. 17 - Variable Cost Variances The standard direct labor...Ch. 17 - Refer to the information in Exercise...Ch. 17 - Prob. 40PCh. 17 - Variable Cost Variances: Materials Purchased and...Ch. 17 - Industry Volume and Market Share Variances:...Ch. 17 - Industry Volume and Market Share: Missing Data The...Ch. 17 - Sales Mix and Quantity Variances Lake Cellars...Ch. 17 - Analyze Performance for a Restaurant Dougs Diner...Ch. 17 - Nonmanufacturing Cost Variances FSBCU is a...Ch. 17 - Performance Evaluation in Service Industries Bay...Ch. 17 - Refer to the information in Problem...Ch. 17 - Prob. 49PCh. 17 - Refer to the data for the Peninsula Candy Company...Ch. 17 - Materials Mix and Yield Variances Plano Products...Ch. 17 - Pinnuck Products makes a liquid solvent using two...Ch. 17 - Labor Mix and Yield Variances Matthews Bros, is a...Ch. 17 - Refer to the information in Problem...Ch. 17 - Derive Amounts for Profit Variance Analysis...Ch. 17 - Flexible Budget Oak Hill Township operates a motor...
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
- Communication The city of Milton has an annual budget cycle that begins on July 1 and ends on June 30. At the beginning of each budget year, an annual budget is established for each department. The annual budget is divided equally among the 12 months to provide a constant monthly static budget. On June 30, all unspent budgeted monies for the budget year from the various city departments must be returned to the General Fund. Thus, if department heads fail to use their budget by year-end, they will lose it. A budget analyst prepared a chart of the difference between the monthly actual and budgeted amounts for all departments in a recent fiscal year. The chart was as follows: Write a memo to Stacy Poindexter, the city manager, interpreting the chart and suggesting improvements to the budgeting system.arrow_forwardGig Harbor Boating is the wholesale distributor of a small recreational catamaran sailboat. Management has prepared the following summary data to use in its annual budgeting process:arrow_forwardThe Document Creation Center (DCC) for Alegis Corp. provides photocopying and document services for three departments in the St. Paul office. The following budget has been prepared for the year. Available capacity Budgeted usage: Software Development Training Management Cost equation 13,000,000 pages 2,600,000 pages 4,875,000 pages 3,900,000 pages 55,000+ $0.03 per page If DCC uses a dual rate for allocating its costs based on usage, how much cost will be allocated to the Software Development Department?arrow_forward
- The Document Creation Center (DCC) for Arlington Corp. provides photocopying and document services for three departments in the Minneapolis office. The following budget has been prepared for the year. Available capacity Budgeted usage: Software Development Training Management Cost equation 8,180,000 pages 1,508,000 pages 3,452,000 pages 2,580,000 pages $460,000+ $0.02 per page If DCC uses a dual-rate for allocating its costs, how much cost will be allocated to the Software Development Department, assuming the Software Development Department actually made 1,960,000 copies during the year?arrow_forwardRhed Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During December, the kennel budgeted for 4,500 tenant-days, but its actual level of activity was 4,550 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for December: Data used in budgeting: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Total expenses Actual results for December: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Fixed element per month $0 $ 3,900 2,250 9,900 7,900 $ 23,950 $ 159,355 $ 46,485 $ 66,835 $ 37,535 $9,865 Variable element per tenant-day $ 35.60 $9.40 14.60 6.10 0.70 $ 30.80 The activity variance for administrative expenses in December would be closest to:arrow_forwardVirgen Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During May, the kennel budgeted for 3,700 tenant-days, but its actual level of activity was 3,690 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for May: Data used in budgeting: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Total expenses Actual results for May: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Fixed Element Variable element per per Month $ 2,500 1,300 8,600 6,800 $ 19,200 $ 92,626 $ 23,919 $ 37,833 $ 18,594 $ 8,386 tenant-day $26.40 $6.10 The wages and salaries in the planning budget for May would be closest to: 9.70 2.60 0.40 $18.80arrow_forward
- Lackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended. Department Admissions Annual Cost $118,000 Registrar Computer Services 197,000 420,000 Planned Courses Budgeted Enrollment Budgeted Credit Hours Requiring Computer Work 12 es Division Liberal Arts Sciences Business Administration 1,100 850 31,000 28,750 22,750 25 750 25 Required: 1. Distribute the departmental costs to the college's three divisions based on the allocation base given. 2. Choose the better allocation base for distributing the cost to the following departments: Complete this question by entering your answers in the tabs below. Required 1 Required 2 1 of 7 Next > Prevarrow_forwardCash budget. Mary Jacobs, the controller of the Jenks Company is working on Jenks’ cash budget for year 2. She has information on each of the following items: Wages due to workers accrued as of December 31, year 1. Limits on a line of credit that may be used to fund Jenks’ operations in year 2. The balance in accounts payable as of December 31, year 1, from credit purchases made in year 1. Which of the items above should Jacobs take into account when building the cash budget for year 2? A. I, II , B. I, III, C. II, III, D, I, II, IIIarrow_forwardLackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended. Department Admissions Registrar Computer Services Division Liberal Arts Annual Cost $136,000 233,000 492,000 Sciences Business Administration Budgeted Budgeted Enrollment Credit Hours 2,900 1,750 1,650 49,000 42,250 36,250 Required: 1. Distribute the departmental costs to the college's three divisions based on the allocation base given. 2. Choose the better allocation base for distributing the cost to the following departments: Department and Allocation Base Planned Courses Requiring Computer Work Complete this question by entering your answers in the tabs below. Admissions (enrollment) Registrar (credit hours) Computer Services (courses requiring…arrow_forward
- The Franklin Management Association held its annual public relations luncheon in April Year 2. Based on the previous year’s results, the organization allocated $24,818 of its operating budget to cover the cost of the luncheon. To ensure that costs would be appropriately controlled, Molly Hubbard, the treasurer, prepared the following budget for the Year 2 luncheon. The budget for the luncheon was based on the following expectations: The meal cost per person was expected to be $12.50. The cost driver for meals was attendance, which was expected to be 1,470 individuals. Postage was based on $0.58 per invitation and 3,350 invitations were expected to be mailed. The cost driver for postage was number of invitations mailed. The facility charge is $1,700 for a room that will accommodate up to 1,600 people; the charge for one to hold more than 1,600 people is $2,200. A fixed amount was designated for printing, decorations, the speaker’s gift, and publicity. FRANKLIN MANAGEMENT…arrow_forwardHugo Medical Supply has applied for a loan. Pacific Commerce Bank has requested a budgeted balance sheet as of April 30, and a combined cash budget for April. As Hugo Medical Supply's controller, you have assembled the following information: a. March 31 equipment balance, $52,600; accumulated depreciation, $41,300. b. April capital expenditures of $ 42,400 budgeted for cash purchase of equipment. c. April depreciation expense, $700. d. Cost of goods sold, 60%of sales. e. Other April operating expenses, including income tax, total $14,200, 35% of which will be paid in cash and the remainder accrued at April 30. f. March 31 owners' equity, $92,600. g. March 31 cash balance, $40,300. h. April budgeted sales, $90,000, 70% of which is for cash. Of the remaining 30%, half will be collected in April and half in May. i. April cash collections on March sales, $29,100. j. April cash payments of March 31 liabilities incurred for March…arrow_forwardDinham Kennel uses tenant-days as its measure of activity; an animal housed in the kennel for one day is counted as one tenant-day. During March, the kennel budgeted for 4,700 tenant-days, but its actual level of activity was 4,780 tenant-days. The kennel has provided the following data concerning the formulas used in its budgeting and its actual results for March: Data used in budgeting: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Total expenses Actual results for March: Revenue Wages and salaries Food and supplies Facility expenses Administrative expenses Fixed element per month 0 The revenue variance for March would be closest to: $ 3,600 1,100 7,500 7,600 $ 19,800 $ 144,230 $ 28,660 $ 74,070 $ 27,220 $ 7,106 Variable element per tenant-day $ 35.20 $ 8.60 15.10 4.10 0.50 $ 28.30arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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
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
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