Utilities cost is probably a mixed cost

Assignment Help Financial Accounting

Reference no: EM13929408

Pleasant View Hospital of British Columbia has just hired a new chief administrator who is anxious to employ sound management and planning techniques in the business affairs of the hospital. Accordingly, she has directed her assistant to summarize the cost structure of the various departments so that data will be available for planning purposes.

The assistant is unsure how to classify the utilities costs in the Radiology Department because these costs do not exhibit either strictly variable or fixed cost behavior. Utilities costs are very high in the department due to a CAT scanner that draws a large amount of power and is kept running at all times. The scanner can’t be turned off due to the long warm-up period required for its use. When the scanner is used to scan a patient, it consumes an additional burst of power. The assistant has accumulated the following data on utilities costs and use of the scanner since the first of the year.

Month	Number of Scans	Utilities Cost
January	140	$5,600
February	120	$4,600
March	110	$4,500
April	130	$5,100
May	210	$7,400
June	200	$7,000
July	100	$5,400
August	90	$4,600
September	80	$4,800
October	70	$3,200

The chief administrator has informed her assistant that the utilities cost is probably a mixed cost that will have to be broken down into its variable and fixed cost elements by use of a scattergraph. The assistant feels, however, that if an analysis of this type is necessary, then the high-low method should be used, since it is easier and quicker. The controller has suggested that there may be a better approach.

Required:

1.Using the high-low method, estimate a cost formula for utilities. Express the formula in the form Y = a + bX. (The variable rate should be stated in terms of cost per scan.)

2.Prepare a scattergraph by plotting the number of scans and utility cost on a graph.

Instructions:

1. On the graph below, use the point tool (Jan) to plot utilities cost on the vertical axis and the number of scans on the horizontal axis.

2. Repeat the same process for the plotter tools (Feb, Mar, Apr, May, June, July, Aug, Sep, Oct).

3. To enter exact coordinates, click on the point and enter the values of x and y.

4. To remove a point from the graph, click on the point and select delete option.

Reference no: EM13929408

Questions Cloud

Break-even point in units and sales dollars : Determine Cove’s break-even point in units and sales dollars. (Round your Break-Even Units answer to the nearest whole number. Round your other intermediate calculations and sales dollars answer to 2 decimal places.)

Projected financial information : Break-even Analysis- Single Product Whirlpool is considering selling delux refrigerators for residential use. Projected financial information related to this project follows (this is the base case or budget): Selling price $3,000 per unit Variable Co..

Job cost sheet for this job. : Compute the unit product cost that would appear on the job cost sheet for this job. (Round your answer to 2 decimal places. Omit the "$" sign in your response.)

Customers and suppliers were conducted in cash : Prepare the appropriate journal entry for each of the items above (a. through j.). You can assume that all transactions with employees, customers, and suppliers were conducted in cash. (Round your answers to the nearest dollar amount. Omit the "$" si..

Utilities cost is probably a mixed cost : The chief administrator has informed her assistant that the utilities cost is probably a mixed cost that will have to be broken down into its variable and fixed cost elements by use of a scattergraph. The assistant feels, however, that if an analysis..

Traditional format, with costs organized by function : Prepare an income statement for Marwick’s Pianos, Inc., for August. Use the traditional format, with costs organized by function. (A "Net operating loss" should be entered as a negative number

Variable or fixed with respect to number of units produced : .Enter the dollar amount of each cost item under the appropriate headings. Note that each cost item is classified in two ways: first, as variable or fixed with respect to the number of units produced and sold; and second, as a selling and administrat..

A one year contract to supply the case : Chinese manufacturer has offered a one-year contract to supply the cases at a cost of $4 per unit. If Nantucket Optics accepts the offer, it will be able to reduce variable manufacturing costs by 10%, reduce fixed costs by $1,500, and rent out some f..

Total variable cost : or the activity level of 3,200 units, compute: (a) the total variable cost; (b) the total fixed cost; (c) the total cost; (d) the average variable cost per unit; (e) the average fixed cost per unit; and (f) the average total cost per unit. Assume tha..

User Account

All Pages