PLEASE ANSWER IN EXCEL FORM WITH EXACT CELL FORMULAS USED TO SOLVE EACH OF THE YELLOW BOXES.

K-Too Everwear Corporation can manufacture mountain climbing shoes for $35.85 per pair in variable raw material costs and $26.45 per pair in variable labor expensse. The shoes sell for $165 per pair. Last year, production was 145,000 pairs. Fixed costs were $1,750,000. What were total production costs? What is the marginal cost per pair? What is the average cost? If the company is considering a one-time order for an extra 5,000 pairs, what is the minimum acceptable total revenue from the order? Variable material cost 35.85 Variable labor cost 26.45 Sales price $ 165.00 Production 145,000 $ 1,750,000 Fixed costs Extra order 5,000 Complete the following analysis. Do not hard code values in your calculations. A A A Complete the following analysis. Do not hard code values in your calculations. Total costs Marginal cost Average cost Minimum acceptable revenue