BUSI 620 MENTOR Learn Do Live /busi620mentor.com BUSI 620 MENTOR Learn Do Live /busi620mentor.com | Page 21

1 7 4 Average variable costs $20 Project selling price $30 Determine the breakeven output and total sales revenues and draw the cost-volume-profit chart Determine the output that would generate a total profit of $60,000 and the total sales revenues at that output level; draw the cost-volume-profit chart. Spreadsheet problem 1: For the following table, calculate in Excel the average fixed costs (AFC), the average variable cost (AVC), the average total costs (ATC), and the marginal costs (MC).(note total fixed cost=$30) Salvatore’s Chapter 9: a) Problems: 7, 11, and spreadsheet problem 1. Problem 7: From figure 9-4, determine the effect of a 33 percent tariff on commodity X