This preview shows pages 1–2. Sign up to view the full content.
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
This note was uploaded on 02/25/2010 for the course AGEC 352 taught by Professor Staff during the Fall '08 term at Purdue University-West Lafayette.
- Fall '08