subject
Business, 23.03.2020 19:58 tmrsavage02p7cj16

Cox Electric makes electronic components and has estimated the following for a new design of one of its products:

Fixed Cost = $10,000
Material cost per unit = $0.15
Labor cost per unit = $0.10
Revenue per unit = $0.65
Production Volume = 12,000

Per-unit material and labor cost together make up the variable cost per unit. Assuming that Cox Electric sells all it produces, build a spreadsheet model that calculates the profit by subtracting the fixed cost and total variable cost from total revenue, and answer the following questions.

Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = total cost, yielding a profit of zero. Vary production volume from 5,000 to 50,000 in increments of 5,000. In which interval of production volume does breakeven occur?

ansver
Answers: 1

Another question on Business

question
Business, 22.06.2019 01:30
Can you post a video on of the question that you need on
Answers: 2
question
Business, 22.06.2019 05:30
Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?
Answers: 2
question
Business, 22.06.2019 10:30
Perez, inc., applies the equity method for its 25 percent investment in senior, inc. during 2018, perez sold goods with a 40 percent gross profit to senior, which sold all of these goods in 2018. how should perez report the effect of the intra-entity sale on its 2018 income statement?
Answers: 2
question
Business, 22.06.2019 11:40
Select the correct answer brian wants to add a chart to his dtp project. what is the best way he can do this? a draw the chart using the dtp program draw option b create the chart in a spreadsheet then import it c. use the dtp chart wizard to create the chart within the dtp d. create an image of the chart in an image editor then import the image e use html code to create a chart within the dtp program
Answers: 3
You know the right answer?
Cox Electric makes electronic components and has estimated the following for a new design of one of...
Questions
question
History, 29.06.2019 06:30
question
Mathematics, 29.06.2019 06:30
Questions on the website: 13722360