BUSINESS TOOLS

Pre-made and low cost, Readily available without licensing

Pueo’s commitment to delivering immediate client value relies upon supporting technologies that are client-ready and easily customizable. Typically built upon available MS Office platforms (with deliberately excluded macro code which may complicate domain transfers), Pueo technologies allow us to rapidly deploy preliminary solutions to demonstrate immediate value and focus attention on supporting data, processes, and knowledge for enduring capabilities.​

Pueo’s portfolio of business tools allow us to deploy differentiating, value-added services from day one. Our consultants can quickly modify, enhance, tailor, or integrate these modular solutions for remarkably robust and powerful systems. While these solutions may not be the most efficient for long-term support, deploying these light-weight applications drive immediate value while affording our customers the time to institutionalize supporting processes and refine requirements before investing in costly advanced technologies.

While the following solutions represent only a sampling of Pueo’s technology portfolio, they also include free and downloadable (no strings attached) tools for your use. Please feel free to replicate and modify (extract logos as you see fit) for your purposes. Our consultants are standing by should you require set-up assistance.

NOTE: If you are unable to download functioning versions, please email inquiries@pueobusinesssolutions.com

Free Business Models

Forecasting Model

This model interprets and presents the relationship between two data sets.  A Monte Carlo analysis provides the probability that the next random input will exceed the user-entered threshold.  A regression analysis estimates the function output based upon the correlation, sample size, precedence, and user-entered data input.  These estimates include confidence levels with narrative captions that can abbreviate or expound according to the user’s preference.

Inform management decisions in anticipation of future events, based upon historical precedence. Defend budget/resource estimates. Automate narrative production for exhibit attachment with consistency and accuracy.

Download

Decision Model

This model documents decision bases and presents a defensible recommendation of alternatives to satisfy a stated objective. Recommendations are based upon user-defined criteria, associated weights, and scores for each alternative. While subject to other considerations, the model’s resulting recommendation provides a defensible point for discussion. Advanced elements of this decision model allow users to estimate the utility curve, and re-orient scores for consistency.

Document decision parameters and defensibility in perpetuity. Evaluate alternatives objectively against specified criteria.

Download

Pair-Wise Comparison Tool

This model applies Eigen vectors to improve the objectivity of unovaidably subjective assessments. This is achieved by evaluating the relative importance of one subject (criteria, alternatives, etc.) to another. In so doing, the result is more objective than an arbitrary or SME-driven assignment. Beyond executing the Pair-Wise analysis, this model facilitates human review with presentation features for group review.

Achieve an objective and more corporate weighting schema to feed decision models.

Download

Advanced Pueo Business Tools

Pueo's advanced tools are most effective with the support and guidance of skilled Pueo consultants for customization and implementation - accomplished virtually or on site. These tools rival most advanced Business Intelligence solutions, are user-customizable, and are integrated into Pueo consulting services with no additional cost. Summarized below are some of our most popular tools.

Get started with advanced tools for your business – contact us

Data Analytics Model

Do any data patterns, trends, or relationships exist across the portolio of available data? Can we predict anything as a result?

Ingest hundreds of data sets to glean data correlations or relationships. The model identifies potential correlations that are direct (both sets increase according to a common interval), indirect (both sets increase according to an uncommon interval), reciprocal (one set rises while the other decrease according to a common interval), lagging (correlations exist over different time periods), or any combination thereof. Such insight serves as a force multiplier, allowing human experts to execute focused analysis.

9-Box Workforce Performance vs Potential Management Model

Where do our employees score against both Performance and Potential dimensions? How do we best develop employees?

Ingest or enter employee scores to place each within a 9-box matrix organized by “High”, “Medium”, and “Low” boxes against both Performance and Potential dimensions. Utilize employee profiles (baseball cards) to maintain useful management information (e.g. most recent bonus, joint duty experience) and apply additional attributes for presentation against each employee.

Procurement and Acquisition Model

What acquisition paths exist to achieve my requirement? What is the best collection of paths to achieve my requirement portfolio?

Pueo’s requirement heuristic applied against our acquisition library help users to understand the types, specific vehicles, and constraints/limits to meet meet mission requirements – expanding visibility beyond the most apparent and sometimes overutilized acquisition paths. Capacity management and optimization tools identify the critical path and workforce limitations, thereby identifying defensible planning schedules and allowing for resource leveling and optimization to achieve acquisition goals.

Lease vs Buy Model

What is the business value of leasing or buying a product or service from a cost and performance perspective? When do I break even?

Particularly useful in the pursuit of Shared IT Service Delivery or other transitions from operational to capital expense (OPEX vs CAPEX). Incorporate spend schedules (e.g. Contract PoP) and derivative spend to truly understand cost differentials for lease vs buy options. Account for performance or return indicators for an RoI or Cost Performance Index to better inform the lease vs buy decision.

Risk Management / Optimization Model

What is our current or future risk profile? How can we best apply resources to mitigate or exploit risks according to our risk tolerance?

Utilizing a risk register, this model displays a typical Risk Matrix, but also presents a Risk Bubble Chart to portray risk and resource magnitude across functional portfolios. Beyond presentation, this model also applies an advanced regression technique to identify the optimal use of scarce resources applied to risk mitigating action.

Prioritization Model

What is the relative importance of each item based upon common criteria, weight, and subject scores? What can we afford?

Ingest activity attributes against common criteria to derive a 1-n ranking of each item. Model features allow for on-the-fly weight toggling, presentation displays, and portfolio views for informed decision making.

Knowledge Management Model

What knowledge exists within common areas of concern (functions, missions, customers, etc.)? How can I store my data for retrieval?

Establish knowledge management repositories, processes, and protocols to structure storage and allow for simple information retrieval? Quickly ascertain prior reports, messaging, or other knowledge sources by selecting standard concern areas.

Succession Planning Model

Mindful of Mission, Individual Growth, Availability and more, who should take over this vacant position and what is the domino effect?

Select from identified common succession-planning constraints, or establish new ones – then run the model’s solver to present viable and optimal solutions. Alternatively, explore various what-if scenarios to evaluate numerous courses of action and the impact of each upon constraints and inviduals.

Text Analysis Model

What is important to our most/least satisfied customers, employees, or overseers according to survey comments?

Dissect text strings of up to 250 words per string, to parse out and understand word popularity. The 500 most common words of the English language are automatically removed and users may manually exclude any other words from popularity count. Upon filtering text strings by associated attributes, glean highly insightful text assessments.

Performance Dashboard

What is our performance level against organizational objectives? Where do we require leadership attention and action?

Populate entry forms to automatically produce a Performance Dashboard, organized categorically (Balanced Scorecard, Organization, etc.), with simple color displays, and advanced trend analysis to inform leadership dialogue.

Labor Mix / Placement Optimization Model

How can we organize our workforce (civilian, military, contractor) to execute mission functions for the strongest RoI?

Enter associated labor data (geographic rate adjustment, service/mix concentrations, etc.) and assign limitations and constraints for Excel’s optimization solver to derive the best labor distribution to reduce costs and meet mission requirements. Sensitivity analysis describes incremental change results against stated objectives. Explore numerous scenarios via what-if planning.

Algorithmic Process Re-Engineering

How can we best apply our limited resources to overcome process bottlenecks and exploit process slack?

Built upon Interface (N2) diagramming, this model identifies process areas for improvement or exploitation and identifies viable resources-leveling solutions to apply against each. Such analysis and solutions are identified algorithmically through the use of objective functions and Operations Research techniques.