I need help creating a cost of goods sold schedule and a cost of goods manufactured schedule.

A B C D E F G H Schedule of Cost of Good Manufactured N 3 Direct Material Beginning balance 5 purchase 9,932,477 6 Raw material available for use 7 Less ending balance of raw material 8 Direct Material used 9 10 Direct labor 11 12 Factory Overhead 13 14 15 16 17 18 19 20 21 22 23 24 25 D Inventory Master File Product Cost Daily Sales bal Inc data sorting Inc data sch cgm Ready Lod + 150%A B C H For the month of Febrary of 2020 N 3 4 52030 Payroll expense- factory labor 224,420 52230 Payroll expense- indirect labor 20,000 52310 Payroll expense- office salary 4,000 52315 Employee benefits- office 6,600 8 52320 Payroll expense- sales salary 8,000 9 52321 Payroll expense- sales commission 256,858 10 52325 Employee benefits - sales 8,000 11 53010 Supply expense- office 200 12 53030 Supplies used- factory 6,000 13 53110 Utilities - office 150 14 53130 Utilities - factory 8,000 15 55010 Insurance expense- office 450 16 55030 Insurance expense - factory 2,000 17 55020 Insurance expense- selling 500 18 56010 Maintenance and repair expense- office 250 19 56030 maintenance expense and repair- factory 5,000 20 57010 Rent- office 1,000 21 57020 Rent - sales 1,200 22 57030 Rent- factory 80,000 23 60020 Advertising 1,000 24 61010 Travel- office/CEO 2,000 25 61020 Travel- sales 5,000 26 62010 Professional fees - office 2,000 27 66010 Depreciation- office equipment 250 28 66020 Depreciation- selling equipment 167 29 66030 Depreciation- factory equipment 5,000 30 31A B C D 1 Balance sheet 2 3 2/1/20 2/29/20 4 Cash 200,000.00 $ 1,595,309.73 5 AR 1,000,000.00 1,487,096.25 6 Supplies 20,000.00 20,000.00 7 Inventory RM 75,860.00 296,190.00 8 Inventory WIP 140,000.00 120,000.00 9 Inventory finished goods 179,680.00 106,980.00 10 Equipment-office 15,000.00 15,000.00 11 Accumulated depreciation (3,250.00) (3,500.00) 12 Equipment-sales 10,000.00 10,000.00 13 Accumulated depreciation (2,166.67) (2,333.33) 14 Equipment-factory 75,000.00 75,000.00 15 Accumulated depreciation (16,250.00) (21,250.00) 16 $ 1,693,873.33 $ 3,698,492.65 17 18 AP 50,000.00 46,250.00 19 Wage payable 250,000.00 250,000.00 20 21 Stockholder equity 1,393,873.33 3,402,242.65 22 Total liability and stockholder equity $ 1,693,873.33 $ 3,698,492.65