Star Limited, a management consultancy firm, has operating hours fluctuate from week to week. Its utilities costs and operating hours for the past six weeks are as follow: Week Operating Hours Utilities Cost ($) 1 42 630 2 55 705 3 37 427 33 485 5 39 552 41 637 Required: a) Use the high-low method to estimate the cost behaviour for the company's utilities costs, assuming that variable costs vary in proportion to the hours of operation. Express the cost behaviour in a cost function (Y = a + bX). b) Star Limited is expected to be operated for 45 hours in next week. Predict the company's total utilities cost for the week

Star Limited, a management consultancy firm, has operating hours fluctuate from week to week. Its utilities costs and operating hours for the past six weeks are as follow: Week Operating Hours Utilities Cost ($) 1 42 630 2 55 705 3 37 427 33 485 5 39 552 41 637 Required: a) Use the high-low method to estimate the cost behaviour for the company's utilities costs, assuming that variable costs vary in proportion to the hours of operation. Express the cost behaviour in a cost function (Y = a + bX). b) Star Limited is expected to be operated for 45 hours in next week. Predict the company's total utilities cost for the week

Managerial Accounting

15th Edition

ISBN:9781337912020

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

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

Chapter7: Variable Costing For Management analysis

Section: Chapter Questions

Problem 8E: Estimated income statements, using absorption and variable costing Prior to the first month of...

See similar textbooks

Similar questions

SmokeCity, Inc., manufactures barbeque smokers. Based on past experience, SmokeCity has found that its total annual overhead costs can be represented by the following formula: Overhead cost = 543,000 + 1.34X, where X equals number of smokers. Last year, SmokeCity produced 20,000 smokers. Actual overhead costs for the year were as expected. Required: 1. What is the driver for the overhead activity? 2. What is the total overhead cost incurred by SmokeCity last year? 3. What is the total fixed overhead cost incurred by SmokeCity last year? 4. What is the total variable overhead cost incurred by SmokeCity last year? 5. What is the overhead cost per unit produced? 6. What is the fixed overhead cost per unit? 7. What is the variable overhead cost per unit? 8. Recalculate Requirements 5, 6, and 7 for the following levels of production: (a) 19,500 units and (b) 21,600 units. (Round your answers to the nearest cent.) Explain this outcome.
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. TotalLaborCost=5,237+(7.40EmployeeHours) 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:
Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.
The following information pertains to Vladamir, Inc., for last year: There are no work-in-process inventories. Normal activity is 100,000 units. Expected and actual overhead costs are the same. Costs have not changed from one year to the next. Required: 1. How many units are in ending inventory? 2. Without preparing an income statement, indicate what the difference will be between variable-costing income and absorption-costing income. 3. Assume the selling price per unit is 29. Prepare an income statement using (a) variable costing and (b) absorption costing.
The following data were adapted from a recent income statement of Caterpillar Inc. (CAT) for the year ended December 31: Assume that 8,500 million of cost of goods sold and 4,000 million of selling, administrative, and other expenses were fixed costs. Inventories at the beginning and end of the year were as follows: Also, assume that 30% of the beginning and ending inventories were fixed costs. a. Prepare an income statement according to the variable costing concept for Caterpillar Inc. Round numbers to nearest million. b. Explain the difference between the amount of operating income reported under the absorption costing and variable costing concepts. Round numbers to nearest million.
The total cost for monthly supervisory cost in a factory is 4,500 regardless of how many hours the supervisor works or the quantity of output achieved. This cost a. is strictly variable. b. is strictly fixed. c. is a mixed cost. d. is a step cost. e. cannot be determined from this information.
Ripley, Inc., costs products using a normal costing system. The following data are available for last year: Overhead is applied on the basis of direct labor hours. Required: 1. What was the predetermined overhead rate? 2. What was the applied overhead for last year? 3. Was overhead over- or underapplied, and by how much? 4. What was the total cost per unit produced (carry your answer to four significant digits)?
Pattison Products, Inc., began operations in October and manufactured 40,000 units during the month with the following unit costs: Fixed overhead per unit = 280,000/40,000 units produced = 7. Total fixed factory overhead is 280,000 per month. During October, 38,400 units were sold at a price of 24, and fixed marketing and administrative expenses were 130,500. Required: 1. Calculate the cost of each unit using absorption costing. 2. How many units remain in ending inventory? What is the cost of ending inventory using absorption costing? 3. Prepare an absorption-costing income statement for Pattison Products, Inc., for the month of October. 4. What if November production was 40,000 units, costs were stable, and sales were 41,000 units? What is the cost of ending inventory? What is operating income for November?
Income Statements under Absorption and Variable Costing In the coming year, Kalling Company expects to sell 28,700 units at 32 each. Kallings controller provided the following information for the coming year: Required: 1. Calculate the cost of one unit of product under absorption costing. 2. Calculate the cost of one unit of product under variable costing. 3. Calculate operating income under absorption costing for next year. 4. Calculate operating income under variable costing for next year.
Scattergraph, High-Low Method, and Predicting Cost for a Different Time Period from the One Used to Develop a Cost Formula Refer to the information for Farnsworth Company on the previous page. Required: 1. Prepare a scattergraph based on the 10 months of data. Does the relationship appear to be linear? 2. Using the high-low method, prepare a cost formula for the receiving activity. Using this formula, what is the predicted cost of receiving for a month in which 1,450 receiving orders are processed? 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? Use the following information for Problems 3-60 and 3-61: Farnsworth Company has gathered data on its overhead activities and associated costs for the past 10 months. Tracy Heppler, a member of the controllers department, has convinced management that overhead costs can be better estimated and controlled if the fixed and variable components of each overhead activity are known. One such activity is receiving raw materials (unloading incoming goods, counting goods, and inspecting goods), which she believes is driven by the number of receiving orders. Ten months of data have been gathered for the receiving activity and are as follows:
Natur-Gro, Inc., manufactures composters. Based on past experience, Natur-Gro has found that its total annual overhead costs can be represented by the following formula: Overhead cost = 264,000 + 1.42X, where X equals number of composters. Last year, Natur-Gro produced 30,000 composters. Actual overhead costs for the year were as expected. Total overhead for per unit was a. 1.42 b. 8.80 c. 11.63 d. 10.22
Grand Canyon Manufacturing Inc. produces and sells a product with a price of 100 per unit. The following cost data have been prepared for its estimated upper and lower limits of activity: Overhead: Selling and administrative expenses: Required: 1. Classify each cost element as either variable, fixed, or semi-variable. (Hint: Recall that variable expenses must go up in direct proportion to changes in the volume of activity.) 2. Calculate the break-even point in units and dollars. (Hint: First use the high-low method illustrated in Chapter 4 to separate costs into their fixed and variable components.) 3. Prepare a break-even chart. 4. Prepare a contribution income statement, similar in format to the statement appearing on page 540, assuming sales of 5,000 units. 5. Recompute the break-even point in units, assuming that variable costs increase by 20% and fixed costs are reduced by 50,000.