Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
6th Edition
ISBN: 9781260848700
Author: William N. Lanen Professor, Shannon Anderson Associate Professor, Michael W Maher
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
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 solutionStudents have asked these similar questions
Alpha Milk Corp is considering taking over their competitor, Dana Dairy Products, and asked your consultancy firm to perform financial statement analysis to assess feasibility of this strategic initiative. You are given the following key financial ratios, the firm’s income statement and the balance sheet. You can assume that there are 365 days in a year.
a) Using the information provided for 31 Dec 2005, calculate the following: net working capital, current ratio, quick ratio, inventory turnover, average collection period, total debt ratio, gross profit margin, net profit margin, return on total assets, return on equity.
b) Evaluate the company’s performance against industry average ratios and compare with last year’s results.
To answer, please refer to pictures attached
Refer to the information for Jasper Company on the previous page.Required:1. Prepare an income statement for Jasper for last year. Calculate the percentage of sales for eachline item on the income statement. (Note: Round percentages to the nearest tenth of a percent.)2. CONCEPTUAL CONNECTION Briefly explain how a manager could use the incomestatement created for Requirement 1 to better control costs.
ZNet Co. is a web-based retail company. The company reports the following for the past year. The company’s CEO believes that sales for next year will increase by 20% and both profit margin (%) and the level of average invested assets will be the same as for the past year. 1. Compute return on investment for the past year. 2. Compute profit margin for the past year. 3. If the CEO’s forecast is correct, what will return on investment equal for next year? 4. If the CEO’s forecast is correct, what will investment turnover equal for next year? Sales . $5,000,000 Operating income . $1,000,000 Average invested assets . $12,500,000
Chapter 5 Solutions
Gen Combo Fundamentals Of Cost Accounting; Connect Access Card
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
- South 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_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_forwardEvaluate 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_forward
- The 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_forwardRefer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?arrow_forwardA Using Common Size Statements The following income statement and vertical analysis data are available for Riley Manufacturing: Required: 1. CONCEPTUAL CONNECTION Suggest why net income declined from $273,200 to $41,600 while the cost of goods sold percentage decreased each year and selling and administrative expenses remained nearly constant. 2. CONCEPTUAL CONNECTION Determine what could cause sales to decline while the gross margin percentage increases.arrow_forward
- The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firms leading product over the past eight years: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the average cost increase that the firm has been realizing per year? d. Compute an estimate of the cost/unit for next year.arrow_forwardRiver Valley Production Inc. seeks to increase its market share and improve its results. The company takes as a starting point the current scenario and the results obtained in 2018 and 2019. Like other companies, River Valley uses financial ratios (ratios) as tools for analyzing the results obtained at the end of the period. Consider the data presented in the financial statements below and analyze the company's results based on the financial ratios.1. Use the financial statements to calculate the following financial ratios for the years 2018 and 2019:1.8 Return on Investment (ROI)1.9 Profit Margin1.10 Debt to Equity Ratio1.11 Price/Earning Ratio Balance Sheet 2018 2019 Cash $63,000 $201,000 Accounts Receivable 199,000 305,000 Marketable Securities 81,000 42,000 Inventories 441,000 455,000 Prepaids 5,000 9,000 Total Current Assets 789,000 1,012,000 Property, Plant, and Equipment, net 858,000 858,000…arrow_forwardSuppose you manage a company, which presents the following financial indicators: Current Ratio: 2 Average Collection Period: 76.3 days Inventory Turnover: 6.7 Operating Income Return on Investment: 13.2% Debt Ratio: 32% The competition has the following results: Current Ratio: 2 Average Collection Period: 35 days Inventory Turnover: 6.7 Operating Income Return on Investment:10% Debt Ratio: 60% How is the financial situation of your company? Justify your answer.arrow_forward
- Smith Branded Apparel designs T-shirts for businesses and corporations. The accounting managerhas presented the latest quarter’s return on sales of 10% and asset turnover of 1.5. What is the company’s current return on investment (ROI)?arrow_forwardDigital Technology wishes to determine its coefficient of variation as a company over time. The firm projects the following data (in millions of dollars): Year Profits: Expected Value Standard Deviation 1 $ 99 $ 37 3 125 52 6 181 100 9 249 150 Compute the coefficient of variation (V) for each time period. Note: Round your answers to 3 decimal places. year cofficient of variation 1 3 6 9arrow_forwardPaul 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?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher: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 LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher: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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial ratio analysis; Author: The Finance Storyteller;https://www.youtube.com/watch?v=MTq7HuvoGck;License: Standard Youtube License