with thorough explanations please !

BA213 Chapter 9 Pricing-Excel problem 2 3 Instructions: Read the Problem Data and complete the calculations section. Enter data in the blue cells and formulas in the yellow cells. Gray cells require no entry. Wh finish. As your work and put 5 your last name in the flame. Upload your file to the dropbox located in the Chapter module on Blackboard. 6 7 For Excel help, click on the symbol in the upper right corner of your screen. Remember you have access to SimNet 8 from your BA131 course. Simnet is also an excellent source for help 9 10 Problem Data 11 12 XYZ Co. uses the product cost concept of applying the cost-plus approach to product pricing The costs of producing and selling 10,000 units are as follows: 13 XYZ desires profit equal to a 30% rate of return on invested assets of $1,200,000. 14 15 Variable costs per unit: Fixed costs: Direct materials $ 162 Factory Overhead $ 364,500 Direct labor 32 Selling & admin. expense $ 139,000 18 Factory overhead 45 Selling & Admin expense 29 20 Total $ 268 21 22 23 Calculations 24 25 1. Compute the product cost and the cost per unit. 16 17 19 + 26 endere formule to compute the answer in yellow cells enter dato il cells 27 Variable Costs 28 Fixed Costs 29 Total Product Cost 30 31 Cost per unit 32 33 34 2. Compute the amount of desired profit 35 36 37 28 38 39 3. Compute the marlaup percentage 40 41 Desired Profit 42 Total variable selling & admin exp. 43 Total fixed selling & admin exp. 44 45 Total Product Cost 46 47 Markup Percentage 48 49 50 4. Compute the normal selling price 51 52 Product Cost per unit 53 Markup percentage 54 55 Markup per Unit 56 57 Normal Selling Price 58 59