Question: 2) Complete columns L and M in the table to the right. For items categorized as variable (V): Enter the Excel formula to compute unit

2) Complete columns L and M in the table to the right. For items categorized as variable (V"): Enter the Excel formula to compute unit variable cost (in column L). For items categorized as fixed ( 'F'): enter the total fixed cost (in column M). For items categorized as mixed (' M '): See \#3, below, for instructions. 3) Use the High-Low method to separate mixed costs into their fixed and variable components. Use Excel formulas to compute the fixed and variable costs. You may use the High-Low Worksheet to show the computations or enter the formulas directly into the appropriate cells in the table. Note: If you use the High-Low Worksheet, enter cell references in the table to the right to 'feed' your answers answers from the worksheet. 4) Use Excel formulas to compute Total cost of 1000 units for each cost item (in column O). Use the information from columns L and M for your computations. DO NOT feed totals from the original given data table. I need to see that you know how to compute the amounts. 5) Compute the Per-Unit cost for each cost item (in column P). 2) Complete columns L and M in the table to the right. For items categorized as variable (V"): Enter the Excel formula to compute unit variable cost (in column L). For items categorized as fixed ( 'F'): enter the total fixed cost (in column M). For items categorized as mixed (' M '): See \#3, below, for instructions. 3) Use the High-Low method to separate mixed costs into their fixed and variable components. Use Excel formulas to compute the fixed and variable costs. You may use the High-Low Worksheet to show the computations or enter the formulas directly into the appropriate cells in the table. Note: If you use the High-Low Worksheet, enter cell references in the table to the right to 'feed' your answers answers from the worksheet. 4) Use Excel formulas to compute Total cost of 1000 units for each cost item (in column O). Use the information from columns L and M for your computations. DO NOT feed totals from the original given data table. I need to see that you know how to compute the amounts. 5) Compute the Per-Unit cost for each cost item (in column P)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
