1. DATA SECTION Selling price per unit Variable cost per unit--manufacturing --S&A Total fixed costs --...

Transcribed Image Text:

1. DATA SECTION Selling price per unit Variable cost per unit--manufacturing --S&A Total fixed costs -- manufacturing --S&A $32.00 15.00 6.00 24,000 21,000 2. TABLE SECTION Compute the following for various sales volume levels. (Start with 0 units and increase the units sold by 500 units. Enter the sales volume in a column). You need to go on for whatever it takes to view the breakeven point nicely in the middle of the graph. Sales revenues Total variable cost Required: Total Contribution margin Fixed cost Total costs (variable and fixed) Income before tax 1. Plot the Sales Volume in units as independent variable (X axis) versus the following dependent variables (Y axis) (all in one graph) Sales Revenue dollars Fixed cost dollars Total cost dollars 2. Plot the Sales Volume in units as independent variable (X axis) versus Income before tax (Y axis). Be sure to label the graph axes appropriately, and to include a legend identifying the lines. 3. Show the entire worksheet on one page as a formal business report (i.e., suppress grid lines and row and column headings...do not include the graphs in this report but attach the two graphs as two separate tabs). Use data given in Section 1 above. 4. Redo the entire worksheet on one page again as a formal business report, changing the selling price to $33. No need for the graphs here. 1. DATA SECTION Selling price per unit Variable cost per unit--manufacturing --S&A Total fixed costs -- manufacturing --S&A $32.00 15.00 6.00 24,000 21,000 2. TABLE SECTION Compute the following for various sales volume levels. (Start with 0 units and increase the units sold by 500 units. Enter the sales volume in a column). You need to go on for whatever it takes to view the breakeven point nicely in the middle of the graph. Sales revenues Total variable cost Required: Total Contribution margin Fixed cost Total costs (variable and fixed) Income before tax 1. Plot the Sales Volume in units as independent variable (X axis) versus the following dependent variables (Y axis) (all in one graph) Sales Revenue dollars Fixed cost dollars Total cost dollars 2. Plot the Sales Volume in units as independent variable (X axis) versus Income before tax (Y axis). Be sure to label the graph axes appropriately, and to include a legend identifying the lines. 3. Show the entire worksheet on one page as a formal business report (i.e., suppress grid lines and row and column headings...do not include the graphs in this report but attach the two graphs as two separate tabs). Use data given in Section 1 above. 4. Redo the entire worksheet on one page again as a formal business report, changing the selling price to $33. No need for the graphs here.