Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service 560 480 280 470 Monthly maintenance cost= 350 460 320 430 490 380 350 340 4,910 409 Maintenance Costs $5,110 4,240 2,730 4,300 3,030 4,120 3,000 3,590 4,000 3,220 3,170 3,070 $ 43,580 $3,632 PR 6-38 (Algo) Part 1 Estimate the behavior of the maintenance costs incurred... Required: 1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation's Capital Fitness, Incorporated. Express the cost behavior pattern in equation form. Note: Round coefficient of X to 2 decimal places and other answer to the nearest whole dollar amount.

Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service 560 480 280 470 Monthly maintenance cost= 350 460 320 430 490 380 350 340 4,910 409 Maintenance Costs $5,110 4,240 2,730 4,300 3,030 4,120 3,000 3,590 4,000 3,220 3,170 3,070 $ 43,580 $3,632 PR 6-38 (Algo) Part 1 Estimate the behavior of the maintenance costs incurred... Required: 1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation's Capital Fitness, Incorporated. Express the cost behavior pattern in equation form. Note: Round coefficient of X to 2 decimal places and other answer to the nearest whole dollar amount.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Prepare a cost-hierarchy income statement for The Insurance Company using the format in Exhibit 14-7 assuming corporate costs are not allocated to each region.
Susan Mills, Company B's chief accountant, has developed an automated costing system that helps track the cost of production activities. This system is capable of accurately measuring and allocating post-manufacturing activities, such as selling, promotional, and distribution activities, in such a way where Company B gets a more detailed view of its product costs. One of the benefits of this system is that it allows Company B to determine which product lines are more profitable. When Susan implemented the new costing system, she realized that the company's current period profits would increase significantly if the new product cost information was used for inventory valuation on the financial statements. Susan has been under intense pressure to improve the company's profits, and this would be a quick and effective way for her to help meet the company's short-term profit goals. As a result, Susan has decided to use the automated costing system to determine the company's profits.…
. Spirit Freightways is a leader in transporting agricultural products in the western provinces of Canada. Reese Brown, a financial analyst at Spirit Freightways, is studying the behav- ior of transportation costs for budgeting purposes. Transportation costs at Spirit are of two types: (a) operating costs (such as labor and fuel) and (b) maintenance costs (primarily overhaul of vehicles). Brown gathers monthly data on each type of cost, as well as the total freight miles traveled by Spirit vehicles in each month. The data collected are shown below (all in thousands): Operating Costs $ 942 Month Maintenance Costs Freight Miles $ 974 January February 1,710 1,008 76 2,655 March 1,218 686 2,705 April May 1,380 694 4,220 1,484 588 4,660 June 1,548 422 4,455 4,435 July August September 1,568 352 1,972 420 4,990 1,190 564 2,990 October 1,302 788 2,610 November 962 762 2,240 December 772 1,028 1,490 1. Conduct a regression using the monthly data of operating costs on freight miles. You should…
Bank overdrafts that are repayable on demand and the bank balance often fluctuates from positive to overdrawn shall be classified as Operating activities Investing activities Financing activities Component of cash and cash equivalents
The Pangasinan plant of the Pilipinas Company manufactures cash registers. It plansto implement an activity-based costing system. The controller has prepared thefollowing estimates regarding cost pools and activity levels for the next year.Cost PoolActivity CostsActivity driver levelsElectricityP100,00040,000 kwhMachine setups300,0001,500 setup hoursMaterial moves80,00040,000 movesQuality inspections120,00030,000 inspectionsTotalP600,000The plant’s present cost accounting system allocates manufacturing overhead to jobs using aplant-wide overhead rate based on machine hours. The total machine hours for the comingyear are estimated to be 100,000 hours.The company has received a request for a bid to deliver 2,000 units of its cash register modelMAI. The following estimates pertain to the production of 2,000 units of MAI:Direct materials costP30,000Direct labor (P10/hour)P15,000Machine hours2,000Setup hours50Electricity (Kwh)2.000Number of quality inspections500Number of material…
Which strategy will you recommend to management? Why? Explain yourrecommendation with reference to your assessment of the strategies.
Howard Cooper, the president of Jordan Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3. Standard rate and variable costs Service rate per hour $ 84.00 Labor cost 33.00 Overhead cost 6.60 Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative 3.50 $517,000 145,000 Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 31,000 hours of services in Year 3. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Jordan charges customers $79 per hour, the firm can achieve 39,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same…
I need help with coat accounting. thanks.
Banc Corporation Trust is considering either a bank-wide overhead rate or department overhead rates to allocate $396,000 of indirect costs. The bank-wide rate could be based on either direct labor-hours (DLH) or the number of loans processed. The departmental rates would be based on direct labor-hours for Consumer Loans and a dual rate based on direct labor-hours and the number of loans processed for Commercial Loans. The following information was gathered for the upcoming period: Department Consumer DLH 16,000 9,000 Loans Processed Direct Costs 700 300 $ 280,000 $ 180,000 Commercial If Banc Corporation Trust uses a bank-wide rate based on the number of loans processed, what would be the total costs for the Consumer Department? Multiple Choice О $254,000 О $280,000 O O $576,000 $557,200 G A
Vaughn Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Revenues Direct materials costs Direct labor costs. Overhead costs Operating income (loss) Revenues Direct materials costs Direct labor costs. Overhead costs Operating income (loss) Activity Cost Pools Scheduling and travel Setup time Supervision The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window coverings are less complex for residential customers. In addition, the residential client base resides in close proximity to the company office, so travel costs are not as expensive on a per client visit for residential customers. As a result, she has decided to take a closer look at the overhead costs assigned to the two product lines to determine whether a more accurate…
Arklan Production is upgrading its manufacturing process from a manual process to a highly automated system. Management believes that the new system will result in greater efficiencies and a better finished product. Arklan is also working on a plan to downsize staff after the implementation of the new system. Arklan has used a traditional absorption costing system to calculate unit product costs for external financial reporting. In the past, Arklan has allocated its manufacturing overhead costs using a predetermined plant-wide overhead rate based on direct labor hours. The controller realizes that the new system may require changing the overhead allocation process. Management plans to take the opportunity to reconsider other improvements to the costing system. Identify and explain three benefits of using departmental overhead rates to allocate overhead costs. Explain the difference between absorption costing and variable costing. Identify which is more suitable for internal…
Founder Consulting Corporation has its headquarters in Memphis and operates from three branch offices in Nashville, Atlanta, and Louisville. Two of the company's activity cost pools are Administrative Service and Development Service. These costs are allocated to the three branch offices using an activity-based costing system. Information for next year follows: Activity Cost Pool Activity Measure Estimated Cost Administrative service % of time devoted to branch $ 1,680,000 Development service Computer time $ 630,000 Estimated branch data for next year is as follows: Time to branch Computer time Nashville 70 % 1,600,000 minutes Atlanta 20 % 1,200,000 minutes Louisville 10 % 400,000 minutes Total 100 % 3,200,000 minutes How much of the headquarters cost allocation should Nashville expect to receive next year?