Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Hi I need help with these becker simulations! EXHIBITS Inventory Subledger Detail ( U... E-mail Regarding Keyboard... Email Regarding Consignme... Packing Slip From Computer... E-mail

Hi I need help with these becker simulations!
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
EXHIBITS Inventory Subledger Detail ( U... E-mail Regarding Keyboard... Email Regarding Consignme... Packing Slip From Computer... E-mail Regarding Motherboar... E-mail Regarding Delivery of ... Scroll down to complete all parts of this task. A wholesale company, Birch Corp., is preparing financial statements as of and for the year ended December 31, Year 5. You have been asked to review the unadjusted inventory subledger and determine the necessary adjustments, if any, to properly report the inventory balance as of December 31, Year 5 , using the information in the exhibits above. The company's purchase and sales terms are FOB destination. To arrive at the adjusted inventory balance: - Click in the cells in column A and select the appropriate description of the required adjustment. A description may be used once or not at all. - In the cell in column B, enter the corresponding amount of the adjustment. - Enter additions to the inventory balance as positive whole values, and deductions from the inventory balance as negative whole values. - Not all rows might be required to determine the adjusted inventory balance. EXHIBITS O Inventory Subledger Detail(U.... E-mail Regarding Keyboard... Email Regarding Consignme... OP Packing Slip From Computer.... Q Receiving Report Detail E-mail Regarding Motherboar... E-mail Regarding Delivery of.... Select an option below Customer FOB destination shipment removed from the subledger before delivery Customer FOB shipping point shipment included in the subledger after delivery Customer returns received but not recorded in the subledger Customer returns recorded in the subledger but not received Damaged inventory Inventory received from a vendor but not recorded in the subledger Inventory received on consignment Inventory recorded in the subledger but not received from a vendor Inventory removed from the subledger but not returned to a vendor Inventory returned to a vendor but not removed from the subledger Inventory shipped on consignment Scroll down to complete all parts of this task. Party Supply, Inc., a calendar year corporation, took a physical inventory count on November 30 , Year 1 and properly valued its inventory at $4,250,000. Because the company will not perform another physical inventory count on December 31, Year 1, you have been asked to calculate how each of the following transactions would affect the inventory balance reported on the December 31 , Year 1 balance sheet. Enter the amount in the associated cells. 3 Sales for the month of December were $5,000,000 and the company has an average gross margin of 30%. Party Supply placed goods with a selling price of $300,000 on its shipping dock on December 31 , Year 1 . The sale and transaction were recorded by the accounting department on December 31 . The terms of the sale were FOB shipping point. The shipper did not pick up the goods the same afternoon because of inclement weather. The goods were picked up on January 2, Year 2. In response to a customer survey, Party Supply decided to start selling goods on consignment in December Year 1. An initial order of $100,000 (at cost) was delivered from the Party Supply warehouse to the consignee. The consignee sold 25% of the goods in December, Year 1 and another 40% in January, Year 2 . The remaining inventory was returned by the consignee in January. Party Supply started to use a public warehouse so that its products would be closer to its customer's location. $150,000 of the total inventory was held in the public warehouse on December 31 , Year 1. The cost to ship the goods from the main warehouse to the public warehouse was $20,000. The rent paid on the public warehouse for December Year 1 was $10,000. goods the same atternoon because of inclement weather. I he goods were picked up on January 2, Year 2. In response to a customer survey, Party Supply decided to start selling goods on consignment in December Year 1. An initial order of $100,000 (at cost) was delivered from the Party Supply warehouse to the consignee. The consignee sold 25% of the goods in December, Year 1 and another 40% in January, Year 2. The remaining inventory was returned by the consignee in January. Party Supply started to use a public warehouse so that its products would be closer to its customer's location. $150,000 of the total inventory was held in the public warehouse on December 31, Year 1. The cost to ship the goods from the main warehouse to the public warehouse was $20,000. The rent paid on the public warehouse for December Year 1 was $10,000. Part of the company's inventory on hand at year-end is specific to New Year's Eve. The value of that inventory decreases substantially if it is not sold before year-end. Remaining inventory of these items with an original cost of $50,000 was on hand at December 31 , Year 1 . In early January, Year 2, Party Supply sold these items for $10,000 and also paid $6,000 to have the inventory shipped to the buyer. Scroll down to complete all parts of this task. A company purchases inventory during the year in 4 batches, with unit and price amounts shown below: 10,800 units were sold after Batch 2 was purchased, while 3,400 units were sold after Batch 3 was urchased. Calculate COGS and Ending Inventory under the FIFO method, using a Perpetual Inventory System. . Calculate COGS and Ending Inventory under the FIFO method, using a Periodic Inventory System. 2. Calculate COGS and Ending Inventory under the FIFO method, using a Periodic Inventory System. 3. Calculate COGS and Ending Inventory under the LIFO method, using a Perpetual Inventory System. 4. Calculate COGS and Ending Inventory under the LIFO method, using a Periodic Inventory System. 5. If Prices were increasing, moving from FIFO to LIFO would lead to: 3. Calculate COGS and Ending Inventory under the LIFO method, using a Perpetual Inventory System. 4. Calculate COGS and Ending Inventory under the LIFO method, using a Periodic Inventory System. 5. If Prices were increasing, moving from FIFO to LIFO would lead to: EXHIBITS Account Reconciliation: Inven... Physical Inventory Report Physical Inventory Observati... Sales Transactions and Cost.. Inventory Net Realizable Valu... Scroll down to complete all parts of this task. Andromeda Devices Corp. is a U.S. corporation that is based in the Pacific Northwest region of the country and imports security, monitoring, and detection equipment from overseas manufacturers for resale to U.S. customers. Andromeda's fiscal year-end is December 31. The company determines inventory cost on a weighted average basis. As part of its November 30, Year 2, month-end close and account reconciliation process, Jessica Smith, a senior accountant in the company's accounting department, must prepare an inventory rollforward. Using the exhibits, complete Andromeda's inventory rollforward schedule at 11/30/Yr2 by entering the appropriate amounts in column B. Enter debits (increases) to inventory as positive whole dollars and credits (decreases) to inventory as negative whole dollars. If no amount is required, enter a zero (0). EXHIBITS Account Reconciliation: Inven. WPhsical Inventory Report QPhysical Inventory Observati... Sales Transactions and Cost.. Oroduct Profitability Report Inventory Receipts Report (1) Inventory Net Realizable Valu... 1 Andromeda Devices Corp. Inventory Rollforward For the Period Ended November 30, Year 2 4 Beginning balance at 11/01/Yr 2 5 Inventory purchases received 6 Sales of goods 7 Inventory in transit EXHIBITS Account Reconciliation: Inven... Physical Inventory Report Physical Inventory Observati... O Sales Transactions and Cost... Product Profitability Report Inventory Receipts Report O Inventory Net Realizable Valu... \begin{tabular}{|l|l|l|} \hline 3 & & DR / (CR) \\ \hline 4 & Beginning balance at 11/01/Yr2 \\ \hline 5 & Inventory purchases received \\ \hline 6 & Sales of goods \\ \hline 7 & Inventory in transit \\ \hline 8 & Other adjustments \\ \hline 9 & Valuation adjustments \\ \hline 10 & Ending balance at 11/30/Yr2 \\ \hline \end{tabular} Scroll down to complete all parts of this task. A company purchases inventory during the year in 4 batches, with unit and price amounts shown below: 5,200 units were sold after Batch 2 was purchased, while 2,000 units were sold after Batch 3 was purchased. 1. Calculate the weighted average price for each unit of inventory. 2. Calculate COGS using the weighted average method. 3. Calculate Ending Inventory using the weighted average method. 4. Populate the table below assuming the moving average method is used. Round all calculated "per unit" amounts to five decimal places. 5. Calculate COGS using the moving average method. 6. Calculate Ending Inventory using the moving average method. Scroll down to complete all parts of this task. Pomike Co. is a regional auto parts distributor. The company's system automatically bills customers net 10 , FOB shipping point. Pomike vendors' terms are net 30 , FOB shipping point, unless otherwise specified. At the end of Year 1, Pomike took a physical inventory, priced the inventory, and then compared it with its book inventory (general ledger inventory account), which indicated a difference. Review the possible reconciling items in the exhibit above to determine the correct adjusted physical and book inventory. The correct difference, if any, at the end of Year 1 will be calculated automatically. To enter an amount for a reconciling item, click in the cell and then enter increases as positive whole values and decreases as negative whole values, as appropriate. If a response is zero, enter a zero (0). Note: Unreconciled differences, if any, will be subsequently adjusted by the accounting staff in a journal entry. As of the date of the physical inventory, the following items and their inventory values were: Inventory Values \begin{tabular}{|l|c|} \hline Vendordropshipments(goodsshippeddirectlyfromvendorstocustomers)notinvoicedorbilled & $13,000 \\ \hline Goods in-transit from vendor & $10,000 \\ \hline Goodsspeciallybilledandin-transittocustomers(termsnet30,FOBdestination) & $7,000 \\ \hline Vendorsgoodsheldonconsignment(includedinphysicalinventorycount) & $12,000 \\ \hline Goods in-transit from vendors (FOB destination) & $16,000 \\ \hline Customerreturns(goodsinspectedandcounted,butpaperworknotyetsenttoaccounting) & $4,000 \\ \hline \end{tabular} EXHIBITS Vinventory Values EXHIBITS Inventory Values

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions