spreedsheet 1
Ely0817
Repair.xlsxDocumentation
| David's Computer Repair | |
| Job Invoicing | |
| Created by: | David Green |
| On: | 2/1 |
| Last Updated by: | |
| On: | |
| Purpose of workbook: | |
| How to use this workbook: | |
| Assumptions inherent | |
| in workbook model: |
Job Invoicing
| David's Computer Repair | |||||||
| Job Invoicing | |||||||
| Data Inputs: | |||||||
| Job Data | David's Computer Repair | ||||||
| Job Date: | 2/15 | 1571 Peachtree Lane | |||||
| Customer Name: | Jordan Perry | Lexington, SC | |||||
| Total Hours: | 4.5 | ||||||
| Charge Per Hour: | $60.00 | Customer Invoice | |||||
| Total Parts Charge: | $22.50 | ||||||
| Customer Name: | Jordan Perry | Invoice Date: | ERROR:#NAME? | ||||
| Total hours spent on job: | 4.5 | Date of Job: | 2/15 | ||||
| Charge per hour: | $60.00 | ||||||
| Sales Tax Information | Total labor charge | $ 270.00 | |||||
| Sales Tax on Labor: | 4.0% | Sales tax on labor | 6.0% | 16.20 | |||
| Sales Tax on Parts: | 6.0% | Total parts charge | 22.50 | ||||
| Sales tax on parts | 6.0% | 1.35 | |||||
| Total Amount Due: | $ 310.05 | ||||||
