I need help with b and how to construct the graph in excel?

b. Prepare a cost-volume-profit graph. Label the horizontal axis in units with a maximum value of 8,000. Label the vertical axis in dollars with a maximum value of $1,000,000. Draw a vertical line on the graph for the current (4,000) unit sales level, and label total variable costs, total fixed costs, and total profits at 4,000 units.

Contribution Income Statement and Cost-Volume-Profit Graph Picnic Time produces a picnic basket that is sold for $100 per unit. Assume the company produced and sold 4,000 baskets during July. There were no beginning or ending inventories. Variable and fixed costs follow. Variable Costs per Unit Fixed Costs per Month Manufacturing overhead.. $ 36,000 Selling and administrative.. 68,000 Total. $104,000 Manufacturing: Direct materials. Direct labor.. Manufacturing overhead. Selling and administrative. Total $25 15 5 $45 4 $49 Required a. Prepare a contribution income statement for July. b. Prepare a cost-volume-profit graph. Label the horizontal axis in units with a maximum value of 8,000. Label the vertical axis in dollars with a maximum value of $1,000,000. Draw a vertical line on the graph for the current (4,000) unit sales level, and label total variable costs, total fixed costs, and total profits at 4,000 units