Required information [The following information applies to the questions displayed below.] Nation's Capital Fitness, Inc., 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 the high-low method to develop 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 520 490 300 500 310 480 320 400 470 Monthly maintenance cost= 350 340 320 4,800 400 Maintenance Costs $4,470 4,260 2,820 4,350 2,960 4,200 3,000 3,600 4,050 3,300 3,160 3,030 $43,200 $ 3,600 Required: 1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation's Capital Fitness, Inc. Express the cost behavior pattern in equation form. (Round coefficient of X to 2 decimal places and other answer to the nearest whole dollar amount.) X

Required information [The following information applies to the questions displayed below.] Nation's Capital Fitness, Inc., 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 the high-low method to develop 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 520 490 300 500 310 480 320 400 470 Monthly maintenance cost= 350 340 320 4,800 400 Maintenance Costs $4,470 4,260 2,820 4,350 2,960 4,200 3,000 3,600 4,050 3,300 3,160 3,030 $43,200 $ 3,600 Required: 1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation's Capital Fitness, Inc. Express the cost behavior pattern in equation form. (Round coefficient of X to 2 decimal places and other answer to the nearest whole dollar amount.) X

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter6: Cost-volume-profit Analysis

Section: Chapter Questions

Problem 5E: Identify fixed and variable costs Intuit Inc. (INTU) develops and sells software products for the...

See similar textbooks

Similar questions

Nation’s Capital Fitness, Inc. 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: (image below) Required:1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation’s Capital Fitness, Inc. Express the cost behavior pattern in equation form.2. Using your answer to requirement (1), what is the variable component of the maintenance cost?3. Compute the predicted maintenance cost at 590 hours of activity.4. Compute the variable cost per hour and the fixed cost per hour at 600 hours of activity. Explain why the fixed cost per hour could be…
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 Variable maintenance cost 560 480 280 470 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 PR 6-38 (Algo) Part 2 What is the variable component of the maintenance cost? 2. Using your answer to requirement 1, what is the variable component of the maintenance cost? Note: Round your answer to 2 decimal places. 3,000 3,590…
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 350 460 320 430 490 380 350 340 4,910 409 Maintenance cost 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 3 Compute the predicted maintenance cost... 3. Compute the predicted maintenance cost at 670 hours of activity. Answer is complete but not entirely correct. $ 49,192 X
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 350 Monthly maintenance cost = 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…
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 Variable maintenance cost 520 470 250 490 340 470 330 410 480 380 390 340 4,870 406 Maintenance Costs $ 5,305 4,170 2,740 4,280 3,050 4,160 3,040 3,570 3,990 3,230 3,170 3,120 $ 43,825 $ 3,652 2. Using your answer to requirement 1, what is the variable component of the maintenance cost? Note: Round your answer to 2 decimal places. ********* per hour
Howard Cooper, the president of Thornton 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 Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 42,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 Thornton charges customers $79 per hour, the firm can achieve 48,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the…
Howard Cooper, the president of Stuart 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 Labor cost Overhead cost Selling, general, and administrative cost Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 30,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 Stuart charges customers $80 per hour, the firm can achieve 36,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…
Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. Costs Product Cost / Period Cost 1. Depreciation on salespersons’ cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors’ salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are…
Suppose that Demont has been given a summer job as an intern at Isaac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. Classify each cost listed below as either product costs or period costs for the purpose of preparing the financial statements for the bank. Cost Product Cost/Period Cost 1. Factory supervisors' salaries 2. Heat, water, and power consumed in the factory 3. Materials used for boxing products for shipment overseas. Units are normally boxed. 4. Advertising costs 5. Workers' compensation insurance for factory employee
Suppose that Demont has been given a summer job as an intern at Isaac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help it finance its growth. The bank requires financial statements before approving such a loan. Classify each cost listed below as either product costs or period costs for the purpose of preparing the financial statements for the bank. Costs Product Cost/Period Cost 1. Depreciated on salesperson's cars 2. Rent on equipment used in the factory 3. Lubricants used for machine maintenance 4. Salaries of personnel who work in the finished goods warehouse 5. Soap and paper towels used by factory workers at the end of a shift
Classifying Costs as Product or Period Costs Suppose that you have been given a summer job as an intern at Issac Aircams, a company that manufactures sophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financial statements before approving the loan. Required: Classify each cost listed below as either a product cost or a period cost for the purpose of preparing financial statements for the bank. 1. Depreciation on salespersons’ cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors’ salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9.…
Suppose that you have been given a summer job as an Intern at Issac Alrcams, a company that manufactures sophisticated spy cameras for remote-controlled millitary reconnalssance alrcraft. The company, which is privately owned, has approached a bank for a loan to help finance its growth. The bank requires financlal statements before approving the loan. Requlred: Classify each cost listed below as elther a product cost or a perlod cost for the purpose of preparing financial statements for the bank. Costs Product Cost or Period Cost 1. Depreciation on salespersons' cars. 2. Rent on equipment used in the factory. 3. Lubricants used for machine maintenance. 4. Salaries of personnel who work in the finished goods warehouse. 5. Soap and paper towels used by factory workers at the end of a shift. 6. Factory supervisors' salaries. 7. Heat, water, and power consumed in the factory. 8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.) 9. Advertising costs.…