Question Show a step by step on Excel please 3) (20 pts) Let the amount of product we produce be G [gallons per year]. Consider the following costs: Fixed costs: $1 million, Variable cost: 10 cents/gallon of G Selling price: 25 cents/gallon of G Plot the total cost and the revenue (use different colors and include a legend) versus the quantity produced in the same plot. Determine the amount of G that must be produced to break even. Assume we sell everything we produce.

FULGCJ The Asker · Mechanical Engineering

Show a step by step on Excel please

Transcribed Image Text: 3) (20 pts) Let the amount of product we produce be G [gallons per year]. Consider the following costs: Fixed costs: $1 million, Variable cost: 10 cents/gallon of G Selling price: 25 cents/gallon of G Plot the total cost and the revenue (use different colors and include a legend) versus the quantity produced in the same plot. Determine the amount of G that must be produced to break even. Assume we sell everything we produce.
More
Transcribed Image Text: 3) (20 pts) Let the amount of product we produce be G [gallons per year]. Consider the following costs: Fixed costs: $1 million, Variable cost: 10 cents/gallon of G Selling price: 25 cents/gallon of G Plot the total cost and the revenue (use different colors and include a legend) versus the quantity produced in the same plot. Determine the amount of G that must be produced to break even. Assume we sell everything we produce.
Community Answer
W64O8Z

ANSWER:- Gecction. Fixed costs => F million =F*CReencee =0.25 xx > gallons of prodeect peryear.=> plot there using Excel.=> Break pi point =>=> Mo profit, no lossSo. Total cost = tolal ... See the full answer