Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I believe the cost of goods sold may be wrong. please no hand written answers, thank you Calculator Weighted Average Cost Method with Perpetual Inventory

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed I believe the cost of goods sold may be wrong. please no hand written answers, thank you
Calculator Weighted Average Cost Method with Perpetual Inventory The beginning inventory for Midnight Supplies and data on purchases and sales for a three-month period are as follows: Number Date Transaction of Units Per Unit Total Jan. 1 Inventory 7,700 $73.00 $562,100 10 Purchase 23,100 83.00 1,917,300 28 Sale 11,550 146.00 1,686,300 30 Sale 3,850 146.00 562,100 Feb. 5 Sale 1,540 146.00 224,840 10 Purchase 55,440 85.50 4,740,120 16 Sale 27,720 156.00 4,324,320 28 Sale 26,1807 156.00 4,084,080 Mar. 5 Purchase 46,200 87.50 4,042,500 14 Sale 30,800 156.00 4,804,800 25 Purchase 7,700 88.00 677,600 30 Sale 26,950 156.00 4,204,200 Required: 1. Record the inventory, purchases, and cost of goods sold data in a perpetual inventory record similar to the one illustrated in Exhibit 5, L average cost method. Round unit cost to two decimal places, if necessary. Round all total cost amounts to the nearest dollar. Activa Calculator Schedule of Cost of Goods Sold Weighted For the Three s Ended March 31 e Cost Method Cost of Goods Sold Purchases Total Cost Quantity Unit Cost Unit Cost Total Cost Quantity Date |Jan. 1 1,917,300 23,100 83 Jan. 10 146 1,686,300 11,550 Jan. 28 146 562,100 3,850 Jan. 30 224,840 146 1,540 Feb. 5 85.5 4,740,120 Feb. 10 55,440 4,324,320 156 27,720 Feb. 16 156 4,084,080 26,180 Feb. 28 4,042,500 Mar. 5 87.5 46,200 4,804,800 30,800 156 Mar. 14 Mar. 25 88 677,600 7,700 4,204,200 156 26,950 Mar. 30 19,890,640 Balances Mar. 31 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. Activ ePrevious ws Ne Go to Settings to activate Wind Save and Exit Submit Test for All work sayed. Schedule of Cost of Goods Sold Weighted Average Cost Method For the Three Months Ended March 31 Cost of Goods Sold Inventory Unit Cost Total Cost Total Cost Quantity Unit Cost Quantity t $ 73 562,100 7,700 4,496,800 146 30,800 300 $1 2,810,500 146 19,250 146 1,686,300 11,550 2,248,400 15,400 146 146 562,100 3,850 2,023,560 146 13,860 146 224,840 1,540 10,810,800 156 69,300 ,120 6,486,480 156 4,324,320 41,580 156 27,720 2,402,400 156 4,084,080 15,400 156 26,180 9,609,600 ,500 61,600 156 4,804,800 30,800 156 4,804,800 30,800 156 6,006,000 ,600 156 38,500 1,801,800 11,550 156 4,204,200 26,950 156 54,065,240 19,890,640 ales for the period. Feb. 10 55,440 85.5 4,740,120 Feb. 16 27 Feb. 28 26, Mar. 5 46,200 87.5 4,042,500 Mar. 14 30, Mar. 25 7,700 88 677,600 Mar. 30 26 Balances Mar. 31 2. Determine the total sales, the total cost of goods sold, and the gross profit from sales for the period. Total sales 19,890,640 Total cost of goods sold Gross profit 3. Determine the ending inventory cost as of March 31. $ 54,065,240

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Accounting For Managers And Entrepreneurs

Authors: Charles T. Horngren

9th Edition

1323167897, 9781323167892

More Books

Students also viewed these Accounting questions