please follow the instructions and create a cogs manufactured report a cogs sold report a period cost and fill in the yellow lines as well thank you.

10:02 AM Sat Sep 5 * ~ 73%O > AA C + 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 Cost Description Classification of Classification of Video Amount 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 :54 Delivery truck driver 75,000 3:30 Windshield 300,000 8:14 Material covering the cars 85,000 OTHER INFORMATION Beginning Inventory, 6/1, WIP 300,000 Beginning Inventory, 6/1, FG (Corvettes) 25,000 Ending Inventory, 6/30, WIP 20,000 Ending Inventory, 6/30 FG 760,000 COST OF GOODS MANUFACTURED REPORT COST OF GOODS SOLD REPORT PERIOD COSTS use as many lines as you need to use as many lines as you need to