Question: Steven was looking back on his multiple years in the grocery business, realizing how much had changed in his company's customer service offerings. Originally, customers'

Steven was looking back on his multiple years in the grocery business, realizing how much had changed in his company's customer service offerings. Originally, customers' only option was to shop in-store for themselves. The store now offered online shopping with in-store pick-up, curbside delivery, and direct shipping to customers' homes. The industry had come a long way, but his business profits hadn't kept pace. His aim was to calculate profitability by customers using different shopping approaches, wondering if the company needed to change pricing for the different services.
His team gathered the following information. The three costs listed below COGS are directly traceable to the shopping approaches, with amounts listed as appropriate.
\table[[,Total,Customer Shopping Method],[,\table[[In-Store],[Shopping]],Online Shopping],[,In-Store pick-up,Curbside pick-up,Deliver to home],[Sales,$13,300,000,$9,310,000,$1,064,000,$665,000,$2,261,000],[Cost of goods sold,10,533,000,7,225,000,911,000,524,000,1,873,000],[Pick-n-Pack costs,248,000,,49,000,40,000,159,000],[Temporary storage costs,23,800,,4,900,4,900,14,000],[Customer shipping costs,19,000,,,,19,000],[General and administrative costs,942,500,,,,],[Selling expenses,247,000,,,,]]
(a)
For each category of service offering determine the gross margin and gross margin percentage. Rank the different categories by their gross margin percentages. (Round gross margin percentage to 2 decimal places, e.g.15.25%)
\table[[,In-store Shopping,In-store Pick-up,Curbside Pick-up,],[Gross margin,$,,$,,,$,,,$],[\table[[Gross],[margin],[percentage]],,%,,,%,,,%,],[Rank,,,,,,,,,],[4,,,,,,,,,-]]
 Steven was looking back on his multiple years in the grocery

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!