the first file consists of the questions I need to get answered. I want to know if you guys can help.The rest of the files are the information needed to answer those questions.
Term Project Description and Reuirements Background Mr. Z (real name Josh Zubkoff) runs a successful chain of cheese (and wine) shops in Oregon that specialize in Oregon artisan cheeses. He also sells his cheeses over the internet. He is considering expanding his business, but he thinks his current accounting and financial systems are restricting his ability to expand. He has come to you for assistance. Instructions Your supervisor met with Mr. Z and discussed his requirements in detail. At that meeting, they agreed on the following deliverables for your project. 1. Document process activity using BPMN. After gaining an understanding of Z’s business processes, you will document current processes using business process modeling notation (BPMN). This involves documenting at least five current business processes (Retail Sales, Wholesales, Internet Sales, Payroll, Inventory Purchases). These diagrams will serve multiple purposes. Mr. Z expects to use them to train new employees. Plus, they will provide information about potential improvements to those processes by the efficient use of information technology. Additionally, they will also highlight areas where Mr. Z is exposed to unnecessary risks in his business. Due April 10, 2019. 2. Prepare an integrated data model using UML class diagrams and the REA framework. This data model will serve as the blueprint for Z’s prototype database that you will also develop. Due April 17, 2019 3. Prepare an Access relational database for Mr. Z. He has agreed to provide financial data from his business for the 1st quarter of his fiscal year. That data will be in EXCEL format. You will move the data into Access, structure it appropriately, and set relationships consistent with your data model. Due April 24, 2019 4. Prepare financial reports using your database. You will prepare queries as necessary to provide the following reports and management information. a. Z Cheddr income statement for the 1st quarter. Remember that Z uses accrual accounting. b. Z Cheddr balance sheet as of the end of the 1st quarter. c. Income statements for each Z Cheddr store for the 1st quarter. d. Analysis of product sales and profitability for the 1st quarter. Determine product turnover and profitability for each inventory item. Due May 1, 2019. Chedd r Z Chedd’r Project Overview The following interviews were conducted prior to the start of the project to explore specific aspects of Z Cheddr business processes. The interviews with employees provide information that is representative of activities performed by all employees with the same titles. For example, the interview with Gordon, manager of the Bend store, provides information about the activities that all store managers perform. It is not suggested that these interviews provide complete information about all of Z Cheddr business processes. They are meant to provide an initial overview of the business. Summary of Interview with Mr. Z Western Oregon’s mild climate and abundant rainfall contribute to the state’s allure for dairy farmers. Mr. Z routinely said, “We have more green grass longer than any state in the country.” What’s more, land prices and living costs are relatively low in Oregon, luring a number of cheesemakers from neighboring California. Many new cheesemakers are also attracted by the cross-marketing potential of locating in Oregon wine country. Those were some of the reasons that he started Z Cheddr just over 10 years ago. His business quickly grew from one store to 10 stores plus an internet presence. Recently, he also started selling some cheeses on a wholesale basis to small groceries and other cheese and wine shops on the west coast. Mr. Z is the sole owner of Z Cheddr and operates his business as a limited liability corporation. He has a small board of directors, including his daughter and her husband, but they are seldom involved in any real business decisions. Mr. Z is a good businessman and knows a lot about selling wine and cheese. Unfortunately, Z’s accounting knowledge is marginal. His systems did not keep up with the growth of his business. He currently relies heavily on manual processes, and his data is spread among several different systems and EXCEL spreadsheets. He plans to expand his business to other west coast states to take advantage of the rapid growth in artisan cheese, wine, and beer makers. So, in addition to providing financial information about his current performance, he wants advice on the risks his business faces and cloud-based accounting system where each store submits transactions daily via the internet. He also sells cheeses and cheese and wine gift baskets over the internet. His website looks good, but the backend processes require heavy manual intervention. After a customer places an order and pays by credit card, his employees must print the orders and move to another system to update inventory, prepare shipping documents, and record the sales. He knows that this can be streamlined, so he also wants an overall evaluation of how he can use information technology to streamline his online process. Of course, he also wants to know how those changes would affect his internal control system. Summary of interview with Gordon Lightfoot, manager of the Bend store Gordon has been the manager of the Bend, Oregon store since it opened in 2005. He has made a number of friends among the regular customers that visit the store. Gordon is known in the area for his knowledge of cheeses and especially his knowledge of which wines to pair with which cheeses. Each morning, Gordon opens the store, checking to make sure that the display cases are at the right temperature, the cash drawers are ready, and the signs are set up to display the daily specials. Then, Gordon or his clerks spend the day selling wine and cheese. A few times a week, Gordon hosts cheese and wine tasting promotions for his customers. These tastings have been very successful. Customers come from all over town to attend, and most leave purchasing both the cheese and wine that they tasted. To determine which wine and cheese to promote, Gordon checks his inventory to be sure that he has plenty on hand so that customers will be able to buy the product after the promotion. Using the Z Cheddr Promotions form, he carefully records the amount of cheese and wine pulled from inventory for the promotion. After the promotion, he files the promotion form until he can send it to Chad, the Z Cheddr accountant, with the van driver. At the end of the day, Gordon closes out the cash registers and collects the various cash drawers. He does a final check of the display cases, making sure that all cheeses are appropriately refrigerated overnight. He puts the drawers and the cash register tapes in the safe for the bookkeeper. Summary of interview with Joan Baez, bookkeeper for the Bend store Joan is the part time bookkeeper for the store. The job is perfect for her, because she just comes in after the store closes, prepares the deposit information, and records the daily transactions in a spreadsheet. She emails the spreadsheet to Chad, the Z Cheddr accountant. She also prepares the cash drawers for the next morning and takes the daily receipts to the bank for deposit. All this usually takes two or three hours. She files the deposit slips until she can send them to Chad with the van driver. Summary of interview with Bob Dylan, cheese and wine buyer Bob recently graduated from Oregon State University, where he worked with other food science students at the O.S Creamery. They learned about cheese making by making and selling cheese, especially their famous Beaver Classic cheese. He uses his knowledge of artisan cheese making and his connections with other cheese makers to select the best cheeses to sell at Z Cheddr . Bob negotiated contracts with each of the cheese, so all he does is call them to place an order. Each day, Bob reviews the Z Cheddr inventory records to determine what to order. He also considers recent sales trends and potential seasonal demand for particular products. Often, he will check the physical warehouse inventory and call the stores to verify inventory levels, since he is not completely confident in the electronic records. He then calls the suppliers to place the orders. The suppliers deliver their products to the Z Cheddr central warehouse in Eugene Oregon. Occasionally, Bob will arrange for a van to pick up the order if it looks like shipment might be delayed. After the products are received and accepted by Judy in shipping and receiving, Bob authorizes the payment and sends a copy of the supplier’s invoice to Chad. Chad pays each cheese maker at the end of the month for purchases during the month. Sometimes, Chad combines payments if there is more than one shipment from the same cheese maker during the month. Recently, Bob has also assumed the duties of wine buyer. The wine buying process is identical to the cheese buying process. It requires a good relationship with the suppliers and knowledge of the products offered by each supplier. Bob has a good rapport with his suppliers, but he makes them compete for our business. This helps keep costs down and allows Z Cheddr to provide high quality wines for reasonable prices to our customers. Summary of interview with Chad Mitchell, accountant Chad has been with Josh (Mr. Z) since the beginning. He used to work in the Bend store while he finished school, but when Mr. Z needed someone to do the accounting, Chad volunteered. Chad’s job is to pay the bills, update the inventory records, put together the financial records, make sure Z Cheddr pays its taxes on time, and keep Mr. Z informed about company performance. Chad gets the sales and promotions information from the stores via the van drivers. He gets transfers, wholesale and internet sales information from shipping and receiving. That way, he can maintain up to date inventory counts and record sales daily. Z Cheddr conducts physical inventory counts each quarter, and Chad uses those counts to update or correct the electronic inventory records. Chad uses average inventory cost (average cost in the inventory worksheet) to value transfers, promotions, and ending inventory. The beginning inventory is valued at the average cost for the previous quarter (beginning cost in the inventory worksheet). Chad also pays all the bills. His clerk assembles the invoices and recurring payment information for both inventory purchases and administrative purchases and prepares the checks. The administrative purchases include recurring payments for rent of Z Cheddr retail stores, all of which are rented through one broker, Oregon Commercial Real Estate. Then Chad reviews the support material, corrects any errors, and signs the checks