Job docket template

Continue reading below to see how you can use these work orders internally as IT job orders or maintenance work order forms. Work order forms are usually customized to include more details than a basic purchase order. A work order is sometimes used as an invoice when working with external customers. License : Private Use not for distribution or resale. Vertex42's free Work Order Form Template is an Excel file that contains two separate work order forms as separate worksheet tabs.

View the sample work order form screenshots above and to the right. Each work order is fully customizable and geared mainly towards service , repair and maintenance work. See our purchase order form if you'd like to create a sales order.

The basic work order form template shown above is great for smaller jobs or putting together a work estimate or quote. It is modeled after our free quote template. The frequency of these updates does however depend on the costing methodology that is applied and the significance of fluctuations in component pricing.

The average actual cost which is calculated in this template is based on all the jobs that are included on the JSetup sheet. It therefore makes sense to "refresh" these average costs from time to time by saving a new version, amending the standard cost basis if necessary , clearing the contents of the JSetup and JDetails sheets user input columns only and recording new jobs on these sheets.

Note: Do not delete any of the formulas in the columns with light blue column headings because this would result in inaccuracies in the template calculations. You can delete rows that are not required but you should always retain at least two rows in these columns.

This means that if you filter the StockCode sheet, only the cells that are visible on the sheet will be included in these calculations. As we've mentioned before, the value of transactions that relate to intermediate stock items will be excluded from the report to the extent that the intermediate products were manufactured receipt transactions and issued to other manufacturing jobs issue transactions during the same review period.

Note: Components are listed on the job costing review JReview sheet in the same order in which they appear on the StockCode sheet. If all stock components are therefore sorted in an ascending order by the stock code, the components will also be displayed in this order on the JReview sheet.

The purpose of the BOM sheet is to create a link between stock components and manufactured products. This is accomplished by entering the appropriate stock code of the manufactured product in column A and entering the stock code of the appropriate component in column B. Multiple stock components can be added to a single manufactured product in order to create a product costing which consists of multiple stock components.

Note: Columns A and B both contain list boxes that include all the stock codes that have been created on the StockCode sheet. You therefore need to create a stock code for each manufactured or component product before you will be able to select the appropriate stock code from the list boxes in these columns. You can add a new stock component to the sheet by simply selecting the appropriate product code from the list box in the first empty cell in column A - the table will be extended automatically to include the new product code.

All the columns on the BOM sheet with a yellow column heading require user input. The columns with light blue column headings contain formulas that are automatically copied for all new stock components that are added to the Excel table. The BOM sheet includes the following user input columns columns with yellow column headings :. The stock code of the manufactured product to which the stock component should be added needs to be selected from the list box in this column. The list box includes all the stock codes that have been created on the StockCode sheet.

The product stock code should be repeated for all the components that are used in the manufacturing process. For example, if 10 components are required in order to produce a particular manufactured product, you need to add 10 different component stock codes in column B in 10 separate rows and repeat the product stock code in column A in each of these rows. All 10 component stock codes will then be linked to the same manufactured product and will be included in the same product costing.

Note: Product stock codes and components do not need to be grouped together on the BOM sheet by the product stock code when entering data but we recommend this approach because it will make it easier to identify components which have been duplicated.

You can also sort the BOM sheet first by the product code in column A and then by the component code in order to reflect your standard costing records in this order. A component stock code needs to be selected from the list box in column B for each component that is used in manufacturing the product which has been selected in column A.

The standard cost of a manufactured product for job costing purposes is calculated based on the costs of all the components that have been linked to a manufactured product on the BOM sheet.

Note: A very efficient method of adding components to a manufactured product is by copying the components from a similar product, selecting the appropriate new product code from the list box in column A and editing the input quantities and yields of all the components.

This method will however only be efficient if components have previously been added to a similar manufactured product on the BOM sheet. The input quantity of the stock component that is used in the manufacturing process should be entered in column C. This quantity should be entered in the same unit of measure that is specified for the particular stock code on the StockCode sheet the component UOM is listed in column J. If the unit of measure of the manufactured product is "Units", the input quantity of the component should be sufficient in order to produce 1 unit of the manufactured product but if the unit of measure of the manufactured product is for example "Dozen", the input quantity that is entered should be sufficient in order to produce 12 units of the manufactured product.

Note: The yield basis should also be taken into account when determining the appropriate component input quantity. If the yield that is entered in column D is based on an Input basis, the component quantity that is added at the beginning of the manufacturing process should be entered in column C. If however the yield is based on an Output basis, the component quantity that remains at the end of the manufacturing process should be entered in column C.

This is because the input quantity is divided by the yield as part of the component cost calculation. Note: You may also want to consider entering a calculation in the input quantity column because this approach may make it easier to determine how the input quantity has been calculated if a calculation has been necessary.

For example: if the component unit of measure is dozen and only one unit is used in the manufactured product, the component quantity is calculated by dividing 1 dozen by twelve. You therefore have the option of entering 0. The component yield should be entered in column D as a percentage. The input quantity that is entered in column C is divided by the yield in column D in order to determine the component quantity that is required in order to produce the manufactured product.

Yields can be determined on an Input or an Output basis - the difference between the two bases is best explained by a definition and a few examples. Definition: The inherent nature of a manufacturing process may result in the component quantity at the end of the manufacturing process being less than the component quantity that is introduced at the start of the manufacturing process. The quantity difference can be described as a yield loss.

The Input basis refers to the component quantity that is introduced at the start of the manufacturing process, while the Output basis refers to the component quantity which remains after the manufacturing process has been completed. Note: If there is a significant yield loss during the manufacturing process and the incorrect yield basis is used to determine the yield that is entered in column D, the product costing of the manufactured product may be inaccurate.

As we've mentioned before, the yield basis also affects the input quantity that needs to be entered. It is therefore important to take the yield basis into account when determining the component input quantity that needs to be entered in column C. Example: If we use minced meat in the manufacturing of a beef burger, we have to decide on a yield basis before we can determine the appropriate input quantity that should be specified.

If our aim is to produce a g burger at the end of the manufacturing process, the quantity is based on the output after manufacturing. We may know that on average g of minced meat is required in order to produce a g burger at the end of the manufacturing process - the g is therefore the Input based quantity. Example: Our example beef burger includes one slice of onions. With this component, we are not really concerned about the output weight because we have already decided that only one slice of onions will be included on our beef burger.

The unit of measure of the onions component is kilogram and we therefore need to calculate the input quantity of this component based on how many slices are included in a kilogram of onions. The quantity that represents one slice then needs to be entered in the Input Quantity column. We also need to take this yield loss into account in order to compile an accurate beef burger product costing. Note: All the columns on the BOM sheet with a yellow column heading require user input.

These two columns are included on the BOM sheet to enable users to view the description of the product stock codes that are selected in column A and to ensure that the correct unit of measure is used when entering component input quantities. This column indicates the bill of material level which has been assigned on the StockCode sheet for the product stock code that has been selected in column A.

The bill of material level determines whether intermediate products are issued on a job for standard costing purposes and should be aligned to the way in which actual components will be included in a manufacturing job.

Note: If a BOM level of all is assigned to a product, it means that the product is produced in a single manufacturing process and that only bought-in items will be issued to the job.

If a first level is selected for the product, it means that the intermediate products that form part of the product's bill of material will be produced through separate manufacturing processes and therefore jobs and that the intermediate products will be issued to the job. These columns are included to enable users to view the description of the component codes that are selected in column B and to ensure that the correct unit of measure is used when entering component input quantities.

This column reflects the type of component that has been selected in column B. If the component type is "Bought-in", it means that the component is purchased from a supplier. If the component type is "Manufactured", it means that the component is an intermediate product which needs to be manufactured.

This column contains the status of a component based on the product level that has been selected and is only used for report calculation purposes. If the component is a bought-in stock item, the standard unit price of the component which is specified on the StockCode sheet will be included in this column.

If the component is a manufactured stock item, the bought-in price will be nil and the component cost will be based on the calculations in the intermediate columns. The bought-in cost of components is calculated by multiplying the bought-in price of the component by the input quantity in column C and dividing the result by the yield in column D. If the component that has been selected in column B is a manufactured product, the component cost in this column is determined based on the product cost of the intermediate product which is calculated in column Q.

Note that the component cost is calculated as the sum of all the product costs of components that are linked to the intermediate product on the BOM sheet. If the component is a bought-in product, the intermediate component cost of the product will be nil. The intermediate product costs of components are calculated by multiplying the intermediate component cost of the component by the input quantity in column C and dividing the result by the yield in column D.

If the component is a bought-in product, the component product cost will be equal to the component bought-in cost. If the component is an intermediate product, the component cost will be equal to the intermediate product cost. Note that the product cost of the manufactured product that has been selected in column A will be equal to the sum of all the component product costs that are calculated for the particular product in this column. If the component is a bought-in stock item, the actual unit cost of the component which is calculated in column AA on the StockCode sheet will be included in this column.

If the component is a manufactured stock item, the actual unit cost will be nil and the component actual cost will be based on the calculations in the intermediate columns. The actual component cost in this column is calculated by multiplying the actual unit cost of the component by the input quantity in column C and dividing the result by the yield in column D. If the component that has been selected in column B is a manufactured product, the actual intermediate component cost in this column is determined based on the actual cost of the intermediate product which is calculated in column V.

Note that the actual component cost is calculated as the sum of all the actual costs of components that are linked to the intermediate product on the BOM sheet. If the component is a bought-in product, the actual intermediate component cost of the product will be nil.

The actual intermediate costs of components are calculated by multiplying the actual intermediate component cost in the previous column by the input quantity in column C and dividing the result by the yield in column D. If the component is a bought-in product, the component actual cost will be equal to the component actual unit cost. If the component is an intermediate product, the component actual cost will be equal to the intermediate actual cost. Note that the actual cost of the manufactured product that has been selected in column A will equal the sum of all the component actual costs that are calculated for the particular product in this column.

Note: The actual cost calculations on the BOM sheet are only used when multiple products have been assigned to a manufacturing job. If only one manufactured product is assigned to each job, the actual unit costs are calculated purely based on the job issue transactions which are entered on the JDetails sheet.

These columns are used to calculate the standard issues of all bought-in and intermediate products based on the received quantities of all manufactured products that have been entered on the JDetails sheet. The total standard quantities issued in column Q on the StockCode sheet are based on the calculations in these columns. These columns are used to calculate the standard issues of all bought-in and intermediate products based on the required quantities on the job that is currently selected on the JReview sheet.

The total standard quantities issued in column D on the JReview sheet are based on the calculations in these columns. These columns are used to calculate the standard issues of all bought-in and intermediate products based on the received quantities of the job that is currently selected on the JReview sheet.

The total standard quantities issued in column E on the JReview sheet are based on the calculations in these columns. These columns are used to calculate the standard issues of all bought-in and intermediate products based on the production forecast quantities of all manufactured products that have been entered in columns A to G on the ReqPlan sheet. The total component quantities required in columns I to N on the ReqPlan sheet are based on the calculations in these columns.

The following section covers some important points that users should take note of regarding the bills of material on the BOM sheet. For the purpose of compiling product costings, stock codes also need to be created for all labour, direct overheads and even distribution costs that need to be included in the product costings. These stock codes should be seen as cost centre codes instead of stock codes which are represented by physical stock on hand.

The appropriate labour pay rates or overhead allocation rates should be entered in the standard unit price column on the StockCode sheet and the appropriate production times should be entered in the input quantity column on the BOM sheet.

Example: A beef burger is manufactured in a kitchen that consists of 3 staff members. You can create multiple labour stock codes on the StockCode sheet if there are different labour rates for different staff members.

All the applicable labour stock codes then need to be added separately on the BOM sheet. Additional stock codes do not need to be created if only the production time input quantity differs between products because different production times can be accommodated by entering different input quantities for each product on the BOM sheet.

It is only when the labour pay rates differ that separate stock codes are required. Example: Direct overheads or distribution costs can also be added to the product costings by creating a stock code for each type of overhead.

All manufacturing jobs need to be set up on the JSetup sheet by assigning a unique job number to the job, entering a date, selecting the appropriate stock code s for the manufactured items that need to be produced and entering a required quantity for the manufactured stock item. The template accommodates any job numbering convention and the format that is supplied in our examples does not need to be used. It is only important that each manufacturing job is assigned a unique job number.

We recommend that you only include one manufactured product per job number. If multiple manufactured products are assigned to the same job number, it will not be possible to calculate an actual cost for each of the manufactured products because the components that are issued to the job are not linked to a particular manufactured product.

The template mode is reflected in cell U1 on the JSetup sheet. Assigning multiple manufactured products to the same job will only really be necessary if more than one manufactured product is produced in the same production process. This may be the case if multiple product variations are produced simultaneously or if one or more by-product is produced as part of the manufacturing process of a main product.

Under these circumstances, switching the template to the Multiple mode is unavoidable. The most practical approach in estimating an actual cost in the Multiple mode would be to use the average actual costs of bought-in products and to include these prices in the existing bills of material in order to calculate an estimated actual cost which is based on actual prices and standard usages.

When the template is therefore switched to the Multiple mode, the estimated average costs of manufactured and intermediate products will be reflected in column AA on the StockCode sheet. The JReview sheet will not however include an actual cost because the calculations are performed for an entire date range and not based on a single job.

Note: The contents of the JSetup sheet have been included in an Excel table. You can add a new job to the sheet by simply entering the appropriate job number in the first empty cell in column A - the table will be extended automatically to include the new job.

All the columns on the JSetup sheet with a yellow column heading require user input. The columns with light blue column headings contain formulas that are automatically copied for all new jobs that are added to the Excel table.

This means that if you filter the JSetup sheet, only the cells that are visible on the sheet will be included in these calculations. The JSetup sheet includes the following user input columns columns with yellow column headings :. Enter a unique job number in this column. The job number needs to be repeated in this column if multiple manufactured products are being linked to the same job number.

You can use any job numbering convention. Enter the date on which the job is completed in this column and repeat the date if multiple manufactured products are linked to the same job.

Select the stock code of the product that is being manufactured in this column. All stock codes need to be added to the StockCode sheet before being available for selection on this sheet. Enter the quantity that is required to be made in this column. This quantity does not have a direct impact on the standard or actual costs but is used to determine the component requirements on the JReview sheet in column D.

This delivery docket template makes managing dockets much easier than any word doc, PDF or excel sheet. Delivery Docket template Free and editable. Preview the full template. Use this smart delivery docket template for yourself now.

Preview this smart delivery docket template below. Open one of the docket entries, and even try edit the template. Use and customise this delivery docket template for free now. The good news is, you can.

Anyone in the Human Resources industry would love this! Instead of hiring a designer or doing it yourself from scratch, we did most of the hard work for you and came up with these vibrant designs and layouts. It's a simple and colorful multisectional resume PDF template.

Candidates can fill the necessary information such as personal info and work experience and upload their photos by using this job application form template. When you decide to offer a job to an applicant, you need to present every single detail like the job title, salary and other critical details together.

Don't waste time constructing your own template for Employee Equipment Agreements. Use this Employee Equipment Agreement Template produced by Jotform and start letting your employees use your equipment right away!

It is important to give value to your employees by acknowledging their performance in achieving the goals of the company or the department. Every month, you can host a small awarding ceremony to honor these hardworking employees by giving them a gift and a certificate. You can use this eye-catching Employee of the Month Certificate Template in order to make your job easier.

This wonderful Employee of the Month Certificate Template shows the employee name, the date the certificate was awarded, the signature of the operations manager, company logo, contact information of the company, and the picture of the employee. Planning a business trip? This Letter of Intent for Promotion PDF document contains a straight forward introduction of the applicant's intention to apply for a higher job role.

The letter also provides some information about the current position of the applicant and his achievements in order for getting a better consideration in his application.

This employment contract template states in clear and explicit terms the conditions of employment. Certify your job application by using this Previous Employment Verification Letter that will increase your chances of getting accepted because the letter authenticates your work experience and credentials. Congratulate an employee by promoting them into a higher position by using this Promotion Letter to Employee template. This document should indicate the job position, salary increase, and new job responsibilities.

Professional Employee Record Template will highly ease your process, as you will be able to view each employee's information in one interface if you are running a business or working in an HR department. Bring your human resource or administrative office work anywhere as long as you have internet access.

Utilize your time producing your Verification of Employment for your employees using this Verification of Employment Letter.

Produce your documents instantly and online using this Verification of Employment Letter Template. Do you want to collect the online job applications for your business? This easy to use job application form template will come in handy for your business!

You can gather the personal information, for example, full name, email address, address, phone number, and job interest details such as type of employment desired, the date that the applicant can begin working, employment history for instance most recent employer name, city, state, employer phone, position, supervisor name, reason for leaving, and additional information such as explanations of the why you should hire the applicant.

As you can see, the form includes all of the information about your applicants. Thus, you can find the best employees by using this job application form template! We have prepared a PDF template with this form, if you want, you can add your branding and use it immediately! Create a custom Letter of Intent to Return to Work with our free template. Just fill in a short form to generate your letter as a professional PDF document. Keep track of employee training. Generate PDF training records automatically.

Collect information and e-signatures. Easy to customize. No coding. These laws provide protection to the person's privacy and thus, an organization or an individual cannot just use, process, or disclose someone else's information without the consent of the information owner.

This is where a Release of Information form comes in. A Release of Information is a document signed by the authorizing person owner, allowing the recipient or holder of the information to disclose or use the information through the consent of the owner. In respect and with the rise of privacy laws on countries, it is safe to assume and has become a common practice that a release of information is needed before one can process the data of the owner.

This Release of Information PDF template contains the necessary information that the owner consents to for the recipient to release information. This template can be used for processing to what specific kind of request is to be made, what information is to be released, and up until when the consent will maintain to be effective. To prevent any possible matters of litigation, it is best to exercise this practice of requiring the consent of the owner before processing the data of the person.

This Letter of Interest for Promotion Letter PDF Template is an easy on-the-fly PDF document for those who wish to make use of a system offering job positions internally to those people who would like to express interest in the job opening. This Letter helps run an introduction and leads form users to know what information should the applicant provide to pitch his interest for his promotion. Help your student to get accepted in college or university he dreams of by using this Letter of Recommendation for College.