8 REA Model-Adirondacks Classic Furniture dirondacks Classic Furniture (ACF) manufactures a range of rustic chairs, lawn furniture, and terior furnishing including lamps, desks, and bedframes. ACF's customer base comprises both rivate consumers and retail outlets. Consumer's sales are for cash or by credit card, but business ustomers are extended a line of credit. New business customers undergo a credit check before eceiving a credit line. All sales are made online, by fax or mailed in hard-copy order. Vhen a credit order is received, the sales clerk verifies inventory availability, prepares a sales order, nd sends the stock release copy to the warehouse clerk who picks the goods and arranges hipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing epartment and inventory control. The billing department updates the sales journal and sends an voice to the customer. The clerk then sends the shipping notice to the AR department, where the R clerk updates the AR subsidiary ledger. ustomers submit checks and remittance advices to the mail room. A clerk sends the remittance dvices to the AR department and the checks to the cash receipts department. At the end of the day, he cash receipts clerk prepares a deposit slip and deposits the checks into the company's bank ccount, files the bank receipt, and updates the cash receipts journal. he physical aspects of cash sales transactions are handled similar to the process described here xcept that checks or credit card account numbers are submitted with the original order. Required a. Prepare the REA model to support the sales/collection process. b. Show the cardinalities for all associations. c. List the tables, keys, and attributes needed to implement this model in a relational database.

Larry's Landscaping Services has extended Net 30 terms to his new customer, Mahoney's Mugs. What sales workflow would you recommend Larry use for Mahoney's?  -Create Invoice > Receive Payment > Check Register -Create Sales Receipt > Bank Deposit -Create Invoice > Receive Payment > Bank Deposit -Create Sales Receipt > Receive Payment > Bank Deposit

GREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING SYSTEM) Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPNSs customers are primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit. GPNSs current information system includes manual procedures supported by independent (non-networked) PCs in each department Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPNSs procedures and internal controls. The following is a description of GPNSs expenditure cycle. Purchasing Process The purchasing agent receives an inventory status report from the inventory control department, which identifies the items that need to be reordered. The agent selects the suppliers, enters this information into the computer terminal to create a digital purchase order, and then prints three hard copies of the purchase order. He sends one copy to the supplier; one copy to the AP department, where it is filed temporarily, and files the third copy in the purchasing department. When the goods are received, the receiving department inspects and verifies them using the packing slip, which is attached to the goods. The receiving clerk manually prepares two hard copies of a receiving report. One copy accompanies the goods to the warehouse for storage. The receiving clerk sends the second copy to the purchasing agent who closes the open purchase order. The purchase agent then forwards the receiving report to the inventory control clerk. The inventory control clerk receives the receiving report and updates the inventory subsidiary. At the close of business, the clerk prepares an inventory summary, which he sends to the general ledger clerk. Accounts Payable and Cash Disbursements Procedures The AP clerk receives the suppliers invoice and reconciles it with the purchase order in the temporary file. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger. The purchases order and invoice are then filed in the department. Each day, the AP clerk visually searches the AP subsidiary ledger from her terminal for invoices that are due to be paid. The clerk prepares the check and records it in the digital check register. The negotiable portion of the check is mailed to the vendor, and a check copy is filed. The clerk then closes the liability in the AP subsidiary ledger and prepares a journal voucher, which she sends to the general ledger clerk. Upon receipt of the inventory summary and journal voucher, the general ledger clerk updates the inventory control, AP control, and cash accounts. Required a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the physical internal control weaknesses in the system. d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.

2. GREEN POND NURSERY (STAND-ALONE PC-BASED ACCOUNTING SYSTEM)Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPNS’s customersare primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit.GPNS’s current information system includes manual procedures supported by independent (nonnetworked) PCs in each department. Communications between departments is entirely through hard-copy documents. Recently, GPNS has been receiving complaints from customers andsuppliers about billing, shipping, and payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPNS’s procedures and internal controls. The following is a description of GPNS’s revenue cycle. Sales…

(Warranty, Customer Loyalty Program) Hale Hardware takes pride as the “shop around the corner” that can compete with the big-box home improvement stores by providing good service from knowledgeable sales associates (many of whom are retired local handymen). Hale has developed the following two revenue arrangements to enhance its relationships with customers and increase its bottom line.1. Hale sells a specialty portable winch that is popular with many of the local customers for use at their lake homes (putting docks in and out, launching boats, etc.). The Hale winch is a standard manufacture winch that Hale modifies so the winch can be used for a variety of tasks. Hale sold 70 of these winches during 2017 at a total price of $21,000, with a warranty guarantee that the product was free of any defects. The cost of winches sold is $16,000. The assurance warranties extend for a 3-year period with an estimated cost of $2,100. In addition, Hale sold extended warranties related to 20 Hale…

(Warranty, Customer Loyalty Program) Hale Hardware takes pride as the “shop around the corner” that can compete with the big-box home improvement stores by providing good service from knowledgeable sales associates (many of whom are retired local handymen). Hale has developed the following two revenue arrangements to enhance its relationships with customers and increase its bottom line.1. Hale sells a specialty portable winch that is popular with many of the local customers for use at their lake homes (putting docks in and out, launching boats, etc.). The Hale winch is a standard manufacture winch that Hale modifies so the winch can be used for a variety of tasks. Hale sold 70 of these winches during 2019 at a total price of $21,000, with a warranty guarantee that the product was free of any defects. The cost of winches sold is $16,000. The assurance warranties extend for a 3-year period with an estimated cost of $2,100. In addition, Hale sold extended warranties related to 20 Hale…

Runway Discount (“Runway” or the “Company”) is a privately held online retailer that sells discounted high-end fashion. In an effort to increase its sales and customer base, Runway implemented a customer referral marketing campaign (the “Refer-a-Friend Program”) whereby existing customers can refer friends to Runway and receive a $25 credit towards the purchase of future merchandise. The terms of the program are as follows:  Runway offers existing customers (the “Existing Customer”) a $25 credit (the “$25 Referral Credit”) if the Existing Customer refers a friend (the “New Customer”) to Runway’s Web site and the New Customer purchases merchandise from Runway. After a purchase is made by the New Customer, the Existing Customer receives a$25 credit to be applied to a future purchase from Runway.  The $25 Referral Credit represents the fair value of the cost Runway would pay to acquire a new customer from an unrelated third party or marketing firm who is not a purchaser of its products.…

Runway Discount ("Runway" or the "Company") is a privately held online retailer that sells discounted high-end fashion. In an effort to increase its sales and customer base, Runway implemented a customer referral marketing campaign (the "Refer-a-Friend Program") whereby existing customers can refer friends to Runway and receive a $25 credit towards the purchase of future merchandise. The terms of the program are as follows:  Runway offers existing customers (the "Existing Customer") a $25 credit (the "$25 Referral Credit") if the Existing Customer refers a friend (the "New Customer") to Runway's Web site and the New Customer purchases merchandise from Runway. After a purchase is made by the New Customer, the Existing Customer receives a$25 credit to be applied to a future purchase from Runway.  The $25 Referral Credit represents the fair value of the cost Runway would pay to acquire a new customer from an unrelated third party or marketing firm who is not a purchaser of its products.…

SMITH’SMARKET (SMALL BUSINESS POS ACCOUNTING SYSTEM) In 1989, Robert Smith opened a small fruit and vegetable market in Bethlehem, Pennsylvania. Originally Smith sold only produce grown on his family farm and orchard. As the market’s popularity grew, however, he added bread, canned goods, fresh meats, and a limited supply of frozen goods. Today Smith’s market is a full range farmers’ market with a strong local customer base. Indeed, the market’s reputation for low prices and high quality draws customers from other Pennsylvania cities and even from the neighboring state of New Jersey. Currently Smith’s market has 40 employees. These include sales staff, shelf stockers, farm laborers, shift supervisors, and clerical staff. Recently Smith has noticed a decline in profits and sales, while his purchases of products for resale have continued to rise. Although the company does not prepare audited financial statements, Robert Smith has commissioned your public accounting firm to assess his…

SMITH’S MARKET (SMALL BUSINESS ACCOUNTING SYSTEM)In 1989, Robert Smith opened a small fruit and vegetable market in Bethlehem,Pennsylvania. Originally, Smith sold only produce grown on his family farm andorchard. As the market’s popularity grew, however, he added bread, canned goods,fresh meats, and a limited supply of frozen goods. Today Smith’s Market is a full-rangefarmers’ market with a strong local customer base. Indeed, the market’s reputation forlow prices and high quality draws customers from other Pennsylvania cities and evenfrom the neighboring state of New Jersey. Currently Smith’s has 40 employees. Theseinclude sales staff, shelf Stockers, farm laborers, shift supervisors, and clerical staff.Recently, Smith has noticed a decline in profits and sales, while his purchases ofproducts for resale have continued to rise. Although the company does not prepareaudited financial statements, Robert Smith has commissioned your public accountingfirm to assess his company’s sales…