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

can you answer this question based on the data please!  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) answered and have done all of the other steps
that is all the info i have been given
just need the last question (question #5) answered and have done all of the other steps

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!