please answer correctly thank you

10:02 AM Sat Sep 5 9 73% AA cdn.inst-fs-lad-prod.inscloudgate.net + ASSIGNMENT 1 - CLASSIFYING COSTS IDENTIFIED IN THE CORVETTE ASSEMBLY VIDEO 1. Your assignment is to prepare a schedule of Cost of Goods Manafactured, Cost of Goods Sold, and Period Costs. 2. After completing these schedules, save this Excel file and upload it back to the Assignment in Canvas. This will be part of your Discussion Group grade. 3. All cells colored YELLOW should have text or data input into them. 4. You will need to prepare this Excel file so that you can participate in the Discussion Group INFORMATION FROM CORVETTE ASSEMBLY VIDEO Time in Classification or Amount Cost Description Classification of Video Cost Cost 0:07 Factory - Depreciation 1,000,000 3:47 Plastic covering steering wheel 35,000 0:30 Man in Yellow Shirt 90,000 3:52 All these workers 400,000 1:08 Workers carrying material 350,000 5:14 Man in autoworker shirt 90,000 1:23 Rivets - Fasteners 50,000 5:25 Tailpipes hanging on wall 600,000 1:31 Dashboard 400,000 5:57 Tires 500,000 1:46 Yellow robot. Depreciation 90,000 6:09 Wheel bolt tightening machine 45,000 2:01 Computer screen with arm on it 90,000 6:53 Man cleaning hood 90,000 2:08 Sanding tool 45,000 6:55 Man inspecting gap 100,000 2:13 Cleaning fluid 22.000 7:44 Delivery truck 600,000 2:48 Electric powering the fans 110,000 7:54 Delivery truck driver 75,000 3:30 Windshield 300,000 8:14 Material covering the cars 85,000 OTHER INFORMATION Beginning Inventory, 61, WIP Ending Inventory, 6/30, WIP 300,000 20,000 Beginning Inventory, 6'1, FG (Corvettes) Ending Inventory, 6/30 FG 25,000 760,000 PERIOD COSTS COST OF GOODS MANUFACTURED REPORT nese as many lines as you need to COST OF GOODS SOLD REPORT Mse as many lines as you need to 10:02 AM Sat Sep 5 9 73% AA cdn.inst-fs-lad-prod.inscloudgate.net + ASSIGNMENT 1 - CLASSIFYING COSTS IDENTIFIED IN THE CORVETTE ASSEMBLY VIDEO 1. Your assignment is to prepare a schedule of Cost of Goods Manafactured, Cost of Goods Sold, and Period Costs. 2. After completing these schedules, save this Excel file and upload it back to the Assignment in Canvas. This will be part of your Discussion Group grade. 3. All cells colored YELLOW should have text or data input into them. 4. You will need to prepare this Excel file so that you can participate in the Discussion Group INFORMATION FROM CORVETTE ASSEMBLY VIDEO Time in Classification or Amount Cost Description Classification of Video Cost Cost 0:07 Factory - Depreciation 1,000,000 3:47 Plastic covering steering wheel 35,000 0:30 Man in Yellow Shirt 90,000 3:52 All these workers 400,000 1:08 Workers carrying material 350,000 5:14 Man in autoworker shirt 90,000 1:23 Rivets - Fasteners 50,000 5:25 Tailpipes hanging on wall 600,000 1:31 Dashboard 400,000 5:57 Tires 500,000 1:46 Yellow robot. Depreciation 90,000 6:09 Wheel bolt tightening machine 45,000 2:01 Computer screen with arm on it 90,000 6:53 Man cleaning hood 90,000 2:08 Sanding tool 45,000 6:55 Man inspecting gap 100,000 2:13 Cleaning fluid 22.000 7:44 Delivery truck 600,000 2:48 Electric powering the fans 110,000 7:54 Delivery truck driver 75,000 3:30 Windshield 300,000 8:14 Material covering the cars 85,000 OTHER INFORMATION Beginning Inventory, 61, WIP Ending Inventory, 6/30, WIP 300,000 20,000 Beginning Inventory, 6'1, FG (Corvettes) Ending Inventory, 6/30 FG 25,000 760,000 PERIOD COSTS COST OF GOODS MANUFACTURED REPORT nese as many lines as you need to COST OF GOODS SOLD REPORT Mse as many lines as you need to