Question

Refer to the following mentioned data. (In millions) 2017 2016 2015 Net sales $ 34,110 $...

Refer to the following mentioned data.

(In millions)
2017 2016 2015
Net sales $ 34,110 $ 30,196 $ 26,986
Cost of products sold 14,428 13,938 13,437
Gross margin $ 19,682 $ 16,258 $ 13,549


Required:
a.
Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.)

2017 %

2016 %

2015 %

b. Assume that Campbell’s net sales for the first four months of 2018 totaled $12.83 billion. Calculate an estimated cost of goods sold and gross profit for the four months, using the gross profit ratio for 2017. (Round intermediate calculations to 2 decimal places. Enter your answers in millions rounded to nearest whole number (i.e., 5,000,000 should be entered as 5).)

cost of goods sold

gross profit

Homework Answers

Answer #1

Gross Profit ratio is obtained by dividing Gross profit by sales

Gross profit= sales-cost of goods sold

2015

=($16,549/$26,986) *100

=61.32%

2016

($16,258/$30,196)*100

=53.84%

2017

($19,682/$34,110)*100

=57.70%

b.2017 GP ratio = 57.70%

1 billion = 1000 million

12.83 billion = ? million

Sales =12,830 Million

Gross Profit = sales*GP ratio

=$12,830*57.70%

Gross profit=$7,403 Million (Rounded to nearest whole number)

Cost of goods sold = Sales-Gross Profit

$12,830-$7,403

Cost of Goods Sold=$5,427

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Refer to the following mentioned data. (In millions) 2017 2016 2015 Net sales $ 34,092 $...
Refer to the following mentioned data. (In millions) 2017 2016 2015 Net sales $ 34,092 $ 30,418 $ 26,944 Cost of products sold 14,318 13,517 13,549 Gross margin $ 19,774 $ 16,901 $ 13,395 a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) b. Assume that Campbell’s net sales for the first four months of 2018 totaled $12.95 billion. Calculate an estimated cost of goods sold and gross profit...
Refer to the following mentioned data. (In millions) 2017 2016 2015 Net sales $ 34,058 $...
Refer to the following mentioned data. (In millions) 2017 2016 2015 Net sales $ 34,058 $ 30,174 $ 26,635 Cost of products sold 14,910 13,485 13,474 Gross margin $ 19,148 $ 16,689 $ 13,161 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) b. Assume that Campbell’s net sales for the first four months of 2018 totaled $12.39 billion. Calculate an estimated cost of goods sold and gross...
Refer to the following mentioned data. (In millions) Net sales 2017: $ 34,412 2016: $ 30,135...
Refer to the following mentioned data. (In millions) Net sales 2017: $ 34,412 2016: $ 30,135 2015: $ 26,795 Cost of products sold 2017: 14,613 2016: 13,145 2015: 13,236 Gross margin 2017: $ 19,799 2016: $ 16,990 2015: $ 13,559 Required: a. Calculate the gross profit ratio for each of the past three years. (Round your answers to 2 decimal places.) b. Assume that Campbell’s net sales for the first four months of 2018 totaled $12.19 billion. Calculate an estimated...
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015...
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $2,100 $2,200 $2,800 Ending inventory 2,200 2,800 2,600 Cost of goods sold 17,951 20,435 20,445 Sales revenue 38,895 42,974 43,152 Calculate the inventory turnover for PepsiCo, Inc. for 2015, 2016, and 2017. (Round inventory turnover to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Inventory turnover times times times Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016,...
Analyze sales for 2015, 2016, and 2017. Calculate any profit measures deemed necessary and discuss the...
Analyze sales for 2015, 2016, and 2017. Calculate any profit measures deemed necessary and discuss the profitability of the company. ABC Company Income Statements             For the Years Ended Dec. 31, 2017, 2016 and 2015                                                                                                  2017                 2016              2015             Net sales                                                                       $174                 $167                $160             COGS                                                                           (114)               (115)               (120)             Gross profit                                                                   $ 60                 $ 52                 $40             General and administrative expenses (54)                  (46)               (34)             Operating profit                                                              $ 6    ...
2019 2018 2017 2016 2015 Sales $ 442,210 $ 285,297 $ 222,021 $ 153,648 $ 116,400...
2019 2018 2017 2016 2015 Sales $ 442,210 $ 285,297 $ 222,021 $ 153,648 $ 116,400 Cost of goods sold 223,505 144,349 114,161 78,174 58,200 Accounts receivable 21,359 16,718 15,231 8,942 7,950 Compute trend percents for the above accounts, using 2015 as the base year. Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Trend percent 2019: / = % 2018: / = % 2017: / = % 2016: / = % Trend Percent for Cost of...
The following information is for Tide Corporation: ($ thousands) 2017 2016 Net sales $ 438,060 $...
The following information is for Tide Corporation: ($ thousands) 2017 2016 Net sales $ 438,060 $ 298,000 Cost of goods sold 214,649 88,208 Determine the 2016 and 2017 trend percents for net sales using 2016 as the base year.
1. Ralph corporation reported the following revenue data: Year Net revenue (in millions) 2016 $7,100 2017...
1. Ralph corporation reported the following revenue data: Year Net revenue (in millions) 2016 $7,100 2017 $7,418 2018 $7,128 2019 $7,668 Use 2016 as the base year. The trend percentage in 2019 is close to A. 113% B. 108% C. 93% D. 103% 2. Ralph company reported the following data (in millions) for the past two years: 2019 2018 Net revenue $380 $290    Cost of goods sold $145 $175 Gross profit $235 $115 Operating expense $150 $45 Operating income...
A company had the following income statement figures for 2016 and 2017 : 2017 2016 Sales...
A company had the following income statement figures for 2016 and 2017 : 2017 2016 Sales Cost of goods Sold 570 000 550 000 300 000 310 000 Gross Margin Operating Expenses 270 000 240 000 180 000 150 000 Net income 90 000 90 000 Calculate component percentages for this information. Please, state your conclusions.
Rate of Change Analyses Teicher Company presents the following condensed comparative income statements for 2015, 2016,...
Rate of Change Analyses Teicher Company presents the following condensed comparative income statements for 2015, 2016, and 2017: For Years Ended December 31, 2017 2016 2015 Sales (net) $120,000 $100,000 $85,000 Cost of goods sold (72,000) (55,000) (45,000) Gross profit $48,000 $45,000 $40,000 Operating expenses (22,000) (20,000) (18,000) Operating income $26,000 $25,000 $22,000 Other items:     Dividend revenue 400 500 200     Interest expense (1,200) (1,000) (500) Income before income taxes $25,200 $24,500 $21,700 Income tax expense (8,200) (8,000) (6,000) Net income...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • What are the benefits an organization can enjoy as a result of establishing a strong environment....
    asked 7 minutes ago
  • According to a​ magazine, as of January​ 2018, 9​% of chief executive officers were women. Complete...
    asked 10 minutes ago
  • Solve the initial value problem: 4y′′+3y=0, y(π/2)=2 , y'(π/2)=−1. Give your answer as y=... Use x...
    asked 11 minutes ago
  • Calculate the approximate main-sequence lifetime of a (K0 type) star with a mass of 0.8 mass...
    asked 16 minutes ago
  • Suppose studies indicate that the earth's vegetative mass, or biomass for tropical woodlands, thought to be...
    asked 19 minutes ago
  • Assume the cost of an extended​ 100,000 mile warranty for a particular SUV follows the normal...
    asked 27 minutes ago
  • In response to an attack of 10 missiles, 500 antiballistic missiles are launched. The missile targets...
    asked 29 minutes ago
  • A study indicates that if eight people occupy the elevator, the probability distribution of the total...
    asked 35 minutes ago
  • To resolve an object in an electron microscope, the wavelength of the electrons must be close...
    asked 47 minutes ago
  • Let A = v1 v2 v3 v1 2 8 16 v2 8 0 4 v3 16...
    asked 58 minutes ago
  • Earnings per Share, Price-Earnings Ratio, Dividend Yield The following information was taken from the financial statements...
    asked 58 minutes ago
  • Required information Many fields of engineering require accurate population estimates. For example, transportation engineers might find...
    asked 1 hour ago