Categories
accounting

Case Study Case

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients doctors procedures and appointments using the following business rules: Patients can have many doctors and many doctors can see many patients. Patients can have many procedures and many procedures are done on patients. Doctors can have multiple appointments. (hint: these are many to many relationships so associative tables need to be added). Requirements Please identify the attributes and primary keys needed for each of the entities. Identify the data types you would use for each of the attributes. Determine the relationships between the entities and find the one-to-many and many-to-many relationships. Create an ER diagram using Visio include the associative tables based on your analysis. Identify all foreign keys needed in the database design. Create the database and relationships in Access and populate the tables using the spreadsheets (unless your Professor wants you to type the data into the tables). Write a 1-3-page APA paper discussing the following topics: Discuss Database impact on the workplace Discuss database benefits when businesses use queries Forms and reports. Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security issues.

Categories
accounting

A report that will describe the Activity Based Costing (ABC) method in compariso

A report that will describe the Activity Based Costing (ABC) method in comparison with Absorption Method(Traditional) using a brewery business as a case study. Estimate the cost of producing two types of beer using applicable examples presented and justifying any judgements made and /or any limitations faced with the methodology used. Finally you should comment if you feel that your estimates can be used by management.

Categories
accounting

A pharmaceutical retail company possesses various stores and manages its current

A pharmaceutical retail company possesses various stores and manages its current sales procurement and materials availability at the stores through Excel sheets. The company executives are now finding this process of data maintenance tedious and would like to develop a complete data warehouse architecture to store historical data and to help making better business decisions. For this reason you are asked to design a star schema to help manage and record the company order operations with information related to the ordered medicines the suppliers the various stores information and when orders were made. Your star schema should be designed so that the following information can be obtained: ¢ What is the name and complete address (Street City Zip code) of the supplier associated with a specific medicine order? ¢ What is the complete address (Street City Zip code) of the store associated with an order made on a specific day month or year? ¢ Not all medicine can be taken by both kids and adult. Actually each medicine is designed for people within a specific age range recorded using a starting age and an ending age. We are interested in knowing the name of all medicine available for anyone within a specific age range. ¢ How many orders of a specific medicine were made by a specific store on specific day month or year? Each store is represented by its own store code. You can also consider the following information: ¢ The order cost should be recorded as facts. ¢ The data mart will contain 4 years worth of data ¢ The data mart will be used to manage 3 different stores. ¢ Each store carries no more than 300 different medicines at the same time ¢ The medicines can be supplied by 5 different suppliers Based on this information answer the following questions: a. Design a star schema for this problem. (10 pts) b. Estimate the number of rows in the fact table. (2 pts) c. Based on your star schema write the SQL code allowing you to answer the following questions: (8 pts 4 pts each) ¢ What is the name and complete address (Street City Zip code) of the supplier associated with a medicine named Tylenol and suited for anyone above 18 years old? ¢ For each city indicate the total amount of order cost of all medicines ordered by a store in this city in November 2020. Your query should display the list of cities where stores are located and the associated total order cost.

Categories
accounting

A project plan is based on research and organizational goals.¯To see¯an exemplar

A project plan is based on research and organizational goals.u202fTo seeu202fan exemplar project plan review the Project Plan Example. Use the Project Plan Template and the business needs identified in your Week 3 Balanced Scorecard to: Develop the project objectives. Explain what operational steps will be taken to achieve your stated objectives. Identify the responsible person(s) for eachu202foperational step. Outline a timeline for each operational step. Justify the choices you made in your project plan in a 525- to 700-word response on the Project Plan Template.

Categories
accounting

A project plan is based on research and organizational goals.¯To see¯an exemplar

A project plan is based on research and organizational goals.u202fTo seeu202fan exemplar project plan review the Project Plan Example. Use the Project Plan Template and the business needs identified in your Week 3 Balanced Scorecard to: Develop the project objectives. Explain what operational steps will be taken to achieve your stated objectives. Identify the responsible person(s) for eachu202foperational step. Outline a timeline for each operational step. Justify the choices you made in your project plan in a 525- to 700-word response on the Project Plan Template.

Categories
accounting

A large retail company wants to determine which investment project it should inv

A large retail company wants to determine which investment project it should invest in. Since you are the vice president of the company you have been asked to analyze these two projects and report back to the board of directors regarding which of these two projects the company should undertake. Project A has an initial investment cost of $42 000. This project is expected to produce $9 450 in net cash flows each year for 7 years. Project B has an initial investment cost of $36 750 with an expected net cash flow of $7 875 per year for 5 years. Both investments have a 10% cost of capital. What is each projects NPV? What is each projects IRR? What is the payback period for each project? Which investment project do you recommend for your company? Be sure to explain why you arrived at the decision that you did. ”PLEASE USE THE RESOURCES ” https://saylordotorg.github.io/text_managerial-accounting/s12-02-net-present-value.html ***** Key Point of Lesson 1 Net present value (NPV) is considered the ideal capital budget decision-making tool managers can use for making an investment decision on a project because it takes into consideration the time value of money and the maximizing of intrinsic value. This lesson also covers how to calculate NPV.***** https://saylordotorg.github.io/text_managerial-accounting/s12-03-the-internal-rate-of-return.html ***** Key Point of Lesson 2 The IRR is yet another common tool used by managers to assess an investment. The IRR is basically the rate of return that makes the NPV of all cash flows from a project equal zero. This lesson defines and explains IRR and how to calculate it.***** https://saylordotorg.github.io/text_managerial-accounting/s12-05-the-payback-method.html Key Point of Lesson 3

Categories
accounting

A list of foreign companies with shares traded on the New York Stock Exchange (N

A list of foreign companies with shares traded on the New York Stock Exchange (NYSE) can be found on the NYSEs website (www.nyse.com) Required: a. Identify a developing country in Asia Africa and Latin America and determine how many companies from each of those countries are listed on the NYSE. b. Describe the manner in which IFRS are used by the companies identified in item.

Categories
accounting

a good time to think about your math, accounting, and Excel skills. Excel is wid

a good time to think about your math accounting and Excel skills. Excel is widely considered a basic skill requirement for accounting and finance jobs. Discussion Requirements Take a moment to think about and then comment on each of the following questions: What has been your experience in this class using Excel to solve math problems? At this point how comfortable are you using Excel for business purposes? When do you still use your calculator? What do you think would help you improve your Excel skills if you need to? Please comment on using Excel in IFSM 201 and / or IFSM 300 if you completed either of these courses.

Categories
accounting

A Codification Exercise on the Reporting of Discontinued Operations Read the fol

A Codification Exercise on the Reporting of Discontinued Operations Read the following case study: McNellis C. J. (2018). Dynamic divestures: A codification exercise on the reporting of discontinued operations. Issues in Accounting Education 33(1) 53“63. Case Requirements: During the first week of 20X8 Dynamics corporate controller Anne Smith prepares to initiate the closing activities for 20X7. The closing process at Dynamic is very extensive as it includes routine activities for consolidating the activities ofseveral subsidiary companies for the creation of the consolidated financial statements. Furthermore Dynamics reporting personnel must also address the unique complications of each acquisition and divesture. As Ms. Smith awaits the final financial statement numbers prepared by the reporting personnel at each subsidiary she is anxious to determine the appropriate financial statement presentation of the three subsidiaries discussed above. Most specifically she is curious as to whether the financial performance of each of the three subsidiaries qualifies for reporting under discontinued operations. Ms. Smith has asked you to review the intricacies of ZD Consulting Hope Industries and AM Mining Operations to determine which type of reporting (i.e. continuing operations versus discontinued operations) is appropriate for each subsidiary on Dynamics consolidated income statement. To complete the case requirements you should perform the following tasks: Consider the facts presented for each company within the Consult the FASB Accounting Standards Codification for guidance on the specific income statement presentation issue to which the controller has requested Prepare a memo that clearly addresses the issue discusses each companys facts and provides a clear conclusion regarding the appropriate presentation of each companys financial information on Dynamics consolidated income In constructing this memo you should expect to incorporate Accounting Standards Codification references as required to support your conclusions. Include any basic calculations used in your analysis from the data provided as part of your submission. Assignment Paper Requirements: Write a paper (memo) of a minimum of six double-spaced pages not counting the title and reference pages (which you must include). Copy and paste each one of the questions into your paper in bold type to ensure you have answered each of the assignment Use terms evidence and concepts from class readings including professional business language. Cite at least three credible academic or professional sources for this assignment. The TAMUCT Library is a great place to find resources as well as the FASB Format your paper according to APA

Categories
accounting

A competitor with a similar product (Like Target) as the company I have chosen h

A competitor with a similar product (Like Target) as the company I have chosen has come into the market. Employees at the companyare worried about job security and the viability of the product and its overall affect on the company if it fails. There was a recent jump in the stock prices of your company. TheCIO is questioning whether the valuation of the company is accurate or not. The CEO and CFO turn to you once again to do the background research and present on what you find. Conduct a business valuation on the company. You may choose to conduct: An Income approach A Market approach or an Asset (or cost) approach. Then create a presentation and report for the leadership team.