Fruit Sales

Using Google Sheets you are going to create a cost and inventory sheet to see which fruit sales best during a week.

Create your Google Sheet:

Step 1:

Cell A1 type : Fruit Sales by the Pound

Merge and Center to G1

Leave Row 2 Blank

Cell A3 to A10

Fruits
Apples
Oranges
Bananas
Grapes
Peaches
Watermelon
Totals Pounds Sold a Day

Step 2:

in Cell B3 Through F3 type the days of the week (except weekends)

Monday - Friday

in Cell G3 Type:

Total Pounds by Fruit

STEP 3: fill in the data for the Fruit. See the example below

Create your Google Sheet to look like this.

STEP 4:

Using the "SUM" Function in cell B10 add the total amount of "Pounds Sold a Day". (b4:b9)

Do that for every day of the week.

Using the "SUM" Function in cell G4. Add the "Total Pounds of Fruit" (b4:f4)

STEP 5: Calculate How Much Money You Will Make a day and by Fruit

Create a New Data Table Below the Top Table.

(So you will skip Row 11 and 12. Leave those BLANK.)

Start in Cell A13.

Type: "Total $$ made a day at 1.03 per pound"

In cell A14 type in =A4 (Make sure to add the = sign) and hit enter on the keyboard.

If you did it correctly you will see it say "Apples". Then autofill to A19

Do the same for the days of the week.

In cell B13 Type =b3. Then autofill to f13

Last type in:

A20 "Totals $$ made a Day"

G13 "Total $$ made a Week by fruit"

STEP 6: Find the $$$

Now we need to find out how much $$ we are making.

In Cell b14 we are going to multiply cell b4 times $1.03. Here is the formula

=b4*1.03

Do the same for all the fruits and the days of the week

In Cell B20 SUM cells b14 to b19. Then do the same for all the days of the week in Row 20.

In Cell G14 SUM cells b14 to f14. Then do the same for all the fruits in Column G

STEP 7: Chart your totals

You are going to make a Pie Chart:

Select A:13 to G19

Click on the Chart Editor Icon

In the Chart Editor Select "Chart Type" and Find "Pie

Then format you chart to be 3D

Final Product should look similar to this. The numbers on this example are not the same one you will come up with. My data is different than the above data.

Page updated

Report abuse