Fundamentals of Cost Accounting
6th Edition
ISBN: 9781260708783
Author: LANEN, William
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 5, Problem 55P
Regressions from Published Data
Obtain 13 years of data from the published financial statements of a company. You will be able to find the data on the Internet. Also, Moody’s, Standard & Poor’s, and Value Line are good sources of financial data. Using the first 12 years of data, perform a regression analysis in which the dependent variable is cost of goods sold and the independent variable is revenue (some companies call it sales).
Required
- a. Use the results from the regression on the first 12 years of data to estimate the cost of goods sold for year 13. How far off was your estimate of cost of goods sold for year 13?
- b. Prepare a report that describes your work and discusses reasons why your estimate of cost of goods sold is different than the actual cost of goods sold for year 13.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
1. The annual net income of MAC Industries since 2005 is given
below.
Years t (since 2005)
Net Income
1
4
6
12
15
$1,500 $2,500 $2,875 $2,850 $2,250
a. Create a scatter plot that includes your curve of best fit on
top of the data. You should try several functions and make
your choice based on best r-squared value.
b. Find the year that Net Income was at its highest point.
c. What was the income in that year?
The initial analysis should include the following:
The ratio equation
The calculation of the ratio using the equation and the pre-assigned Quick Study or Exercise from the textbook. (See below)
Use the result in a sentence; i.e. For every dollar invested in assets the company is earning 22.4 cents or 22.4% in net income.
Then explain whether this is a good result or a result that needs improving.
Use citations to cite any outside sources used.
The original post should include at least three (3) sentences but no more than seven (7) sentences.
SHOW WORK
Paul Sabin has also gathered the following financial data and ratios that are typical of companies in the electronics industry:
Current Ratio 2.5
Acid-Test Ratio 1.3
Average Collection period 18 Days
Average Sales Period 60 Days
Debt-to-Equity Ratio 0.90
Times Interest Earned Ratio 6.0
Comment on the results of your analysis (1) and (2) from the screenshots and images shown and compare Sabin Electronics’ performance to the benchmarks from the electronics industry. Do you think that the company is likely to get its loan application approved?
Chapter 5 Solutions
Fundamentals of Cost Accounting
Ch. 5 - What are the common methods of cost estimation?Ch. 5 - Prob. 2RQCh. 5 - Under what conditions is the engineering estimates...Ch. 5 - If one wishes simply to prepare a cost estimate...Ch. 5 - When using cost estimation methods based on past...Ch. 5 - Prob. 6RQCh. 5 - What is the difference between R2 and adjusted R2?Ch. 5 - Why are accurate cost estimates important?Ch. 5 - What are three practical implementation problems...Ch. 5 - Why is it important to incorporate learning into...
Ch. 5 - What are some complications that can arise when...Ch. 5 - The following costs are labeled fixed or variable...Ch. 5 - Prob. 13CADQCh. 5 - When preparing cost estimates for account analysis...Ch. 5 - How can one compensate for the effects of price...Ch. 5 - Prob. 16CADQCh. 5 - Prob. 17CADQCh. 5 - A decision maker is interested in obtaining a cost...Ch. 5 - Consider the Business Application item Using...Ch. 5 - A friend comes to you with the following problem....Ch. 5 - After doing an account analysis and giving the...Ch. 5 - In doing cost analysis, you realize that there...Ch. 5 - Prob. 23CADQCh. 5 - Are learning curves likely to affect materials...Ch. 5 - McDonalds, the fast-food restaurant, is known for...Ch. 5 - Prob. 26CADQCh. 5 - A manager asks you for a cost estimate to open a...Ch. 5 - Prob. 28CADQCh. 5 - Methods of Estimating Costs: Engineering Estimates...Ch. 5 - Prob. 30ECh. 5 - Methods of Estimating Costs: Engineering Estimates...Ch. 5 - Prob. 32ECh. 5 - Methods of Estimating Costs: Account Analysis The...Ch. 5 - Methods of Estimating Costs: Account Analysis...Ch. 5 - Methods of Estimating Costs: High-Low, Ethical...Ch. 5 - Methods of Estimating Costs: High-Low Adriana...Ch. 5 - Methods of Estimating Costs: High-Low
Adriana...Ch. 5 - Prob. 38ECh. 5 - Adriana Corporation manufactures football...Ch. 5 - Methods of Estimating Costs: Simple...Ch. 5 - Prob. 41ECh. 5 - Methods of Estimating Costs: High-Low Davis Stores...Ch. 5 - Methods of Estimating Costs: Scattergraph Prepare...Ch. 5 - Prob. 44ECh. 5 - Interpretation of Regression Results: Multiple...Ch. 5 - Interpretation of Regression Results Brodie...Ch. 5 - Prob. 47ECh. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Learning Curves Assume that General Dynamics,...Ch. 5 - Learning Curves Assume that Whee, Cheatham, and...Ch. 5 - Prob. 51ECh. 5 - Learning Curves (Appendix B) Refer to the example...Ch. 5 - Prob. 53PCh. 5 - Prob. 54PCh. 5 - Regressions from Published Data Obtain 13 years of...Ch. 5 - Prob. 56PCh. 5 - High-Low Method, Scattcrgraph Cubicle Solutions...Ch. 5 - High-Low Method, Scattcrgraph Academy Products...Ch. 5 - High-Low, Scattergraph, Issues with Data
Wyoming...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results: Multiple...Ch. 5 - Interpretation of Regression Results: Simple...Ch. 5 - Interpretation of Regression Results Brews 4 U is...Ch. 5 - Cost Estimation: Simple Regression The following...Ch. 5 - Prob. 68PCh. 5 - Methods of Cost Analysis: Account Analysis, Simple...Ch. 5 - Learning Curves (Appendix B) Refer to the example...Ch. 5 - Learning Curves (Appendix B) Krylon Company...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.arrow_forwardFinancial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an accounting intern, who has asked for your guidance on how to prepare an income statement format that will be distributed to management. Subtotals and totals are included in the information, but you will need to calculate the values. A. In the correct format, prepare the income statement using the following information: B. Calculate the profit margin, return on investment, and residual income. Assume an investment base of $100,000 and 6% cost of capital. C. Prepare a short response to accompany the income statement that explains why uncontrollable costs are included in the income statement.arrow_forwardConsider again the example introduced in Section 7.5 of a credit card company that has a database of information provided by its customers when they apply for credit cards. An analyst has created a multiple regression model for which the dependent variable in the model is credit card charges accrued by a customer in the data set over the past year (y), and the independent variables are the customers annual household income (x1), number of members of the household (x2), and number of years of post-high school education (x3). Figure 7.23 provides Excel output for a multiple regression model estimated using a data set the company created. a. Estimate the corresponding simple linear regression with the customers annual household income as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers annual household income and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year is explained by this simple linear regression model? b. Estimate the corresponding simple linear regression with the number of members in the customers household as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the number of members in the customers household and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year is explained by this simple linear regression model? c. Estimate the corresponding simple linear regression with the customers number of years of posthigh school education as the independent variable and credit card charges accrued by a customer over the past year as the dependent variable. Interpret the estimated relationship between the customers number of years of posthigh school education and credit card charges accrued over the past year. How much variation in credit card charges accrued by a customer over the past year is explained by this simple linear regression model? d. Recall the multiple regression in Figure 7.23 with credit card charges accrued by a customer over the past year as the dependent variable and customers annual household income (x1), number of members of the household (x2), and number of years of post-high school education (x3) as the independent variables. Do the estimated slopes differ substantially from the corresponding slopes that were estimated using simple linear regression in parts (a), (b), and (c)? What does this tell you about multicollinearity in the multiple regression model in Figure 7.23? e. Add the coefficients of determination for the simple linear regression in parts (a), (b), and (c), and compare the result to the coefficient of determination for the multiple regression model in Figure 7.23. What does this tell you about multicollinearity in the multiple regression model in Figure 7.23? f. Add age, a dummy variable for sex, and a dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as independent variables to the multiple regression model in Figure 7.23. Code the dummy variable for sex as 1 if the customer is female and 0 if male, and code the dummy variable for whether a customer has exceeded his or her credit limit in the past 12 months as 1 if the customer has exceeded his or her credit limit in the past 12 months and 0 otherwise. Do these variables substantially improve the fit of your model?arrow_forward
- Evaluate the two departments for Moxie Products. Compare the years performance of the two departments in terms of ROI and RI. Which department has created the most wealth for Moxie shareholders in the past year?arrow_forwardThe income statement comparison for Rush Delivery Company shows the income statement for the current and prior year. A. Determine the operating income (loss) (dollars) for each year. B. Determine the operating income (percentage) for each year. C. The company made a strategic decision to invest in additional assets in the current year. These amounts are provided. Using the total assets amounts as the investment base, calculate the ROI. Was the decision to invest additional assets in the company successful? Explain. D. Assuming an 8% cost of capital, calculate the RI for each year. Explain how this compares to your findings in part C.arrow_forwardSouth Shore Construction builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $308,000 in the first year of operation to $1,084,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars: Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter I, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Based on the model you developed in part (b), compute estimates of quarterly sales for year 6. Let Period = 1 refer to the observation in quarter 1 of year 1; Period = 2 refer to the observation in quarter 2 of year 1; … and Period = 20 refer to the observation in quarter 4 of year 5. Using the dummy variables defined in part (b) and the variable Period, develop an equation to account for seasonal effects and any linear trend in the time series. Based on the seasonal effects in the data and linear trend estimated in part (c), compute estimates of quarterly sales for year 6. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.arrow_forward
- forecasted balance sheet is calculated from asset ratios that management has reviewed and changed based on industry and benchmark averages. An Excel spreadsheet is used for this analysis because changes in assumptions, financing, and ratios can be made to the statements to review alternative scenarios. The impact of these changes on the firm's forecasted financial statements ultimately can be used to improve the firm's operations. Quantitative Problem: At the end of last year, Edwin Inc. reported the following income statement (in millions of dollars): Sales Operating costs excluding depreciation EBITDA Depreciation $4,250.00 3,016.00 $1,234.00 320.00 $914.00 150.00 $764.00 305.60 $458.40 Looking ahead to the following year, the company's CFO has assembled this information: EBIT Interest EBT Taxes (40%) Net income ▪ Year-end sales are expected to be 4% higher than $4.25 billion in sales generated last year. ▪ Year-end operating costs, excluding depreciation, will equal 80% of sales. ■…arrow_forwardWhich one of the following ratios is relevant to assess long-term solvency? A. Current Ratio B. Debt-Service Coverage Ratio C. Return on Equity D. Profit Marginarrow_forwardCommon-Size Financial Statement Analysis Using Excel Completing this activity will help you learn to: 1. create Excel formulas using cell references. 2. create absolute cell references to perform calculations efficiently and correctly. 3. apply conditional formatting to highlight cells based on criteria that you specify. Case scenario: You are working at a small business that has been mostly stable. You want to analyze the financial statements of the past five years to examine the trends over time and compare the percentages of income statement items relative to overall sales. You also want to highlight cells according to whether the calculated ratio increases or decreases more than a specified amount. Required: Download spreadsheet CommonSizeCaseData-52d586.xlsx You will build a spreadsheet that performs common-size analysis using five years of a company's income statements. Specifically, you will create two sheets within the workbook, one for the horizontal analysis and one for the…arrow_forward
- Calculate the profitability ratios of Dernham Inc. in the following table. Convert all calculations to a percentage rounded to two decimal places. Ratio Operating margin Value Year 2 Year 1 61.54% Profit margin 44.39% Return on total assets 17.09% Return on common equity 32.13% Basic earning power 22.22% Decision makers and analysts look deeply into profitability ratios to identify trends in a company's profitability. Profitability ratios give insights into both the survivability of a company and the benefits that shareholders receive. Identify which of the following statements are true about profitability ratios. Check all that apply. A higher operating margin than the industry average indicates either lower operating costs, higher product pricing, or both. If a company's operating margin increases but its profit margin decreases, it could mean that the company paid more in interest or taxes. An increase in the return on assets ratio implies an increase in the assets a firm owns. If a…arrow_forwardI need help with questions 1-6arrow_forwardUsing the income statement below, please compute the correct variance in total revenue (horizontal analysis) in Korean Won (Billion) and in percentage between the years ending 12/31/2023 and 12/31/2020 and chose the correct answer": yahoo/finance Search for news, symbols or companies a News Finance Sports More My Portfolio News Markets Research Personal Finance Videos Follow Compare News Research Chart Community Statistics Hyundai Motor Company (HYMTF) 60.50 -0.30 (-0.49%) At close: August 13 at 4:00 PM EDT Balance Sheet Cash Flow Dividends Historical Data All numbers in thousands יוויון Sustainability Breakdown Currency in KRW Annual Quarterly Download Collapse All 15 TTM 12/31/2023 12/31/2022 12/31/2021 12/31/2020 165,543,425,000 162,663,579,000 142,151,469,000 117,610,626,000 103,997,601,000 Total Revenue Operating Revenue Cost of Revenue Gross Profit Operating Expense 165,543,425,000 162,663,579,000 142,151,469,000 117,610,626,000 103,997,601,000 131.353,259,000 129.179.183.000…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License