i have to do all projects for my computer class in the book GO office 2013 volume 1 in word...

profileothfal
excel.zip
Home>Computer Science homework help>i have to do all projects for my computer class in the book GO office 2013 volume 1 in word...

e01_student_data_files.zip

e01_student_data_files/e01_1A_Web.docx

Second Quarter Cardio Sales

Exercise Bikes

68,991.12

86,894.82

99,650.58

255,536.52

Elliptical Machines

28,836.00

22,634.23

22,828.78

74,299.01

Treadmills

59,519.78

82,337.98

99,823.87

241,681.63

Rowing Machines

81,267.17

87,867.50

91,669.98

260,804.65

Total

238,614.07

279,734.53

313,973.21

832,321.81

e01_student_data_files/e01_1B_Web.docx

Pro Fit Marietta

Plyometric Products Inventory Valuation

Warehouse Location

Quantity In Stock

Retail Price

Power Hurdle

Atlanta

125

32.95

Speed Hurdle

Atlanta

995

59.95

Stackable Steps

Marietta

450

251.59

Pro Jump Rope

Marietta

1,105

49.95

Plyometric Box Set

Marietta

255

158.05

Plyometrics Mat

Atlanta

215

94.99

e01_student_data_files/e01H_Team_Sales.xlsx

Sheet1

Pro Fit Marietta
Sales by Team Mmbers
Month Eding June 30
Week 1 Week 2 Week 3 Week 4 Total Percent of Total Sales
Mendez A. 2523.00 3555.00 2945.00 3689.00 12712.00 0.2756287944
Lee J. 2,687 4,785 3,654 4,241 15,367 ERROR:#DIV/0!
Lampert R. 1,865 2,688 3,003 3,266 10,822 ERROR:#DIV/0!
Orr D. 1,423 1,958 2,566 3,230 9,177 ERROR:#DIV/0!
Walters, L. 2,587 2,563 2,842 4,254 12,246 ERROR:#DIV/0!
Fenway, N. 1,987 3,016 3,584 5,288 13,875 ERROR:#DIV/0!
Total 7862.00 10225.00 11995.00 16038.00 46120.00

Week 1 Mendez A. Lee J. Lampert R. Orr D. Walters, L. Fenway, N. 2523 2687 1865 1423 2587 1987 Week 2 Mendez A. Lee J. Lampert R. Orr D. Walters, L. Fenway, N. 3555 4785 2688 1958 2563 3016 Week 3 Mendez A. Lee J. Lampert R. Orr D. Walters, L. Fenway, N. 2945 3654 3003 2566 2842 3584 Week 4 Mendez A. Lee J. Lampert R. Orr D. Walters, L. Fenway, N. 3689 4241 3266 3230 4254 5288

e01_student_data_files/e01J_Kettlebell_Sales.xlsx

Sheet1

Pro Fit Marietta
Vinyl Kettlebell Sales Summary
Year Ending December 31, 2016
Quarter 1 Total Sold Retail Price Total Sales Percent of Total Sales
5 pound 98 210 136 232 29.99
10 pound 150 143 70 99 39.99
20 pound 70 82 54 65 69.99
40 pound 25 75 82 83 99.99
Total For All Products

&F

e01_student_data_files/e01K_Commission.xlsx

Sheet1

Pro Fit Marietta
First Quarter Salesperson Commissions
January Total Trend
Northeast 25696.63 28963.17 29527.49
Southeast 13646.37 12533.22 15621.28
Midwest 12981.36 13998.99 11586.57
West 22877.52 25776.44 24696.53
Total Commission

e02_student_data_files.zip

e02_student_data_files/e02_2A_Web.docx

Total Items in Stock

Average Price

Median Price

Lowest Price

Highest Price

Oak Trees:

Magnolia Trees:

Quantity in Stock

Item #

Tree Name

Retail Price

Light

Landscape Use

Category

Stock Level

78

13129

Golden Oak

108.99

Partial Sun

Erosion

Oak

35

13358

Columnar English

106.95

Full Shade

Border

Oak

60

15688

Coral Bark

106.25

Partial Shade

Erosion

Oak

20

16555

Crimson King

105.50

Full Shade

Border

Oak

75

21683

Japanese Blooming

103.99

Partial Shade

Erosion

Cherry

60

22189

Crimson Queen

109.95

Filtered Sun

Erosion

Oak

68

23677

Black Japanese

107.99

Partial Sun

Border

Maple

71

23688

Artist Flowering

109.95

Partial Sun

Erosion

Pear

159

24896

Bing Small Sweet

105.99

Partial Shade

Border

Cherry

60

25678

Bartlett

109.75

Partial Sun

Erosion

Pear

179

25844

Bloodgood

110.99

Partial Shade

Border

Maple

90

26787

Sentry

108.50

Partial Sun

Border

Oak

81

32544

Burgundy Bell

110.95

Partial Sun

Border

Maple

81

34266

Lace Maple

109.99

Partial Sun

Border

Maple

113

34793

Emerald Elf

103.98

Full Shade

Erosion

Oak

191

34878

Ginger Pear

107.78

Partial Sun

Border

Pear

102

34982

Fernleaf

105.99

Partial Shade

Border

Oak

170

35677

Flamingo

109.99

Partial Sun

Border

Oak

170

35690

Bing Sweet

107.99

Partial Sun

Erosion

Cherry

70

35988

Butterfly Japanese

111.75

Partial Sun

Border

Maple

92

36820

Ever Red

110.95

Partial Sun

Border

Maple

173

37803

Osakazuki

103.88

Full Shade

Erosion

Oak

113

37845

Anna

117.98

Partial Sun

Woodland Garden

Magnolia

75

38675

Palo Alto

102.99

Partial Shade

Erosion

Oak

93

38700

Pacific Fire

103.75

Full Shade

Erosion

Oak

45

38744

Cheals Weeping

104.99

Partial Shade

Erosion

Cherry

58

39704

Embers

105.99

Partial Sun

Erosion

Oak

90

42599

Beurre

109.98

Partial Sun

Border

Pear

350

43153

Bradford

104.99

Full Shade

Border

Pear

20

43625

Petite Red

79.99

Partial Shade

Hedge

Oak

136

43633

Athene

105.99

Partial Shade

Woodland Garden

Magnolia

169

43813

Japanese Flowering

104.99

Partial Shade

Erosion

Maple

93

44482

Majestic Oak

105.99

Filtered Sun

Erosion

Oak

75

44587

Capital Flowering

116.98

Partial Sun

Border

Pear

160

44589

Paperbark

111.87

Full Shade

Erosion

Oak

85

44879

Candlewood

107.99

Partial Sun

Erosion

Pear

90

45265

Cleveland Select

106.98

Full Shade

Erosion

Pear

25

45688

Comice

107.99

Partial Sun

Erosion

Pear

190

46532

Bold Box

100.95

Partial Sun

Erosion

Maple

73

49652

Pagoda

105.99

Partial Shade

Border

Oak

110

52164

Evergreen

118.98

Partial Sun

Erosion

Pear

110

53634

Butterflies

116.99

Partial Sun

Woodland Garden

Magnolia

250

54635

Kagiri

102.99

Partial Shade

Border

Maple

120

55255

Canadian Boxwood

89.99

Partial Sun

Hedge

Oak

237

56853

John Flowering

104.98

Full Shade

Erosion

Pear

77

64525

Beni Japanese

104.98

Partial Shade

Erosion

Oak

140

78655

Honey Oak

102.78

Filtered Sun

Erosion

Oak

465

85655

New Scranton

103.78

Full Shade

Hedge

Pear

150

92258

Fairy

115.78

Partial Shade

Woodland Garden

Magnolia

293

93157

Felix Jung

107.99

Partial Shade

Woodland Garden

Magnolia

210

93553

Galaxy

124.99

Filtered Sun

Woodland Garden

Magnolia

51

94236

Yellow Select

103.98

Partial Shade

Border

Pear

348

96854

Elizabeth

131.78

Filtered Sun

Woodland Garden

Magnolia

250

98225

Messel

124.78

Filtered Sun

Woodland Garden

Magnolia

136

98655

Persian

105.99

Filtered Sun

Erosion

Pear

e02_student_data_files/e02_2B_TV_Sales.docx

Rose Plants and Rose Supplies: TV Sales

Week of May 24

Day

Climbing Roses

Patio Roses

Tea Roses

Total Rose Sales

Rose Supply Sales

Total Sales

Sun

$ 911.51

$ 26.46

$ 33.47

$ 971.44

$ 1,926.49

$ 2,897.93

Mon

310.49

313.85

782.64

1,406.98

1,526.03

2,933.01

Tue

942.37

402.99

30.08

1,375.44

1,853.82

3,229.26

Wed

185.89

992.29

253.98

1,432.16

1,922.36

3,354.52

Thu

3.53

825.79

340.34

1,169.66

1,973.73

3,143.39

Fri

931.46

946.92

966.92

2,845.30

2,121.47

4,966.77

Sat

47.23

978.23

234.12

1,259.58

2,025.55

3,285.13

e02_student_data_files/e02_2B_Web.xlsx

Summary

Sales of Rose Plants and Rose Supplies
Week of May 24
Roses/Rose Supplies Rose Sales Rose Supply Sales Total Sales
Online Sales $ 43,460.56 $ 13,349.45 $ 56,810.01
In-Store Sales 32,957.58 11,138.12 44,095.70
Total $ 76,418.14 $ 24,487.57 $ 100,905.71

&F

Online Sales

Rose Plants and Rose Supplies: Weekly Online Sales
Week of May 24
Day Climbing Roses Patio Roses Tea Roses Total Rose Sales Rose Supply Sales Total Sales
Sun $ 1,911.51 $ 2,026.46 $ 2,033.47 $ 5,971.44 $ 1,926.49 $ 7,897.93
Mon 2,310.49 2,313.85 1,782.64 6,406.98 1,526.03 7,933.01
Tue 1,942.37 2,402.99 2,030.08 6,375.44 1,853.82 8,229.26
Wed 2,185.89 1,992.29 2,253.98 6,432.16 1,922.36 8,354.52
Thu 2,003.53 1,825.79 2,340.34 6,169.66 1,973.73 8,143.39
Fri 1,931.46 1,946.92 1,966.92 5,845.30 2,121.47 7,966.77
Sat 2,047.23 1,978.23 2,234.12 6,259.58 2,025.55 8,285.13
Total $ 14,332.48 $ 14,486.53 $ 14,641.55 $ 43,460.56 $ 13,349.45 $ 56,810.01
Recorded on:
6/3/16
Reviewed on:
6/7/16

&F

In-Store Sales

Rose Plants and Rose Supplies: Weekly In-Store Sales
Week of May 24
Day Climbing Roses Patio Roses Tea Roses Total Rose Sales Rose Supply Sales Total Sales
Sun $ 1,493.21 $ 1,681.92 $ 1,594.22 $ 4,769.35 $ 1,626.59 $ 6,395.94
Mon 1,689.37 1,552.58 1,624.44 4,866.39 1,483.69 6,350.08
Tue 1,271.12 1,709.58 1,386.26 4,366.96 1,693.82 6,060.78
Wed 1,410.88 1,584.02 1,596.72 4,591.62 1,778.94 6,370.56
Thu 1,558.58 1,526.63 1,735.51 4,820.72 1,416.37 6,237.09
Fri 1,483.62 1,486.91 1,656.56 4,627.09 1,645.24 6,272.33
Sat 1,605.58 1,783.64 1,526.23 4,915.45 1,493.47 6,408.92
Total $ 10,512.36 $ 11,325.28 $ 11,119.94 $ 32,957.58 $ 11,138.12 $ 44,095.70
Recorded on:
6/3/16
Reviewed on:
6/7/16

&F

e02_student_data_files/e02A_Tree_Inventory.xlsx

Sheet1

Pasadena Tree Nursery
As of December 31
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
Quantity in Stock Item #/Category Tree Name Retail Price Light Landscape Use
78 13129-Oak Golden Oak 108.99 Partial Sun Erosion
35 13358-Oak Columnar English 106.95 Full Shade Border
60 15688-Oak Coral Bark 106.25 Partial Shade Erosion
20 16555-Oak Crimson King 105.50 Full Shade Border
75 21683-Cherry Japanese Blooming 103.99 Partial Shade Erosion
60 22189-Oak Crimson Queen 109.95 Filtered Sun Erosion
68 23677-Maple Black Japanese 107.99 Partial Sun Border
71 23688-Pear Artist Flowering 109.95 Partial Sun Erosion
159 24896-Cherry Bing Small Sweet 105.99 Partial Shade Border
60 25678-Pear Bartlett 109.75 Partial Sun Erosion
179 25844-Maple Bloodgood 110.99 Partial Shade Border
90 26787-Oak Sentry 108.50 Partial Sun Border
81 32544-Maple Burgundy Bell 110.95 Partial Sun Border
81 34266-Maple Lace Maple 109.99 Partial Sun Border
113 34793-Oak Emerald Elf 103.98 Full Shade Erosion
191 34878-Pear Ginger Pear 107.78 Partial Sun Border
102 34982-Oak Fernleaf 105.99 Partial Shade Border
170 35677-Oak Flamingo 109.99 Partial Sun Border
170 35690-Cherry Bing Sweet 107.99 Partial Sun Erosion
70 35988-Maple Butterfly Japanese 111.75 Partial Sun Border
92 36820-Maple Ever Red 110.95 Partial Sun Border
173 37803-Oak Osakazuki 103.88 Full Shade Erosion
113 37845-Magnolia Anna 117.98 Partial Sun Woodland Garden
75 38675-Oak Palo Alto 102.99 Partial Shade Erosion
93 38700-Oak Pacific Fire 103.75 Full Shade Erosion
45 38744-Cherry Cheals Weeping 104.99 Partial Shade Erosion
58 39704-Oak Embers 105.99 Partial Sun Erosion
90 42599-Pear Beurre 109.98 Partial Sun Border
350 43153-Pear Bradford 104.99 Full Shade Border

e02_student_data_files/e02B_Weekly_Sales.xlsx

Sheet1

Online
Sales
Day Climbing Roses Patio Roses Tea Roses
Sun 1911.51 2026.46 2033.47
Mon 2310.49 2313.85 1782.64
Tue 1942.37 2402.99 2030.08
Wed 2185.89 1992.29 2253.98
Thu 2003.53 1825.79 2340.34
Fri 1931.46 1946.92 1966.92
Sat 2047.23 1978.23 2234.12
Recorded on:
6/3
Reviewed on:

Sheet2

In-Store
Climbing Roses Patio Roses Tea Roses
1493.21 1681.92 1594.22
1689.37 1552.58 1624.44
1271.12 1709.58 1386.26
1192.61 1584.02 1596.72
1558.58 1526.63 1735.51
1483.62 1486.91 1656.56
1605.58 1783.64 1526.23

e02_student_data_files/e02C_Roses.xlsx

Sheet1

Pasadena Nursery: Roses Inventory
As of June 30
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
Yellow Rose Types
Red Rose Types
Quantity in Stock Item #/Zone Rose Name Retail Price Color
28 12113-Zone 5 Sunny Days 8.99 Yellow
23 12116-Zone 3 Common Yarrow 14.25 Merlot
46 12119-Zone 2 Sun Blaze 22.99 Pink
49 12221-Zone 5 Coral Bells 9.97 Red
45 12223-Zone 5 Gushing Pride 12.99 Red
56 12225-Zone 5 Julia Peony 13.75 Merlot
48 12288-Zone 5 Krebbs Hens 14.88 Merlot
39 12312-Zone 8 Tropical Rose 8.99 Red
55 12333-Zone 4 Glow Azalea 19.88 Pink
45 12336-Zone 6 China Bloom 11.95 Deep Burgundy
28 12345-Zone 2 Heaven Scent 15.95 Purple
49 12346-Zone 7 Spotted Lady 32.66 Red
65 12347-Zone 2 Perfume Delight 9.95 Deep Burgundy
26 12365-Zone 7 Sensation Meadow 7.59 Apricot
23 12396-Zone 7 Vineyard Rose 18.97 Deep Burgundy
29 12398-Zone 7 Lace Christmas 12.95 Black
29 12433-Zone 5 Small Kin 16.95 Yellow
36 12444-Zone 1 Nearly Wild 17.97 Apricot
65 12446-Zone 5 Midnight Coral 28.55 Purple
46 12455-Zone 7 Heritage Strain 9.78 Pink
32 12457-Zone 2 Wildberry 11.95 Red
42 12465-Zone 6 Singing Winter 7.95 Deep Burgundy
49 12485-Zone 8 Clown Mallow 6.99 White
49 12489-Zone 1 Woodland Red 12.98 Deep Burgundy
43 12493-Zone 3 Azurri Lace 12.98 Deep Burgundy
46 12534-Zone 8 Queen Bishops 7.95 Red
46 12553-Zone 6 Rose Satin 8.75 Purple
46 12554-Zone 8 Sweet Tips 15.98 Red
65 12556-Zone 5 Many Shades 12.95 Red
29 12564-Zone 1 Woodland Pink 13.95 Pink
45 12582-Zone 4 White Chiffon 9.95 Deep Burgundy
37 12598-Zone 4 Know Select 18.99 Deep Burgundy
37 2616-Zone 1 Honey Bun 9.95 Deep Burgundy
49 12642-Zone 7 Winter Blossom 8.99 Red
46 12647-Zone 1 New Dawn 12.5 Pink
36 12663-Zone 7 Rose Marianne 9.95 Deep Burgundy
46 12664-Zone 6 Winter Bliss 13.97 Pink
42 12668-Zone 4 Apricot Bloom 10.95 Apricot
26 12678-Zone 1 Lavender Bloom 18.95 Lavender
36 12696-Zone 6 Sandy Sharon 17.95 Pink
46 12698-Zone 6 Golden Jewels 20.99 Deep Burgundy
36 12783-Zone 8 Warley Rock 11.95 Pink
56 12841-Zone 6 Double Fantasy 12.95 Black
13 12877-Zone 4 Rock Rose 24.99 Purple
26 12892-Zone 3 Origami 9.97 Deep Burgundy
46 12893-Zone 1 Berry Pie 7.98 Purple
85 12894-Zone 4 Blue Bird 7.95 Deep Burgundy
28 12895-Zone 3 Bennett Rock 9.55 Red
26 12897-Zone 1 Lady Jo 14.95 Lavender
62 12934-Zone 3 River 2 11.99 White
36 12954-Zone 2 Aphrodite 13.95 Red
32 12963-Zone 5 Shaded Mardi Gras 16.99 Yellow
23 12968-Zone 3 Racer Lenten 8.95 Orange
62 12978-Zone 8 Valley Red 14.95 Red
49 12999-Zone 2 White Bunker 39.95 Red

e02_student_data_files/e02D_Canada.xlsx

Sheet1

Canada Sales: Western Region
Vancouver Edmonton Calgary In-Store Sales Total Online Sales Total Total Sales
Week 1 13477 13210 12259 23844
Week 2 14265 13546 12387 25697
Week 3 14199 13481 12260 28466
Week 4 13623 13333 129461 23741
Recorded on:
3/31
Reviewed on:

Sheet2

Canada Sales: Eastern Region
Ottawa Toronto Montreal In-Store Sales Total Online Sales Total Total Sales
13080 12553 11816 30633
13321 12744 11933 21284
15182 9650 12021 25550
12963 10820 12267 28385

e02_student_data_files/e02E_Plants.xlsx

Sheet1

Pasadena Facility: Inventory Status of Plants
As of September 30
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
Specialty Plant Types
Specialty Quantity in Stock
Quantity in Stock Item #/Category Item Name Retail Price Size Special Feature
95 1123-Edibles Macadamia Nut 15.42 24" Fall Color
37 1267-Container Plants Clematis Hank 28.95 42" Fall Color
58 1843-Bonsai Fragrant Plum 24.95 10" Showy
78 1852-Specialty Banana Cream 13.95 14" Pollenizer
93 1862-Container Plants Minny Pearl 16.95 15" Showy
27 2132-Edibles September Raspberry 7.58 12" Fall Color
78 2157-Specialty Elite Gold Pineapple 12.65 16" Easy Care
28 2158-Specialty Salzia Glue 15.95 12" Fall Color
24 2176-Container Plants Strawberry Sweet 6.59 6" Showy
26 2201-Edibles Dwarf Banana 18.59 24" Easy Care
56 2202-Edibles Top Hat Blueberry 18.95 18" Easy Care
24 2202-Vine Roses Magid Hybrid 11.35 14" Pollenizer
49 2219-Vine Roses Sunshine Dream 16.57 24" Fall Color
65 2223-Vine Roses Purple Splash 25.95 14" Showy
175 2266-Vine Roses Wing Ding 45.95 41" Fall Color
18 2268-Specialty Tetrapleed Breeder 54.95 24" Fall Color
28 2278-Container Plants Blanket Flower 24.95 16" Easy Care
19 2308-Container Plants Cinnamon Tree 16.58 12" Easy Care
56 2317-Vine Roses Pope Benedict 11.35 16" Pollenizer
135 2356-Vine Roses Black Pie 26.95 11" Fall Color
45 2364-Edibles Super Dwarf Tomato 34.95 36" Easy Care
36 2402-Edibles Dwarf Raspberry 28.95 28" Easy Care
52 2404-Vine Roses Hot Chocolate 10.59 18" Pollenizer
49 2428-Edibles Elite Pineapple 38.95 28" Easy Care
23 2437-Specialty Cashew Tree 26.95 33" Easy Care
150 2439-Edibles Holiday Assortment 34.95 35" Pollenizer
42 2543-Container Plants Lavandula 14.95 12" Showy
32 2580-Specialty New Dimension 31.95 26" Pollenizer
52 2582-Container Plants Chandler Blueberry 18.65 24" Easy Care

e02_student_data_files/e02F_Bonus.xlsx

Sheet1

Commercial Salesperson June Compensation: Western Canada
Salesperson Sales Eligible for Bonus Bonus Rate Bonus Base Salary Total Compensation
Reid 25630 2.50% 2275
Leung 28940 2.75% 2400
Singh 41850 3.25% 3250
Evans 35954 3.15% 3150
Total

Sheet2

Commercial Salesperson June Compensation: Eastern Canada
Salesperson Sales Eligible for Bonus Bonus Rate Bonus Base Salary Total Compensation
Watson 22637 2.25% 2350
Firesen 20868 1.75% 2325
Tam 26849 2.55% 2425
Johnston 33575 3.20% 3325
Total

e02_student_data_files/e02G_Inventory.xlsx

Sheet1

Pasadena Facility: Inventory Status of Bulbs
As of December 31
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
Tulip Types
Tulip Total Quantity
Quantity in Stock Item #/Category Item Name Retail Price Size
78 1239-Daffodils Exotic 10.98 18"
88 1265-Daffodils Bell Song 7.45 18"
109 1285-Dahlias Haley Jane 8.58 12"
49 1296-Daffodils Yellow Hoop 6.98 18"
175 1325-Daffodils Split Crown 4.75 18"
128 1356-Dahlias Contessa 7.89 12"
55 1365-Daffodils Jonquilla 6.89 18"
165 1368-Gladiolus Butterfly Mix 8.25 25'
136 1379-Begonias Fringed Mix 12.99 15"
49 1389-Dahlias Decorative Glory 6.98 12"
222 1425-Gladiolus Mon Amour 7.58 25"
56 1436-Dahlias Topmix Yellow 5.95 12"
165 1452-Daffodils Campernella 5.25 18"
123 1453-Tulips Apeldoom Elite 11.25 10"
89 1456-Dahlias Stars Lady 8.59 12"
126 1456-Begonias Pendula Cascade 9.89 15"
52 1456-Callas Zantedeschia Mix 10.95 20"
75 1463-Daffodils Manley 7.85 18"
25 1465-Tulips Goldstick 9.59 10"
42 1465-Dahlias Topmix Color 7.52 12"
49 1468-Callas Elliottiana White 4.99 20"
52 1469-Begonias Multiflora 9.89 15"
70 1478-Daffodils Narcissa Mixed 9.98 18"
129 1482-Gladiolus Nathalie 16.58 25"
255 1482-Gladiolus Morning Gold 7.85 25"
75 1489-Tulips Maureen 12.85 10"
135 1489-Tulips Purple Flag 14.85 10"
75 1498-Tulips Passionate 8.59 10''

Sheet2

Pasadena Facility: Inventory Status of Trees
As of December 31
Total Items in Stock
Average Price
Median Price
Lowest Price
Highest Price
Evergreen Types
Evergreen Total Quantity:
Quantity in Stock Item #/Category Item Name Retail Price Size
49 1783-Nut Trees Stuart Grafted Pecans 42.00 8'
35 2133-Shade Trees Green Weeping 40.00 13'
126 2345-Shade Trees Kentucky Coffee 22.00 6'
87 2347-Nut Trees Buckeye 56.00 7'
14 2348-Nut Trees Chinese Chestnut 32.00 6'
110 2389-Evergreens Andorra Juniper 16.00 6'
32 2469-Nut Trees American Beech 65.00 12'
42 2587-Flowering Trees Flowering Cherry 38.00 7'
175 2850-Fruit Trees Nectarines 59.00 9'
108 2895-Nut Trees Pecan 44.00 6'
82 3252-Evergreens American Arborvita 9.00 3'
54 3933-Nut Trees American Filbert 42.00 8'
156 4535-Evergreens Canadian Hemlock 8.00 2'
185 4567-Nut Trees Shelle Bark Hickory 49.00 7'
210 4587-Shade Trees Black Gum 42.00 8'
385 4597-Shade Trees Red Maple 35.00 6'
108 4625-Fruit Trees Persimmon 35.00 6'
126 4652-Nut Trees Grafted Pecans 38.00 8'
285 4822-Flowering Trees Chinese Dogwood 17.00 4'
110 5463-Nut Trees English Walnut 38.00 8'
185 5522-Shade Trees Hybrid Poplar 23.00 8'
182 5635-Shade Trees Scarlet Oak 36.00 5'
95 5636-Shade Trees Lombardy Poplar 48.00 7'
153 5664-Nut Trees Pecan Seedling 29.00 7'
42 6255-Shade Trees Sawtooth Oak 23.00 5'
45 8256-Fruit Trees Pear 18.00 5'
235 8582-Evergreens Red Cedar 10.00 4'
87 9952-Flowering Trees Catalpa 22.00 5'

e02_student_data_files/e02H_Planters.xlsx

Sheet1

Pasadena Facility: Inventory Status of Planters
As of June 30
Total Items in Stock 903
Average Price $ 50.52
Median Price $ 37.95
Lowest Price $ 125.95
Highest Price $ 12.65
Quantity in Stock Item # Item Name Retail Price Style Stock Level
64 1852 Textile Pot $ 33.95 Pot Order
18 1834 Garden Urn $ 125.95 Urn Order
31 1256 Square Garden Urn $ 31.95 Urn Order
23 1437 Small Grecian Classic $ 26.95 Pot Order
59 1631 Cherub Planter $ 112.65 Box Order
75 772 Sunflower Pot $ 23.95 Pot OK
22 1157 Small Crest Pot $ 12.65 Pot Order
52 1268 Medium Crest Pot $ 54.95 Pot Order
28 2158 Large Crest Pot $ 74.95 Pot Order
61 1018 Motif Garden Urn $ 49.85 Urn Order
67 728 Medium Oval Planter $ 63.95 Box OK
44 902 Large Oval Planter $ 79.95 Box Order
38 503 Small Terracotta Urn $ 24.55 Urn Order
39 762 Large Terracotta Urn $ 66.95 Urn Order
53 711 Old World Urn $ 37.95 Urn Order
22 852 Regency Garden Urn $ 46.95 Urn Order
62 967 Spanish Outoor Urn $ 28.95 Urn Order
64 892 Large Herb Box $ 36.95 Box Order
81 764 Medium Herb Box $ 25.95 Box OK

e02_student_data_files/e02I_Salary.xlsx

Sheet1

Rosedale Landscape and Garden
Southern California March Sales and Compensation
Sales Compensation
Total
Average
Highest
Lowest
Commission Rate 5%
Name Sales Commission Bonus Base Salary Total Compensation
Chiu 12542 1500
Littleton 14526 1750
Rogers 13912 1225
Rodriguez 15508 1500
Lane 18092 1500
Marcuso 21344 2500
Eliason 14045 1725
Hughes 26799 1525
Nguyen 22285 1250
Manriquez 23239 2150
Abel 27340 2200
Walters 34900 1750
Blake 29565 1575
Cloutier 36559 2525
Lin 31334 1575
Patel 32457 2225
Corpus 23909 1850

e02_student_data_files/e02J_Sod.xlsx

Sheet1

Rosedale Landscape and Garden
Pasadena Facility Sod Delivery Schedule
Week Ending February 16
Average Sale Price
Lowest Sale Price
Highest Sale Price
Total Sod Sales
Total Bulk Seed Sales
Total Seed Sales
Order # Product Category Price Per Unit Units Ordered Sale Price Delivery
14-8256 Tiffgreen Bermuda Sod 2.85 125 356.25
10-1326 Shady Mix Bulk Seed 199.99 4 799.96
13-0801 Mara II Seed 6.99 34 237.66
15-5636 Dichondra Sod 1.33 822 1,093.26
10-1312 Sunshine Bulk Seed 144.99 6 869.94
15-5635 Ryeblue Lite Sod 7.09 45 319.05
16-4625 El Toro Zoysia Sod 1.01 38 38.38
13-0820 Mara I Seed 99.99 30 2,999.70
16-2389 Korean Grass Sod 4.82 15 72.30
16-3881 Marathon I Sod 2.85 75 213.75
14-1164 St. Augustine Sod 5.15 15 77.25
14-2311 Mara III Seed 136.99 1 136.99
14-2344 Tiffgreen Sod 2.85 52 148.20
14-3252 Marathon Lite Sod 6.24 25 156.00
17-2850 Dwarf Fescue Sod 2.95 127 374.65
17-5522 Extra Dwarf Sod 3.10 22 68.20
54-2113 Red Fescue Bulk Seed 159.99 3 479.97

e02_student_data_files/e02K_Products.xlsx

U.S.

Rosedale Landscape and Garden
Second Quarter Product Sales Summary: U.S
April May June Product Total Percent of Total
Sod 419314 421698 488742
Trees 221668 188752 220950
Shrubs 123661 124080 125900
Roses 315774 284883 276902
Color 216500 217010 216823
Monthly Total

Canada

Rosedale Landscape and Garden
Second Quarter Product Sales Summary: Canada
April May June Product Total Percent of Total
Sod 374642 431698 444905
Trees 316750 387800 366325
Shrubs 217950 217402 218633
Roses 212050 211475 212268
Color 352960 323554 382684
Monthly Total

e02_student_data_files/e02L_Palms.xlsx

Sheet1

Rosedale Landscape and Garden
Pasadena Facility Palm Tree Inventory
Quantity in Stock Number of Product Types
Queen
Pygmy Date
King
Sago
Quantity in Stock Item #/Category Product Name Retail Price
54 12398-King King Palm 15 Gallon 47.50
74 13189-Queen Queen 1 Gallon 5.00
98 15688-Queen Queen 30" Box 325.00
12 16555-Pygmy Pygmy Date 24" Box 195.00
15 22189-Pygmy Pygmy Date 36" Box 475.00
124 23371-Pygmy Pygmy Date 10" 15.00
143 23677-King King Palm 1 Gallon 5.50
129 25844-King King Palm 36" Box 450.00
76 26787-Sago Sago Palm 1 Gallon 7.50
15 32544-Sago Sago Palm 10" 30.00
41 34793-Sago Sago Palm 17" 155.00
122 37283-Queen Queen 24" Box 135.00
234 43877-King King Palm 5 Gallon 15.50
98 49293-Pygmy Pygmy Date 14" 52.00
66 65213-Sago Sago Palm 14" 65.00
23 76352-Pygmy Pygmy Date 17" 95.00
56 78324-Queen Queen 5 Gallon 15.00
32 98376-Queen Queen 15 Gallon 45.00

e02_student_data_files/e02M_Contracts.xlsx

Design

Rosedale Landscape and Garden
First Quarter Design Contracts Completed
Pasadena San Diego Riverside Total Pasadena/San Diego/Riverside
January 12250 32789 22908
February 18175 44321 32756
March 16854 67543 18598
Total

&F

Installation

Rosedale Landscape and Garden
First Quarter Installation Contracts Completed
Pasadena San Diego Riverside Total Pasadena/San Diego/Riverside
January 111743 331575 486440
February 135630 211996 325129
March 231725 172112 265605
Total

&F

e03_student_data_files.zip

e03_student_data_files/e03_3B_Web.xlsx

Sheet1

Pacifica Bay
Tourism Spending 2010 to 2014
Year 2010 2011 2012 2013 2014
Tourism Spending $ 4,644,325 $ 5,605,958 $ 7,235,397 $ 8,824,638 $ 11,086,354
Percent Increase 21% 29% 22% 26%
Projected Tourism Spending
Estimated Growth Rate 21%
Year 2014 2015 2016 2017 2018
$ 11,086,354 $ 13,414,488 $ 16,231,531 $ 19,640,152 $ 23,764,584
Estimated Growth in Tourism Spending 2014 to 2018
Year 2014 2015 2016 2017 2018
25% Growth Rate $ 11,086,354 $ 13,857,943 $ 17,322,428 $ 21,653,035 $ 27,066,294
21% Growth Rate $ 11,086,354 $ 13,414,488 $ 16,231,531 $ 19,640,152 $ 23,764,584

e03_student_data_files/e03A_Enterprise_Fund.xlsx

Enterprise Fund Expenditures

Pacifica Bay
Enterprise Fund Expenditures
Recommended Adjustments
Originally Proposed Adjusted % of Total Fund Expenditures
Airport $ 17,610,810 $ 17,456,056
Parking 6,824,865 7,897,526
Solid Waste 18,695,222 17,845,287
Wastewater 12,657,765 13,985,695
Water Usage 30,457,903 32,356,236
Waterfront 10,976,843 10,945,369
Total $ 97,223,408 $ 100,486,169

e03_student_data_files/e03B_Surfers.jpg

e03_student_data_files/e03C_Parks.xlsx

Sheet1

City of Pacifica Bay
Fee and Rental Revenue from City Parks
Projection for Next Fiscal Year Budget
Current Year Revenue Projected Revenue for Next Fiscal Year % of Total Projected Budget
Community Park $ 2,510,980 $ 2,536,529
Grand Park 1,245,730 1,395,218
Diamond League Fields 3,385,050 5,896,360
Pacifica Soccer Park 2,231,050 3,423,515
Bayside Park 1,907,890 1,812,297
Community Center 2,582,340 2,711,459
Total $ 13,863,040 $ 17,775,378

e03_student_data_files/e03D_Housing.JPG

e03_student_data_files/e03E_Revenue.xlsx

Sheet1

City of Pacifica Bay
Revenue Sources
Projection for Next Fiscal Year Budget
Current Year Revenue Projected Revenue for Next Fiscal Year % of Total Projected Revenue
Taxes $ 54,152,873 $ 55,956,359
Licenses and Permits 28,120,500 30,854,962
Intergovernmental 31,786,400 33,712,614
Services 14,007,745 15,743,040
Other 8,694,563 13,987,550
Total

e03_student_data_files/e03G_Expenses.xlsx

Expenses

City of Pacifica Bay
Summary of Annual Expenses
Quarter 1 Quarter 2 Quarter 3 Quarter 4 Annual Total Percent of Total
Salaries and Benefits $ 721,216 $ 810,451 $ 785,960 $ 788,657
Machinery and Equipment 325,723 289,430 254,638 336,354
Materials and Supplies 445,420 398,675 348,642 254,233
Professional Services 563,243 689,243 542,683 976,245
Miscellaneous 227,126 224,876 228,238 223,827
Totals by Quarter
Expenses 5-Year Forecast
Forecasted Increase 3.5%
Year 2016 2017 2018 2019 2020
Projected Expenses

Projected Decrease

City of Pacifica Bay
Projected Decrease in Expenses
Annual Total Percent of Total
Salaries and Benefits $ - 0
Machinery and Equipment - 0
Materials and Supplies - 0
Professional Services - 0
Miscellaneous - 0
Totals by Quarter $ - 0
Goal: Decrease Professional Services to 25%
Goal Amount

e03_student_data_files/e03H_Schools.xlsx

Enrollment Data

Pacifica Bay Unified School District
Elementary School Enrollment Trend
School Level 2014 2015 2016
Coronita 582 535 530
Rogers 698 525 470
Johnson 886 802 761
McKinley 562 540 502
Raney 889 875 801
Total 3,617 3,277 1,761

2014 High School Enrollment

Coronita Rogers Johnson McKinley Raney 530 470 761 502 801

e03_student_data_files/e03J_Staffing.xlsx

Departmental Staffing Levels

City of Pacifica Bay
Departmental Staffing Levels
Department Current Year Two-Year Projection % of Total Employees
Public Safety 125 132
City Clerk and Manager 64 59
Parks and Recreation 72 81
Economic Development 81 75
Planning/Public Works 51 62
Administration 195 212
Total City Employees

e03_student_data_files/e03K_Beach.JPG