Required information Skip to question The following information applies to the questions displayed below 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 Document process activity using BPMN After gaining an understanding of Zs business processes, you will document current processes using business process modeling notation (BPMN) This involves documenting at least five current business processes 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 Prepare an integrated data model using UML class diagrams and the REA framework This data model will serve as the blueprint for Zs prototype database that you will also develop Prepare a prototype database for Mr Z He has agreed to provide financial data from his business for the 1 st 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 Prepare financial reports using your database You will prepare queries as necessary to provide the following reports and management information Z Cheddr income statement for the 1 st quarter Remember that Z uses accrual accounting Z Cheddr balance sheet as of the end of the 1 st quarter Income statements for each Z Cheddr store for the 1 st quarter Analysis of product sales and profitability for the 1 st quarter Determine product turnover and profitability for each inventory item Evaluate the financial performance of Z Cheddr for the 1 st quarter Use your Access queries but also prepare formal financial statements and appropriate ratios to evaluate performance against the industry and past performance Assess the business case for use of information technology in Zs business Mr Z wants to move to a cloud based accounting system, such as Netsuite He wants to upload transactions daily from new smart cash registers in each store Project Resources You will need to make use of the following files as you work through the project Summary of Z Cheddr interviews Additional interview to outline the financial reporting process Excel spreadsheet of Z Cheddr's current data Additional Excel spreadsheet of Z Cheddr's historical data Additionally, the following files have been provided for assistance Instructions on how to move data from Excel to Access List of modeling software List of project management software Requirements Complete the Z Cheddr project using the instructions and resources listed above For your Connect assignment, Sections 1 and 2 should be attempted after you have completed Project Deliverable 2 listed above Section 3 should be attempted after you have completed Project Deliverable 3 rev 06 15 2020 QC CS 216185 Section 3, Question 1 Move the Excel data to Microsoft Access and prepare queries to answer the following questions Round answers in dollars to two decimal places Differences in rounding may produce slightly different totals, so select the closest answer when your exact answer is not shown When you summarize information by store, be sure to include all stores and convert and blanks (NULL values) to zeroes It is recommended that you create queries and save them as you go, since later queries will build on some of the earlier queries Required Use the Sales and Sales Items tables Join the Sales table with the Sales Items (linking table between Sales and Inventory) table Include order , sale date, customer , sale type, cash receipt , store , ship rate per order, invent , quantity sold, sale price, and item amount in the query Limit sales to the first quarter of 2022 beginning on January 1 and ending on March 31 How many records are there in your query

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 22, 2024

Required information Skip to question [The following information applies to the questions displayed below.] Background Mr. Z (real name Josh Zubkoff) runs a successful chain

Required information

Skip to question

[The following information applies to the questions displayed below.]

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.

Document process activity using BPMN. After gaining an understanding of Zs business processes, you will document current processes using business process modeling notation (BPMN). This involves documenting at least five current business processes. 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.
Prepare an integrated data model using UML class diagrams and the REA framework. This data model will serve as the blueprint for Zs prototype database that you will also develop.
Prepare a prototype database for Mr. Z. He has agreed to provide financial data from his business for the 1^st 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.
Prepare financial reports using your database. You will prepare queries as necessary to provide the following reports and management information:
1. Z Cheddr income statement for the 1^st quarter. Remember that Z uses accrual accounting.
2. Z Cheddr balance sheet as of the end of the 1^st quarter.
3. Income statements for each Z Cheddr store for the 1^st quarter.
4. Analysis of product sales and profitability for the 1^st quarter. Determine product turnover and profitability for each inventory item.
Evaluate the financial performance of Z Cheddr for the 1^st quarter. Use your Access queries but also prepare formal financial statements and appropriate ratios to evaluate performance against the industry and past performance.
Assess the business case for use of information technology in Zs business. Mr. Z wants to move to a cloud-based accounting system, such as Netsuite. He wants to upload transactions daily from new smart cash registers in each store.

Project Resources

You will need to make use of the following files as you work through the project:

Summary of Z Cheddr interviews
Additional interview to outline the financial reporting process
Excel spreadsheet of Z Cheddr's current data
Additional Excel spreadsheet of Z Cheddr's historical data

Additionally, the following files have been provided for assistance:

Instructions on how to move data from Excel to Access
List of modeling software
List of project management software

Requirements

Complete the Z Cheddr project using the instructions and resources listed above. For your Connect assignment, Sections 1 and 2 should be attempted after you have completed Project Deliverable 2 listed above. Section 3 should be attempted after you have completed Project Deliverable 3.

rev: 06_15_2020_QC_CS-216185

Section 3, Question 1

Move the Excel data to Microsoft Access and prepare queries to answer the following questions. Round answers in dollars to two decimal places. Differences in rounding may produce slightly different totals, so select the closest answer when your exact answer is not shown. When you summarize information by store, be sure to include all stores and convert and blanks (NULL values) to zeroes. It is recommended that you create queries and save them as you go, since later queries will build on some of the earlier queries.

Required:

Use the Sales and Sales Items tables. Join the Sales table with the Sales Items (linking table between Sales and Inventory) table. Include order#, sale date, customer#, sale type, cash receipt#, store#, ship rate per order, invent#, quantity sold, sale price, and item amount in the query. Limit sales to the first quarter of 2022 beginning on January 1 and ending on March 31. How many records are there in your query?