HW Help
dfaert
ch04ex01.xlsSheet1
| Lisa's Catering | ||||||
| Disposable Supplies - Inventory Data | ||||||
| Category | Item No. | Description | Color | Unit | Unit Cost | On Hand |
| Dinnerware | 630K-C | Deluxe Heavy Duty Disposable Plastic Knives | Clear | Case (12 pk/24 each) | 13.61 | 3 |
| 630F-C | Deluxe Heavy Duty Disposable Plastic Forks | Clear | Case (12 pk/24 each) | 13.61 | 3 | |
| 630S-C | Deluxe Heavy Duty Disposable Plastic Spoons | Clear | Case (12 pk/24 each) | 13.61 | 3 | |
| 630K-B | Deluxe Heavy Duty Disposable Plastic Knives | Black | Case (12 pk/24 each) | 13.61 | 2 | |
| 630F-B | Deluxe Heavy Duty Disposable Plastic Forks | Black | Case (12 pk/24 each) | 13.61 | 2 | |
| 630S-B | Deluxe Heavy Duty Disposable Plastic Spoons | Black | Case (12 pk/24 each) | 13.61 | 2 | |
| Table Cloths | 5454W | 54" × 54" Plastic Table Cover | White | Case (24) | 19.15 | 1 |
| 5454B | 54" × 54" Plastic Table Cover | Beige | Case (24) | 19.15 | 2 | |
| 5454BL | 54" × 54" Plastic Table Cover | Black | Case (24) | 19.15 | 1 | |
| 549W | 54" × 108" Plastic Table Cover | White | Case (24) | 30.24 | 4 | |
| 549B | 54" × 108" Plastic Table Cover | Beige | Case (24) | 30.24 | 2 | |
| 549BL | 54" × 108" Plastic Table Cover | Black | Case (24) | 30.24 | 1 | |
| 72W | 72" Round Plastic Table Cover | White | Case (24) | 52.08 | 3 | |
| 72B | 72" Round Plastic Table Cover | Beige | Case (24) | 52.08 | 3 | |
| 72BL | 72" Round Plastic Table Cover | Black | Case (24) | 52.08 | 1 | |
| Napkins | 537 | 13" × 17" Linen-Like Napkins | White | Case (6 pk/50 each) | 45.90 | 6 |
| 28500 | 10" × 10" Linen-Like Napkins | White | Case (8 pk/50 each) | 42.00 | 3 | |
| 1010W | 10" × 10" 2-ply Beverage Napkins | White | Case (12 pk/50 each) | 18.14 | 6 | |
| 1010B | 10" × 10" 2-ply Beverage Napkins | Black | Case (12 pk/50 each) | 18.14 | 1 | |
| 1010R | 10" × 10" 2-ply Beverage Napkins | Red | Case (12 pk/50 each) | 18.14 | 1 | |
| 1313W | 13" × 13" 2-ply Luncheon Napkins | White | Case (12 pk/50 each) | 25.20 | 3 | |
| 1313B | 13" × 13" 2-ply Luncheon Napkins | Black | Case (12 pk/50 each) | 25.20 | 2 | |
| 1010WED | 10" × 10" Wedding Bells Print Napkins | White | Case (12 pk/50 each) | 26.46 | 3 | |
| 1313WED | 13" × 13" Wedding Bells Print Napkins | White | Case (12 pk/50 each) | 37.80 | 4 | |
| Drinkware | CC12 | 12 oz. Classic Crystal Tall Plastic Glasses | Clear | Case (12 pk/20 each) | 78.33 | 1 |
| CC16 | 16 oz. Classic Crystal Tall Plastic Glasses | Clear | Case (12 pk/20 each) | 107.73 | 1 | |
| CCR9 | 9 oz. Classic Crystal Plastic Rocks Glasses | Clear | Case (12 pk/20 each) | 53.90 | 3 |
Sheet 2
| Lisa's Catering | Markup | ||||||||||
| Disposable Supplies - Inventory Data | 25% | ||||||||||
| Category | Item No. | Description | Color | Unit | Unit Cost | On Hand | Total Cost | Case Packs | Packs On Hand | Cost Per Pack | Sales Price Per Pack |
| Dinnerware | 630K-C | Deluxe Heavy Duty Disposable Plastic Knives | Clear | Case (12 pk/24 each) | 13.61 | 3 | $0.00 | 12 | 0 | 0.00 | 0.00 |
| 630F-C | Deluxe Heavy Duty Disposable Plastic Forks | Clear | Case (12 pk/24 each) | 13.61 | 3 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 630S-C | Deluxe Heavy Duty Disposable Plastic Spoons | Clear | Case (12 pk/24 each) | 13.61 | 3 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 630K-B | Deluxe Heavy Duty Disposable Plastic Knives | Black | Case (12 pk/24 each) | 13.61 | 2 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 630F-B | Deluxe Heavy Duty Disposable Plastic Forks | Black | Case (12 pk/24 each) | 13.61 | 2 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 630S-B | Deluxe Heavy Duty Disposable Plastic Spoons | Black | Case (12 pk/24 each) | 13.61 | 2 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| Table Cloths | 5454W | 54" × 54" Plastic Table Cover | White | Case (24) | 19.15 | 1 | $0.00 | 24 | 0 | 0.00 | 0.00 |
| 5454B | 54" × 54" Plastic Table Cover | Beige | Case (24) | 19.15 | 2 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| 5454BL | 54" × 54" Plastic Table Cover | Black | Case (24) | 19.15 | 1 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| 549W | 54" × 108" Plastic Table Cover | White | Case (24) | 30.24 | 4 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| 549B | 54" × 108" Plastic Table Cover | Beige | Case (24) | 30.24 | 2 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| 549BL | 54" × 108" Plastic Table Cover | Black | Case (24) | 30.24 | 1 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| 72W | 72" Round Plastic Table Cover | White | Case (24) | 52.08 | 3 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| 72B | 72" Round Plastic Table Cover | Beige | Case (24) | 52.08 | 3 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| 72BL | 72" Round Plastic Table Cover | Black | Case (24) | 52.08 | 1 | $0.00 | 24 | 0 | 0.00 | 0.00 | |
| Napkins | 537 | 13" × 17" Linen-Like Napkins | White | Case (6 pk/50 each) | 45.90 | 6 | $0.00 | 6 | 0 | 0.00 | 0.00 |
| 28500 | 10" × 10" Linen-Like Napkins | White | Case (8 pk/50 each) | 42.00 | 3 | $0.00 | 8 | 0 | 0.00 | 0.00 | |
| 1010W | 10" × 10" 2-ply Beverage Napkins | White | Case (12 pk/50 each) | 18.14 | 6 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 1010B | 10" × 10" 2-ply Beverage Napkins | Black | Case (12 pk/50 each) | 18.14 | 1 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 1010R | 10" × 10" 2-ply Beverage Napkins | Red | Case (12 pk/50 each) | 18.14 | 1 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 1313W | 13" × 13" 2-ply Luncheon Napkins | White | Case (12 pk/50 each) | 25.20 | 3 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 1313B | 13" × 13" 2-ply Luncheon Napkins | Black | Case (12 pk/50 each) | 25.20 | 2 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 1010WED | 10" × 10" Wedding Bells Print Napkins | White | Case (12 pk/50 each) | 26.46 | 3 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| 1313WED | 13" × 13" Wedding Bells Print Napkins | White | Case (12 pk/50 each) | 37.80 | 4 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| Drinkware | CC12 | 12 oz. Classic Crystal Tall Plastic Glasses | Clear | Case (12 pk/20 each) | 78.33 | 1 | $0.00 | 12 | 0 | 0.00 | 0.00 |
| CC16 | 16 oz. Classic Crystal Tall Plastic Glasses | Clear | Case (12 pk/20 each) | 107.73 | 1 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| CCR9 | 9 oz. Classic Crystal Plastic Rocks Glasses | Clear | Case (12 pk/20 each) | 53.90 | 3 | $0.00 | 12 | 0 | 0.00 | 0.00 | |
| $0.00 | |||||||||||
| Value | $0.00 | ||||||||||
| Profit | $0.00 |
