In Vista, the closing balance for one week is always equal to the opening balance for the next week.
When using standard costing, it is possible for the closing value of stock not to match the opening value the following week in reports.
For example: The item Mars Bar is configured with a standard cost price of $1.00 (in Bulk Items), and is recorded with the unit of measure Each. 10 units are sold during the week, then the cost price is increased, and 1 more unit is sold.
| Week 1 | Qty | Std Cost | Cost Value | Total Sales Cost |
|
Opening Balance |
100 |
$1.00 |
$100.00 |
- |
|
Sell 10 |
90 |
$1.00 |
$90.00 |
$10.00 |
|
Cost change |
90 |
$1.50 |
$135.00 |
- |
|
Sell 1 |
89 |
$1.50 |
$133.50 |
$11.50 |
|
Closing Balance |
89 |
$1.50 |
$133.50 |
$11.50 |
However, reports calculate the closing balance based on the opening balance plus/minus movement for the week. The opening cost value was $100.00, with a total sales cost of $11.50, so reports calculate the closing cost value as $88.50, which is different to the system value calculated in the stocktake. Stocktake at the end of week 1 shows the closing balance 89 units (11 sold, none lost) and a cost value of $133.50 (89 @ $1.50). The cost value of Mars Bars increase even though 11 units were sold.
When reports are run for week 1, the opening balance will use the actual system cost value of $133.50, which is different to the reported closing balance cost value of $88.50 for week 1.
| System Cost | Reported Cost | |
| Opening Balance |
$100.00 |
$100.00 |
| Closing Balance |
$133.50 |
$88.50 |
| Opening Balance |
$133.50 |
$133.50 |
This is an issue with standard costing that weighted average costing seeks to avoid.
Comments
0 comments
Please sign in to leave a comment.