Need answers to number 1 - 6, thank you Cookie Co. produces three products: coffee beans, tea bags, and chai. The following monthly information is available regarding Cookie Co. manufacturing costs and production volumes. Total Pounds of coffee Number of tea Boxes of chai Month Manufacturing beans produced bags produced produced Costs April, 2019 $1,709,880 13,800 15,000 1,500 May, 2019 $1,708,550 13,350 11,250 2,100 June, 2019 $1,667,130 12,750 7,500 2,400 July, 2019 $2,647,000 14,780 10,150 5,400 August, 2019 $1,918,680 14,330 7,500 3,160 September, 2019 $1,907,030 13,950 10,500 3,600 October, 2019 $1,785,650 13,830 11.250 2,100 November, 2019 $1,569,750 12,530 7.900 1,800 December, 2019 $1,698,350 12.980 8,250 2,560 January, 2020 $1,904,000 14,250 13,150 3,160 February, 2020 $1,906,530 13,950 10.500 3,600 March, 2020 $1,596,150 13,150 L 12,750 1,200 Requirements: 1. Using Excel, prepare a multiple regression analysis to estimate total manufacturing costs using coffee, tea bags, and chai. 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. Based on the regression output, are you confident that each of the independent variables affects the total manufacturing costs? Why or why not? 5. Cookie Co. plans to produce 14,000 pounds of coffee beans, 11,000 teabags, and 1,600 boxes of chai in May 2020. Using your cost-estimating equation, what is the estimated total manufacturing cost for May 2020? 6. You have a special-order opportunity assume that you have sufficient excess capacity to complete the order). A customer has offered to buy 500 boxes of chai for $225 per box. You normally sell Chai for $275 per box. Should you accept the order? Why or why not