Topic 1, Munson's Pickles and Preserves Farm
Current environment. General
Munson's uses a mix of internally-developed legacy systems that handle their finance and distribution activities. The company has an isolated CRM system.
Both Canadian subsidiaries have two departments: marketing and operations.
Financial reporting is difficult due to data residing in disparate systems.
Financial reporting is currently performed by using Microsoft Excel.
Pre-orders in the current system are difficult to track because the order management system is not integrated with the finance system.
Pickle sales post to one revenue account, but this does not allow for targeted reporting by pickle cut and type.
Current environment
Organization
The following chart shows Accounting/Reporting Currencies and Tax ID, if applicable.
Typically, vendor invoices are received prior to receipt of product.
The following fixed assets are sold for a loss:
BUILD-100
CAR-1233
At the regional distribution centers, the value for physical inventory does not match the inventory in the financial system.
Munson's rents their corporate office. Rent is not paid by purchase order. Rent is due once a quarter.
Allocations are performed manually.
Barrels are inventoried by site and warehouse.
Munson's has multiple depreciation and tax books for all of their fixed asset equipment.
Budgets are posted at the department level for each legal entity.
Requirements. Sales
Customers should be able to pre-order for fall release of pickles.
Three-way matching must be enforced for all purchases.
Fixed asset sale transactions require a ledger account entered at the time of transaction.
Fixed assets purchased must be automatically created in fixed asset module. This includes inventory items and write in purchase orders/non-inventoried items.
One dollar from every sale needs must be tracked and donated at the end of each month to a charitable organization.
Purchasing budgets must be enforced at the main account level.
Requirements. Finance
Accounts payable must be able to enter vendor invoices on the day they were received to be settled against when product is received.
Accounts payable must be able to enter vendor invoices to accrue expense without specifying a purchase order at the time of entry.
Postage expenses must be split evenly across the regional distribution centers automatically.
Administrative expenses must be distributed across the regional distribution centers by percentage of fulfillment orders monthly.
Pickling machines depreciation must be uniquely recorded for visibility but not post to the ledger.
Issues
During implementation testing, User1 indicates that after packing slips are generated for purchase orders, there are no ledger postings.
User2 indicates that fixed assets purchased on a purchase order do not show up in the Fixed Assets module.
User3 reports that they are seeing inconsistent application of the one-dollar donation from all sales orders.
User4 in the Canadian subsidiary is able to purchase supplies for marketing despite exceeding the marketing department budget.
User5 reports that when purchasing a non-inventoried computer, the system is automatically assigning it to the buildings fixed asset group.