A1 6 4557 HER General Xfx Accessibility tab summary: An income statement for Lake Athletics is...
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/05/6655f4aee0bcb_2306655f4aed6594.jpg)
Transcribed Image Text:
A1 6 4557 HER General Xfx Accessibility tab summary: An income statement for Lake Athletics is presented in cell A5 to E18. S A B C D E M 8 9 10 Net sales 11 Cost of goods sold 12 Gross profit 13 Operating expenses 14 Operating income 15 Other income 16 Income before tax 17 Income tax expense LAKE ATHLETICS Income Statement For the Year Ended December 31 Apparel Amount $3,150,000 Equipment Percent Amount Percent $5,550,000 L 2,720,000 2,830,000 F ne 1,400,000 1,750,000 800,000 95,000 20,000 970,000 241,250 $728,750 875,000 1,955,000 10,000 1,965,000 491,000 18 Net income 19 20 Required: 21 22 23 $1,474,000 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales. 24 2. Use the completed vertical analysis above to answer each of the questions below: 25 26 Which product line has the highest gross profit percent? 27 Which product line has the highest net income percent? 28 29 Graded Worksheet + Workbook Statistics Calculation Mode: Automatic WC A1 6 4557 HER General Xfx Accessibility tab summary: An income statement for Lake Athletics is presented in cell A5 to E18. S A B C D E M 8 9 10 Net sales 11 Cost of goods sold 12 Gross profit 13 Operating expenses 14 Operating income 15 Other income 16 Income before tax 17 Income tax expense LAKE ATHLETICS Income Statement For the Year Ended December 31 Apparel Amount $3,150,000 Equipment Percent Amount Percent $5,550,000 L 2,720,000 2,830,000 F ne 1,400,000 1,750,000 800,000 95,000 20,000 970,000 241,250 $728,750 875,000 1,955,000 10,000 1,965,000 491,000 18 Net income 19 20 Required: 21 22 23 $1,474,000 1. Use appropriate Excel formulas to perform vertical analysis and complete the "Percent" columns for both product lines above. Express each amount as a percentage of net sales. 24 2. Use the completed vertical analysis above to answer each of the questions below: 25 26 Which product line has the highest gross profit percent? 27 Which product line has the highest net income percent? 28 29 Graded Worksheet + Workbook Statistics Calculation Mode: Automatic WC
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
Why must todays managers understand and utilize various motivational strategies?
-
Repeat problem 10 with the initial design of \(b_{1}=2 \times 10^{-4} \mathrm{~m}^{2}\) and \(b_{2}=1 \times 10^{-4} \mathrm{~m}^{2}\). Discuss the results with that of problem 10 . Data From Problem...
-
Service without a smile. Service with a smile is a slogan that many businesses adhere to. However, there are some jobs (e.g., those of judges, law enforcement officers, pollsters) that require...
-
Explain how to determine the number of variables and constraints that would be in a transportation problem simply by knowing the number of sources and the number of destinations.
-
RentAPhone is a new service company that provides European mobile phones to American visitors to Europe. The company currently has 110 phones available at Charles de Gaulle Airport in Paris. There...
-
Several months ago while shopping I was interviewed to see whether or not I'd be interested in signing up for a subscription to yoga app I fall into the category of people who have a membership at a...
-
Match each of the following transactions of Lesch \& Company with the appropriate letters, indicating the debits and credits to be made. The key for the letters follows the list of transactions. The...
-
Workers act as sellers of their time in the labor market in return for some wage. Lets discover your individual supply curve for labor. For each hourly wage rate provided in the accompanying table,...
-
The Joint Commission on Accreditation of Healthcare Organizations (JCAHO) monitors and evaluates health care providers according to strict standards and guidelines. Improvement in the quality of care...
-
The U.S. National Highway Traffic Safety Administratio (NHTSA) independently tests over 2,400 types of tires annually. In 2015, they issued more than 900 recalls, affecting 51 million vehicles...
-
The Hudson Jewelers case study can be found in Appendix C. Chapter 17 Case Questions for Discussion: 1.Research and acquire the criteria for diamond appraisals and critique these criteria in terms of...
-
Please help soon! This question is about free fall You are standing on the roof of the Gould-Simpson building and drop a quarter from the edge of the roof. (Ignore air resistance) A. What is the...
-
Learning organisations are dreams which can never come true. Discuss why you agree or disagree with this statement.. lo1
-
Library Database. Your college library maintains the records of books borrowed. Some of the many variables stored in the database include the titles of the books, their subject categories...
-
National Airport Authority. The National Airport Authority (NAA) of a country stores the relevant data for all the airports in a country to perform periodic checks on their maintenance. Data from...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App