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 W/CONNECT
- 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_forwardHeavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a web site and began selling its products over the Internet. Web-site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the web-site customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the web site, the number of web pages viewed, and the amount spent by each of the 50 customers are contained in the file named Heavenly Chocolates. A portion of the data is shown in the table that follows: Heavenly Chocolates would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. Managerial Report Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. Graphical and numerical summaries for the length of time the shopper spends on the web site, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolates’ online shoppers from these numerical summaries. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Discuss the observations you can make about Heavenly Chocolates’ business based on the day of the week? Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Heavenly Chocolates’ business based on the type of browser? Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings.arrow_forwardHorton Manufacturing Incorporated produces blinds and other window treatments for residential homes and offices. The owner is concerned about the maintenance costs for the production machinery because maintenance costs for the previous fiscal year were higher than he expected. The owner has asked you to assist in estimating future maintenance costs to better predict the firm's profitability. Together, you have determined that the best cost driver for maintenance costs is machine hours. The data from the previous fiscal year for maintenance costs and machine hours follow: Month 1 3 4 6 7 8 9 10 11 12 Maintenance Costs Machine Hours $ 2,665 2,710 2,760 2,860 2,895 3,045 2,905 2,945 2,820 2,610 2,630 2,930 Maintenance cost 1,566 1,670 1,685 1,735 1,855 1,890 1,865 1,885 1,775 1,450 1,630 1,465 Required: 1. Use the high-low method to estimate the fixed and variable portions for maintenance costs. (In your calculations, round "slope (unit variable cost)" to 4 decimal places. Enter the…arrow_forward
- 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: 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_forwardWindows is a small company that installs windows. Its cost structure is as follows: LOADING... (Click the icon to view the cost structure.) Traylor Windows' breakeven revenues is $1,870,000 and breakeven units is 3,400. Calculate the margin of safety in units and dollars and the margin of safety percentage if Traylor Windows expects to sell 3,600 windows in the year. Begin with calculating the margin of safety in dollars. Determine the formula to calculate the margin of safety in dollars. Then, enter the amounts and calculate the margin of safety in dollars. Budgeted revenue - Breakeven revenue = Margin of safety in dollars - = Next, determine the formula, enter the amounts, and calculate the margin of safety in units. Budgeted units - Breakeven units = Margin of safety in units - = Finally, calculate the margin of safety percentage if…arrow_forwardVice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company's profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it mass-produces, Last year, the company sold 630,000 units at an average unit selling price of $4.40. The variable costs were $1,663,200, and the fixed costs were $742,896. Show Transcribed Text Margin of safety in dollars What is the margin of safety, both in dollars and as a ratio? (Round ratio to 0 decimal places, e.g. 25%.) Margin of safety ratio 3 $ Ć %arrow_forward
- Vice President for Sales and Marketing at Waterways Corporation is planning for production needs to meet sales demand in the coming year. He is also trying to determine how the company's profits might be increased in the coming year. This problem asks you to use cost-volume-profit concepts to help Waterways understand contribution margins of some of its products and decide whether to mass-produce any of them. Waterways markets a simple water control and timer that it mass-produces. Last year, the company sold 735,000 units at an average unit selling price of $3.60. The variable costs were $1,852,200, and the fixed costs were $508,032.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 The company's direct labour rate is $19 per hour. Sales Costs: Activity Rates $3 per direct labour-hour $15 per order $50 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service Customer margin Standard Deluxe Model Model 120 35 23 ta ta OSOF 0.20 $ $ 5 35 10 64 $9 $ Required: Using the…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
- Albedo Incorporated manufactures high-end replacement telescope lenses for amateur and professional astronomers who are seeking to upgrade the performance of their telescopes. You have just become employed as a staff accountant at Albedo, and Jordan Coleman, the controller, has asked you to help with maintenance cost estimation for the lens manufacturing process. You review the manufacturing process and decide that the best cost driver for maintenance costs is machine hours. The data below are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours $ 3,210 4,650 5,175 3,350 3,100 1 2 3 4 5 6 7 8 9 10 11 12 2,950 2,900 2,900 4,120 4,350 3,500 3,775 2,750 3,900 4,050 2,690 2,500 2,580 2,300 2,500 3,160 3,325 2,780 3,000 Required: 1. What is the cost equation for maintenance costs using the high-low method? (Round "slope (unit variable cost)" to 2 decimal places. Negative amounts should be indicated by a minus sign.)arrow_forwardNicholson Co sells mobile telephones. It supplies its customers with telephones and wireless telephone connections. Customers pay an annual fee plus a monthly charge based on calls made. The company has recently employed a consultant to install a balanced scorecard system of performance measurement and to benchmark the results against those of Nicholson Co's competitors. Unfortunately the consultant was called away before the work was finished. You have been asked to complete the work. The following data is available. Nicholson Co Operating data for the year ended 30 November 2013 Sales revenue $480 million Sales attributable to new products $8 million Average capital employed $192 million Profit before interest and tax $48 million Average number of customers 1,960,000 Average number of telephones returned for repair each day 10,000 Number of bill queries 12,000 Number of customer complaints 21,600 Number of customers lost 117,600 Average number of telephones unrepaired at the end of…arrow_forwardNicholson Co sells mobile telephones. It supplies its customers with telephones and wireless telephone connections. Customers pay an annual fee plus a monthly charge based on calls made.The company has recently employed a consultant to install a balanced scorecard system of performance measurement and to benchmark the results against those of Nicholson Co’s competitors. Unfortunately the consultant was called away before the work was finished. You have been asked to complete the work. The following data is available.Nicholson Co Operating data for the year ended 30 November 2013 Sales revenue $480 millionSales attributable to new products $8 millionAverage capital employed $192 millionProfit before interest and tax $48 millionAverage numbers of customers 1,960,000Average number of telephones returned for repair each year 10,000Number of bill queries 12,000Number of customer complaints 21,600Number of customers lost 117,600Average number of telephones unrepaired at the end of each day…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel 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