Question

Financial Accounting for MBAs 7th Edition. P5-48 (page 5-43)

Target Corporation reported total sales of $73,785 million in 2015, $72,618 million in 2014, and $71,279 million in 2013. In 2015, cost of sales was $51,997 million.

The revenue recognition footnote from Target’s 2015 annual report includes the following:

• Our retail stores generally record revenue at the point of sale.
• Digital channel sales include shipping revenue and are recorded upon delivery to the guest.
• Total revenues do not include sales tax because we are a pass-through conduit for collecting and remitting sales taxes.
• Generally, guests may return national brand merchandise within 90 days of purchase and owned and exclusive brands within one year of purchase. Revenues are recognized net of expected returns, which we estimate using historical return patterns as a percentage of sales.
• Revenue from gift card sales is recognized upon gift card redemption. Our gift cards do not expire. Based on historical redemption rates, a small and relatively stable percentage of gift cards will never be redeemed, referred to as “breakage.” Estimated breakage revenue is recognized over time in proportion to actual gift card redemptions and was not material in any period presented.
• Guests receive a 5 percent discount on virtually all purchases and receive free shipping at Tar-get.com when they use their REDcard. These discounts associated with loyalty programs are included as reductions in sales in our Consolidated Statements of Operations and were $1,067 million, $943 million, and $833 million in 2015, 2014, and 2013, respectively

Gift Card Information: $millions

Gift card balance May 1..................$198

New gift cards sold..........................148

Gift cards redeemed.......................(172)

Gift card balance May 31................$174

1. Use the financial statement effects template to record retail sales of $1,000 in a state with a sales-tax rate of 8%. For this question, assume 10% of all merchandise sold is returned within 90 days.

2. Use the financial statement effects template to record the following transaction: On March 4, an internet customer places an order for $2,000 and pays online with a credit card (which is equivalent to cash for accounting purposes). The goods are shipped from the warehouse on March 6, and FedEx confirms delivery on March 7. Ignore shipping costs, sales tax, and returns.

3. Use the financial statement effects template to record the gift card activity during May. Ignore sales tax and returns. Details are on page 1.

4. Determine the amount of revenue Target collected from customers who used their loyalty card (REDcard™) for 2013 to 2015. What proportion of total revenues comes from REDcard™ customers each year? Does the loyalty program seem to be working? Explain.

Answer 1

a	Total sale is $1000 and tax rate is 8%. According to the company's policy, sales will record without giving any tax effects.
	But further sales will record after giving the effects of returned goods i.e 10% of total sales.
	Hence net sale will record $900 ($1000-10% of 1000) after giving the effect of returned goods but without giving any
	tax effects.
b	On 7th march, sales will recognize as per the companys policy with $1900 ($2000-5% of $2000)
c	Gift card account in T format
	Particulars (Dr.)	Amount in $	Particulars (Cr.)	Amount in $
	Gift card redeemed	172	Opening balance on 1 may	198
			New card sold	148
	Closing balance on 31st may	174
	Total	346	Total	346
d	Particular	Year
		2013	2014	2015
	Sales (a)	$71,279	$72,618	$73,785
	Discount (b)	$833	$943	$1,067
	Discount rate @5% ©	5%	5%	5%
	Target revenue (b/c=d)	$16,660	$18,860	$21,340
	proportion to total revenue (d/a)*100	23.37%	25.97%	28.92%
	From the above solution , as sales revenue is in increasing trend , loyalty card is successful.