Concept introduction:
Mixed Costs:
There are three types of costs according to the unit of production; Variable, Fixed and Mixed. Variable costs change proportionally with the number of units produced and variable cost per unit remains constant. Fixed Cost remains same in totality irrespective of the number of units produced.
The mixed cost is the mix of variable and fixed cost, some of its part is fixed and some variable.
High-Low Method:
This method is used to determine the fixed as well as variable part of the mixed cost. The formula for calculation of variable cost per unit is as follows:
The formula to calculate the Fixed Cost is as follows:
To calculate:
The Total Fixed operating costs and Variable operating cost per unit
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Managerial Accounting
- DeMarco Company is developing a cost formula for its packing activity. Discussion with the workers in the Packing Department has revealed that packing costs are associated with the number of customer orders, the size of the orders, and the relative fragility of the items (more fragile items must be specially wrapped in bubble wrap and Styrofoam). Data for the past 20 months have been gathered: Required: 1. Using the method of least squares, run a regression using the number of orders as the independent variable. 2. Run a multiple regression using three independent variables: the number of orders, the weight of orders, and the number of fragile items. Which regression equation is better? Why? 3. Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with 4,000 fragile items.arrow_forwardLog Cabins Unlimited constructs vacation houses in the North Carolina mountains. The company has developed the following value chart: a. How much of the total time is value-added time? ______ hours b. How much total time is spent performing non-value-added activities? ______ hours c. Calculate the manufacturing cycle efficiency of the process. Note: Round the percentage to one decimal point (i.e. show 14.445% as 14.4%). ______%arrow_forwardJava Joe coffees wants to find an equation to estimate monthly utility costs. Java Joe's has been in business for one year and has collected the following cost data for utilities 1.which of the preceding costs is variable? Fixed? Mixed? Explain 2. using the high-low method, determine the cost function for each cost 3. combine the preceding information to get a monthly utility cost function for Java 4. next month, Java's expects to use 2200 kilowatt hours of electricity, make 1500 minutes of telephone calls and use 32000 gallons of water. Estimate total cost of utilities for the month Month Electricity bill Kilowatt hours used telefone telefone min used Water bill Gallonsof water used January $360 1200 $92.00 1100 $60 30560 February $420 1400 $91.80 1060 $60 26800 March $549 1830 $94.80 1240 $60 31450 April $405 1350 $89.60 980 $60 29965 May $588 1960 $98.00 1400 $60 30568 June $624 2080…arrow_forward
- herri’s Tan-O-Rama is a local tanning salon. Its regression output is as follows: Coefficients Intercept 4,630.34 X Variable 1 2.33 Suppose that the company charges $7.20 per tanning session. Required: 1. Calculate the unit contribution margin.2. Calculate contribution margin ratio.3. Calculate the total contribution margin if the shop books 1,400 tanning sessions this month. Complete this question by entering your answers in the tabs below. Unit CM CM Ratio Total CM Calculate the unit contribution margin. (Round your final answer to 2 decimal places.) = Unit Contribution Margin Unit CM CMarrow_forwardStable Paper Delivery has decided to analyze the profitability of five new customers. It buys recycled paper at $12 per case and sells to retail customers at a list price of $14.80 per case. Data pertaining to the five customers are: E (Click the icon to view the data.) Stable Paper Delivery's five activities and their cost drivers are as follows: E (Click the icon to view the activities and cost drivers.) Read the requirements. Requirement 1. Compute the customer-level operating income of each of the five retail Begin by calculating each customer's gross margin. Then calculate the operating incom minus sign for operating losses.) Requirements 1 2 1. Compute the customer-level operating income of each of the five retail customers now being examined (1, 2, 3, 4, and 5). Comment on the results. 2. What insights do managers gain by reporting both the list selling price and the actual selling price for each customer? 3. What factors should managers consider in deciding whether to drop one…arrow_forwardThe managerial accountant at Organic Beverage Factory used spreadsheet software to run a regression analysis scenario and compile the following monthly cost data: Organic Beverage Factory Intercept coefficient X Variable 1 Coefficient $4,286,652 $28.21 R-square 0.6521 Which of the following is the correct cost equation showing the correlation of monthly costs, based on the results of the regression analysis compiled by the managerial accountant? O A. y $4,286,652 $28.21 O B. y $0.6521 $28.21x O C. y $28.21x + $4,286,652 O D. y 0.6521x + $4,286,652arrow_forward
- 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 = $arrow_forwardMethod 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;…arrow_forwardPlot the relationship between promotional costs and ticket revenues. Also draw the regression line and evaluate it using the criteria of economic plausibility, goodness of fit, and slope of the regression line.arrow_forward
- Method of Least Squares Refer to the information for Luisa Crimini on the previous page. Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Based on the regression output, write the cost formula for tanning. (Note: Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.) 2. Using the formula computed in Requirement 1, what is the predicted cost of tanning services for September for 2,500 appointments? Use the following information for Exercises 3-44 through 3-46: Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:arrow_forwardManagement would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders. Direct labour-hours per case Selling price per case. Direct materials cost per case Sales Costs: Direct materials Direct labour Supporting manufacturing Order processing Customer service The company's direct labour rate is $30 per hour. Required: Using the company's ABC system, compute the customer margin of Cell City. Customer margin Standard Model 290 5 0.25 $49 $ 26 70 Deluxe Model 105 2 $ 0.40 $ 69 $29 70 (70)arrow_forwardColby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost pools and activity rates for these models: Activity Cost Pool Supporting manufacturing Order processing Customer service Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders Direct labour-hours per case Selling price per case Direct materials cost per case. Sales Costs: Activity Rates $2 per direct labour-hour $19 per order $60 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service The company's direct labour rate is $20 per hour. Required: Using the company's ABC system, compute the customer margin of Cell City. Customer margin Standard Model…arrow_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 LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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