Basics & operators2 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFree

Gross profit per menu item

Fajar runs a small coffee shop near a campus in Yogyakarta. Every week he records the selling price, the cost per cup and the number of cups sold. This week he wants to know which menu item brings in the most profit.

Task

Fill E2:E6 with this week's gross profit for each item: (selling price minus cost per cup) times cups sold. Write the formula in E2, then copy it down.

Cells to fillE2:E6

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
Profit per cup = selling price - cost. Only then multiply it by the number of cups sold.
Hint 2
Excel does multiplication before subtraction. Wrap the subtraction in parentheses so it is calculated first.
Hint 3
The pattern is =(price - cost) * sold, with the price in B2, the cost in C2 and the cups sold in D2.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

E2:E6

=(B2-C2)*D2

Write it in E2, then fill down to E6.

Explanation

=(B2-C2)*D2 works out the profit per cup first because it is inside the parentheses, then multiplies it by the cups sold. Without parentheses, =B2-C2*D2 subtracts the cost of all cups from the price of a single cup and gives a large negative number. Another correct version: =B2*D2-C2*D2 (revenue minus total cost). The palm sugar milk coffee wins with Rp1,812,500 in profit.

Starting worksheet: Sheet1
Row	A	B	C	D	E
1	Menu item	Selling price	Cost per cup	Cups sold	Gross profit
2	Palm sugar milk coffee	22,000	9,500	145
3	Americano	18,000	6,000	88
4	Matcha latte	25,000	11,000	64
5	Iced lemon tea	12,000	3,500	120
6	Hot chocolate	20,000	8,000	47
7
8
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result