ProductName CategoryName ProductSales

3-gal watering can Tools 122.15

Bow rake Tools 43.00
Clay flowerpot 2" Tools 85.32
Compost bin Tools 232.00
Edger Tools 17.95
Fiberglass loppers Tools 51.00
Garden Cart Tools 350.00
Garden hoe Tools 29.00
Gardening gloves (L) Tools 5.90
Gardening gloves (M) Tools 2.95
Gardening gloves (S) Tools 2.95
Grass rake Tools 35.85
Grass shears 5" Tools 18.25
Hand trowel Tools 22.05
Hand-held spreader Tools 10.95
Hose hanger Tools 6.00
Hose saver Tools 2.95
Landscape rake Tools 59.90
Lawn cart Tools 76.50
Leaf blower Tools 65.50
Long-handled shovel Tools 18.95
Low volume sprinkler Tools 29.25
Oscillating sprinkler Tools 14.95
Pistol-grip nozzle Tools 3.95
Planter's wagon Tools 54.00
Rotary sprinkler Tools 25.95
Soaker hose 50' Tools 16.95
Spade & fork set Tools 53.00
Sprinkler hose 25' Tools 19.90
Sprinkler hose 50' Tools 29.90
Sprinkler timer Tools 15.50
Tree pruners Tools 99.00
Weed whacker Tools 178.00
Wheelbarrow Tools 149.75
Tools Total
Cactus sand potting mix Soils/sand 31.50
Crushed glass Soils/sand 60.00
Crushed rock Soils/sand 161.20
GrowGood potting soil Soils/sand 31.75
Pea gravel Soils/sand 72.00
Peat moss Soils/sand 4.95
Soil/sand Total
Animal repellent Pest control 63.80
Animal trap Pest control 34.00
Bat box Pest control 113.58
Beneficial nematodes Pest control 19.95
Citronella candle Pest control 15.95
Inflatable owl Pest control 11.90
Ladybug house Pest control 14.00
Martin house Pest control 140.00
Sticky pest barrier Pest control 8.95
Pest control Total
Lawn fertilizer Fertilizers 24.00
Organic compost Fertilizers 14.25
Organic fertilizer Fertilizers 5.95
QwikRoot Fertilizers 18.00
Red earthworms Fertilizers 20.85
Rose & flower fertilizer Fertilizers 19.50
SureToGrow soil mix Fertilizers 79.60
Tree & shrub fertilizer spikes Fertilizers 9.00
Tree fertilizer Fertilizers 64.00
Fertilizers Total
Anacharis Wetland plants 8.75
Fragrant Water Lily Wetland plants 18.80
Pickerelweed Wetland plants 9.95
Water Snowflakes Wetland plants 10.50
Wetland plants Total
Austrian Pine Trees 72.00
Douglas Fir Trees 143.44
English Yew Trees 64.00
Golden Larch Trees 81.00
Scots Pine Trees 22.00
White Poplar Trees 76.80
Trees Total
Daisy Flowers 7.00
Grandiflora Hydrangeas Flowers 152.00
Flowers Total
American Pitcher Plant Carnivorous 28.00
Bladderwort Carnivorous 16.95
Butterworts Carnivorous 28.00
Pitcher Plant Carnivorous 30.00
Sundew Carnivorous 31.35
Carnivorous Total
Prickly Pear Cacti 9.00
Cacti Total
Anemone Bulbs 112.00
Autumn crocus Bulbs 75.00
Begonias Bulbs 37.90
Bulb planter Bulbs 13.90
Daffodil Bulbs 191.66
Lilies Bulbs 56.70
Lily-of-the-Field Bulbs 38.00
Siberian Iris Bulbs 69.93
Bulbs Total
Bonsai toolkit Bonsai supplies 60.00
Dwarf Ficus Benjamina Bonsai supplies 32.00
Dwarf Jack Pine Bonsai supplies 26.95
Dwarf Juniper Bonsai supplies 16.50
Dwarf Mugo Pine Bonsai supplies 39.95
Bonsai supplies Total
Blackberries Berry bushes 31.50
Gooseberries Berry bushes 45.00
Berry bushes Total
Grand Total $4,644.42
 Our Team
Karen Berg Owner Karen is the owner of Adventure Works. Her education includes a
degree in Accounting and an MBA from the University of
Washington. She completed "The Master Gardener" program at
Edmonds Community College and is a member of the American
Horticultural Society.

Kim Akers Head Buyer Kim received her BS in Botany from the University of Oregon. She
joined the company as a buyer and was promoted to head buyer.
Kim is a member of the American Horticultural Society.
David J. Osborn Assistant David completed a certificate program in non-toxic pest control
from Edmonds Community College. He was hired as an assistant.
Additionally he specializes in dealing with soils, fertilizers, chemical
and non-toxic pesticides.

Chase Carpenter Sales Manager Chase is a graduate of the University of California, Davis. He was
hired as a sales representative and was promoted to sales manager.
Kirk DeGrasse Gardener Kirk is a high-school graduate working as a gardener to gain
experience before entering college to pursue a degree in
horitculture. Kirk is responsible for watering, pruning, and
transplanting, as well as groundskeeping.

Nancy Anderson Sales Nancy is a part-time employee working as a sales representative

while attending Edmonds Community College Master Garden
Program.
Michael Emanuel Sales Michael is a full-time sales representative who brings several years
experience working with plants in nurseries.
Karen Furse Buyer Kari has a degree in Horticulture from the University of Hawaii. She
was hired as a buyer. Her interests are in bulbs, bonsai, and
flowering plants.
Sandeep Katyal Gardener Sandeep graduated from the University of Washington with a
degree in forest management. He was hired as a gardener,
specializing in evergreens and deciduous trees.
 Item Quantity Price
Item 1 10 $ 3.00
Item 2 10 $ 2.95
Item 3 10 $ 2.90
Item 4 10 $ 2.85
Item 5 10 $ 2.80
Item 6 10 $ 2.75
Item 7 10 $ 2.70
Item 8 10 $ 2.65
Item 9 10 $ 2.60
Item 10 10 $ 2.55
Item 11 10 $ 2.50
Item 12 10 $ 2.45
Item 13 10 $ 2.40
Item 14 10 $ 2.35
Item 15 10 $ 2.30
Item 16 10 $ 2.25
Item 17 10 $ 2.20
Item 18 10 $ 2.15
Item 19 10 $ 2.10
Item 20 10 $ 2.05
OrderID ProductIDUnitPrice Quantity Discount ExtendedPrice
11079 3 $58.00 1 0.00 $58.00
11079 18 $62.50 1 0.00 $62.50
11080 36 $18.75 1 0.00 $18.75
11080 41 $24.00 2 0.15 $44.42
11081 37 $27.00 1 0.00 $27.00
11081 62 $85.00 1 0.15 $72.33
11082 6 $14.75 3 0.00 $44.25
11083 3 $58.00 1 0.00 $58.00
11083 14 $6.35 1 0.00 $6.35
11083 26 $18.00 1 0.00 $18.00
11083 45 $11.95 1 0.00 $11.95
11084 39 $4.50 6 0.00 $27.00
11084 40 $7.50 3 0.00 $22.50
11084 49 $6.25 1 0.00 $6.25
11085 4 $4.50 2 0.00 $9.00
11086 6 $14.75 2 0.00 $29.50
11087 51 $24.00 3 0.00 $72.00
11088 60 $40.00 1 0.00 $40.00
11089 9 $12.95 1 0.00 $12.95
11089 10 $5.95 1 0.00 $5.95
11089 14 $6.35 1 0.00 $6.35
11089 29 $7.35 1 0.00 $7.35
11089 159 $6.00 1 0.00 $6.00
11089 170 $2.95 1 0.00 $2.95
11090 18 $21.00 2 0.00 $42.00
11091 2 $18.75 4 0.00 $75.00
11091 50 $28.00 3 0.00 $84.00
11091 53 $10.50 1 0.00 $10.50
11092 23 $25.95 1 0.00 $25.95
11092 27 $9.40 1 0.00 $9.40
11092 30 $24.00 1 0.00 $24.00
11092 49 $6.25 1 0.00 $6.25
11092 60 $40.00 2 0.15 $74.04
11093 4 $4.50 2 0.00 $9.00
11094 74 $17.45 1 0.00 $17.45
11094 110 $4.50 1 0.00 $4.50
11094 119 $5.50 1 0.00 $5.50
11094 127 $6.50 1 0.00 $6.50
11096 29 $7.35 1 0.00 $7.35
11096 56 $14.50 1 0.00 $14.50
11096 104 $7.00 3 0.00 $21.00
11096 107 $7.00 2 0.00 $14.00
11096 126 $4.75 2 0.00 $9.50
11097 49 $6.25 2 0.00 $12.50
11097 52 $38.00 1 0.00 $38.00
11097 96 $3.25 3 0.00 $9.75
11097 110 $4.50 1 0.00 $4.50
11097 136 $12.95 4 0.00 $51.80
11098 142 $39.95 1 0.00 $39.95
11098 143 $32.00 1 0.00 $32.00
11099 61 $54.00 1 0.00 $54.00
11100 41 $24.00 1 0.00 $24.00
11100 43 $20.00 1 0.00 $20.00
11100 109 $4.50 1 0.00 $4.50
11101 65 $14.00 1 0.00 $14.00
11102 36 $18.75 1 0.00 $18.75
11102 47 $16.50 1 0.00 $16.50
11103 36 $18.75 2 0.15 $34.71
11103 37 $27.00 1 0.00 $27.00
11103 108 $4.50 1 0.00 $4.50
11104 14 $6.35 3 0.00 $19.05
11104 86 $10.95 1 0.00 $10.95
11104 121 $7.50 1 0.00 $7.50
11105 101 $3.50 2 0.00 $7.00
11105 110 $4.50 1 0.00 $4.50
11106 63 $70.00 1 0.00 $70.00
11107 45 $11.95 1 0.00 $11.95
11107 90 $18.25 1 0.00 $18.25
11108 19 $4.25 1 0.00 $4.25
11108 99 $2.25 1 0.00 $2.25
11109 113 $12.00 1 0.00 $12.00
11110 9 $12.95 1 0.00 $12.95
11110 10 $5.95 1 0.00 $5.95
11110 27 $9.40 1 0.00 $9.40
11110 74 $17.45 1 0.00 $17.45
11110 83 $29.25 1 0.00 $29.25
11110 96 $3.25 1 0.00 $3.25
11110 166 $3.95 12 0.15 $46.81
11111 18 $21.00 3 0.15 $59.87
11111 80 $29.95 1 0.00 $29.95
11112 38 $12.00 6 0.15 $70.21
11113 24 $17.95 2 0.00 $35.90
11113 25 $9.95 4 0.00 $39.80
11113 45 $11.95 1 0.00 $11.95
11113 113 $12.00 1 0.00 $12.00
11114 5 $18.00 3 0.00 $54.00
11115 69 $65.50 1 0.00 $65.50
11116 39 $4.50 1 0.00 $4.50
11116 40 $7.50 3 0.00 $22.50
11117 58 $16.50 1 0.00 $16.50
11118 60 $40.00 1 0.00 $40.00
11119 54 $32.00 2 0.00 $64.00
11120 132 $15.95 1 0.00 $15.95
11121 4 $4.50 1 0.00 $4.50
11121 98 $3.00 2 0.00 $6.00
11122 72 $17.95 1 0.00 $17.95
11122 74 $17.45 1 0.00 $17.45
11122 100 $9.95 4 0.00 $39.80
11122 139 $18.95 1 0.00 $18.95
11123 89 $25.50 1 0.00 $25.50
11124 68 $30.95 1 0.00 $30.95
11124 109 $4.50 1 0.00 $4.50
11125 123 $4.50 1 0.00 $4.50
11125 135 $12.95 6 0.15 $75.77
11125 156 $6.95 1 0.00 $6.95
11126 81 $14.95 1 0.00 $14.95
11126 85 $15.50 1 0.00 $15.50
11127 16 $14.50 1 0.00 $14.50
11128 30 $24.00 1 0.00 $24.00
11129 77 $10.50 1 0.00 $10.50
11130 105 $6.95 3 0.00 $20.85
11131 87 $49.50 1 0.00 $49.50
11132 4 $4.50 1 0.00 $4.50
11132 94 $125.00 1 0.00 $125.00
11132 98 $3.00 1 0.00 $3.00
11133 44 $30.00 2 0.00 $60.00
11133 80 $29.95 1 0.00 $29.95
11133 93 $21.50 1 0.00 $21.50
11134 20 $4.95 1 0.00 $4.95
11134 25 $9.95 1 0.00 $9.95
11134 50 $28.00 1 0.00 $28.00
11134 55 $9.75 1 0.00 $9.75
11134 74 $17.45 1 0.00 $17.45
11134 139 $18.95 1 0.00 $18.95
11135 43 $20.00 1 0.00 $20.00
11135 56 $14.50 1 0.00 $14.50
11135 57 $53.00 1 0.00 $53.00
11135 117 $5.95 1 0.00 $5.95
11136 116 $6.50 1 0.00 $6.50
11137 12 $12.95 6 0.15 $75.77
11137 29 $7.35 1 0.00 $7.35
11137 116 $6.50 1 0.00 $6.50
11137 126 $4.75 1 0.00 $4.75
11138 3 $58.00 1 0.00 $58.00
11138 115 $15.95 1 0.00 $15.95
11139 32 $10.00 1 0.00 $10.00
11139 107 $7.00 2 0.00 $14.00
11140 144 $26.95 1 0.00 $26.95
11141 153 $5.95 2 0.00 $11.90
11142 161 $16.95 1 0.00 $16.95
11143 25 $9.95 1 0.00 $9.95
11143 74 $17.45 1 0.00 $17.45
11143 110 $4.50 1 0.00 $4.50
11143 166 $3.95 12 0.15 $46.81
11144 31 $10.00 3 0.00 $30.00
11145 68 $30.95 1 0.00 $30.95
11145 70 $89.00 1 0.00 $89.00
11145 80 $29.95 1 0.00 $29.95
11145 89 $25.50 1 0.00 $25.50
11146 49 $6.25 4 0.00 $25.00
11147 5 $18.00 1 0.00 $18.00
11147 80 $29.95 1 0.00 $29.95
11147 145 $4.95 1 0.00 $4.95
11148 4 $4.50 1 0.00 $4.50
11148 38 $12.00 1 0.00 $12.00
11148 92 $18.95 1 0.00 $18.95
11148 128 $32.00 1 0.00 $32.00
11149 74 $17.45 1 0.00 $17.45
11149 94 $125.00 1 0.15 $106.37
11149 97 $2.75 6 0.00 $16.50
11149 100 $9.95 1 0.00 $9.95
11149 119 $5.50 1 0.00 $5.50
11150 123 $4.50 1 0.00 $4.50
11150 138 $10.50 6 0.15 $61.44
11150 156 $6.95 1 0.00 $6.95
11151 79 $8.75 1 0.00 $8.75
11151 82 $9.95 1 0.00 $9.95
11151 136 $12.95 12 0.15 $153.47
11151 157 $2.95 1 0.00 $2.95
11151 169 $2.95 1 0.00 $2.95
11152 3 $58.00 1 0.00 $58.00
11152 8 $19.95 1 0.00 $19.95
11152 80 $29.95 1 0.00 $29.95
11152 81 $14.95 1 0.00 $14.95
11152 93 $21.50 1 0.00 $21.50
11152 160 $14.95 1 0.00 $14.95
11152 162 $6.95 3 0.00 $20.85
11152 171 $2.95 1 0.00 $2.95
11153 30 $24.00 1 0.00 $24.00
11153 36 $18.75 1 0.00 $18.75
11153 37 $27.00 1 0.00 $27.00
11154 132 $15.95 3 0.00 $47.85
11155 35 $22.00 1 0.00 $22.00
11155 36 $18.75 3 0.05 $55.31
11155 87 $49.50 1 0.00 $49.50
11155 108 $4.50 1 0.00 $4.50
11155 128 $32.00 1 0.00 $32.00
11155 134 $8.95 1 0.00 $8.95
11156 76 $9.95 1 0.00 $9.95
11156 104 $7.00 1 0.00 $7.00
11156 106 $6.95 1 0.00 $6.95
11157 64 $34.00 1 0.00 $34.00
11158 71 $29.95 1 0.00 $29.95
11159 6 $14.75 3 0.15 $42.05
11159 63 $70.00 1 0.00 $70.00
11160 70 $89.00 1 0.00 $89.00
11160 71 $29.95 1 0.00 $29.95
11160 94 $125.00 1 0.15 $106.37
11160 171 $2.95 1 0.00 $2.95
11161 12 $12.95 6 0.15 $75.77
11161 25 $9.95 1 0.00 $9.95
11161 55 $9.75 3 0.00 $29.25
11161 74 $17.45 1 0.00 $17.45
11161 96 $3.25 5 0.00 $16.25
11161 116 $6.50 1 0.00 $6.50
11162 140 $60.00 1 0.00 $60.00
11163 43 $20.00 4 0.15 $77.02
11164 17 $5.65 2 0.00 $11.30
11164 20 $4.95 4 0.00 $19.80
11165 25 $9.95 1 0.00 $9.95
11165 82 $9.95 1 0.00 $9.95
11165 119 $5.50 1 0.00 $5.50
11165 158 $3.95 1 0.00 $3.95
Magazine Readers Number of Ads Cost per Ad Total Cost Audience
Mag1 100,000 8 $ 30,000.00 $ 240,000.00 800,000
Mag2 350,000 8 $ 27,000.00 $ 216,000.00 2,800,000
Mag3
Mag4 200,000 10 $ 80,000.00 $ 800,000.00 2,000,000
Totals $ 1,256,000.00 5,600,000

Total Budget $ 3,000,000.00

Minimum Audience 10,000,000
Constraints Minimum Ads for Magazines 1 through 3 8
Minimum Ads for Magazine 4 10
Maximum Ads in Any Magazine 20

Magazine Readers Number of Ads Total Cost Audience

Mag1 100,000 8 $ 240,000.00 800,000
Mag2 Cost per Ad 400,000 8 $ 320,000.00 3,200,000
Mag3 $ 30,000.00 350,000 8 $ 216,000.00 2,800,000
Mag4 $ 40,000.00 200,000 10 $ 800,000.00 2,000,000
Totals $ 27,000.00 $ 1,576,000.00 8,800,000
$ 80,000.00
Magazine Readers Number of Ads Total Cost Audience
Mag1 100000 8 240000 800000
Mag2 Cost per Ad 400000 8 320000 3200000
Mag3 30000 350000 8 216000 2800000
Mag4 40000 200000 10 800000 2000000
Totals 27000 1576000 8800000
80000
Magazine
Period Region Sales Period Subtotal by period
Fall NE $ 760,000.00 Fall ₹ 1,926,000.00
Fall NW $ 456,000.00 Spring ₹ 1,560,000.00
Fall SE $ 300,000.00 Summer ₹ 1,560,000.00
Fall SW $ 410,000.00 Winter ₹ 1,547,000.00
Spring NE $ 540,000.00
Spring NW $ 360,000.00
Spring SE $ 280,000.00 Period Average by period
Spring SW $ 380,000.00 Fall $ 481,500.00
Summer NE $ 460,000.00 Spring $ 390,000.00
Summer NW $ 500,000.00 Summer $ 390,000.00
Summer SE $ 200,000.00 Winter $ 386,750.00
Summer SW $ 400,000.00
Winter NE $ 500,000.00
Winter NW $ 320,000.00
Winter SE $ 240,000.00
Winter SW $ 487,000.00
Region Subtotal by region
NE $ 2,260,000.00
NW $ 1,636,000.00
SE $ 1,020,000.00
SW $ 1,677,000.00

Region Average by region

NE $ 565,000.00
NW $ 409,000.00
SE $ 255,000.00
SW $ 419,250.00
 January
Hour
Day 5:00 AM 6:00 AM 7:00 AM 8:00 AM 9:00 AM 10:00 AM 11:00 AM 12:00 PM 1:00 PM 2:00 PM

1 2117 1989 1544 2408 1921 1505 1687 2391 1486 2075
2 1128 1109 1354 1115 2277 1432 1559 2103 2493 1317
3 1228 1350 1662 1758 1892 1710 1709 1889 1495 1405
4 2295 2496 1964 1793 1138 1592 1811 1479 2339 1839
5 1866 1631 1631 1136 1959 2275 2348 1355 1346 1947
6 1234 1536 2348 1208 2109 2382 2487 2464 1755 2086
7 1608 1825 1851 1037 2259 2091 2211 1195 1395 1727
8 1903 2014 1451 1283 2243 1266 1746 2243 1385 1414
9 2275 2360 1392 1511 1942 1639 2018 2468 2247 2493
10 1039 2191 1729 1028 2278 1044 1936 1233 1677 1988
11 1569 1069 1487 1155 2434 2181 1721 2235 1534 1407
12 1773 1782 1224 2401 2426 1514 1526 1086 1478 1943
13 2108 1511 1916 2488 1459 1703 1706 2083 2305 2348
14 1512 2319 2239 1063 1164 2115 1469 1629 2398 1970
15 1003 1283 1874 1512 1238 1993 2390 2040 1366 1422
16 2007 1864 2088 1228 2023 1186 1585 1422 1486 2232
17 1016 2400 1039 1024 1107 2178 1445 1452 1506 1605
18 1794 2291 2166 1966 1650 1899 1931 2124 1166 1630
19 1904 2424 1799 2332 1089 1132 1045 1203 1364 2346
20 2035 2174 1123 2277 1400 2468 1287 2146 1578 1476
21 1288 2321 1171 1884 2292 2437 2465 1936 2138 1043
22 1577 1235 1742 1089 2203 2143 1073 1795 1960 1874
23 1987 1349 2170 1728 2426 1015 1227 1762 2352 1383
24 1868 2459 1380 1390 2270 1336 1886 1541 1774 1911
25 1058 1541 1753 1740 2360 2308 2167 1131 1146 1966
26 2016 2412 1128 1477 1184 2104 1513 1222 1484 1385
27 1640 2180 1904 1048 1531 1541 1858 1744 1605 1280
28 2363 1340 2113 1350 1814 2358 1613 1519 1938 1665
29 2398 1324 1572 2264 1335 2002 1495 1423 2190 2170
 30 2225 1178 1633 1148 1640 1872 1581 1431 2024 1423
31 1726 1794 2020 1777 1016 1405 1845 2108 1597 1846
February
Hour
Day 5:00 AM 6:00 AM 7:00 AM 8:00 AM 9:00 AM 10:00 AM 11:00 AM 12:00 PM 1:00 PM 2:00 PM

1 2117 1989 1544 2408 1921 1505 1687 2391 1486 2075
2 1128 1109 1354 1115 2277 1432 1559 2103 2493 1317
3 1228 1350 1662 1758 1892 1710 1709 1889 1495 1405
4 2295 2496 1964 1793 1138 1592 1811 1479 2339 1839
5 1866 1631 1631 1136 1959 2275 2348 1355 1346 1947
6 1234 1536 2348 1208 2109 2382 2487 2464 1755 2086
7 1608 1825 1851 1037 2259 2091 2211 1195 1395 1727
8 1903 2014 1451 1283 2243 1266 1746 2243 1385 1414
9 2275 2360 1392 1511 1942 1639 2018 2468 2247 2493
10 1039 2191 1729 1028 2278 1044 1936 1233 1677 1988
11 1569 1069 1487 1155 2434 2181 1721 2235 1534 1407
12 1773 1782 1224 2401 2426 1514 1526 1086 1478 1943
13 2108 1511 1916 2488 1459 1703 1706 2083 2305 2348
14 1512 2319 2239 1063 1164 2115 1469 1629 2398 1970
15 1003 1283 1874 1512 1238 1993 2390 2040 1366 1422
16 2007 1864 2088 1228 2023 1186 1585 1422 1486 2232
17 1016 2400 1039 1024 1107 2178 1445 1452 1506 1605
18 1794 2291 2166 1966 1650 1899 1931 2124 1166 1630
19 1904 2424 1799 2332 1089 1132 1045 1203 1364 2346
20 2035 2174 1123 2277 1400 2468 1287 2146 1578 1476
21 1288 2321 1171 1884 2292 2437 2465 1936 2138 1043
22 1577 1235 1742 1089 2203 2143 1073 1795 1960 1874
23 1987 1349 2170 1728 2426 1015 1227 1762 2352 1383
24 1868 2459 1380 1390 2270 1336 1886 1541 1774 1911
25 1058 1541 1753 1740 2360 2308 2167 1131 1146 1966
26 2016 2412 1128 1477 1184 2104 1513 1222 1484 1385
27 1640 2180 1904 1048 1531 1541 1858 1744 1605 1280
28 1726 1794 2020 1777 1016 1405 1845 2108 1597 1846
3:00 PM 4:00 PM 5:00 PM

1626 1326 1612

1519 1836 1439
1513 1493 1997
2416 1838 1403
2098 1163 1410
1261 1989 2338
1171 1753 1029
1675 2274 1765
1827 2261 1861
1690 1649 1784
1187 1581 2355
1028 1988 1892
1662 2218 2257
1665 1343 1471
2344 1144 1011
1907 2001 1919
1925 2223 1136
2178 1185 1915
1654 1483 1866
2411 1721 2173
2265 1660 1949
1312 1332 1920
2144 1583 2223
2079 2269 1688
2120 2038 2380
2271 1842 2453
1937 1013 1817
1104 1065 1934
2282 1920 1743
 1972 1674 1700
1737 2024 1914

3:00 PM 4:00 PM 5:00 PM

1626 1326 1612

1519 1836 1439
1513 1493 1997
2416 1838 1403
2098 1163 1410
1261 1989 2338
1171 1753 1029
1675 2274 1765
1827 2261 1861
1690 1649 1784
1187 1581 2355
1028 1988 1892
1662 2218 2257
1665 1343 1471
2344 1144 1011
1907 2001 1919
1925 2223 1136
2178 1185 1915
1654 1483 1866
2411 1721 2173
2265 1660 1949
1312 1332 1920
2144 1583 2223
2079 2269 1688
2120 2038 2380
2271 1842 2453
1937 1013 1817
1737 2024 1914
Country Continent Official/Primary Language Population Area (Square KM) Currency
China Asia Standard Chinese 1,397,715,000 9,596,960 CNY
India Asia Hindi 1,366,417,754 3,287,263 INR
United States North America English 328,239,523 9,833,517 USD
Indonesia Asia Indonesian 270,203,917 1,904,569 IDR
Pakistan Asia Urdu 216,565,318 796,095 PKR
Brazil South America Portuguese 212,559,417 8,515,770 BRL
Nigeria Africa English 200,963,599 923,768 NGN
Bangladesh Asia Bengali 163,046,161 148,460 BDT
Russia Europe Russian 144,373,535 17,098,240 RUB
Mexico North America Spanish 126,014,024 1,964,375 MXN
Japan Asia Japanese 126,264,931 377,944 JPY
Ethiopia Africa Amharic 112,078,730 1,104,300 ETB
Philippines Asia Tagalog 108,116,615 300,000 PHP
Egypt Africa Modern Standard Arabic 100,388,073 1,001,450 EGP
Vietnam Asia Vietnamese 96,462,106 331,210 VND
Democratic Republic of
the Congo Africa French 86,790,567 2,344,858 CDF
Iran Asia Persian 82,913,906 1,648,195 IRR
Turkey Asia Turkish 83,429,615 783,562 TRY
Germany Europe German 83,132,799 357,022 EUR
France Europe French 67,059,887 643,801 EUR
United Kingdom Europe English 66,834,405 243,610 GBP
Thailand Asia Thai 69,625,582 513,120 THB
South Africa Africa Zulu 58,558,270 1,219,090 ZAR
Tanzania Africa Swahili 58,005,463 947,300 TSH
Italy Europe Italian 60,297,396 301,340 EUR
Myanmar Asia Burmese 54,045,420 676,578 MMK
South Korea Asia Korean 51,709,098 99,720 KRW
Colombia South America Spanish 50,339,443 1,138,910 COP
Kenya Africa Kiswahili 52,573,973 580,367 KES
Spain Europe Spanish 47,076,781 505,370 EUR
GDP (Billions) Spanish
14,343 Spanish speaking countries located in South America 1
2,611 countries have population greater than 100 million, and Area less than 1,000,000 Square KM
22,675
1,119
304
1,840
448
303
1,700
1,258
5,082
96
377
303
262

47
445
754
3,846
2,716
2,827
544
351
63
2,001
76
2,029
324
96
1,394
 Continent
South America #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?

#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
Total Population
4086515423
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?

#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
1

4
5
6
7
8
9
10
11
12

13

14
15
16

17

18
19

20
21
22
23
Search the workbook for all instances of the word garden. Confirm that the search returns results from all the worksheets.
Search the workbook for text that is formatted with a White font color. Change the font color to Orange to show that you

Display the Product List worksheet and do the following:

Move to the first cell that contains a comment.

by using the data in cells B4:G9 of the Ad Buy Constraints worksheet:

Paste only the values and formatting into the range beginning at B18.
Paste only the formulas into the range beginning at B25.
Paste only the formatting (but not the content) into the range beginning at B32.
Delete rows to move the headings to row 1.
Delete columns to move the Magazine column to column A.
Cut the data from the Mag3 row (B4:F4) and insert it into the Mag2 row (B3:F3).
Move the Cost Per Ad data to the left of the Total Cost cells.
Insert two blank cells in positions B8:B9, shifting any existing data down.
Transpose the names in the Magazine column (cells A1:A6) to the first row of a new worksheet.

On the Price List worksheet, do the following:

❑ Using the fill handle, fill cells A2:A21 with Item 1, Item 2, Item 3, and so on through Item 20. with $3.00, $2.95, $2.90, an

On the Order Details worksheet, use conditional formatting to do the following to all the values in the Extended Price co
Add blue data bars to the column. (Keep the default settings.)
Apply the 3 Arrows (Colored) icon set. (Keep the default settings.)
Fill all cells in the column that contain values of greater than $100 with bright yellow.

On the JanFeb worksheet, do the following:

Insert a row below the times. In that row, summarize the data for each hour by using a Column sparkline.

On the Sales By Region worksheet, do the following:

❑ Create subtotals of sales amounts first by period and then by region
Find the average sales by period and then by region.

On country worksheet do the following:

insert a function in J2 that will calculate the number of Spanish speaking countries that are located in South America
Insert a function in J3 that will calculate the number of countries have population greater than 100 million, and Area less t
Go to V1 and create the list of unique list of continents present in the range A1: G31
Insert a function in w2 that will calculate the total population of the first continent and autofill it to get the total populatio
 12 Cells found

4 Cells found

Square KM

he unique continent