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**

PREPARATION MACHINE ROOM BINDERY LITHO TOTAL COST |
999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 |
Sum of above |

STD ADDITION 99.9% PRICE AS STD SALES COMM 99.99% SUBTOTAL EXCISE DUTY 99.99% AGENCY COMM. 99.99% SPECIAL COMM. 99.99% V.A.T. 99.99% TOTAL Per Copy OR Per 1000 |
999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 |
% of total cost total cost + std addition % of std addition price as std + sales comm % of subtotal % of [total - (special+vat)] % of (total - vat) % of total |

**NEW CAPITAL/ENERGY FORMAT**

PREPARATION MACHINE ROOM BINDERY LITHO PRODUCTION COST |
999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 |
Sum of above |

WORKING CAPITAL 99.99% ENERGY COST 99.99% SUBTOTAL 1 SALES COMM 99.99% SALES DISCOUNT 99.99% AGENCY COMM. 99.99% SPECIAL COMM. 99.99% EXCISE DUTY 99.99% SUBTOTAL 2 MARK UP 99.99% SELLING VALUE V.A.T. 99.99% SELLING VALUE (plus VAT) UNIT PRICE (plus VAT) |
999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 999,999,999,999.99 |
% of production cost % of production cost production cost+energy+working capital % of selling value % of selling value % of selling value % of selling value % of subtotal 1 sum of 5 values above % of (subtotal 1+2) Subtotal 1+2+mark up % of selling value selling value + vat (selling value + vat)/quantity |

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:

From | To |

TOTAL COST | PRODUCTION COST |

STD ADDITION | MARK UP |

TOTAL | SELLING VALUE |

TOTAL | SELLING VALUE (plus VAT) |

PER COPY | UNIT PRICE (plus VAT) |

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

- Summary estimate working sheet
- Revised summary estimate working sheet
- Supplementary sheet
- Cost sheet (estimate cost summary)
- Quotation (3 reports/formats)
- Quotation schedule
- Work-back estimate
- Cumulative estimate summary
- Estimate chart
- Cost analysis
- Flexible estimate spreadsheet
- 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:

*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.*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.- 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. - The
**File > Open > Working Capital**menu item is enabled. - 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.)