please write the formula

the instruction:

1 1. Prepare a schedule for the cost of goods manufactured in 2017. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 2 Instructions tab you will be marked wrong.) 3 4 5 Carolina Corporation Schedule of Cost of Goods Manufactured Year Ended December 31, 2017 (in thousands) 6 7 8 Direct materials costs: 9 10 11 12 13 Direct materials used 14 15 Manufacturing overhead costs: 16 17 18 19 20 21 22 Total manufacturing overhead costs 23 Manufacturing costs incurred during 2017 24 25 Total manufacturing costs to account for 26 27 Cost of goods manufactured (to Income Statement) 28 29 2. Revenues (in thousands) for 2017 were $1,300,000. Prepare the income statement for 2017. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 30 Instructions tab you will be marked wrong.) 31 Carolina Corporation Income Statement Year Ended December 31, 2017 (in thousands) 31 32 33 34 35 36 37 Cost of goods sold: 38 39 40 41 42 Cost of goods sold 43 44 Operating Costs: 45 46 47 Total operating costs 48 Operating income (loss) 49 1 Anlintroduction to Cost Terms and Purposes 2 Cost of goods manufactured, income statement, manufacturing company 3 4 Consider the following account balances (in thousands) for the Carolina Corporation: 5 6 Beginning of 2017 124,000 173,000 240,000 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Carolina Corporation Direct materials inventory Work-in-process inventory Finished-goods inventory Purchases of direct materials Direct manufacturing labor Indirect manufacturing labor Plant insurance Depreciation-plant, building, and equipment Plant utilities Repairs and maintenance-plant Equipment leasing costs Marketing, distribution, and customer-service costs General and administrative costs End of 2017 73,000 145,000 206,000 262,000 217,000 97,000 9,000 45,000 26,000 12,000 65,000 125,000 71,000 25 26 27 21 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the 22 Instructions tab you will be marked wrong. 23 24 Requirements 1 Prepare a schedule for the cost of goods manufactured for 2017. a. Check your spelling carefully and do not abbreviate. b. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. c. Follow the format in the exhibit that shows the schedule of cost of goods manufactured of a manufacturing-sector company. 29 d. Enter any dates using the following format: MM/DD/YY. For example, 1/1/17. 30 2 Revenues (in thousands) for 2017 were $1,300,000. Prepare the income statement for 2017. 31 a. Check your spelling carefully and do not abbreviate. b. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. c. Follow the format in the exhibit that shows the income statement of a manufacturing-sector company. d. Enter any dates using the following format: MM/DD/YY. For example, 1/1/17. 28 32 33 34 35 37 39 40 36 Saving & Submitting Solution 1 Save file to desktop. 38 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. a. Navigate back to the activity window - screen where you downloaded the initial spreadsheet 41 b. Click Choose button under step 3; locate the file you just saved and click Open 42 C. Click Upload button under step 3 43 d. Click Submit button under step 4 44 45 46 Viewing Results 1 Click on Results tab in MyAccountingLab 2 Click on the Assignment you were working on 49 3 Click on Project link; this will bring up your Score Card 50 4 Within Score Card window, click on Live Comments Report (lower right) to download spreadsheet with feedback 51 52 53 47 48