Warning: Changing SHEETNAMES or cell positions will break most of the formulas in this workbook.
If you don't know what something costs you to make, how can you expect to make any profit on it?
If you have ideas about something to add, please let me know since I'd probably like to use it to.
Your shop's product's Quote
Click on the Description > Select Part > Part Quote is displayed.
Your shop's products list. For each part, fill in the fields.
Weight (g) and Print Time (2 days, 3 hours, 5 Minutes enter as 51:05 / 52 Mins enter as 0:52) from your slicer.
The next 7 fields are in minutes it takes to perform the action.
Quote Price is how much you want for the part. The purple fields are just for notes.
Hardware fields: Select the intended hardware via dropdown and input a count of them to the right.
One-off parts/project quote. Same as "Quote", but isolated.
One-off parts/project List. Same as "Parts", but isolated.
Hardware that is added to your parts.
A list of hardware, their costs per pack, cost per unit, and where to get them.
Your printer Models, not individual machines. (I have four Sovol SV06+ printers; I list one printer.)
Input: Name, Material Diameter [mm], Price, Depreciation Time, Service costs per life, Energy Consumption [kWh/h], Start-Up Time
Your materials. This is where the pricing for your material resides.
General Variables
Input: Energy cost, High Labor Costs, Low Labor Costs, Failure rate, Money unit, Payment processing costs
For Space Input: Rent/Mo, Tot. Sq. Ft., Used Sq. Ft.
In these four sheets, I have each of the colors I use denoted with a color name and a background color representative of the color.
Each product (line) has a list of colors, and each color has 3 numbers:
- Printed parts in inventory ready to sell.
- How many printed parts do you want in inventory?
- Parts that are needed to be printed to fill inventory.
Overstocks are shown as negatives
Inventory of individual rolls of filament.