Markowis Company accumulates the following data concerning a mixed cost, using miles as the activity level. Miles Total Miles Total Driven Cost Driven Cost January 7,920 $13,004 March 8,480 $13,324 February 7,500 12,050 13,174 Compute the variable and fixed cost elements using the high-low April 8,240 method.

Markowis Company accumulates the following data concerning a mixed cost, using miles as the activity level. Miles Total Miles Total Driven Cost Driven Cost January 7,920 $13,004 March 8,480 $13,324 February 7,500 12,050 13,174 Compute the variable and fixed cost elements using the high-low April 8,240 method.

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4E: Using the data in E4-2 and spreadsheet software, determine: The variable cost per unit, the total...

See similar textbooks

Similar questions

Choose the correct letter of answer On a scattergrap, the diagonal line cuts across two sets of observations, namely: 600:200, and 900:500 which refer to costs and units, respectively. The fixed costs is plotted in the graph at P400. In this case, the variable cost per unit is equal to: a. P1.00b. P1.25c. P1.50d. P1.12
IN EXCEKL FORMAT
1. You have been provided with the following data regarding shipments and costs for Brighton Boutiques: Number of Shipments Received Cost per Receiving Report $202 185 120 105 70 80 87 115 100 $300 $200 $100 $- 0 142 154 20 162 Required: Plot the data points on a scatter graph, and then using the high-low method, determine the cost function of the line that will connect the high and low points on the graph. Does the cost function appear to be linear in nature? 200 175 Graph Template 40 80 60 Number of Shipments 100 120 140
Q3. ADLG Company has two support departments, SS1 and SS2, and two operating departments, OD1 and OD2. The company has decided to use the direct method and allocate variable SS1 dept. costs based on the number of transactions and fixed SS1 dept. costs based on the number of employees. SS2 dept. variable costs will be allocated based on the number of service requests and fixed costs will be allocated based on the number of computers. The following values have been extracted for the allocation | Total Department variable costs Total department fixed costs Number of transactions Number of employees Number of service requests Number of computers Support Departments SS1 16,000 19,500 50 18 37 20 SS2 19,000 34,000 You are required to allocate variable and fixed costs. 55 24 22 25 Operating Departments OD1 105,000 120,000 250 47 26 31 OD2 68,000 55,000 140 38 32 37
High-low method Evander Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the t cost. The data for various levels of production are as follows: Units Produced Total Costs 2,100 3,770 5,600 $245,700 332,790 382,200 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input answers in the questions below. X Open spreadsheet a. Determine the variable cost per unit and the total fixed cost. Variable cost $ Total fixed cost $ 36 X b. Based on part (a), estimate the total cost for 2,770 units of production. Total cost for 2,770 units
Use the following information about sales and costs to prepare a scatter diagram. Draw a cost line that reflects the behavior displayed by this cost. Determine whether the cost is variable, step-wise, fixed, mixed, or curvilinear. Period Sales Costs Period Sales Costs $760 $590 9. $580 $390 2. 800 560 10. 320 240 3. 200 230 II. 240 230 4 400 400 12. 720 550 5 480 390 13 280 260 6 620 550 14. 440 410 7 680 590 15 380 260 8 540 430
Felix & Company reports the following information. Period Units Produced Total Costs 1 0 $2,595 2 400 3,235 3 800 3,875 4 1,200 4,515 5 1,600 5,155 6 2,000 5,795 7 2,400 6,435 8 2,800 7,075 9 3,200 7,715 10 3,600 8,355 Use spreadsheet software to use ordinary least-squares regression to estimate the cost equation, including fixed and variable cost amounts.
The MTN Company has assembled the following data pertaining to certain costs which cannot be easily identified as either fixed or variable. MTN has heard about a method of measuring cost functions called the high-low method and has decided to use it in this situation Cost Hours $100,000 3,500 61,o00 2,000 85,000 2,600 78,200 2,450 91,000 3,000 110,400 3,900 106,000 3,740 93,000 3,380 Calculate the variable cost per hour Calculate the total fixed costs Write the equation which measures the cost behavior of the costs Calculate the operating costs for 3,750
Falsetta Corporation makes three products that use the current constraint, which is a particular type of machine. Data concerning those products appear below: ZA JK DHSelling price per unit........................ $402.67 $462.82 $374.06Variable cost per unit....................... $307.53 $344.56 $285.56Time on the constraint (minutes) ...... 6.70 7.30 5.90 Required:a. Rank the products in order of their current profitability from the most profitable to the least profitable. In other words, rank the products in the order in which they should be emphasized. Show your work! b. Assume that sufficient constraint time is available to satisfy demand for all but the least profitable product. Up to how much should the company be willing to pay to acquire more of the constrained resource?
An analyst built the following spreadsheet, complete with named ranges (for example, cell B2 is named "Unit_Price" based on the heading in cell A2). A 2 Unit Price 11 3 Unit Cost 5.55 4. Unit Gross Profit Unit_Price Unit_Cost Quantity Sold 5,600 8 Gross Revenue = Quantity_Sold x Unit_Price Variable Costs = Quantity_Sold x Unit_Cost 9 10 Fixed Costs 2,500 11 Net Profit = Gross Revenue - Variable Costs Fixed Costs 12 Profit per Unit = Net_Profit/Quantity_Sold After entering the data shown below in cells B2, B3, B6, and B10, what values should appear in the following cells? (Round your "Unit Gross Profit and Profit per Unit" answers to 2 decimal places.) Cell Value B4 (Unit_Gross_Profit) B8 (Gross_Revenue) B9 (Variable_Costs) B11 (Net Profit) B12 (Profit_per_Unit)
Hardev
sing the following data, apply the high-low method of cost analysis to the three cost data groups: Volume Alpha Beta Gamma 2,000 $6,600 $2,400 $8,000 6,000 $9,800 $7,000 $8,000 13,000 $13,000 $12,000 $8,000 20,000 $21,000 $24,000 $8,000 What cost behavior patterns are apparent for Beta? Select one: a. Fixed b. Variable c. Mixed d. Semi-fixed e. None of the above