Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period That Differs from the Data Period
Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost.
Required:
Assume that 4,000 employee hours are budgeted for the coming year. Use the total labor cost formula to make the following calculations:
- 1. Calculate total variable labor cost for the year.
- 2. Calculate total fixed labor cost for the year.
- 3. Calculate total labor cost for the coming year.
Use the following information for Brief Exercises 3-17 through 3-20:
Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected:
Trending nowThis is a popular solution!
Chapter 3 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Speedy Petes on the previous page. Coefficients shown by a regression program for Speedy Petes data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of deliveries and the variable rate per delivery. 2. Construct the cost formula for total delivery cost. 3. Calculate the budgeted cost for next month, assuming that 3,000 deliveries are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-26 through 3-29: Speedy Petes is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows:arrow_forwardMethod of Least Squares, Predicting Cost for Different Time Periods from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. However, assume that Tracy has used the method of least squares on the receiving data and has gotten the following results: Required: 1. Using the results from the method of least squares, prepare a cost formula for the receiving activity. 2. Using the formula from Requirement 1, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? (Note: Round your answer to the nearest dollar.) 3. Prepare a cost formula for the receiving activity for a quarter. Based on this formula, what is the predicted cost of receiving for a quarter in which 4,650 receiving orders are anticipated? Prepare a cost formula for the receiving activity for a year. Based on this formula, what is the predicted cost of receiving for a year in which 18,000 receiving orders are anticipated?arrow_forwardUsing High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Pizza Vesuvio on the previous page. Assume that this information was used to construct the following formula for monthly labor cost. TotalLaborCost=5,237+(7.40EmployeeHours) Required: Assume that 675 employee hours are budgeted for the month of September. Use the total labor cost formula for the following calculations: 1. Calculate total variable labor cost for September. 2. Calculate total labor cost for September.arrow_forward
- Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for Budgeted Output Refer to the information for Speedy Petes above. Assume that this information was used to construct the following formula for monthly delivery cost. TotalDeliveryCost=41,850+(12.00NumberofDeliveries) Required: Assume that 3,000 deliveries are budgeted for the following month of January. Use the total delivery cost formula for the following calculations: 1. Calculate total variable delivery cost for January. 2. Calculate total delivery cost for January.arrow_forwardUsing Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Employee Hours Month January February March April May June July August Labor Cost $7,000 8,140 9,899 9,787 8,490 7,450 9,490 7,531 Coefficients shown by a regression program for Pizza Vesuvio's data are: 360 550 630 600 480 350 570 310. Intercept 4,497 X Variable 8.26 In your calculations, round the variable rate per employee hour to the nearest cent. Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor. 17,430 X Calculate the variable rate per employee hour. 7.40 X per employee hourarrow_forwardWrite a linear cost function equation for each of the following conditions. Use y for estimated costsand X for activity of the cost driver. Machine operating costs include $1,000 of maintenance per month, and $15.00 of coolant usagecosts for each day the machinery is in operation.arrow_forward
- Write a linear cost function equation for each of the following conditions. Use y for estimated costsand X for activity of the cost driver.a. Direct materials cost is $2.70 per pound b. Total cost is fixed at $800 per month regardless of the number of units produced. c. Auto rental has a fixed fee of $90.00 per day plus $1.75 per mile driven. d. Machine operating costs include $1,000 of maintenance per month, and $15.00 of coolant usagecosts for each day the machinery is in operation.arrow_forwardThe table below shows monthly data collected on production costs and on the number of units produced over a twelve-month period. a) Determine the variable cost per unit and the fixed cost using the high-low method.b) What is the equation of the total mixed cost function?c) Prepare the scatter diagram, clearly showing any outliers.d) Using the line of best-fit, determine the company’s fixed cost per month and the variable cost per unit. (Use 0 & 5,000 units.)e) In view of the department’s cost behavior pattern, which of the two methods appear more appropriate? Explain your answer.arrow_forwardRefer to the data given below.Required:1. Draw a scatter diagram and graph the company’s energy cost behavior using the visual-fit method.2. Predict the energy cost for a month in which 26,000 pints of applesauce are produced.3. What peculiarity is apparent from the scatter diagram? What should the cost analyst do?arrow_forward
- Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January $7,000 360 February 8,140 550 March 9,899 630 April 9,787 600 May 8,490 480 June 7,450 350 July 9,490 570 August 7,531 310 Coefficients shown by a regression program for Pizza Vesuvio's data are: Intercept 4,497 X Variable 8.26 In your calculations, round the variable rate per employee hour to the nearest cent. Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of labor.$fill in the blank 1 Calculate the variable rate per employee hour.$fill in the blank 2per employee hour 2. Construct the cost formula for total labor cost.Total labor cost = $fill in the blank 3 + ($fill in the blank 4 × Employee hours) 3. Calculate the budgeted…arrow_forwardUse 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.arrow_forwardTracey Packaged Snax reports the following information for November: Units produced and sold Per unit revenue and costs: Sales revenue Direct materials costs Direct labor costs Variable manufacturing overhead Fixed manufacturing overhead (at 320,000 units) Variable marketing and administrative costs Fixed marketing and administrative costs (at 320,000 units) Required: a. Prepare a gross margin income statement. b. Prepare a contribution margin income statement. Complete this question by entering your ansivers in the tabs below. Required A Required B Prepare a contribution margin income statement. Contribution Margin Income Statement 320,000 $9.60 1.65 0.90 0.80 1.55 0.75 1.15arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College