Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm'scontroller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior patternof the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of anequation, in the form of Y= a + bx, for maintenance costs. Data regarding the maintenance hours and costs for last yearare as follows:MonthJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberTotalAverageHours ofMaintenanceService5604802804703504603204304903803503404,910409Maintenance costMaintenanceCosts$ 5,1104,2402,7304,3003,0304, 1203,0003,5904,0003,2203,1703,070$ 43,580$ 3,632PR 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

Variable component of maintenance costs : Variable maintenance costs change with the productivity of…

Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The fi controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost beh of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use c equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs fo are as follows: Month January February March April May June July August September October November December Total Hours of Maintenance Service 560 480 280 470 350 460 320 430 490 380 350 340 4,910 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

Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The fi controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost beh of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use c equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs fo are as follows: Month January February March April May June July August September October November December Total Hours of Maintenance Service 560 480 280 470 350 460 320 430 490 380 350 340 4,910 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

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter7: Linear Regression

Section: Chapter Questions

Problem 3P: Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel...

See similar textbooks

Similar questions

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
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…
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 Monthly maintenance cost= 320 400 470 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…
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 "Rounded Hours of Maintenance Service 530 470 260 470 360 450 330 450 470 380 360 360 4,890 408- Maintenance Costs $ 5,068 4,220 2,800 4,330 2,970 4,140 3,100 3,510 4,010 3,200 3,250 3,040 $43,638 $ 3,637 Required: 1. Using the high-low method of cost estimation, estimate the behavior of the…
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…
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. Cost Product Cost/Period Cost1. Depreciation on chairs and tables in the factory lunchroom 2. The wages of the receptionist in the administrative offices 3. Cost of leasing the corporate jet used by the company's executives 4. The cost of renting rooms at a Florida resort for the annual sales conference 5. The cost of packaging the company's product
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…
Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours $ 2,665 2,710 2,760 1 2 3 4 6 7 8 9 10 11 12 2,860 2,895 Maintenance cost 3,045 2,905 2,945 2,820 2,610 2,630 2,930 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the…
Horton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month Maintenance Costs Machine Hours $ 2,695 2,740 2,790 2,890 2,925 3,025 2,935 1 2 3 4 56789012 10 11 2,975 2,850 2,640 2,660 2,960 Maintenance cost 1,620 1,730 1,745 1,795 1,790 1,890 1,810 1,845 1,835 1,480 1,690 1,495 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (uni variable cost)" to 4 decimal places. Enter the "slope…