Excel Pricing Tool for Sign Manufacturing Company
18 hours ago

Job description
Project Overview:
We are a full-service sign company (design, manufacture, project manage, install) seeking an experienced Excel developer to build a logic-based pricing tool for our sales team.
We need a structured Excel pricing engine — not a basic calculator.
Detailed pricing logic and rates will be shared after hire.
Scope:
Create a multi-product Excel tool that allows sales reps to:
- Select product types via dropdown
- Enter sizes and attributes
- Automatically calculate pricing
- Add design hours
- Apply project management fees
- Enforce minimum pricing thresholds
- Allow install to be added manually
Products (Categories Only):
Interior signage:
- ADA / code-compliant signs
- Wall graphics
- Interior logos
- Dimensional letters
Exterior signage:
- Cabinet signs (single, double, flex-face)
- Channel letters
- Monument signs
- Pylon signs
The Excel tool must include:
- Dropdowns for product attributes
- Centralized rate tables (no hard-coded values in formulas)
- Separate input vs calculation sheets
- Locked formula cells
- Ability to globally update pricing variables
- Design priced hourly (user input)
- Project management fee as percentage with minimum (toggle on/off)
- Manual install field
- Clean UX for sales reps
MUST HAVES (Non-Negotiable)
- All pricing variables stored in a single editable "Rates" sheet
- No hard-coded numbers inside formulas
- Separate Input vs Logic sheets
- Locked calculation cells
- Dropdowns for product attributes
Written documentation explaining:
Pricing structure
Where to update rates
How to add products
At least 2 revision rounds
Simple user interface for sales reps
Short Loom walkthrough video explaining the spreadsheet
Deliverables
Fully functional Excel pricing tool
Editable rate tables
Documentation
Video walkthrough
Payment Milestones:
30% – Architecture & structure
40% – Pricing logic implementation
30% – Final polish + documentation
Ideal Candidate
- Advanced Excel experience
- Pricing or financial modeling background
- Comfortable with complex formulas
- Organized, logical thinker
- English documentation required
Please briefly describe how you would structure a complex pricing model in Excel to avoid hard-coded values
Contract duration of less than 1 month.
Mandatory skills:
Microsoft Excel, Financial Analysis, Financial Modeling
Similar jobs
I'm looking for branding service for a new supplement manufacturing company. We look to have a minimalistic and modern feel. · ...
2 weeks ago
Bookkeeper Required for Manufacturing Company
Only for registered members
Job summary: We are a manufacturing company seeking a reliable bookkeeper for year-round accounting support and year-end tax preparation. The ideal candidate must be proficient in using Odoo ERP for managing financial records, invoicing, and payroll. ...
1 week ago
This is a long-term virtual assistant role for a growing manufacturing & e-commerce company. · C Customer service (emails, order questions, follow-ups) · General admin tasks (updating orders, organizing info, basic coordination) · ...
2 days ago
Production Supervisor es responsable de supervisar a los empleados en una fábrica, mantener el control de producción y calidad mientras mantienen un foco continuo en entornos productivos/manufactureros. · ...
3 weeks ago
B2B Marketplace Development for Manufacturing Companies
Only for registered members
We are seeking a skilled developer to help create Shartetribe, a B2B marketplace designed for manufacturing companies looking to connect their free capacities with potential clients. · ...
1 month ago
We are seeking an experienced professional to assist in setting up HubSpot CRM optimised for our national reach. · Customizing the CRM to fit our specific business processes · ...
1 week ago
Workflow Automation Design for Manufacturing Company
Only for registered members
We are seeking a skilled freelancer to design a comprehensive workflow automation system tailored for our manufacturing processes. Our company specializes in water and wastewater treatment projects, and we require an expert to streamline our operations from order to execution. · ...
1 month ago
We are a manufacturing company in the supplement industry and we have high converting website that is well-designed. · Mandatory skills:PPC Campaign Setup & Management · Google Ad Manager · ...
1 month ago
Lead Generation – Food Manufacturing Companies
Only for registered members
I'm looking for a reliable freelancer to help with lead generation for a short-term project focused on food manufacturing companies in North America. · ...
4 weeks ago
Brochure Development for Textile Manufacturing Company
Only for registered members
We are seeking a skilled brochure developer to create an engaging and visually appealing brochure for our textile manufacturing company.The ideal candidate will have experience in graphic design and marketing materials, with the ability to effectively communicate our brand story ...
3 weeks ago
Social Media Posts for Appliance Manufacturing Company
Only for registered members
We are seeking a creative social media specialist to craft engaging posts for our appliance manufacturing company. The ideal candidate should have experience in creating content that resonates with our target audience and promotes our products effectively. · ...
2 days ago
Day-to-Day Accounting Support for Manufacturing Company
Only for registered members
We are seeking an experienced accounting professional to assist with daily accounting tasks for our manufacturing company using Infor M3 (on-premise version). · ...
2 weeks ago
Website Content Writer for Machinery Manufacturing Company
Only for registered members
We are seeking a talented writer to develop engaging and informative content for our company website, specializing in machinery manufacturing and customized products. · ...
1 month ago
Build a professional website for a custom manufacturing company
Only for registered members
We need to have a website created for our new manufacturing company. · come up with something that is unique, engaging and exciting to experience. · ...
1 month ago
Modern Corporate Website for Furniture Manufacturing Company
Only for registered members
We are looking for an experienced web developer or team to build a modern corporate website. ...
3 weeks ago
Grant Writer for BC Based Manufacturing Company
Only for registered members
We're a company based in Vancouver BC looking for a grant writer with experience. · We want someone who knows the industry inside out. · You have experience working with wood / furniture / industry · If this sounds like you, get in touch. ...
1 month ago
WordPress Developer Needed for Machinery Manufacturing Company Website
Only for registered members
We are looking for an experienced WordPress developer to create a professional website for a machinery manufacturing company. · This is not an eCommerce website. The website will display products with full details, and instead of an "Add to Cart" option, there will be an "Inquiry ...
1 month ago
Quickbooks Online Setup for Small Manufacturing DTC Company
Only for registered members
I recently acquired a small business in an asset sales that manufacturers jewelry and sells direct to consumer on Amazon, Etsy, eBay and also sells Wholesale (35% of sales). This project is to provide expertise and assistance in setting up Quickbooks Online to support a small bus ...
1 month ago
Research & Compile List of Manufacturing Companies in East/Central US
Only for registered members
We are seeking a detail-oriented freelancer to compile a comprehensive list of 2000 small to mid-size manufacturing companies located in the East or Central regions of the United States. · The target companies should have between 50 to 1000 employees. ...
3 weeks ago
WordPress Website Design for Custom Wood Truss Manufacturing Company
Only for registered members
We are seeking a talented web designer to create a WordPress website for our custom wood truss manufacturing company based in Utah, USA. · The ideal candidate will have experience in designing user-friendly, visually appealing websites tailored to the construction industry. Knowl ...
1 month ago