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
- Spring '08