This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: =Sumproduct(B3:D3,B4:D4) 3. Write an Excel formula for Unit Cost of each of the products given the levels indicated in the spreadsheet in Question 3. The unit cost is the average cost per unit. Therefore we can calculate Total cost and divide by the quantity for each product. This formula for product A is given below: =(B2+B3*B4)/B4 Alternatively, since we already know the variable cost per unit, we could calculate the fixed cost per unit and add the two together. This formula for product A is given below: =B3+B2/B4...
View Full Document
- Fall '08
- line graph