Microsoft Office for
Artists and Craftspeople
55 Ways to Organize Your Craft Fair Business with
Word and Excel
Get organized and make more money with Microsoft® Office as
you learn more about computers and spreadsheets. This book/software* package includes:
An easy monthly
bookkeeping system, with an up-to-date accounting of income and expenses.
Estimated sales taxes and Social Security taxes are automatically calculated.
A product pricing template that will instantly calculate the best price for
distribution, wholesale, and retail sale of your handmade craft product. Just enter your
annual desired salary, production rate and material costs.
A complete method designed to help you organize your fair applications and
show schedule. Now you won’t miss important craft deadlines. You can see your entire
years’ worth of shows at a glance.
A detailed inventory tracking template that shows what you need to make,
what you have in stock, how much it’s worth, and what you need to order.
A mail list manager database to keep track of your best customers and to
print labels to notify them of new products or your next show in their area.
Formal and legal agreements for sales reps, independent contractors,
employees, and consignment stores, designed to help keep you from getting ripped off!
Forty other forms with step-by-step instructions are included to help you organize your
business—invoice, packing slip, budget, press release, vehicle expense
logs, credit application, business plan, project bid, collection letters, and more!
Minimum system requirements for using the software templates included with this
book for Microsoft® Office, Word and Excel: Personal computer with a 486 DX processor or higher,
Microsoft Windows 95, 16 MB RAM or more, VGA graphics, Microsoft Office 95
or higher or Word 6.0 and Excel 6.0 or higher, MS mouse.
There are 75 templates, spreadsheets, letters and forms on
the CD-ROM. Also on the CD is 18,000 black and white clip-art images
to use for logos, painting, etc.
Here is the table of contents of the book:
(The
names in parenthesis are the names of the templates on the CD)
Introduction
Different Microsoft Office Configurations
How to Use the "Forms and Spreadsheets"
Disk
Bookkeeping
Monthly Accounting System (accounts.xls)
Daily Cash Report (dailyrep.xls)
Show Expense Report (expenses.xls)
Vehicle Log (vehicle.xls)
Accounts Receivable (accntrec.xls)
Selling Retail at Craft Fairs and Art Shows
Craft Fair Application Organizer (organizr.xls)
Craft Fairs at a Glance (fairshow.xls)
Craft Fair Equipment List (equipmnt.xls)
Customer Mailing List (customer.xls)
Craft Fair Database (fairlist.xls)
Selling Wholesale to Craft Galleries
Craft Gallery Database (gallery.xls)
Credit Application (credappl.doc)
Consignment Agreement (consign.doc)
Another Consignment Agreement (consign2.doc)
Craft Gallery Startup Costs (startup.xls)
Sales Representative Agreement (repagree.doc)
Sales Representative Commission Report (commisn.xls)
Sales Call Record (salescal.xls)
Trade Show Expenses (tradesho.xls)
Forms <
Invoice (invoice.xls)
Purchase Order (purchord.xls)
Statement (statment.xls)
Packing List (packlist.xls)
Price List (pricelst.xls)
Sales Order (salesord.xls)
Planning
Business Plan (busplan.doc)
Budget (budget.xls)
Cash Flow Planner (cashflow.xls)
Daily Planner (dayplan.xls)
Production
Inventory (invntory.xls)
Employee Application (emplappl.doc)
Employee Non-Competing Agreement (emplcomp.doc)
Independent Contractor (contract.doc)
Marketing
Product Pricing (pricing.xls)
Marketing Plan (mrktplan.xls)
Press Release (pressrel.doc)
Project Bid (projbid.doc)
Mail Order Advertising Results (advertis.xls)
Desktop Publishing
Letterheads (letheads.doc)
Shipping Labels (labelrw.doc)
Resume (resume.doc)
Calendar (calendar.xls)
To-do List (todolist.xls)
Miscellaneous
Personal Financial Statement (networth.xls)
Home Office Deduction (homeuse.xls)
Business Evaluation (busvalue.xls)
Profit and Loss Statement (profitst.xls)
Balance Sheet (balance.xls)
Letters
Craft Fair Letter
Opening Accounts
Customer Service
Employee Letter
Bad Checks
Late Payments
Requests for Information
A Brief Note About QuickBooks
Other Forms on the Disk
Conclusion
Index
You can order this book and CD combination for $39.95 with
PayPal. Just click on the button. Shipping with delivery
confirmation is $4.60.
| 
