Analytics in Action Assignment Background: You are an accountant at a large hospital, reporting to the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Analytics in Action Assignment Background: 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 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: DR: CR: Inventory Accounts Payable XXXXX XXXXXX IF: A staff member distributes inventory and updates the quantity in the perpetual system THEN: The perpetual system automatically calculates and posts this entry DR: Cost of Goods Sold CR Inventory XXXXX XXXXX As a result of these automatic entries, the hospital's Inventory account balance in the general ledger is kept in line with the perpetual inventory system balance during the year. On December 31, 2018, the Inventory account had a balance of $678,798.28, which matches the perpetual system. In preparation for the physical count, the supply room supervisor locked staff members out of the perpetual system so that they could no longer update the system after 5:00 pm of December 31, 2018. Staff members conducted the physical count on the evening of December 31, beginning at 5:00 pm and finishing at 8:00 pm. Following completion of the count, the supply room supervisor input the new inventory quantities resulting from the physical count into the perpetual inventory system. He also made the following notes, but he did not adjust any of the inventory quantities for the situations described. Analytics in Action Assignment Background: 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 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: DR: CR: Inventory Accounts Payable XXXXX XXXXXX IF: A staff member distributes inventory and updates the quantity in the perpetual system THEN: The perpetual system automatically calculates and posts this entry DR: Cost of Goods Sold CR Inventory XXXXX XXXXX As a result of these automatic entries, the hospital's Inventory account balance in the general ledger is kept in line with the perpetual inventory system balance during the year. On December 31, 2018, the Inventory account had a balance of $678,798.28, which matches the perpetual system. In preparation for the physical count, the supply room supervisor locked staff members out of the perpetual system so that they could no longer update the system after 5:00 pm of December 31, 2018. Staff members conducted the physical count on the evening of December 31, beginning at 5:00 pm and finishing at 8:00 pm. Following completion of the count, the supply room supervisor input the new inventory quantities resulting from the physical count into the perpetual inventory system. He also made the following notes, but he did not adjust any of the inventory quantities for the situations described.
Expert Answer:
Related Book For
Corporate Finance and Investment decisions and strategies
ISBN: 978-1292064062
8th edition
Authors: Richard Pike, Bill Neale, Philip Linsley
Posted Date:
Students also viewed these accounting questions
-
Write a report on the company Magan International including the following: Section I - A summary of your company's business and the economic environment in which it operates. You can find this...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
March is a month of variable weather in the Northeast. The chart below records the actual high and low temperatures for a selection of days in March from the weather report for Pittsburgh,...
-
How might trade hurt a country if it imports goods that are produced under conditions of external economies of scale?
-
Let A be a 4 5 matrix. If a1, a2, a4 are linearly independent and a3 = a1 + 2a2 a5 = 2a1 - a2 + 3a4 determine the reduced row echelon form of A.
-
From the following information relating to Louise Jones, prepare the income statement for the year ended 30 November 2009 and a balance sheet as at that date. Assume that relevant expense totals have...
-
Velocity, Inc., a foreign corporation, operates a U.S. branch. It reports the following tax results and other information for the year. Pretax earnings effectively connected with a U.S. trade or...
-
AABC is congruent to ADEF. Find x and then mZCAB and m/FDE A D (3x 3) B (4x 11) C F E Note: Always make sure the value of x produces positive angles. x = mZCAB =
-
5 Required information The Foundational 15 (Algo) [LO3-1, LO3-2, LO3-3, LO3-4] [The following information applies to the questions displayed below] Bunnell Corporation is a manufacturer that uses...
-
1 . Distinguish the technological and operational needs of smart manufacturing. 2 . Critique architectures of smart manufacturing systems. 3 . Explore strategies for improving manufacturing...
-
The brakes are applied to a moving car, causing it to uniformly slow down. While slowing, it moves a distance of 40.0 m in 8.15 s to a final velocity of 2.20 m/s, at which point the brakes are...
-
Ross Company makes handbags. Last month, direct materials (leather, thread, zippers, decorative accents) costing $76,000 were put into production. Ross Company had 30 workers, each of whom worked for...
-
1-Explain why a dollar has different values depending on the point in time received and how "present valuing" or "future valuing" cash flow corrects for these differences. 2. Explain how movements in...
-
A construction company signed a loan contract at 7.27% compounded semi-annually, with the provision to pay $575 at the end of each month for four years.(a) What is amount of the loan?(b) How much...
-
company ABC is a leader in the high precision machining market. Located in India, the company and its customers who are spread across the world(vacuum chambers, complex structures) using different...
-
Estimate a range for the optimal objective value for the following LPs: (a) Minimize z = 5x1 + 2x2 Subject to X1 - x2 3 2x1 + 3x2 5 X1, x2 0 (b) Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 +...
-
Jud's Manufacturing Company produces one product, Kebo. Because of wide fluctuations in demand for Kebo, the Assembly Department experiences significant variations in monthly production levels. The...
-
Lorch Company uses budgets in controlling costs. The May 2002 budget report for the company's Packaging Department is as follows. The budget amounts in the report were on the master budget For the...
-
Lakem elder Dutch manufactures expensive watch eases sold as souvenirs. Three ol its sales departments are: Retail Sales, Wholesale Sales, and Outlet Sales. The Retail Sales Department is a profit...
Study smarter with the SolutionInn App