requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.
Current environment
Deliveries
1. The company receives daily truckloads of products from their vendors, warehouses the products briefly, and then ships orders based on a weekly delivery cycle to each customer's store.
2. Customers have regular standing orders that are revised and finished one week prior to delivery.
3. Best for You Organics has a fleet of trucks that make deliveries according to planned routes.
4. The company also has a floating route for trucks to deliver rush orders. The route is being used more often by customers and has overwhelmed the warehouse with exception processing.
Duties
The company wants to provide greater separation of duties between activities in the office and activities in the warehouse.
The accounting team enters orders for the sales team, sends pick tickers back to the warehouse, and organizes shipping documents. The accounting team invoices the orders when they receive instructions from the warehouse that an order shipped.
Employees have expressed frustration because they need to work longer hours to accommodate the increase in sales.
The company does not use the Advanced Warehousing function.
Requirements
Salespeople
1. Salespeople must be able to manage opportunities that are converted to quotes.
2. Salespeople must be able to release orders to the warehouse to be fulfilled once a quote is final.
3. Salespeople must be trained on how to determine if inventory is available when they are completing the quote to avoid promising inventory that is not on hand because all orders are processed one week in advance of delivery.
Team responsibilities
Deliveries must be shipped daily by employees in the warehouse. The office must be responsible for completing the invoicing process.
The current team responsibilities are shown in the following graphic:
The required team responsibilities are shown in the following graphic:
Vendor management
1. The company contracts with each vendor for regular discounts at the invoice level.
2. The company requires a pre-set discount percentage to calculate automatically when the purchaser completes a purchase order.
3. The company must be able to see a copy of the completed purchase order in the system when they have new contract negotiations with their vendors.
Customer and inventory management
1. Sales invoices must be automatically emailed by the system to customers.
2. A template must be used for emails sent to customers. The template must not be altered.
3. Customers who pre-pay their invoices must not receive a copy of their invoices.
4. The company warehouses all products as Case quantities. The company has difficulty recording accurate costs for product returns. The company wants to expand their capabilities for managing returns by setting up all inventory in a quantity of Each.
Reporting
The company must be able to answer two key questions when they report financial results:
1. Which customers are buying which items?
2.
Which salespeople are selling in which regions?
When discussing customers, the company must refer to each Customer Group as follows:
1. Big Box
2. Franchise
3. Private
When discussing items, the company must refer to each Item Group as follows:
1. Fair Trade
2. Free Range
3. Grass Fed
4. Heirloom
5. Organic
Salesperson names that must be used are:
1. SalespersonA
2. SalespersonB
3. SalespersonC
4. SalespersonD
Region names that must be used are:
1. North
2. South
3. East
4. West
Commission
1. The company must be able to track salesperson performance within certain regions to calculate commission.
2. Each salesperson must be assigned only to a single region.
3. This commission data is currently recorded inconsistently, resulting in incorrect combinations that require manual correction. The company must have some level of automation to manage this.
Issues
Issue 1
The accounting team needs an improved process for reconciling inventory to the general ledger.
1. Posted transactions are changing financial reporting in periods that have been closed.
2. Unexpected changes in inventory cost for previous months are causing costing inaccuracies.
3. The system must restrict the adjustment of costs for closed months.
4. The new policy will be to restrict all users to posting in the current month only, with the exception of a few employees from the accounting team.
5. The calendar fiscal year for company must begin on June 1.
Issue 2
The accounting team uses a complex manual accrual process to determine the accounting impact of items received but not invoiced. The system must streamline the item accrual process.
Issue 3
The company often receives a higher quantity of produce items than what they order because vendors allow for spoilage or damage of produce in transit. The company does not want to allow over receipt on non-produce items.
Issue 4
The company has received comments from their auditors that invoices are not being properly compared to received inventory documents before they are posted. The company does not use warehouse management and always handles processes directly from the purchase order. The company always has the following documents:
1. purchase order from the procurement department
2. receiving document from the warehouse
3. electronic invoice from the vendor
