In Excel, create a variables sheet and Link variables to financial statements. Formulas can be included in the links. A link begins in the destination cell with = and then you pick up the variable from the variables page. If necessary, build a formula and add more variables. 1st picture shown is current Financial Statement & Income Statement for this problem.
2nd Picture shown is an example of what it should look like
AutoSave On excel pr... - Saved Search Developer File Home Insert Page Layout Formulas Data Review View Automate Help G3 fx A 1 2 3 Direct materials 4 Materials Inventory, January 01 5 Add: Net delivered cost of materials purchased 6 Less: Materials Inventory,December 31 7 Direct materials used in production 8 Direct labor 9 Manufacturing overhead 10 Depreciation -Factory 11 Factory Rent 12 Factory supplies used 13 Indirect Materials used 14 Indirect labor 15 Other Factory Overhead 16 Total Manufacturing overhead 17 Total manufacturing costs 18 Add: Work In Process inventory,January 01 19 Less: Work In Process inventory,December 31 20 Cost of goods manufactured 21 22 Calculation of cost of qoods sold 23 Cost of goods manufactured 24 Add: Finished goods inventory,January 01 25 Less: Finished goods inventory,December 31 26 Cost of goods sold 27 28 29 30 31 32 33 34 35 36 B Bishop Manufacturing Company Schedule of Cost of goods manufactured Ready i? Accessibility: Good to go \begin{tabular}{|r|} \\ $850,000 \\ 61,000 \\ 655,000 \\ \hline$846,000 \\ \hline \end{tabular} C 22,000 210,000 27,000 D 27,00044,00055,000 \begin{tabular}{|r|} \hline$312,000 \\ \hline$842,000 \\ $333,000 \\ $25,000 \\ \hline$850,000 \\ \hline \end{tabular} AutoSave On excel pr... - Saved Search Developer File Home Insert Page Layout Formulas Data Review View Automate Help G3 fx A 1 2 3 Direct materials 4 Materials Inventory, January 01 5 Add: Net delivered cost of materials purchased 6 Less: Materials Inventory,December 31 7 Direct materials used in production 8 Direct labor 9 Manufacturing overhead 10 Depreciation -Factory 11 Factory Rent 12 Factory supplies used 13 Indirect Materials used 14 Indirect labor 15 Other Factory Overhead 16 Total Manufacturing overhead 17 Total manufacturing costs 18 Add: Work In Process inventory,January 01 19 Less: Work In Process inventory,December 31 20 Cost of goods manufactured 21 22 Calculation of cost of qoods sold 23 Cost of goods manufactured 24 Add: Finished goods inventory,January 01 25 Less: Finished goods inventory,December 31 26 Cost of goods sold 27 28 29 30 31 32 33 34 35 36 B Bishop Manufacturing Company Schedule of Cost of goods manufactured Ready i? Accessibility: Good to go \begin{tabular}{|r|} \\ $850,000 \\ 61,000 \\ 655,000 \\ \hline$846,000 \\ \hline \end{tabular} C 22,000 210,000 27,000 D 27,00044,00055,000 \begin{tabular}{|r|} \hline$312,000 \\ \hline$842,000 \\ $333,000 \\ $25,000 \\ \hline$850,000 \\ \hline \end{tabular}
