logo

Crowdly

Browser

Add to Chrome

Based on this pivot table in Lab 1.3 Excel, Assessing Product (SKU) Profitabili...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Based on this pivot table in Lab 1.3 Excel, Assessing Product (SKU) Profitability, which product number is the most profitable per dollar of sales?

S K U, description, sales price per pound, cost per pound, gross margin, and gross margin percentage are the column heads of the pivot table with dropdown buttons. The row entries are as follows: F R T hyphen S A R, salal berry, 1.12, 0.66, 0.46, and 0.411. F R T hyphen R E N, redcurrant, 1.42, 0.85, 0.57, and 0.401. F R T hyphen A V D, avocado, 1, 0.59, 0.41, and 0.410. F R T hyphen P U E, purple mangos, 1.01, 0.59, 0.42, and 0.416. F R T hyphen B I T, bilberty, 2, 1.17, 0.83, and 0.415. F R T hyphen P L T, plumcot, 2.1, 1.24, 0.86, and 0.410. F R T hyphen B L N, blackcurrent, 2, 1.18, 0.82, and 0.410. F R T hyphen P I L, pineapple, 0.77, 0.46, 0.31, and 0.403. F R T hyphen P L M, plumprune, 1.31, 0.77, 0.54, and 0.412. F R T hyphen C U N, currant, 1.75, 1.04, 0.71, and 0.406. F R T hyphen P E A, pear, 1.83, 1.07, 0.76, and 0.415. F R T hyphen P A Y, papaya, 1.06, 0.63, 0.43, and 0.406. F R T hyphen C H I, chico fruit, 1.75, 1.03, 0.72, and 0.411. F R T hyphen M I I, miracle fruit, 2.05, 1.2, 0.85, and 0.415. F R T hyphen L O A, Longan, 1.85, 1.1, 0.75, and 0.405. F R T hyphen L I M, lime, 0.96, 0.57, 0.39, and 0.406. F R T hyphen C U E, cucumber, 1.82, 1.09, 0.73, and 0.401. F R T hyphen K I I, kiwifruit, 2.32, 1.37, 0.95, and 0.409. F R T hyphen J A U, jambul, 1.95, 1.13, 0.82, and 0.421. F R T hyphen J A I, jackfruit, 0.63, 0.37, 0.26, and 0.413. F R T hyphen J A B, jabuticaba, 0.89, 0.52, 0.37, and 0.416. F R T hyphen G U V, guava, 0.94, 0.56, 0.38, and 0.404. F R T hyphen G R I, graperaisin, 1.25, 0.74, 0.51, and 0.408.

❌
✅
❌
❌
More questions like this

Want instant access to all verified answers on moodle.polytechnic.bh?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome

TelegramInstagramTikTokQuestion Bank
Terms of UseContact Us