121 23 A B C D E F G 1 Building Blocks of Managerial Accounting 2 Compute Cost of Goods Sold for a merchandiser Ending inventory Website maintenance Revenues 3 4 The following information is given for a retailer. 56960 $5,900 $7,700 7 8 9 10 11 12 $67,000 $3,700 $1,300 $12,000 $1,500 $40,000 $3,800 13 14 15 Freight-in Import duties Marketing expenses Delivery expenses Purchases Beginning inventory 16 Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If 17 you copy/paste from the Instructions tab you will be marked wrong. 18 19 Requirement 20 Compute the cost of goods sold. 21 22 23 24 a. b. C. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values to be subtracted. Check your spelling carefully and do not abbreviate. Follow the format shown in Exhibit 2-14. For any labels that list more than one cost in one input cell, list the costs in the same order as in the exhibit. 25 Saving & Submitting Solution 1 Save file to desktop. a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 2 Upload and submit your file to be graded. Navigate back to the activity window-screen where you downloaded the initial spreadsheet Click Choose button under step 3; locate the file you just saved and click Open 26 27 28 29 a. 30 b. 31 C. 32 d. Click Submit button under step 4 33 34 Click Upload button under step 3 Ready INSTRUCTIONS ENTERANSWERS (Always use cell references and formulas where appropriate to receive full credit. If you 1 copy/paste from the Instructions tab you will be marked wrong.) 2 3 4 5 6 7 Calculation of cost of goods sold 8 Cost of goods sold 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32