introduction to microcomputers - excel exam
juicywang
excel_exam2013.xlsxFirst
| Pro Fit Marietta | ||||
| First Quarter Shoe Sales | ||||
| January | February | March | Total | Trends |
| Aerobic | ||||
| Running | 74858.32 | 79167.11 | 82144.56 | |
| Walking | 45816.3 | 49547.36 | 50148.59 | |
| Cross Trainer | 72699.1 | 76589.5 | 80056.65 | |
| Total |
&F
Second
| Pro Fit Marietta | |||||
| Shoe Products Inventory Valuation | |||||
| As of March 31 Susan Fry: Susan Fry: Why are your colors green and mine are blue? |
|||||
| Warehouse Location | Quantity | Average Cost | Retail Price | Total Retail Value | Percent of Total Retail Value |
| Aerobic | Atlanta | 278 | $ 32.00 | $ 64.00 | |
| Running | Marietta | 413 | 35.00 | 70.00 | |
| Walking | Atlanta | 872 | 29.00 | 68.00 | |
| Cross Trainer | Marietta | 689 | 35.00 | 70.00 | |
| Total Retail Value for All Products |
&F
Third
| Pro Fit Marietta | ||||||||
| As of March 31 | ||||||||
| Total Items in Stock | ||||||||
| Average Price | ||||||||
| Median Price | ||||||||
| Lowest Price | ||||||||
| Womens | Highest Price | |||||||
| Quantity in Stock | Item #/Category | Category | Shoe Name | Retail Price | Type | Style | Category2 | Stock Level |
| 78 | 1345-Run | Marathon 1 | 99.00 | Running | Womens | |||
| 35 | 1261-Walk | Trails XX | 78.00 | Walking | Mens | |||
| 60 | 1463-Run | Marathon 85 | 105.00 | Running | Mens | |||
| 20 | 16810-Aerobic | Synergy XI | 76.00 | Aerobic | Womens | |||
| 75 | 1952-Run | RunFit XII | 108.00 | Running | Womens | |||
| 60 | 7812-Cross | Transition VI | 76.00 | Cross Trainer | Womens | |||
| 68 | 8912-Run | RunFit 1000 | 99.00 | Running | Womens | |||
| 71 | 5612-Walk | WalkFit 500 | 64.00 | Walking | Womens | |||
| 159 | 78712-Aerobic | Pro-Fit Aerobic XX | 89.00 | Aerobic | Womens | |||
| 60 | 3412-Walk | Trails XXX | 82.00 | Walking | Mens | |||
| 179 | 6981-Run | RunFit 5000 | 110.00 | Running | Mens | |||
| 90 | 4821-Walk | WalkFit 1000 | 108.00 | Walking | Womens | |||
| 81 | 5683-Cross | Strength XI | 110.00 | Cross Trainer | Womens | |||
| 81 | 4512-Cross | Agility 543 | 115.00 | Cross Trainer | Mens | |||
| 113 | 6821-Run | Offroad 452 | 100.00 | Running | Womens | |||
| 191 | 34139-Aerobic | Endurance | 115.00 | Aerobic | Womens | |||
| 102 | 5412-Walk | Pro-Fit Support XX | 108.00 | Walking | Womens | |||
| 170 | 7812-Run | Extreme Run 4000 | 115.00 | Running | Mens | |||
| 170 | 5781-Cross | Enhance | 99.00 | Cross Trainer | Womens | |||
| 70 | 6712-Run | RunFit 500 | 60.00 | Running | Womens | |||
| 92 | 6813-Run | RunFit 400 | 50.00 | Running | Womens | |||
| 173 | 7823-Walk | WalkFit 700 | 85.00 | Walking | Womens | |||
| 113 | 5634-Aerobic | Endurance XT II | 115.00 | Aerobic | Womens | |||
| 75 | 6723-Run | RunFit 600 | 75.00 | Running | Mens | |||
| 93 | 7134-Cross | Enhance XT II | 125.00 | Cross Trainer | Womens | |||
| 45 | 7135-Cross | Enhance XX | 135.00 | Cross Trainer | Mens | |||
| 58 | 8712-Walk | Xtreme Support 100 | 106.00 | Walking | Womens | |||
| 90 | 8715-Walk | Xtreme Support 200 | 110.00 | Walking | Mens | |||
| 350 | 9183-Run | WalkFit 100 | 45.00 | Walking | Womens |
Sheet1
| Center Store Sales | |||
| Day | Running | Walking | Total |
| Sun | $ 1,458.12 | $ 1,281.25 | $ 2,739.37 |
| Mon | 2,714.58 | 3,582.58 | 6,297.16 |
| Tue | 925.28 | 2,162.14 | 3,087.42 |
| Wed | 899.10 | 1,058.58 | 1,957.68 |
| Thu | 2,105.58 | 825.45 | 2,931.03 |
| Fri | 1,250.56 | 1,365.45 | 2,616.01 |
| Sat | $ 845.25 | $ 1,848.25 | $ 2,693.50 |
| $ 10,198.47 | $ 12,123.70 | $ 22,322.17 | |
&F
Sheet2
| West Store Sales | |||
| Day | Running | Walking | Total |
| Sun | $ 1,004.25 | $ 678.94 | $ 1,683.19 |
| Mon | 675.25 | 889.34 | 1,564.59 |
| Tue | 789.26 | 245.26 | 1,034.52 |
| Wed | 985.15 | 682.11 | 1,667.26 |
| Thu | 350.12 | 899.15 | 1,249.27 |
| Fri | 678.25 | 789.15 | 1,467.40 |
| Sat | $ 345.85 | $ 487.15 | $ 833.00 |
| $ 4,828.13 | $ 4,671.10 | $ 9,499.23 | |
&F
Summary
| Shoe Sales | |||
| Week of March 1 | |||
| Running | Walking | Total | |
| Center Store | - 0 | ||
| West Store | - 0 | ||
| TOTAL | $ - 0 | $ - 0 | $ - 0 |
&F
Fourth
| Pro Fit Marietta | ||
| Shoe Sales Income | ||
| Recommended Adjustments | ||
| Originally Budgeted | Adjusted | |
| Running | $ 432,578 | $ 442,218 |
| Walking | 678,512 | 677,125 |
| Aerobic | 512,485 | 525,126 |
| Cross Trainer | 671,258 | 665,123 |
| Total | $ 2,294,833 | $ 2,309,592 |
&F
