Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Oceanside Garden Nursery buys flowring plants in four-inch pots for $1.50 each and sells them for $3.00 each. Managment budgets monthly fixed costs of
The Oceanside Garden Nursery buys flowring plants in four-inch pots for $1.50 each and sells them for $3.00 each. Managment budgets monthly fixed costs of $2,600 for sales volumes between 0 and 7,500 plants. Prepare a graph of the company's CVP relationships. Include the sales revenue lone, the fixed cost line, and the total cosy line by completeing the table beloe. Creat a chart title and lablr the aces.
244 25 Chart assistance 26 27 ANASHARE: 28 25 30 31 32 33 34 35 36 37 38 39 40 41 43 43 44 45 46 47 48 49 50 51 52 59 34 Ready Create a table to compute the revenue, variable costs, fixed costs, and total costs for each volume to use in creating your graph. Volume Revenue Variable Costs Fixed Costs Total Cost 0 200 Instructions 400 ENTERANSWERS1 600 To create the graph 1. Once the data are entered, select the following four rows using the CTRL key to select non-contiguous cells Volume, Revenue Fixed Costs, and Total Cost This means you select Rows 25, 26, 28 and 29, Column & through Colume O ENTERGRAPH 2. Select the insert tab, select "scatter or bubble chart" from the chart menu, then click "Scatter with Smooth Lines and Markers Night click and move the chart to the Graph tab 256 800 1,000 Seker la pet Se + 1,200 1,400 M term 1,600 1,800 2,000 2,200 2,400 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started