Culver World provided the following data concerning its costs of operating and the number of riders of its Scream ride and the relatedlinear regression for selected operation months:RidersOperating costsJanuary$2.40$1.84$1.94O $2.052900$8640February March April2800$851023002210May2500$7490 $6984 $7910Using the high-low method, what is the unit variable cost for the Scream ride?June2700$8580

The high-low method is used to differentiate the mixed costs. Mixed cost is the combination of fixed…

Culver World provided the following data concerning its costs of operating and the number of riders of its Scream ride and the related linear regression for selected operation months: Riders Operating costs January O $2.40 O $1.84 O $1.94 O $2.05 2900 $8640 February March 2300 2700 $8510 $7490 $6984 $7910 $8580 2800 April 2210 May 2500 Using the high-low method, what is the unit variable cost for the Scream ride? June

Culver World provided the following data concerning its costs of operating and the number of riders of its Scream ride and the related linear regression for selected operation months: Riders Operating costs January O $2.40 O $1.84 O $1.94 O $2.05 2900 $8640 February March 2300 2700 $8510 $7490 $6984 $7910 $8580 2800 April 2210 May 2500 Using the high-low method, what is the unit variable cost for the Scream ride? June

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter28: Statistics And Linear Regression (stats)

Section: Chapter Questions

Problem 1R

See similar textbooks

Similar questions

Use the high-low method to estimate the variable cost per tour mile traveled and the fixed cost per month. Develop a formula to express the cost behavior exhibited by the company’s maintenance cost. Round "Variable cost per tour mile" to 3 decimal places.
Jensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. What does the scatter chart indicate about the relationship between weekly usage and annual maintenance expense? b. Use the data to develop an estimated regression equation that could be used to predict the annual maintenance expense for a given number of hours of weekly usage. What is the estimated regression model? c. Test whether each of the regression parameters 0 and 1 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? d. How much of the variation in the sample values of annual maintenance expense does the model you estimated in part (b) explain? e. If the maintenance contract costs 3,000 per year, would you recommend purchasing it? Why or why not?
The following activity and cost data that were provided by Hoist Corporation would help in estimating its future maintenance costs: Units Maintenance cost P1,350 7. P1,590 11 P1,920 15 P2.100 Using the least squares regression method to estimates the cost formula, the expected total cost for an activity level of 10 units would be closest to (nearest peso) e.g. 1405.688888, Type 1406 3.
Given the following cost and activity observations for Bounty Company's utilities, use the high-low method to determine Bounty's variable utilities cost per machine hour. Round your answer to the nearest cent. Cost Machine Hours March $3,091 14,781 April 2,676 9,929 May 2,812 11,845 June 3,520 17,889 a.$0.49 b.$0.53 c.$0.11 d.$1.17
Determining mixed costs—the high-low method The manager of Trusty Car inspection reviewed the monthly operating costs for the past year. The costs ranged from $4,300 for 1,300 inspections to $3,900 for 900 inspections. Requirements Use the high—low method to calculate the variable cost per inspection. Calculate the total fixed costs. Write the equation and calculate the operating costs for 1,000 inspections. Draw a graph illustrating the total cost under this plan. Label the axes, and show the costs at 900, 1,000, and 1,300 inspections.
Data table Month Total Cost Machine Hours January.. 3,420 1,090 February..... S 3,760 1,120 March .... $ 3,532 1,080 April ..... 3,720 1,220 May S 4,800 1,330 June 4,192 1,480 .. %24 %24
Method of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received: Intercept 175,600 Slope 455 The cost driver used was number of parts inspected. Required: 1. What is the cost formula? Total cost of receiving = $ + ( $ × ) 2. Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month. Independent variable Dependent variable Variable rate per professional hour per part inspected Fixed cost per month 3. Using the cost formula, predict the cost of receiving for a month in which 7,200 parts are inspected. Total cost of receiving = $
Method of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received: Intercept 147,400 Slope 210 The cost driver used was number of parts inspected. Required: 1. What is the cost formula? Total cost of receiving = $ + ( $ × ) 2. Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month. Independent variable Dependent variable Variable rate per professional hour per part inspected Fixed cost per month 3. Using the cost formula, predict the cost of receiving for a month in which 6,800 parts are inspected. Total cost of receiving = $ Identifying the Parts of the Cost Formula;…
Philippine Island Tours has incurred the following bus maintenance costs during the recent tourist season. Answer the following: Using the high-low method, determine which month is the highest? Using the high-low method, determine which month is the lowest? Using the high-low method, determine the variable cost per tour mile traveled. (Use this format 0..123) Using the high-low method, determine fixed cost per month (Use this format 10,000) Using the high-low method Develop a formula to express the cost behavior exhibited by the company’s maintenance cost. (Use this format Y=2a+10) Using the high-low method, predict the level of maintenance cost that would be incurring during the month of May when 34,000 tour miles are driven. (Use this format 10,000)
The following activity and cost data that were provided by Hoist Corporation would help in estimating its future maintenance costs: Units Maintenance cost P1,350 7 P1,590 11 P1,920 15 P2,100 Using the least squares regression method to estimates the cost formula, the expected total cost for an activity level of 10 units would be closest to:
Given the following cost and activity observations for Bounty Company's utilities, use the high-low method to determine Bounty's variable utilities cost per machine hour. Round your answer to the nearest cent. Cost Machine Hours March $3,107 14,586 April 2,674 10,257 May 2,816 12,190 June 3,767 17,550 Oa. S1.80 Оb. so.15 Oc. S0.71 Od. S0.75 Previous Next MacBook Air
Given the following cost and activity observations for Bounty Company's utilities, use the high-low method to determine Bounty's variable utilities cost per machine hour. Round your answer to the nearest cent. Cost Machine Hours March $3,142 15,489 April 2,691 10,041 May 2,810 11,509 4 June 3,881 18,009 a. $0.15 b. $1.05 O c. $1.64 Od. $1.01 10:21 PM 670002 K 63°F