I’m working on a management multi-part question and need support to help me study.1. please provide excel work for the following A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $9,200 per month and vari-able costs of 70 cents per unit produced.
Each item is sold to retailers at a price that averages 90 cents.
a. What volume per month is required in order to break even?
b. What profit would be realized on a monthly volume of 61,000 units? 87,000 units?
c. What volume is needed to obtain a profit of $16,000 per month?
d. What volume is needed to provide a revenue of $23,000 per month?
e. Plot the total cost and total revenue lines.
Requirements: 1 page