The capital/energy estimate summary format (v10.0 effective April 2024) introduces three new variables in computing the cost price, working capital cost (to cover bank interest on funds), energy cost and sales discount, to better meet the changing economic environment. Energy cost could have previously been represented by a rarely-used charge like excise duty, but is now properly represented on its own. Both working capital and energy cost are calculated as percentages of production cost. The format also introduces new terminology for some items on the estimate summary working sheet as illustrated below.

STANDARD FORMAT

NEW CAPITAL/ENERGY FORMAT

All percentages are input on the Estimate Form prior to report generation. Any variable that is not needed will have its percentage specified as 0%. Any nonchargeable items in an estimate will be listed as part of Subtotal 2.

The changes in terminology are:

All reports in Printwiser (Estimating) that include estimate summary items or calculate unit price now reflect the new format, for applicable estimates. These are:

1. Summary estimate working sheet
2. Revised summary estimate working sheet
3. Supplementary sheet
4. Cost sheet (estimate cost summary)
5. Quotation (3 reports/formats)
6. Quotation schedule
7. Work-back estimate
8. Cumulative estimate summary
9. Estimate chart
10. Cost analysis
11. Flexible estimate spreadsheet
12. Detailed estimate with summary (pricing)

Program menu and window changes

In addition to changes in the report formats, on the Option menu, a checkmark item Capital/Energy Estimate Summary was added. It can be temporarily turned on or off by a Supervisor. When it is on:

1. Estimate List will have the following new columns: Estimate Summary Format, Working Capital Rate %, Energy Rate %, Sales Disc Rate%. Only Estimate Summary Format is editable on the list.
2. Estimate Form will have the following new items: Estimate summary working sheet format, Sales discount, Working capital rate, Energy rate. All are editable; visibility of last three depend on the entry for the first. When Capital/Energy Estimate Summary is turned off, only Estimate summary working sheet format will show on the form, with its value not editable and set to Standard for new estimates.
3. New estimates are assigned the Capital/Energy settings. Old estimates will have their Standard (former) settings, but could be switched to Capital/Energy any time.
4. The File > Open > Working Capital menu item is enabled.
5. The Settings form will include Working capital rate and Energy rate. These values are automatically assigned to new estimates.

New flexible estimate spreadsheet columns

The following 16 new columns were added for selection, all in the SPECIFICATION category: Production Cost, Mark Up Rate, Mark Up Amount, Working Capital Rate, Working Capital Amount, Energy Cost Rate, Energy Cost Amount, Subtotal 1, Sales Discount Rate, Sales Discount Amount, Subtotal 2, Selling Value, Selling Value Plus VAT, Unit Price Plus VAT, Excise Duty Rate, Excise Duty Amount.

Other features that come with this upgrade include:

• Working capital list and form for interest calculation/prorating
• Cost analysis report review to include client stock amount
• Hard/limp cover estimate summary for price calculation

1. Working capital list and form for interest calculation/prorating

When Capital/Energy Estimate Summary setting is on, the File > Open submenu will include Working Capital item, that displays a list, and from the list, a form:


All data entry is done on the form. When adding a new record, only Annual interest amount is calculated. The lower part of monthly interest breakdown will appear when the entry is updated. In the interest breakdown, Cumulative interest is total interest as at each month, while Instalmental interest is how much of the interest is to be paid instalmentally in the given number of months. In the above example, for month 4, total interest is 400,000 while paying the annual interest in 4 instalments will be 225,000 each. You can increase the height of the window to see more months.

2. Cost analysis report review to include client stock amount

If an estimate includes client stock, then the client stock (charge) amount will now show up as a new column on the report.

3. Hard/limp cover estimate summary for price calculation

On the Option menu, a second checkmark item Hard/Limp Summary Price Splitting was added, always checked if installed, and not changeable. From File > Build Report > Estimate submenu item, a new Report Format now appears, Hard/Limp Cover Summary:

It generates summary reports with unit prices for both Hard Cover and Limp Cover quantities, for estimates that include both.

For such estimates, the Case Binding Quantities form displayed from the Estimate Form, now includes “Rates to apply to Preparation and Machine Room totals for price splitting” (two items, hard and limp cover rates), and a “Prorate litho/extra charges as above” checkbox. If the prorate checkbox is not ticked then 100% of litho/extra charges will be used for the report. The hard and limp cover rates are recalculated when Quantity 1 is changed, though are changeable.

(If you specify an estimate that does not include case binding quantity, nothing will be generated.)