exuel Tutorial 5, Case Problem 1 , Tutorial 5, Case Problem 2 , Tutorial 6, Case Problem 1,Tutorial 6, Case Problem 2 ,Tutorial 7 Case Problem 1, Tutorial 7 Case Problem 2
aboznada007
cloggers.xlsmDocumentation
| OMG Cloggers | |
| Author: | |
| Date: | |
| Purpose: | To analyze the annual holiday fruit fundraiser for the cloggers |
| Defined Names: | |
| ApplesOrdered | ='Fundraiser Data'!$A$3 |
| ApplesSold | ='Fundraiser Data'!$E$7 |
| GrapefruitOrdered | ='Fundraiser Data'!$B$6 |
| GrapefruitSold | ='Fundraiser Data'!$E$6 |
| OrangesSold | ='Fundraiser Data'!$E$5 |
| ThreeFruitOrdered | ='Fundraiser Data'!$B$9 |
| ThreeFruitSold | ='Fundraiser Data'!$E$9 |
| TwoFruitOrdered | ='Fundraiser Data'!$B$8 |
| TwoFruitSold | ='Fundraiser Data'!$E$8 |
Fundraiser Data
| OMG Cloggers | |||||||
| Holiday Fruit Fundraiser | |||||||
| Product | Quantity Ordered | Cost | Total Cost | Quantity Sold | Price to Customer | Total $ Collected | Profit |
| Oranges | 1,000 | 20.00 | 20,000.00 | 995 | 25.00 | 24,875.00 | (4,875.00) |
| Grapefruit | 1,000 | 20.00 | 20,000.00 | 950 | 25.00 | 23,750.00 | (3,750.00) |
| Apples | 1,000 | 30.00 | 30,000.00 | 890 | 35.00 | 31,150.00 | (1,150.00) |
| Two Fruit (O/G) | 500 | 30.00 | 15,000.00 | 450 | 35.00 | 15,750.00 | (750.00) |
| Three Fruit (O/G/A) | 400 | 30.00 | 12,000.00 | 375 | 35.00 | 13,125.00 | (1,125.00) |
| 97,000.00 | 108,650.00 | (11,650.00) | |||||
Fundraiser Chart
Holiday Fruit Fundraiser
Oranges Grapefruit Apples Two Fruit (O/G) Three Fruit (O/G/A) -4875 -3750 -1150 -750 -1125
