Question

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.

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

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**

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
$
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 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
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
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
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
$
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 $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
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, 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

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 7 minutes ago

asked 10 minutes ago

asked 11 minutes ago

asked 16 minutes ago

asked 19 minutes ago

asked 27 minutes ago

asked 29 minutes ago

asked 35 minutes ago

asked 47 minutes ago

asked 58 minutes ago

asked 58 minutes ago

asked 1 hour ago