Posts Tagged ‘BIC Report Sage Cape Town’

h1

Working Capital Cashflow Model (Pastel Partner)

December 3, 2013

BIC  Cape Town Report PL

Solution Description

The Working Capital Cashflow Model reveals relevant cash related information relating to Working Capital components. It answers the question that business managers ask with high frequency: ‘how much money will there be in the bank account during and after the current working capital cycle’.

It does this by asking the business manager ‘how many days would you like to forecast cashflows for?’
The model then reveals the Accounts Receivable and Accounts Payable due over the prediction period.
It also predicts other cash outflows incl. Payroll, based on cash outflow activity from the previous month for the same period.

By having this predictive cash information real-time and in one place, you can now take corrective actions by collecting debts with precision,
renegotiate vendor terms and identify other cash outflows that may not be required this month or may not be required at all.

It’s the working capital cashflow model that you dreamed about but have never had the luxury of possessing….until now.

Download this solution here > >

Supported Versions

Microsoft® Excel® 2007+

Pastel v11+

Casflow Blog

h1

Price List Report (Pastel Partner)

October 28, 2013

BIC  Cape Town Report PL

Solution Description

The ‘Price List’ solution reveals the 10 Price Lists available in Sage Pastel, with a comparison to the current cost of each inventory item.

On one page it answers some important questions relating to expected profit on inventory items:
‘At a glance, do my price lists look accurate with regard to my current pricing strategy?’
‘Do my price lists exceed the value of the current item cost?’
‘Are any of the price lists redundant?’

Isolate individual Inventory Groups or Stores to apply these business questions to.

The model also calculates the percentage markup for each inventory item on ‘Price List 1’, affording you the opportunity to have exception reporting on inventory which are projected to have poor markups or unrealistic high markups.
Use basic pivot table skills to add your own calculated fields to this report for customized analysis. From here on out, embrace this tool to manage your price lists so that you manage your profits

Download this solution here > >

Supported Versions

Microsoft® Excel® 2007+

Pastel v11+

PriceList 3