Please answer these in excel & show the excel formulas please. thank you WILL RATE
1. Compute the equivalent units in the mixing department for April 2020 for each cost category. a. For accounts with a 0 balance, make sure to enter the result of " =0 " in the appropriate cell. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. Use cell references from prior inputs, where applicable.) 2. Compute (a) the cost of goods completed and transferred to the baking department during April and (b) the cost of work in process as of April 30, 2020. a. For accounts with a $0 balance, make sure to enter the result of "=0" in the appropriate cell. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. Use cell references from prior inputs, where applicable.) Castle Cakes uses a mixing department and a baking department in producing its cake. Its processcosting system in the mixing department has two direct materials cost categories (cake mix and flavorings) and one conversion cost pool. The following data pertain to the mixing department for April 2020: The cake mix is introduced at the start of operations in the mixing department, and the flavorings are added when the product is Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. Use cell references from prior inputs, where applicable. 1 1 Compute the equivalent units in the mixing department for April 2020 for each cost category. a. For accounts with a 0 balance, make sure to enter the result of " =0 " in the appropriate cell. 2 Compute (a) the cost of goods completed and transferred to the baking department during April and (b) the cost of work in process as of April 30, 2020. a. For accounts with a $0 balance, make sure to enter the result of " =0 " in the appropriate cell. 1. Compute the equivalent units in the mixing department for April 2020 for each cost categor (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. Use cell references from prior inputs, where applicable. For accounts with a 0 balance, make sure to enter the result of " =0 " in the appropriate cell.) 2. Compute (a) the cost of goods completed and transferred to the baking department during April and (b) the cost of work in process as of April 30, 2020. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong. Use cell references from prior inputs, where applicable. For accounts with a 0 balance, make sure to enter the result of " =0 " in the appropriate cell.)
