Question: can you answer this question based on the data please! that is all the info i have been given just need the last question (question


5) The supply room supervisor tells you that he recently learned that a local crime ring traffics in stolen medical supplies. Recommend two different ways that you could use this data set and our data analytics tools to efficiently identify specific items that appear to be at a higher risk of theft. What internal controls should be implemented to address these risks? Create a new tab called "Recommend" to record your answers to this question. You are an accountant at a large hospital, reporting to the controller. The hospital maintains a perpetual inventory system. Hospital policy requires that a physical count of inventory be performed at year-end and that the Inventory account balance must be adjusted to match the physical count results. Following the results of the year end physical inventory count, the controller has provided an Excel file containing the physical inventory count results (instructions above on where to find this file) and asked you to use the data contained in this file to prepare three manual journal entries adjusting the Inventory account balance: 1) Remove consignments tracked in the perpetual system from the Inventory balance. 2) Use the Inventory Over/Short account to adjust the Inventory balance to match the count results. 3) Use the Loss Due to Decline in Value account to adjust the Inventory balance for known spoilage. At last tally, the hospital's supply room held 2,146 unique items. Upon ordering new inventory, a supply room staff member increases the quantity in the perpetual inventory system and computes a new average cost per unit consistent with the weighted average cost flow assumption. Upon distribution of inventory (to the operating room, etc.), a staff member decreases the quantity in the perpetual inventory system. The perpetual inventory system is configured to automatically calculate and post journal entries to the hospital's general ledger based on the following logic: - IF: A staff member orders new inventory and updates the quantity/cost in the perpetual system THEN: The perpetual system automatically calculates and posts this entry
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
