Use the Excel workbook provided on Blackboard. The workbook has two tabs, part 1 and part 2 Part 1: this part is based on 1-26 in your textbook and I will discuss the case when I provide the solution. Your part in this project is to do the following: 1. For each of the costs, type in the appropriate cell a. whether the cost is a variable cost or a fixed cost b. Period cost, direct product cost or indirect product cost. As you can see, the first two have been provided for you as examples. Direct labor is a variable cost and is a direct product cost. D 3,00 $ 0.00 fety La for 8 12000 6.000 $ 0.00 Dety the office wewe $ 0.00 $. Ufwy God 2. When you have completed that task for all of the $503,000, the program will provide you with your total variable cost and fixed cost and the variable cost per unit and the fixed cost per unit for production and sales of 2,000 units. Using that data, provide in the appropriate cells the predicted costs for production and sales of 1,000 units and for 3,000 units: Teller Tell Part 2: part 2 has two independent questions. One in blue as shown below and the second in orange. This is similar to Exercise 1-11 in your textbook that was discussed in the fourth video. For the second part of part 2 (the orange example) I suggest reviewing the video. 4 Period (Selling or Administrative) Cost 5 Product Cost Direct Indirect $ 30.000 1 Total COST 2 based on production and sales of Cost Behavior 2.000 unita Variable Fixed 6 Direct Labor $ 118,000 $ 118,000 7 Advertising $ 50,000 $ 50.000 8 Factory supervision $ 40,000 9 Property taxes, factory building $ 3,500 10 Sales commissions $ 80,000 11 Insurance, factory $ 2.500 12 Depreciation, administrative office equipment $ 4,000 11 Lease cost, factory equipment $ 12.000 14 Indirect materials, factory $ 6,000 15 Depreciation, factory building $ 10,000 16 Administrative office supplies (billing) $ 3,000 17 Administrative office salaries $ 60,000 13 Direct materials used (wood belts, etc.) $ 94,000 19 Utilities, factory $ 20,000 20 Total Cont $ 503,000 21 Cost per unit (assuming 2,000 units produced and sold) 32 24 Production and Production and Production and sales of 1,000 sales of 2,000 sales of 3,000 units units units 27 Total Variable Cont Total Fixed Cost 29 Total Cost 30 1,000 units 2.000 units 3,000 units 2 Total Cost: 3 Total Variable Cost 4 Total Fixed Cost 5 Total Cost 60,000 6 8 20.00/unit 7 Cost per unit: Variable Cost per unit Fixed Cost per unit Total Cost per Unit 9 10 11 12 13 14 15 16 1,000 units 5,000 units 10,000 units 17 Total Cost: 18 Total Variable Cost 19 Total Fixed Cost 20 Total Cost 110,000 21 22 Cost per unit: 23 Variable Cost per unit 24 Fixed Cost per unit 25 Total Cost per Unit 26 20.00/unit 27 28