Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table [ [ table [ [ Revenues ] , [ ( millions ) ] ] , , 2 0 2 2 , 2

\table[[\table[[Revenues],[(millions)]],,2022,2021,2020],[Apparel and accessories ?(a),$,17,646$,17,931$,14,772],[Beauty and household essentials ?(b),,29,575,27,268,24,461],[Food and beverage ?(c),,22,918,20,306,18,135],[Hardlines ?(d),,17,739,18,614,16,626],[Home furnishings and dcor ?(e),,19,463,20,255,18,231],[Other,,247,237,175],[Sales,,107,588,104,611,92,400],[Credit card profit sharing,,734,710,666],[Other,,798,684,495],[Other revenue,,1,532,1,394,1,161],[Total revenue,$,109,120$,106,005$,93,561]]
In looking at the composition of sales by product line (for example apparel, beauty, food, hardlines, home furnishings), which statement best describes the change from 2021 to 2022. Perform both horizontal and vertical analysis on the sales detail to answer this question.
Horizontal analysis (also called trend analysis) computes a percent change in the account and uses the following formula.
(current year - prior year)/prior year
Vertical analysis looks at the proportion of one account to a total amount. It is computed as follows:
Account/Total of two or more accounts
1)
Beauty and Household supplies ranked as the highest selling product line. This product line also had the highest percentage growth increase from 2021 to 2022.
2)
As the effects of the pandemic declined, shoppers continued to increase spending on apparel. The greatest percentage increase in sales from 2021 to 2022 occurred in the apparel line.
3)
There was little notable change in Target's product line sales from 2021 to 2022. All the product lines (Apparel, Food, Beauty, Hardlines, and Home) increased by the same rate of between 2% and 6%.
4)
The category of sales that experienced the highest increase from 2021 to 2022 was food and beverage. Inflation likely contributed to the increase.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing An International Approach

Authors: Wally J. Smieliauskas, Kathryn Bewley

7th edition

1259259870, 1259087468, 70968292, 978-1259087462

More Books

Students also viewed these Accounting questions

Question

What are some of the hiring standards to avoid?

Answered: 1 week ago

Question

What are some metrics for evaluating recruitment and selection?

Answered: 1 week ago