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: 3. Given the Excel spreadsheet below, write the sumproduct formula that calculates Total Variable Cost. Excel formula: =SUMPRODUCT(B3:D3,B4:D4) Total variable cost = 10085 4. Write an Excel formula for Unit Cost of each of the products given the levels indicated in the spreadsheet in Question 3. Unit cost is defined as the Total cost (fixed plus total variable costs) for a product divided by the number of units produced. Product A Product B Product C = ((B3*B4) +B2)/ (B4) =((C3*C4)+C2)/(C4)=((D3*D4)+D2)/(D4) Unit Cost=$11.20 Unit Cost=$5.32 Unit Cost=$8.22...
View Full Document
This note was uploaded on 03/01/2010 for the course AGEC 352 taught by Professor Staff during the Spring '08 term at Purdue University-West Lafayette.
- Spring '08