Products
Sunday, 31 May 2009 19:50
 | Try InformXL free for 30 days. Contact us today.  |
| InformXL is an affordable, comprehensive, and easy to use Microsoft Excel(c) based data analytics solution. The concept is simple: an always connected, real-time, pre-built data analyzer with information linked directly to your enterprise database - ALL in Excel. With InformXL you can view your data in detail, summarize in pivots, build charts and graphs, add headers and footers, sorts, filters, logos, formats, etc. If you can do it in Excel, you can do it in InformXL. Try InformXL on your system risk-free for 30 days. Contact us today to try it out or to schedule an online demo. Once you see it and once you try it, you won't want InformXL, you will need InformXL!! | |
Homebuilder Essentials
9 pre-configured, plug-n-play InformXL analyzers designed specifically for builders running the Constellation Newstar™ software suite.
| Analyzer | Analyzer Description | Commonly Used By |
| AP Details | Provides detailed breakdown of all Newstar AP and Journal Entry transactions. This analyzer is designed for use by Accounting, as the primary parameter set is Company specific. Common uses include: · Open AP Report · Supplier invoice inquiry & audit · Journal Entry inquiry & audit · Job Cost to GL auditing · Company/Division AP summary | AP, Accountants, Controller, VP Finance |
| GL Balance | Provides summary OR detailed level breakdown of GL account balances. All balances can be summarized by Company, Division, Account, and Sub-Ledger. When run in detailed mode, displays GL transaction details for each account (in & out). Common uses include: · Month-end account inquiry · Trial Balance review & audit · General GL account review and audit · Ad-hoc company consolidation review & audit | Accountants, Controller, VP Finance |
| Job Cost Details | Detailed breakdown of all Newstar Job Cost transactions, including job cost Journal Entries. This analyzer is designed for use by Purchasing and Construction personnel, as only Job Cost (H and J string) transactions are included. Common uses include: · General Job Cost inquiry (by project, lot, major, minor) · Supplier invoice inquiry · Job scrub analysis & audit · Job Cost to GL auditing · Job Cost variance analysis | Purchasing, Construction VP, Accountants, Controller, VP Finance |
| Lot Options (NEW!!)
| Detailed listing of all options selected at the lot level. When viewed on a lot basis, this analyzer can be used be used to quickly view options associated with a spec, model, or contracted home. When viewed en-masse by Operating Unit or Project, the analyzer can be used to review option sales in various forms by revenue and sales volume. Common uses include: · View of option sales by buyer or lot · Summarize option sales by popularity · Summarize option sales by revenue dollars generated · Average option sales by project, category, subcategory, etc. · View of lot options relative to PO generation | Purchasing, Sales VP, Sales Coordinator, Sales Agents, Construction VP |
| Lot Schedules | Summary or detailed breakdown of lot construction schedules. Can be run in summary or detailed mode. Summary mode is intended for management level reporting. When run in detail, includes committed and open PO balances for each task. Common uses include: · Management level lot schedule summary · Backlog lot schedule review · Detailed job schedule review and audit · Job Cost projections (advanced) · Milestone summary | Purchasing, Construction, Controller, VP Finance |
| PO Details | Provides detailed view of PO line items. Includes payment and check details, and product, part, and task details. Common uses include: · Supplier PO audit and review · PO summary by job · VPO summary and analysis · Open PO balance summary · General PO audit and review | Purchasing, Construction, Controller, Warranty |
| Sales Summary | Provides summary of all lot level sales records in Newstar Sales (a.k.a. Sales Profiler). Includes lot and buyer details, gross sale and incentive summary, closing date projections, sales agent and realtor details, and contingency information. Common uses include: · General project, lot, buyer, sales analysis · Backlog review (under contract, pending offer, spec, model) · Neighborhood MLS comparison (via Google Maps) · Home closing projections (including revenue projections) · Sales agent and realtor sales analysis · Contingent sale management | Sales VP, Sales Coordinator, Purchasing, Controller, VP Finance |
| Subcontract Details | Detailed analysis of Newstar subcontract records. Intended primarily for purchasing to analyze and audit subcontract details. Common uses include: · Subcontract item detailed audit and review · Subcontract comparison by supplier or project · Price per square foot analysis · Supplier bid sheets · Subcontract product, draw, and task audits | Purchasing |
| Warranty Details | Provides detailed analysis of Newstar warranty line items. Includes all fields from Header, Item, and Item Craft data entry screens (approximately 75 fields). Intended to be used primarily by Warranty and Construction personnel to review current and past homeowner warranty items. Common uses include: · General Warranty open item analysis · Homeowner warranty lookup · Supplier or Assignee item summary · Warranty performance & average days | Warranty, Construction |
Last Updated ( Monday, 22 March 2010 10:34 )