Step 1: The income data (inc data) worksheet is provided and sorted by the account name. You will need to re-sort the accounts and its balance by function to complete the cost of goods manufactured and income statements.

Step 2: Create a new work sheet by right clicking the inc data tab. Choose move or copy function to duplicate the inc data work sheet. Name is as inc data sorting work sheet. You can work out all your numbers in here without changing your original numbers.

The quick way to re-sort is utilizing the excel function called text to columns. (Hint: The ccount numbers second digit represents the functional difference. Use the text to columns\fixed width function to split the account number into two groups. Then you can use the sorting function to sort the second group which contains the first and second digit of the account number). For reference on how to use the text to columns, see link "Text to Columns- Excel 2019"

Step 3: Using data provided from the income statement data (inc data) worksheet and the balance sheet (bal) complete the Schedule of Cost of Goods Manufactured (see tab sch cgm). (Please reference your textbook for the correct statement format on page 548. Or see the attached image of a sample statement.)

Step 4: Calculate the cost of the goods manufactured for the month of February.

Schedule of Cost of Good Manufactured 9,932,477 Direct Material Beginning balance purchase Raw material available for use Less ending balance of raw material Direct Material used Direct labor Factory Overhead Schedule of Cost of Good Manufactured 9,932,477 Direct Material Beginning balance purchase Raw material available for use Less ending balance of raw material Direct Material used Direct labor Factory Overhead