Fixed costs of 25000 per month are allocated to the


A producer of felt-tip pens has received a forecast of demand of 30,000 pens for the coming month from its marketing department.

Fixed costs of $25,000 per month are allocated to the felt-tip operation, and variable costs are 37 cents per pen.

Explain and please provide the excel formulas.

a) Find the break-even quantity if pens sell for $1 each.

b) At what price must pens be sold to obtain a monthly profit of $15,000, assuming that estimated demand materialized?

Solution Preview :

Prepared by a verified Expert
Operation Management: Fixed costs of 25000 per month are allocated to the
Reference No:- TGS02717286

Now Priced at $15 (50% Discount)

Recommended (94%)

Rated (4.6/5)