Those are the questions that need to be answered the assignment is attached to file 1.
1. Who are the key stakeholders of the analysis?
2. What knowledge do you need to provide a valid interpretation of the descriptive analysis?
3. Is this analysis sufficient for segment reporting or will you need additional analyses?
Ortho Inc. is a medical device manufacturer based in San Diego, California. The company produces and sells custom-made knee replacement implants: Itis a privately held company and files U.S GAAP based financial statements with its bank as part of its debt covenants. «The board of directors is very involved and continues to emphasize the importance of well-designed and effective internal controls. « Orthois a decentralized organization, with 5 manufacturing and sales sites across the United States employing a total of 28 product managers and 29 sales managers. Each site operates independently and is responsible for procurement of raw materials, production, and sales of finished products in its own geographic region. Sales managers maintain their own customer relationships, while product managers monitor inventory levels and order raw materials as needed. «Silicone and plaster are used to create the molds for all the company’s knee replacements. The materials poured into molds vary by product-some are metal, some are plastic, and some are ceramic. The company has invested significantly in the development and maintenance of its information system to collect and report complete and accurate data. Company management uses the data captured in the information system to creat reports and support decision- making. The data dictionary includes the most relevant data used by management, accountants, auditors, and other professionals. MATERIAL MASTER TABLE hein Primai LiL MaterialCategory 0 Constant stating raw material Material “ Material item identifier Material Description OJ Description of material Notes: The Material Master table contains information about different raw materials purchased by Ortho. PRODUCT MASTER TABLE NPT Primary Key Definition ProductCategory a Constant stating knee implant Product “ Product item identifier ProductDescription Oo Description of product Notes: The Product Master table contains information about different products sold by Ortho. TRANSACTIONS TABLE JEL TS Primary Key Definition TransType v Indicates the type of transaction (O for orders and § for sales) TransNumber “ Identifier for orders and sales SiteCode o ‘Transaction site (one of five locations) Manager O Employee associated with the transaction EntitylD O Supplier/Customer associated with the transaction Quantity oO ‘Transaction quantity Unit oO Unit of transaction (Ib or kg for orders, ea for sales) UnitPrice oO Price per unit TransDate O Sales/purchase order date CompleteDate oO Shipping/receiving date (sales/orders) Item 0 ‘The material purchased or product sold CreatedBy O ‘The source of the data (e.g., daily batch) Subtotal O ‘Transaction total before tax (UnitPrice * Quantity) Tax oO ‘Tax amount Notes: The Transactions table contains a combination of purchase order, sales order, and sales return transactions SITES TABLE PTT PET SiteCode = Identified for company sites (five state abbreviations) siteName 0 Name of site (states) Notes: The Sites table contains the name of each site, which is the name of the state where the site is located. EMPLOYEE MASTER TABLE PTS Primary Key Description EmployeelD 2 Employee identifier FirstName 0 Employee first name LastName 0 Employee last name SiteCode a Company site identified (state) Position 0 Employee position OrderApproval 0 Employee order approval authority Notes: The Employee Master table contains information about employees associated with the sales order and pur- chase order transactions, c.g, sales and product managers. ENTITY MASTER TABLE Name Primary Key Description EntitylD “2 Entity (supplier/customer/Ortho, Inc.) identifier SiteCode 0 Indicates which Ortho site the entity is associated with EntityName 0 Entity company name ContactFirstName 0 Entity contact first name ContactLastName 0 Entity contact last name Phone 0 Entity phone Email 0 Entity email StreetAddress| 0 Entity street address City 0 Entity city State g Entity state Zip 0 Entity zip code Entity Type 0 Entity type (“S” for customer and “O for supplier) The entity-relationship diagram (ERD) shows the relationships among the tables in the information system. S—— 11 § sttecode Stename . : Material Quantity [— 3 Lasthame. WaterilCategory unierice Aan Matertalbescription Transbate Position ee] wu Completevate orderapproval ee rr ProductCategory [C0 Productoescrption Sttecode Entityname contactirstName ContactLasthame Phone Email Strectaddress ay state 2p EntityType (Notes: The ERD indicates which tabi i Join and which columns 0 use fn the ins) The comparative income statement shows income for 2024 and 2025. Ortho Inc. Comparative Income Statement Comparative Income Statement EILTVITEEN 2024 2025 (audited) (unaudited) Net Sales $913 $854 Costof Sales 579 542 Gross Profit 334 312 Research and development 57 59 Selling, general and administrative 191 196 Recall charges, net of insurance proceeds 5 5 Intangible asset amortization 3 2 Total operating expenses 256 262 Operating Income 78 50 Other income (expenses), Net 2 Earnings before income taxes 79 52 Income taxes 1 8 Net earnings $68 $44 Financial Accounting: Interpret Descriptive Analytics The Controller at Ortho Inc. has asked you to understand the requirements of ASC 606 Revenue Recognition regarding the disclosure of sales data by geographic or product categories. You have prepared the cross tabulation analysis for 2025 and 2024 as a starting point for preparing the disclosure. Site 2025 2024 Difference cA 172,934,662.11 174,888,045.18 -1,953,383.07 FL 183,493,309.15 164,530,136.81 18,963,172.34 IL 175,041,416.59 174,872,628.25 168,788.34 NY 193,364,104.19 163,660,289.73 29,703,814.46 TX 188,249,027.51 175,554,510.70 12,694,516.81 Total 913,082,519.55 853,505,610.67 59,576,908.88 Who are the key stakeholders of the analysis? B 7 YU TT IL = = E E = 9” Bla 1 | « - 0Word(s) eTextbook and Media Assistance Used What knowledge do you need to provide a valid interpretation of the descriptive analysis? B 7 YU TT IL E EE E EE 9» = 8B +9 TT « - 0Word(s) eTextbook and Media Assistance Used Is this analysis sufficient for segment reporting or will you need additional analyses? B 7 YY TT IL Ew = 8 i 0 | « 0Word(s)