Kudler Fine Foods Database Project
Background and Business Application Proposal
Kudler Fine Foods is an upscale specialty food store, servicing the fine food conesouer from their three California locations. Kudler's business objective is to maximize profits by offering the highest quality products at competitive prices. Through adding the on-line ordering system, Kudler hopes to boost profits by increasing their customer base beyond customers in their local areas. The Kudler on-line ordering system will add three important advantages to Kudler customers. First, the on-line ordering system will allow current Kudler customers to access the system, place their order, and have it ready for pickup when they arrive at the store. The
…show more content…
? Additional Tables Needed
1. ?Reserved Inventory? table ? this table will be a transaction table that will ?reserve? the items by removing them from inventory and holding them in the reserved table until one of the following conditions is met:
a. The transaction has obtained credit approval. Once this condition is met, the ?reservation? entry is removed.
b. The items have been reserved for 30 minutes without activity, at that time the reservation entry is removed, and the items are placed back in general inventory.
2. ?Shipping Method? Table ? this table will indicate how the order will be delivered. Shipping charges will be calculated by multiplying the total purchase price by a shipping factor. Options for this table will include
a. In store purchase
b. Pickup
c. Local Delivery
d. FedEx
e. UPS
f. DHL
3. ?City State Zip? table ? This table will allow the customer to enter their Zip Code and the city and state will automatically populate in the online order form.
4. Emergency Contact information ? This information should be moved to its own table, making this information easier to maintain and update.
5. Building Information - Floor Space, Lease Owner, and Lease Rate should be in its own table.
6. Unit_of_Measure - Should be in its own table with an ID and a foreign key added to the Inventory table.
In addition to adding several tables to service the new
Determine the types of inventories these companies currently manage and describe their essential inventory characteristics.
3. Using the variable costing method, which of the following costs are assigned to inventory?
Question 4.4.(TCO 4) Which of the following is not included in the information about the inventory records file for an
The amount of each item purchased relies on many reasons such as the number of consumers for whom the item is intentional for, storage requirements and facilities available, purchasing power and ready cash, unit of sale, and price. Store operations must be adjusted to connect with the customer’s time of purchase pattern. Store buyers and merchandisers must keep on schedule with it.
Which of the following journal entries would a retailer make to record a purchase of inventory on account?
Appendix C is the quarterly inventory table I conduct in Daan, which is prepared by physically inspection and comparison with financial record. This task requires me have sufficient knowledge about the flow of inventory, in order to obtain the accurate number of goods.
management. It requires no buffer stocks are held, products arrives just they are needed on
It is with this food supplier that you can make your orders to get placement of your orders you look forward to.
Kudler Fine Foods has a very valuable inventory system at this time but there is always room for improvement. All recommendations were discussed in the paragraphs above. They have a very neat and concise inventory report on hand but adding the additional areas will give them the upper hand on tracking their inventory and also their budgets regarding their inventory. Using pivot tables and entity relationship diagrams will also be beneficial to KFF in order to categorize, organize, and track their inventory. In
Quantity – indicate on this field the number of quantities for adjustment for each affected inventory items on a per unit basis and not per selling or buying unit. If you are to adjust inventory to add to quantity, enter the number as positive number (without positive sign). In case of deduction in inventory quantity of item, enter the amount with a negative sign before the number.
A screen showing a list of pending orders (orders for which there is sufficient quantity in the warehouse of all selected products).
3) Total Issue quantity will include quantity of the item moved out of the Warehouse through Inter-
d. Each installment is treated as hire charges so that if default is made in payment of any installment, the seller becomes entitled to take away the goods, and