show formulas please

thats all the information provided. I need help with the chart

1. Create a table to compute the revenue, variable costs, fred costs, and total colta for each volume to use in creatieg your eraph. \begin{tabular}{l} Cost-Volurhe-froft Analysis \\ \hline Using Excel for cost-Volume-Profit (CVP) Analysis \\ \hline \end{tabular} The Oceanside Garden Nursery buys flowering plants in four-inch pots for $2.00 each and sells them for $4.00 each. Management budgets monthly fixed costs of $2,800 for sales volumes between 0 and 9,500 plants. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to recelve full credit. If you copy/paste from the Instructions tab you will be marked wrong. Requirements: 1. Create a table to compute the revenue, variable costs, fixed costs, and total costs for each volume to use in creating your graph. 2. Use the contribution margin approach to compute the company's monthly breakeven point in units, 3. Use the contribution margin ratio approach to compute the breakeven point in sales dollars. 4. Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $8,000. 5. Use the contribution margin approach to compute the monthly sales level (in units) required to increase the target operating income of $8,000 by 15% and increase advertising costs by $1,400. 6. Use the contribution margin approach to compute the margin of safety (in units) using the target operating income of $8,000. 7. Use the high low method and the units and associated total costs from Requirement 3 if targeted operating income was $8,000 and the units and associated total costs if targeted operating income was $9,000 to develop the mixed cost formula for our flowering plants business. 8. Prepare a graph of the companys CVP relationships, Include the sales revenue line, the fixed cost line, and the total cost line by completing the table below. Create a chart title and label the axes. Excel Shalls: 1. Create formulas with cell references. 2. Format the cells as accounting number format or percent style. 3. Prepare a breakeven chart. Add chart title and x-axis description. 4. Use the Excel function ROUNDUP to obtain units in whole mumbers needed to achieve a minimum target operating income. 1. Createa table to compute the revenue, variable costs, fixed costs, and total' costs for each wolume to use in creating your graph. \begin{tabular}{|l|r|r|r|r|r|r|r|r|r|r|r|} \hline Volume & 0 & 200 & 400 & 600 & 800 & 1,000 & 1,200 & 1,400 & 1,600 & 1,800 & 2,0 \\ \hline Revenue & & & & & & & & & & & \\ \hline Sariahiefratt & & & & & & & \end{tabular} Excelsh: 1. Create formulas with cell references. 2. Format the cells as accountine number format or percent style. 3. Prepare a breakeven chart. Add chart titie and x-axis desoription. 4. Use the Excel function ROUNDUP to obtain units in whole numbers needed to athieve a minimum target ogerating iraome. 1. Create a table to compute the revenue, variable costs, fred costs, and total colta for each volume to use in creatieg your eraph. \begin{tabular}{l} Cost-Volurhe-froft Analysis \\ \hline Using Excel for cost-Volume-Profit (CVP) Analysis \\ \hline \end{tabular} The Oceanside Garden Nursery buys flowering plants in four-inch pots for $2.00 each and sells them for $4.00 each. Management budgets monthly fixed costs of $2,800 for sales volumes between 0 and 9,500 plants. Use the blue shaded areas on the ENTERANSWERS tab for inputs. Always use cell references and formulas where appropriate to recelve full credit. If you copy/paste from the Instructions tab you will be marked wrong. Requirements: 1. Create a table to compute the revenue, variable costs, fixed costs, and total costs for each volume to use in creating your graph. 2. Use the contribution margin approach to compute the company's monthly breakeven point in units, 3. Use the contribution margin ratio approach to compute the breakeven point in sales dollars. 4. Use the contribution margin approach to compute the monthly sales level (in units) required to earn a target operating income of $8,000. 5. Use the contribution margin approach to compute the monthly sales level (in units) required to increase the target operating income of $8,000 by 15% and increase advertising costs by $1,400. 6. Use the contribution margin approach to compute the margin of safety (in units) using the target operating income of $8,000. 7. Use the high low method and the units and associated total costs from Requirement 3 if targeted operating income was $8,000 and the units and associated total costs if targeted operating income was $9,000 to develop the mixed cost formula for our flowering plants business. 8. Prepare a graph of the companys CVP relationships, Include the sales revenue line, the fixed cost line, and the total cost line by completing the table below. Create a chart title and label the axes. Excel Shalls: 1. Create formulas with cell references. 2. Format the cells as accounting number format or percent style. 3. Prepare a breakeven chart. Add chart title and x-axis description. 4. Use the Excel function ROUNDUP to obtain units in whole mumbers needed to achieve a minimum target operating income. 1. Createa table to compute the revenue, variable costs, fixed costs, and total' costs for each wolume to use in creating your graph. \begin{tabular}{|l|r|r|r|r|r|r|r|r|r|r|r|} \hline Volume & 0 & 200 & 400 & 600 & 800 & 1,000 & 1,200 & 1,400 & 1,600 & 1,800 & 2,0 \\ \hline Revenue & & & & & & & & & & & \\ \hline Sariahiefratt & & & & & & & \end{tabular} Excelsh: 1. Create formulas with cell references. 2. Format the cells as accountine number format or percent style. 3. Prepare a breakeven chart. Add chart titie and x-axis desoription. 4. Use the Excel function ROUNDUP to obtain units in whole numbers needed to athieve a minimum target ogerating iraome