Managerial Accounting
null Edition
ISBN: 9781260195408
Author: Whitecotton
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 13, Problem 3E
To determine
(a)
Introduction:
Horizontal analysis is an analysis used to compare the historical data. It shows the changes in the amount of financial statements over the period of time.
To prepare:
The horizontal analyses with rounding the answer up to one decimal place. Also, compare the change in price of computers to the company’s change in sales revenue.
To determine
(b)
Introduction:
Vertical analysis help to express each financial statement line item as a percentage of the base year.
To prepare:
Vertical analyses with rounding the answer up to one decimal place.To compare if the company earned more gross profit per sales dollar during 2013 compare to 2012.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2016. Let’s see whether these changes are reflected in the income statement of Computer Tycoon Inc. for the year ended December 31, 2016.
2016
2015
Sales Revenue
$
120,000
$
150,000
Cost of Goods Sold
70,000
79,500
Gross Profit
50,000
70,500
Selling, General, and Administrative Expenses
38,000
41,000
Interest Expense
700
575
Income before Income Tax Expense
11,300
28,925
Income Tax Expense
2,500
7,000
Net Income
$
8,800
$
21,925
Required:
Compute the gross profit percentage for each year. Assuming that the change from 2015 to 2016 is the beginning of a sustained trend, is Computer Tycoon likely to earn more or less gross profit from each dollar of sales in 2017?
Compute the net profit margin…
calculate the fixed and variable components of the selling and administrative expenses by dividing the change in cost of the selling and administrative expenses between 2009 and 2010 to change in sales between 2009 and 2010 and use it to determine the fixed and variable components of the cost of the selling and administrative expenses .
Saunders Corporation (amounts in millions of dollars)
2009
2010
Sales
8,296
8,871
Cost of Goods Sold
(5,890)
(6,290)
Selling and Administrative Expenses
(1,788)
(1,714)
Operating Income before Income Taxes
618
867
The problem is stated in the picture.
Here is the question:
1. Assume instead, the Company uses the Moving Average method in the measurement of its inventories, how much would be the weighted average cost per unit of the sales made at May 20? (Round off the final answers to two decimal places)
Chapter 13 Solutions
Managerial Accounting
Ch. 13 - Prob. 1QCh. 13 - Prob. 2QCh. 13 - What is ratio analysis? Why is it useful?
Ch. 13 - What benchmarks are commonly used for interpreting...Ch. 13 - Prob. 5QCh. 13 - Why are some analyses called horizontal and others...Ch. 13 - Slow Cellar’s current ratio increased from 1.2 to...Ch. 13 - From last year to this year. Colossal Company’s...Ch. 13 - From last year to this year, Berry Barn reported...Ch. 13 - Prob. 10Q
Ch. 13 - Prob. 1MCCh. 13 - Prob. 2MCCh. 13 - Prob. 3MCCh. 13 - Prob. 4MCCh. 13 - Prob. 5MCCh. 13 - Prob. 6MCCh. 13 - Prob. 7MCCh. 13 - Prob. 8MCCh. 13 - Prob. 9MCCh. 13 - Prob. 1MECh. 13 - Prob. 2MECh. 13 - Prob. 3MECh. 13 - Prob. 4MECh. 13 - Prob. 5MECh. 13 - Prob. 6MECh. 13 - Prob. 7MECh. 13 - Prob. 8MECh. 13 - Prob. 9MECh. 13 - Prob. 10MECh. 13 - Prob. 11MECh. 13 - Prob. 12MECh. 13 - Prob. 13MECh. 13 - Prob. 14MECh. 13 - Prob. 1ECh. 13 - Prob. 2ECh. 13 - Prob. 3ECh. 13 - Prob. 4ECh. 13 - Prob. 5ECh. 13 - Prob. 6ECh. 13 - Prob. 7ECh. 13 - Computing and Interpreting Liquidity Ratios...Ch. 13 - Prob. 9ECh. 13 - Prob. 10ECh. 13 - Prob. 11ECh. 13 - Prob. 12ECh. 13 - Prob. 13ECh. 13 - Analyzing the Impact of Selected Transactions on...Ch. 13 - Prob. 15ECh. 13 - Prob. 1.1GAPCh. 13 - Prob. 1.2GAPCh. 13 - Prob. 2.1GAPCh. 13 - Prob. 2.2GAPCh. 13 - Prob. 2.3GAPCh. 13 - Prob. 2.4GAPCh. 13 - Prob. 2.5GAPCh. 13 - Prob. 2.6GAPCh. 13 - Prob. 2.7GAPCh. 13 - Prob. 2.8GAPCh. 13 - Prob. 3.1GAPCh. 13 - Prob. 3.2GAPCh. 13 - Prob. 3.3GAPCh. 13 - Prob. 4.1GAPCh. 13 - Prob. 4.2GAPCh. 13 - Prob. 4.3GAPCh. 13 - Prob. 5.1GAPCh. 13 - Prob. 5.2GAPCh. 13 - Prob. 5.3GAPCh. 13 - Prob. 5.4GAPCh. 13 - Prob. 6.1GAPCh. 13 - Prob. 6.2GAPCh. 13 - Prob. 7GAPCh. 13 - Prob. 1.1GBPCh. 13 - Prob. 1.2GBPCh. 13 - Prob. 2.1GBPCh. 13 - Prob. 2.2GBPCh. 13 - Prob. 2.3GBPCh. 13 - Prob. 2.4GBPCh. 13 - Prob. 2.5GBPCh. 13 - Prob. 2.6GBPCh. 13 - Prob. 2.7GBPCh. 13 - Prob. 2.8GBPCh. 13 - Prob. 3.1GBPCh. 13 - Prob. 3.2GBPCh. 13 - Prob. 3.3GBPCh. 13 - Prob. 4.1GBPCh. 13 - Prob. 4.2GBPCh. 13 - Prob. 4.3GBPCh. 13 - Prob. 5.1GBPCh. 13 - Prob. 5.2GBPCh. 13 - Prob. 5.3GBPCh. 13 - Prob. 5.4GBPCh. 13 - Prob. 6.1GBPCh. 13 - Prob. 6.2GBPCh. 13 - Prob. 7GBP
Knowledge Booster
Similar questions
- A 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_forwardThe following revenue data were taken from the December 31, 2017, General Electric annual report (10-K): For each segment and each year, calculate intersegment sales (another name for transfer sales) as a percentage of total sales. Using Microsoft Excel or another spreadsheet application, create a clustered column graph to show the 2016 and 2017 percentages for each division. Comment on your observations of this data. How might a division sales manager use this data?arrow_forwardDuring the current year, Sokowski Manufacturing earned income of $350,000 from total sales of $5,500,000 and average capital assets of $12,000,000. A. Based on this information, calculate asset turnover. B. Using the sales margin from the previous exercise, what is the total ROI for the company during the current year?arrow_forward
- Using the information in the previous exercises about Marleys Manufacturing, determine the operating income for department B, assuming department A sold department B 1,000 units during the month and department A reduces the selling price to the market price.arrow_forwardClick the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a deflationary period, which bar (A, B, or C) represents FIFO costing, which represents LIFO costing, and which represents weighted average? Explain your reasoning. On January 4 following year-end, Rio Enterprises received a shipment of 60 units of product costing 580 each. These units had been ordered by Del in December and had been shipped to him on December 27. They were shipped FOB shipping point. Revise the FIFOLIFO3 worksheet to include this shipment. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as FIFOLIFOT. Using the FIFOLIFO3 file, prepare a 3-D bar (stacked) chart showing the cost of goods sold and ending inventory under each of the four inventory cost flow assumptions. No Chart Data Table is needed. Use the values in the Calculations Section of the worksheet for your chart. Enter your name somewhere on the chart. Save the file again as FIFOLIFO3. Print the chart.arrow_forwardA large manufacturer of truck and car tires recently changed its cost-flow assumption method for inventories at the beginning of 2014. The manufacturer has been in operation for almost 40 years, and for the last decade it has reported moderate growth in revenues. The firm changed from the LIFO method to the FIFO method and reported the following information (amounts in millions): REQUIRED Calculate the inventory turnover ratio for 2014 using the LIFO and FIFO cost-flow assumption methods. Explain why the costs assigned to inventory under LIFO at the end of 2013 and 2014 are so much less than they are under FIFO.arrow_forward
- (Disclosure of Estimates) Nancy Tercek, the financial vice president, and Margaret Lilly, the controller, of Romine Manufacturing Company are reviewing the financial ratios of the company for the years 2017 and 2018. The financial vice president notes that the profit margin on sales ratio has increased from 6% to 12%, a hefty gain for the 2-year period. Tercek is in the process of issuing a media release that emphasizes the efficiency of Romine Manufacturing in controlling cost. Margaret Lilly knows that the difference in ratios is due primarily to an earlier company decision to reduce the estimates of warranty and bad debt expense for 2018. The controller, not sure of her supervisor’s motives, hesitates to suggest to Tercek that the company’s improvement is unrelated to efficiency in controlling cost. To complicate matters, the media release is scheduledin a few days.Instructions(a) What, if any, is the ethical dilemma in this situation?(b) Should Lilly, the controller, remain silent?…arrow_forwardThe following data for the years ended December 31, 2019 and 2020 were presented to the management Zigzag Company: 2020 = Net sales: 1,363,000, Cost of Sales: 911,800, Gross Profit: 451,200; 2019 = Net Sales: 1,250,000, Cost of Sales: 776,000, Gross Profit: 474,000. The management requested you to determine the cause of the decline in gross profit on sales in spite of the favorable information given by the sales division that the quantity sold in 2020 was higher than in 2019 and that the production costs in 2020 were lower than that of 2019 by 6%. The percent change in volume is A. 17.50% B. 14.00% C. 25.00% D. 20.00%arrow_forwardThe following data for the years ended December 31, 2019 and 2020 were presented to the management Zigzag Company: 2020 = Net sales: 1,363,000, Cost of Sales: 911,800, Gross Profit: 451,200; 2019 = Net Sales: 1,250,000, Cost of Sales: 776,000, Gross Profit: 474,000. The management requested you to determine the cause of the decline in gross profit on sales in spite of the favorable information given by the sales division that the quantity sold in 2020 was higher than in 2019 and that the production costs in 2020 were lower than that of 2019 by 6%. The increase (decrease) in net sales due to volume factor is: a. (P194,000) b. P194,000 c. (P312,500) d. P312,500arrow_forward
- The following data for the years ended December 31, 2019 and 2020 were presented to the management Zigzag Company: 2020 = Net sales: 1,363,000, Cost of Sales: 911,800, Gross Profit: 451,200; 2019 = Net Sales: 1,250,000, Cost of Sales: 776,000, Gross Profit: 474,000. The management requested you to determine the cause of the decline in gross profit on sales in spite of the favorable information given by the sales division that the quantity sold in 2020 was higher than in 2019 and that the production costs in 2020 were lower than that of 2019 by 6%. The increase (decrease) in net sales due to cost factor is A. (P135,800) B. 135,800 C. (P58,200) D. 58,200arrow_forwardThe following data for the years ended December 31, 2019 and 2020 were presented to the management Zigzag Company: 2020 = Net sales: 1,363,000, Cost of Sales: 911,800, Gross Profit: 451,200; 2019 = Net Sales: 1,250,000, Cost of Sales: 776,000, Gross Profit: 474,000. The management requested you to determine the cause of the decline in gross profit on sales in spite of the favorable information given by the sales division that the quantity sold in 2020 was higher than in 2019 and that the production costs in 2020 were lower than that of 2019 by 6%. (Based on information given above) The increase (decrease) in net sales due to volume factor is: (P194,000) P194,000 (P312,500) P312,500 (Based on information given above) The increase (decrease) in net sales due to price factor is: (P113,000) P113,000 (P199,500) P199,500 (Based on information given above) The increase (decrease) in net sales due to cost factor is: (P135,800) P135,800…arrow_forwardOn January 1 2020, South by Southwest Company used least squares regression analysis to estimate the total monthly payroll department cost of the company in 2020. The followings are the output from the regression analysis based on the observation of the payroll department cost( dependent variable) and the labor hours worked ( independent variable) for the last 20 months: Constant $18,000 r2 0.8924 X coefficient(s) $ 2.55 Required: BASED ON THE OUTPUT FROM THE REGRESSION ANALYSIS a. What is the total estimated fixed payroll department cost? b. What is the variable payroll department cost per labor hour? c. What is the estimate cost function of the payroll department cost? d. What is the coefficient of determination? Comment on the goodness of fit of the cost function? Plzz give all the ansarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning