ACCTG 331, Intermediate Accounting Simulations #3: Inventory Ch 8 and 9 30 points USE EXCEL SPREADSHEET FOR ALL OF YOUR WORK #1-Perpetual Inventory Method Journal Entries Required: Prepare journal entries for each of the following transactions under the Perpetual Inventory method-include recording date and all required revenue expense and balance sheet accounts. The Widget Company sells only one product (widgets) and uses FIFO. December 31, 2019 inventory is as follows: Date purchased December 5, 2019 December 20, 2019 December 28, 2019 Quantity 1.500 700 500 Unit cost $5.34 $5.48 $5.40 1. January 2, 2020: Received 1,000 widgets with a unit cost of $6.00. The units were shipped from the supplier on December 29, 2019 FOB shipping point. The widgets were not included in the December 31, 2019 inventory. Payment terms are 2/10, net 30. The company uses the Net Method for recording payment discounts. 2. January 5, 2020: Sold 3,000 widgets for $11.00 each and shipped FOB shipping point. Payment terms are 1/10.net 30. The company uses the Gross Method for recording sales discounts. 3. January 6, 2020: Paid in full for the 1.000 widgets received on January 2, 2020. 4. January 10, 2020: Customer returned 200 of the widgets sold and shipped on January 5, 2020. All items were in excellent condition and returned to inventory 5. January 15, 2020: Received 2.500 widgets with unit cost of $5.90. Payment terms are net 30 no payment discount offered. Atlas Freight Company billed Widgets $250.00 for delivering the widgets and Widgets paid Atlas immediately. 6. Calculate the following for January 2020: a. Inventory quantity on hand and account balance at the end of the month b. Net Sales, Cost of Goods Sold and Gross Profit for January 2020 AaBbCc. AaBbcc Aabbur ABDUL 1 Normal T No Spac... Heading 1 Heading 2 Title Styles #2-Conventional Retail Method Required: 1. Prepare an Excel spreadsheet analysis using the data provided on the following page to determine the ending inventory and cost of goods sold for 2019. Any calculated number should be calculated in Excel using reference to other cells. The spreadsheet should be designed for reuse in subsequent periods. 2. Correctly calculate ending inventory and cost of goods sold. Prepare the journal entry in Excel to adjust inventory to the estimated value and close the purchase accounts to cost of goods sold. Link the amounts to your calculations. a. Round all calculated values to whole integers, ee 123.456.789 b. Round all ratios to 5 decimal places, e.g. 0.12345 or 12.345% Unlucky Blue Jean Company Conventional Retail Method Inventory and COGS During 2019. Unlucky Blue Jean Company lost its market share to Amazon.com. Unlucky was unable to sell all of its merchandise and offered big markdowns in December. Unlucky a yearend is December 31. Use the Conventional Retail Method and the information provided below to determine the ending inventory, cost of goods sold and gross profit reported in the income statement for 2019. FACTS for 2019: Balances in general ledger: Inventory at January 1 Purchases Freight-in for purchases Purchase discounts taken Purchase returns Sales revenue Sales returns Retail Data: Value of inventory at January 1 Value of net purchases Net markups Net markdowns $ 27,889,356 355,086,236 908.368 4,372.980 12.352.525 704.767.693 58,627,749 62.345,952 754.973.542 7.426.242 154.297.270 2 2 AaBbUCL AbuLLL Hau I Normal 1 No Spac... Heading Styles Paragraph n ACCTG 331, Intermediate Accounting Simulations #3: Inventory Ch 8 and 9 30 points USE EXCEL SPREADSHEET FOR ALL OF YOUR WORK #1-Perpetual Inventory Method-Journal Entries Required. Prepare journal entries for each of the following transactions under the Perpetual Inventory method -include recording date and all required revenue expense and balance sheet accounts. The Widget Company sells only one product (widgets) and uses FIFO. December 31, 2019 inventory is as follows Date purchased Quantity Unit cost December 5, 2019 11500 1 5534 December 20, 2019 700 December 28, 2019 500 1. January 2, 2020: Received 1.000 widgets with a unit cost of $6.00. The units were shipped from the supplier on December 29, 2019 FOB shipping point The wides were not included in the December 31, 2019 inventory. Payment terms are 2/10, net 30. The company uses the Net Method for recording payment discounts 2. January 5.2020. Sold 3.000 widgets for $11.00 each and shipped FOB shipping point. Payment terms are 1/10.net 30. The company uses the Gross Method for recording sales discounts 3. January 6, 2020: Paid in full for the 1.000 widgets received on January 2 4. January 10, 2020, Customer returned 200 of the wides sold and shipped on January 5, 2020. All items were in excellent condition and returned to inventory. 5. January 15, 2020: Received 2.500 widgets with unit cost of $5.90. Payment terms are net 30-no payment discount offered. Atlas Freight Company billed Widgets $250.00 for delivering the widgets and Widget paid Atlas immediately 6. Calculate the following for January 2020: Inventory quantity on hand and account balance at the end of the b. Net Sales Cost of Goods Sold and Gross Profit for January 2020 o 9 @ a ou want to do & Share ADA O Find aBbc Aabbccc AaB abc Replace eading 1 Heading 2 Title Select Styles Editing Open Grammarly Grammarly #2-Conventional Retail Method Required: 1. Prepare an Excel spreadsheet analysis using the data provided on the following page to determine the ending inventory and cost of goods sold for 2019. Any calculated number should be calculated in Excel using reference to other cells. The spreadsheet should be designed for reuse in subsequent periods Correctly calculate ending inventory and cost of goods sold. Prepare the Journal entry in Excel to adjust inventory to the estimated value and close the purchase accounts to cost of goods sold. Link the amounts to your calculations. a. Round all calculated values to whole integerse. 123,456,789 b. Round all ratios to 5 decimal places, ex. 0.12345 or 12.345% Unlucky Blue Jean Company Conventional Retail Method Inventory and COGS During 2019. Unlucky Blue Jean Company lost its market share to Amazon.com Unlucky was unable to sell all of its merchandise and offered big markdowns in December. Unluckovis yearend is December 31. Use the Conventional Retail Method and the information provided below to determine the ending inventory, cost of goods sold and gross profit reported in the income statement for 2019, FACTS for 2019 Balances in general ledger Inventory at January 1 Purchases Freight-in for purchases Purchase discounts taken Purchase returns Sales revenue Sales returns Retail Data: Value of inventory at January 1 Value of net purchases Net markups Net markdowns $ 27,899.356 355.086.236 908 368 4.372.900 12352.525 704.767,693 58.627.749 62345.952 754.973,542 7426 242 154.297,270 ACCTG 331, Intermediate Accounting Simulations #3: Inventory Ch 8 and 9 30 points USE EXCEL SPREADSHEET FOR ALL OF YOUR WORK #1-Perpetual Inventory Method Journal Entries Required: Prepare journal entries for each of the following transactions under the Perpetual Inventory method-include recording date and all required revenue expense and balance sheet accounts. The Widget Company sells only one product (widgets) and uses FIFO. December 31, 2019 inventory is as follows: Date purchased December 5, 2019 December 20, 2019 December 28, 2019 Quantity 1.500 700 500 Unit cost $5.34 $5.48 $5.40 1. January 2, 2020: Received 1,000 widgets with a unit cost of $6.00. The units were shipped from the supplier on December 29, 2019 FOB shipping point. The widgets were not included in the December 31, 2019 inventory. Payment terms are 2/10, net 30. The company uses the Net Method for recording payment discounts. 2. January 5, 2020: Sold 3,000 widgets for $11.00 each and shipped FOB shipping point. Payment terms are 1/10.net 30. The company uses the Gross Method for recording sales discounts. 3. January 6, 2020: Paid in full for the 1.000 widgets received on January 2, 2020. 4. January 10, 2020: Customer returned 200 of the widgets sold and shipped on January 5, 2020. All items were in excellent condition and returned to inventory 5. January 15, 2020: Received 2.500 widgets with unit cost of $5.90. Payment terms are net 30 no payment discount offered. Atlas Freight Company billed Widgets $250.00 for delivering the widgets and Widgets paid Atlas immediately. 6. Calculate the following for January 2020: a. Inventory quantity on hand and account balance at the end of the month b. Net Sales, Cost of Goods Sold and Gross Profit for January 2020 AaBbCc. AaBbcc Aabbur ABDUL 1 Normal T No Spac... Heading 1 Heading 2 Title Styles #2-Conventional Retail Method Required: 1. Prepare an Excel spreadsheet analysis using the data provided on the following page to determine the ending inventory and cost of goods sold for 2019. Any calculated number should be calculated in Excel using reference to other cells. The spreadsheet should be designed for reuse in subsequent periods. 2. Correctly calculate ending inventory and cost of goods sold. Prepare the journal entry in Excel to adjust inventory to the estimated value and close the purchase accounts to cost of goods sold. Link the amounts to your calculations. a. Round all calculated values to whole integers, ee 123.456.789 b. Round all ratios to 5 decimal places, e.g. 0.12345 or 12.345% Unlucky Blue Jean Company Conventional Retail Method Inventory and COGS During 2019. Unlucky Blue Jean Company lost its market share to Amazon.com. Unlucky was unable to sell all of its merchandise and offered big markdowns in December. Unlucky a yearend is December 31. Use the Conventional Retail Method and the information provided below to determine the ending inventory, cost of goods sold and gross profit reported in the income statement for 2019. FACTS for 2019: Balances in general ledger: Inventory at January 1 Purchases Freight-in for purchases Purchase discounts taken Purchase returns Sales revenue Sales returns Retail Data: Value of inventory at January 1 Value of net purchases Net markups Net markdowns $ 27,889,356 355,086,236 908.368 4,372.980 12.352.525 704.767.693 58,627,749 62.345,952 754.973.542 7.426.242 154.297.270 2 2 AaBbUCL AbuLLL Hau I Normal 1 No Spac... Heading Styles Paragraph n ACCTG 331, Intermediate Accounting Simulations #3: Inventory Ch 8 and 9 30 points USE EXCEL SPREADSHEET FOR ALL OF YOUR WORK #1-Perpetual Inventory Method-Journal Entries Required. Prepare journal entries for each of the following transactions under the Perpetual Inventory method -include recording date and all required revenue expense and balance sheet accounts. The Widget Company sells only one product (widgets) and uses FIFO. December 31, 2019 inventory is as follows Date purchased Quantity Unit cost December 5, 2019 11500 1 5534 December 20, 2019 700 December 28, 2019 500 1. January 2, 2020: Received 1.000 widgets with a unit cost of $6.00. The units were shipped from the supplier on December 29, 2019 FOB shipping point The wides were not included in the December 31, 2019 inventory. Payment terms are 2/10, net 30. The company uses the Net Method for recording payment discounts 2. January 5.2020. Sold 3.000 widgets for $11.00 each and shipped FOB shipping point. Payment terms are 1/10.net 30. The company uses the Gross Method for recording sales discounts 3. January 6, 2020: Paid in full for the 1.000 widgets received on January 2 4. January 10, 2020, Customer returned 200 of the wides sold and shipped on January 5, 2020. All items were in excellent condition and returned to inventory. 5. January 15, 2020: Received 2.500 widgets with unit cost of $5.90. Payment terms are net 30-no payment discount offered. Atlas Freight Company billed Widgets $250.00 for delivering the widgets and Widget paid Atlas immediately 6. Calculate the following for January 2020: Inventory quantity on hand and account balance at the end of the b. Net Sales Cost of Goods Sold and Gross Profit for January 2020 o 9 @ a ou want to do & Share ADA O Find aBbc Aabbccc AaB abc Replace eading 1 Heading 2 Title Select Styles Editing Open Grammarly Grammarly #2-Conventional Retail Method Required: 1. Prepare an Excel spreadsheet analysis using the data provided on the following page to determine the ending inventory and cost of goods sold for 2019. Any calculated number should be calculated in Excel using reference to other cells. The spreadsheet should be designed for reuse in subsequent periods Correctly calculate ending inventory and cost of goods sold. Prepare the Journal entry in Excel to adjust inventory to the estimated value and close the purchase accounts to cost of goods sold. Link the amounts to your calculations. a. Round all calculated values to whole integerse. 123,456,789 b. Round all ratios to 5 decimal places, ex. 0.12345 or 12.345% Unlucky Blue Jean Company Conventional Retail Method Inventory and COGS During 2019. Unlucky Blue Jean Company lost its market share to Amazon.com Unlucky was unable to sell all of its merchandise and offered big markdowns in December. Unluckovis yearend is December 31. Use the Conventional Retail Method and the information provided below to determine the ending inventory, cost of goods sold and gross profit reported in the income statement for 2019, FACTS for 2019 Balances in general ledger Inventory at January 1 Purchases Freight-in for purchases Purchase discounts taken Purchase returns Sales revenue Sales returns Retail Data: Value of inventory at January 1 Value of net purchases Net markups Net markdowns $ 27,899.356 355.086.236 908 368 4.372.900 12352.525 704.767,693 58.627.749 62345.952 754.973,542 7426 242 154.297,270