BIS 155 WEEK 1 LAB 1

profiletedhuge11
wk1_chap1_cap_fundraising_1.xlsx

Sheet1

Upper Saddle River Marching Band - Fundraising Event
Band Booster Equipment Sales through Day 10
GOAL 50000
Item Sales Price Profit Per Item 7/4/06 7/5/06 7/7/06 7/8/06 7/9/06 7/10/06 7/11/06 7/12/06 7/13/06 7/14/06 Number of Items Sold Profit Percent of Profit
Tee Shirt 15 56 12 14 22 18 17 19 19 18 25
Baseball Hat 20 22 9 8 11 8 13 14 12 8 10
Golf Shirt 30 6 7 6 9 5 11 8 11 7 14
Head Covers 23 0 0 0 0 0 0 0 0 0 0
Warm Up Suit 60 23 10 8 12 12 14 15 14 16 12
Sweater 35 23 13 11 15 12 19 15 14 16 12
Sweat Shirt 20 5 1 0 1 2 2 2 2 6 2
Sweat Pants 20 10 2 5 2 8 8 8 8 13 4
Calling Card 100 10 2 5 2 4 8 8 8 13 4
Lamp 135 18 6 11 4 10 8 8 8 13 4
Profit (as a percent of sales price) 0.5 Total Profit to Date
Remaining Profit to Reach Goal

Sheet2

Sheet3