Question: 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.
 \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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!