Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting

Authors: John Burns, Martin Quinn, Liz Warren, João Oliveira

1st Edition

0077121619, 978-0077121617

More Books

Students also viewed these Accounting questions