Use the amounts you computed in the Excel Template to complete items (a) through (h):

The variable manufacturing cost per unit for this product is _______

The total variable cost per unit for this product is ______

The total fixed manufacturing cost for this product is

The total fixed cost for this product is ________

The total manufacturing cost when 1,000 units are produced is ________

The total cost when 1,000 units are produced is _______

The manufacturing cost per unit when 1,000 units are produced is _______

The total cost per unit when 1,000 units are produced is ______

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 cel 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 cel 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)