Answers to 1-5 please, The chart needed to answer the question is in the word document. If you can provide an explanation on steps to create the excel that would be appreciated, but not necessary.

Coffee Co. produces three products: coffee beans, tea bags, and chai. The following monthly information is available regarding Coffee Co.'s manufacturing costs and production volumes

Requirements:

1. Using Excel, createmultiple regression analysis to determine the unit cost of each product.
2. What is the cost-estimating equation based on your multiple regression analysis?
3. How much of the variation in monthly cost is explained by your cost-estimating equation? Do you think that this equation does a good job estimating production costs? Why or why not.
4. Coffee Co. plans to produce 4,000 pounds of coffee beans, 27,000 teabags, and 800 boxes of chai in May 2018. Using your cost-estimating equation, what is the estimated total manufacturing cost for May 2018?
5. You have a special-order opportunity (assume that you have enough excess capacity to complete the order). A customer has offered to buy 500 boxes of chair for $425 per box. Should you accept the order? Why or why not.