|
Do You Want To Know:
- What sales volume is required to break even?
- What sales volume is necessary in order to earn a desired (target) profit?
- What profit can be expected on a given sales volume?
- How would changes in selling price, variable costs, fixed costs, and output affect profits?
- How would a change in the mix of products sold affect the break-even and target volume and profit potential?
Included Templates
A collection of pre-built views included with this view pack to answer common reporting
questions.
-
Famous Profit Analysis Report
-
Summary view that simulates the Famous profit analysis report.
-
Weekly Product Profitability
-
Summary view of product gross profit and gross profit percentage by week.
Technical Details
|
|
Name
|
Type
|
|
AP Charges
|
Measures
|
|
AR Charges
|
Measures
|
|
Block
|
Dimensions
|
|
Block Id
|
Dimensions
|
|
Broker
|
Dimensions
|
|
Carrier
|
Dimensions
|
|
Color
|
Dimensions
|
|
Commodity
|
Dimensions
|
|
Cost
|
Measures
|
|
Currency
|
Dimensions
|
|
Customer
|
Dimensions
|
|
Customer Class
|
Dimensions
|
|
Customer Group
|
Dimensions
|
|
Customer Group2
|
Dimensions
|
|
Customer Group3
|
Dimensions
|
|
Customer PO#
|
Dimensions
|
|
Delivery Date
|
Dates
|
|
Destination Group
|
Dimensions
|
|
Entry User
|
Dimensions
|
|
Equiv Qty
|
Measures
|
|
Fill Type
|
Dimensions
|
|
FOB Price
|
Measures
|
|
Grade
|
Dimensions
|
|
Grower Charges
|
Dimensions
|
|
Grower/Vendor Id
|
Dimensions
|
|
Grower/Vendor Name
|
Dimensions
|
|
Invoice Date
|
Dates
|
|
Label
|
Dimensions
|
|
Load Id
|
Dimensions
|
|
Lot Id
|
Dimensions
|
|
Lot Name
|
Dimensions
|
|
Method
|
Dimensions
|
|
Order Date
|
Dates
|
|
OrderId
|
Dimensions
|
|
Other Charges
|
Measures
|
|
Pay Terms
|
Dimensions
|
|
PO #
|
Dimensions
|
|
Product
|
Dimensions
|
|
Product Description
|
Dimensions
|
|
Product Id
|
Dimensions
|
|
Profit
|
Measures
|
|
Purchasing Agent
|
Dimensions
|
|
Qty
|
Measures
|
|
Receipt Description
|
Dimensions
|
|
Receive Date
|
Dates
|
|
Region
|
Dimensions
|
|
Sale Price
|
Measures
|
|
Sale Terms
|
Dimensions
|
|
Sales Equiv Qty
|
Measures
|
|
Sales Person
|
Dimensions
|
|
Sales Qty
|
Measures
|
|
Ship Date
|
Dates
|
|
Ship Location
|
Dimensions
|
|
Ship To City
|
Dimensions
|
|
Ship To Country
|
Dimensions
|
|
Ship To State
|
Dimensions
|
|
Ship To Zip Code
|
Dimensions
|
|
Shipper
|
Dimensions
|
|
Size
|
Dimensions
|
|
Size Equiv
|
Dimensions
|
|
Status
|
Dimensions
|
|
Storage
|
Dimensions
|
|
Style
|
Dimensions
|
|
Units Per Pallet
|
Measures
|
|
UOM
|
Dimensions
|
|
Variety
|
Dimensions
|
|
Variety Group
|
Dimensions
|
|
Vendor Class
|
Dimensions
|
|
Warehouse
|
Dimensions
|
|
Weight Factor
|
Measures
|
|
Weight UOM
|
Dimensions
|
Version 1.0.34
Updated:
08/26/2010
|
New Fields- PO Delivered Amount
- PO Received Amount
|
Version 1.0.33
Updated:
07/13/2010
|
What's Changed:- Fixed a bug that would eliminate certain future orders. This was introduced in the last performance increase release and is now fixed.
|
Version 1.0.32
Updated:
05/04/2010
|
What's Changed:- Added Imported as a potential selection in the Status field.
|
Version 1.0.31
Updated:
02/10/2010
|
New Fields:- Product Id
- Product Description
|
Version 1.0.30
Updated:
11/13/2009
|
New Fields:
|
Version 1.0.29
Updated:
10/27/2009
|
New Fields:
|
Version 1.0.28
Updated:
08/21/2009
|
What's Fixed:- Updated to handle the case where there are only deleted products on the invoice and charges. These were previously not getting picked up.
|
Version 1.0.27
Updated:
08/19/2009
|
What's Changed:- Updated one of the date formats to include the extended date picture that includes time.
|
Version 1.0.26
Updated:
07/31/2009
|
New Fields:
|
Version 1.0.25
Updated:
07/30/2009
|
What's Fixed:- Corrected an error that would not show invoice-wide charges when there was no product on the invoice.
|
Version 1.0.24
Updated:
07/28/2009
|
New Fields:- Gross Profit - this is calculated using the following equation (fob price + ar charges) - (cost + ap charges).
|
Version 1.0.23
Updated:
07/15/2009
|
What's Changed:- Adjusted the handling of the invoice-wide charges to display the amount when the quantity is zero.
|
Version 1.0.22
Updated:
06/18/2009
|
What's Changed:- Removed the "Standard Order" type from the Orders section.
|
Version 1.0.21
Updated:
03/24/2009
|
New Fields:- Packer Name
- Packer Id
- Size Equiv
|
Version 1.0.20
Updated:
01/21/2009
|
New Fields:
|
Version 1.0.19
Updated:
08/18/2008
|
What's Fixed:- Update for currency and double issue on the orders side when direct inventory is assigned.
|
Version 1.0.17
Updated:
03/27/2008
|
New Fields:
|
Version 1.0.16
Updated:
03/18/2008
|
New Fields:- AP Pay Terms - Accounts Payable pay terms from the Purchase Order Header.
- AP Sales Terms - Accounts Payable sales terms from the Purchase Order Header.
|
Version 1.0.15
Updated:
02/06/2008
|
New Fields:- History Date - This is the date in which the last significant change was made to the invoice.
What's Changed:- Currency Rate now takes the most current rate for the currency type before or on the Invoice Date. This will assure the most applicable rate for every invoice will be used. Previously, this was just the most current rate overall, not based on invoice date.
|
|
|