2 3 How to submit this file for grading. 4 5 First, download the excel template and open it, view the excel video and complete the activity. 6 7 8 9 Then, save the file on your desktop, with the name "Completed Excel Activity." Make sure the file you upload has a ".xlsx" extension on the file name. If you upload some other kind of file, you will not get credit for completing the activity. 10 Second, go to Blackboard and click on the excel activity link in the module. 11 12 You will see a link there for the Excel Activity, if you are submitting the file prior to the deadline. Third, click on the link and upload your file to Blackboard. Click submit and I will grade your spreadsheet within 24 hours. If your spreadsheet is correct, you will receive 5 points. Otherwise, no points. Jasper Company provided the following information for last year: 280,000 $12.00 $ 180,000 $ 505,000 $ 110,000 $ 437,000 $ 854,000 Selling expense Administrative Expense Last year, the beginning and ending inventories of raw materials, work-in-process and finished goods were zero. 13 14 15 16 17 18 Number of units sold 19 Selling price per unit 20 Direct Materials used 21 Direct Labor cost 22 Manufacturing Overhead 23 24 25 26 27 28 29 30 31 32 33 34 35 Sales revenue 36 Cost of goods sold 37 Gross profit 38 Less: 39 Selling expense 40 Administrative expense 41 Operating income 42 43 Jasper Company Income Statement For the Past Year Sales & Expenses Percent of Sales