Question

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 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).)

Homework Answers

Answer #1

a.

2017 2016 2015
Net Sales 34,412 30,135 26,795
Cost of products sold 14,613 13,145 13,236
Gross margin 19,799 16,990 13,559
Gross profit ratio (Gross Margin/Net sales) 57.54% 56.38% 50.60%

b.

Net sales = $12.19 billion

= 12.19 x 1,000

= $12,190 million

Gross profit ratio = 57.54%

Gross profit = Net sales x Gross profit ratio

= 12,190 x 57.54%

= 7,014 million

Cost of goods sold = Net sales - Gross profit

= 12,190-7,014

= $5,176 million

Kindly comment if you need further assistance.

Thanks‼!

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,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...
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...
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,...
The following financial information is available for Flint Corporation. (in millions) 2017 2016 Average common stockholders’...
The following financial information is available for Flint Corporation. (in millions) 2017 2016 Average common stockholders’ equity $2,825 $2,925 Dividends declared for common stockholders 335 630 Dividends declared for preferred stockholders 45 45 Net income 605 685 Calculate the payout ratio and return on common stockholders’ equity ratio for 2017 and 2016. (Round answers to 1 decimal place, e.g. 12.5%)
shares in Millions, $ in Millions 2018 2017 2016 Income Statement Net Sales $108,203 $100,904 $94,595...
shares in Millions, $ in Millions 2018 2017 2016 Income Statement Net Sales $108,203 $100,904 $94,595 Cost of sales 71,043 66,548 62,282 Gross profit 37,160 34,356 32,313 Operating expenses: Selling, general and administrative 19,513 17,864 17,132 Depreciation and amortization 1,870 1,811 1,754 Impairment loss 247 0 0 Total operating expenses 21,630 19,675 18,886 Operating income 15,530 14,681 13,427 Interest and other (income) expense: Interest and investment income -93 -74 -36 Interest expense 1,051 1,057 972 Other 16 0 0 Interest...
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...
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    ...
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.
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.