[email protected] +1 303 779 0344

Home Examples By Industry Manufacturing

Site Production Roadmap

This site production roadmap, planned in OnePager, imports key production dates from Smartsheet, Excel, or Microsoft Project. It is designed to help a manufacturing company optimize its global production assets over a diverse and evolving line of consumer electronics products.

This site production roadmap shows allocation of manufacturing assets worldwide across a diverse line of electronics products for a fictional manufacturer.


Download Site Production Roadmap as PDF      Download Site Production Roadmap as Image


Site Production Roadmap Features

This site production roadmap features:

  • Collection of manufacturing activities by assembly line, which shows allocation of manufacturing assets
  • Grouping of assembly lines by manufacturing site, showing concurrent activities in each plant or division
  • Conditional formatting of each product manufacturing activity by the product category (e.g. chips, batteries, etc.)
  • Tracking of machine hours through the use of a stacked area graph*, broken out by product category.
  • Links to show movement of manufacturing activities from one plant to another as established products are outsourced overseas, and cutting-edge products are manufactured locally

This site production roadmap was created using OnePager, product roadmapping software that integrates with Smartsheet, Microsoft Project, Excel, and more.

To learn more about OnePager, and see how it can help your product roadmapping activities, get started today by downloading a free trial.

15-Day
Free Trial

Sample Files

This site production roadmap was built using the following files, which you can download if you'd like to create something similar:

Smartsheet Samples

Site Production Roadmap (Smartsheet).xlsx (Excel for import into Smartsheet)

Site Production Roadmap (Smartsheet).tat (OnePager Template for Smartsheet)


Smartsheet Instructions

To build a site production roadmap like the example above, follow these instructions:

  1. Download the sample files above. The Excel file contains all of the manufacturing timelines for each site, and will be imported into your Smartsheet account, while the OnePager template will help define the layout of the roadmap itself. Save both files to your desktop.

  2. To import the Excel file into Smartsheet, first log into your Smartsheet account.

  3. In Smartsheet, click on + Start a New Project, and then from the Import tile, choose Microsoft Excel:

    Import from Excel into Smartsheet

  4. Point Smartsheet to the Excel file that you downloaded above and press Continue. On the Import Settings, review the name of your sheet, and then click Import::

    Finish importing from Excel into Smartsheet

  5. Now that the sample project has been imported into your Smartsheet account, go to your desktop, and click the OnePager button.

  6. On the OnePager start screen, click NEW to build a new roadmap.

  7. Go to Select > BROWSE Smartsheet, log into your Smartsheet account, and then point OnePager to the example project.

  8. We need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (styles, layout, etc.) that make the roadmap look the way that it does.

  9. Once the custom OnePager template is selected, click on Create New Chart to build your roadmap. It should look like the example at the top of this article.

15-Day
Free Trial

Microsoft Project Samples

Site Production Roadmap.mpp (Microsoft Project Plan)

Site Production Roadmap (Project).tat (OnePager Template for Project)


Microsoft Project Instructions

To build a site production roadmap like the example above, follow these instructions:

  1. Download the sample files above. The Microsoft Project file contains all of the manufacturing timelines for each site, while the OnePager template will help define the layout of the roadmap itself. Save both files to your desktop.

  2. Open the Microsoft Project file

  3. Now that the sample project has been imported into Microsoft Project, go to your Add-Ins tab, and click the OnePager button.

  4. On the OnePager start screen, click NEW to build a new roadmap.

  5. We need to change OnePager's default template to the one downloaded above. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains all of the data-driven formatting (styles, layout, etc.) that make the roadmap look the way that it does.

  6. Once the custom OnePager template is selected, click on Create New Chart to build your roadmap. It should look like the example at the top of this article.

15-Day
Free Trial

Excel Samples

Site Production Roadmap.xlsx (Excel Plan)

Site Production Roadmap (Excel).tat (OnePager Template for Excel)


Excel Instructions

To build a site production roadmap like the example above, follow these instructions:

  1. Download the sample files listed above. The Excel files contains all of the manufacturing timelines for each site, and the matching OnePager template file has most of the settings that drive the look and feel of the roadmap based on the data from or Excel. Save both files to your desktop.

  2. Open the Excel plan.

  3. Once the project plan is open, go to Add-Ins and click the OnePager button.

  4. When the start screen appears, click NEW to build a new roadmap.

  5. Change OnePager's default template to the one downloaded above, making sure that you pick the template that matches the Excel plan that you downloaded. To do this, click on Change, and then BROWSE FILES to the OnePager template (*.tat) file. This OnePager template contains most of the data-driven formatting (colors, layout, etc.) that give this site production roadmap its specific look.

  6. With the template loaded, click on Create New Chart. It should closely match the example at the top of this article.

15-Day
Free Trial

* Graphing is an optional feature, purchased separately from the standard OnePager license.