Nicole's Getaway Spa (NGS) has been so successful that Nicole has decided to expand her spa...

Nicole's Getaway Spa (NGS) has been so successful that Nicole has decided to expand her spa by selling merchandise. She sells things such as nail polish, at-home spa kits, cosmetics, and aromatherapy items. Nicole uses a perpetual inventory system and is starting to realizeall of the work that is created when inventory is involved in a business. The following transactions were selected from among those completed by NGS in August.

Aug.	2	Sold a bundle of spa services with a merchandise basket. When sold separately, the spa service part of the bundle sells for $672 and the merchandise basket normally sells for $168. Together, the bundle was sold to Val Amy for cash at a selling price of $570 (total). Val booked a spa treatment for August 10, and she took the basket of goods with her. The goods had cost NGS $165.
Aug.	3	Sold 5 identical items of merchandise to Cosmetics R Us on account at a selling price of $670 (total); terms n/30. The goods cost NGS $570.
Aug.	6	Cosmetics R Us returned one of the five items purchased on August 3. The item could still be sold by NGS in the future and credit was given to the customer.
Aug.	10	Val Amy used one of the three spa treatments she had purchased as part of the bundle sold to her on August 2.
Aug.	20	Sold two at-home spa kits to Meghan Witzel for $470 cash. The goods cost NGS $181.
Aug.	22	Cosmetics R Us paid its remaining account balance in full.

2-a. Calculate the Sales Revenue and Cost of Goods Sold for the transactions listed above (but exclude Service Revenue for spa services).

2-b. What is Nicole’s Getaway Spa’s gross profit percentage (excluding Service Revenue)? (Round your answer to 1 decimal place.)

Solutions

Expert Solution

calculation for Sales revenue and cost of goods sold

Aug 2 - Spa services actual selling price = $672.00

Spa Merchandise actual selling price = $168.00

Total Price = $840.00

Bundle Selling Price = $570.00

Bundle Discount = $840.00 - $570.00 = $270.00

Bundle discount percentage = $27.00/$840.00 *100 =32.14 %

so the Spa Merchandise selling price after bundle discount = $168.00 - (168*32.14/1000) = $ 168.00 - $54.00 = $114.00

Cost of Merchandise = $165.00 so the transaction has a loss of $165.00 - $114.00 = $51.00

Aug 3 Sales 5 units - $670.00

Cost of 5 Units - $570.00

Profit = $670.00 - $570.00 = $100.00

Aug 6 Return Inwards at selling price ($670.00/5) = $134 and cost is ($570.00/5 = $114.00

Aug 10 - Spa services is not considered in the calculation

Aug 20 - Sales 2 units - $470.00

Cost of 2 Units - $181.00

Profit = $470.00 - $181.00 = $289.00

Total sales revenue = $114.00 + $670.00 - $134.00 + 470 = $1120.00

Total cost of goods sold = $165.00 + $570.00 - 114 +181 = $802.00

2. Gross Profit = Sales Revenue - Cost of goods sold = $1,120.00 - $ 802.00 = $318.00

Gross profit percentage = Gross profit / sales *100 = $318.00 / $1,120.00 *100 = 28.4%

Gross Profit / COGS *100 = $318.00 / $802.00 *100 = 39.7%

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Nicole's Getaway Spa (NGS) has been so successful that Nicole has decided to expand her spa...

Nicole's Getaway Spa (NGS) has been so successful that Nicole has decided to expand her spa by selling merchandise. She sells things such as nail polish, at-home spa kits, cosmetics, and aromatherapy items. Nicole uses a perpetual inventory system and is starting to realize all of the work that is created when inventory is involved in a business. The following transactions were selected from among those completed by NGS in August. Aug.2 Sold a bundle of spa services with a...

Nicole has decided that she is going to start her business, Nicole’s Getaway Spa (NGS). A...

Nicole has decided that she is going to start her business, Nicole’s Getaway Spa (NGS). A lot has to be done when starting a new business. Here are some transactions that have occurred prior to April 30, 2017. Received $80,000 cash when issuing 8,000 new shares. Purchased some land by paying $2,000 cash and signing a note payable for $7,000 due in 2017. Hired a new esthetician for a salary of $1,000 a month, starting next month. Bought $1,000 in...

Nicole’s Getaway Spa (NGS) continues to grow and develop. Nicole is now evaluating a computerized accounting...

Nicole’s Getaway Spa (NGS) continues to grow and develop. Nicole is now evaluating a computerized accounting system and needs your help in understanding how source documents inform accounting processes. She also needs some help reconciling NGS’s bank account. Required: 1. For each source information shown below, prepare the appropriate journal entry. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) Purchase order dated October 13 for massage chairs costing $805 and...

CC6-1 Accounting for Merchandising Operations [LO 6-4, LO 6-5] Nicole's Getaway Spa (NGS) has been so...

CC6-1 Accounting for Merchandising Operations [LO 6-4, LO 6-5] Nicole's Getaway Spa (NGS) has been so successful that Nicole has decided to expand her spa by selling merchandise. She sells things such as nail polish, at-home spa kits, cosmetics, and aromatherapy items. Nicole uses a perpetual inventory system and is starting to realize all of the work that is created when inventory is involved in a business. The following transactions were selected from among those completed by NGS in August....

CC6-1 Accounting for Merchandising Operations [LO 6-4, LO 6-5] Nicole's Getaway Spa (NGS) has been so...

Nicole’s Getaway Spa (NGS) purchased a hydrotherapy tub system to add to the wellness programs at...

Nicole’s Getaway Spa (NGS) purchased a hydrotherapy tub system to add to the wellness programs at NGS. The machine was purchased at the beginning of the year at a cost of $6,500. The estimated useful life was five years and the residual value was $500. Assume that the estimated productive life of the machine is 10,000 hours. Expected annual production was year 1, 2,350 hours; year 2, 2,450 hours; year 3, 2,100 hours; year 4, 2,100 hours; and year 5,...

Nicole’s Getaway Spa (NGS) purchased a hydrotherapy tub system to add to the wellness programs at...

Nicole’s Getaway Spa (NGS) purchased a hydrotherapy tub system to add to the wellness programs at NGS. The machine was purchased at the beginning of the year at a cost of $9,500. The estimated useful life was five years and the residual value was $500. Assume that the estimated productive life of the machine is 10,000 hours. Expected annual production was year 1, 2,200 hours; year 2, 2,300 hours; year 3, 2,400 hours; year 4, 2,100 hours; and year 5,...

Nicole’s Getaway Spa (NGS) purchased a hydrotherapy tub system to add to the wellness programs at...

Nicole’s Getaway Spa (NGS) purchased a hydrotherapy tub system to add to the wellness programs at NGS. The machine was purchased at the beginning of the year at a cost of $25,000. The estimated useful life was five years and the residual value was $1,000. Assume that the estimated productive life of the machine is 10,000 hours. Expected annual production was year 1, 2,550 hours; year 2, 2,300 hours; year 3, 2,050 hours; year 4, 2,100 hours; and year 5,...

The following transactions occurred over the months of September to December at Nicole’s Getaway Spa (NGS)....

The following transactions occurred over the months of September to December at Nicole’s Getaway Spa (NGS). September Sold spa merchandise to Ashley Welch Beauty for $2,150 on account; the cost of these goods to NGS was $1,040. October Sold merchandise to Kelly Fast Nail Gallery for $590 on account; the cost of these goods to NGS was $270. November Sold merchandise to Raea Gooding Wellness for $440 on account; the cost of these goods to NGS was $260. December Received...

The following transactions occurred over the months of September to December at Nicole’s Getaway Spa (NGS)....

The following transactions occurred over the months of September to December at Nicole’s Getaway Spa (NGS). September Sold spa merchandise to Ashley Welch Beauty for $1,400 on account; the cost of these goods to NGS was $740. October Sold merchandise to Kelly Fast Nail Gallery for $290 on account; the cost of these goods to NGS was $120. November Sold merchandise to Raea Gooding Wellness for $140 on account; the cost of these goods to NGS was $110. December Received...

Subjects