Sheet Click on the "Manufacturing Cost Flows tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to se Each graded cell is highlighted in yellow. Select all account titles/tabels using dropdowns. Enter formulas for all dollar amount The formula must only contain cell addresses. Each correct formula will begin with = +, or The basic mathematical operators are and/ Addition: To add the values in cells A1 and B4, the formula is A1+34 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is A1-84 Multiplication: To multiply the values in cells A1 and 84, the formula is -A1-84 Division: To divide the value in cell A1 by the value in cell B4, the formula is -A1/B4 THIS FILE REQUIRES THE USE OF -SUM FOR ALL TOTALS AND SUBTOTALS The SUM function adds all values within a range of cells For example, the formula to calculate total attendees in cell B19 is - SUM(B16:818). len 850 Women 930 Children 1,145 Total 2.925 23 MacBook Pro SC @ ! 1 2 # 3 $ 4 % 5 6 & 7 8 9 Q W u REQUIRED: Calculate the ending T-account balances for each account, then compute the amount for each of the manufacturing cost flows. Every yellow cell must include a valid formula, even if the result is $0. Raw Materials Inventory 48,500 28,000 11,200 Factory Wages Payable 130,000 84,000 46,000 Work in Process Inventory 28,000 164,000 84,000 92,400 Factory Overhead 11,200 46,000 37,600 92,400 Finished Goods Inventory 164.000 131,000 Required: Enter a valid formula to compute the amount for each of the following. a b C d e 1 9 h Direct materials used Indirect materials used Direct labor used Indirect labor used Cost of goods manufactured Cost of goods sold (before closing over-or underapplied overhead) Actual overhead incurred Overhead applied The Artist 3 4 5 A B D E G 11,200 F 46,000 Work in Process Inventory 28,000 164,000 84.000 92,400 Factory Overhead 11,200 46,000 37,600 92,400 Finished Goods Inventory 164,000 131,000 Required: Enter a valid formula to compute the amount for each of the following. a b. c. d. e. f. Direct materials used Indirect materials used Direct labor used Indirect labor used Cost of goods manufactured Cost of goods sold (before closing over-or underapplied overhead) Actual overhead incurred h. Overhead applied The amount of over-or underapplied overhead . Use dropdown button to indicate whether overhead is over- or underapplied. k. Cost of goods sold (after closing over-or underapplied overhead) g. 1. Insert Table Chart + Instructions Manufacturing Cost Flows Sheet1 Cell F8 You entered: Feedback