No paperwork Please. Do it in excel step by step inserting formulas in the cells.

01. (15 points) Cape Breton Coal Company (CBCC) must mine a minimum of 30 tons of coal weekly from any of four sites. Relevant data concerning fixed weekly operation costs of the sites, variable mining costs per ton of coal, and estimated maximum weekly output of coal at each site are given in the following table. Formulate a mixed integer programming model and solve for the CBCC management mining strategy that will minimize total weekly costs. Site Weekly Operating Costs ($1000's) $5 $6 $2 $7 Mining Costs Per Ton ($10005) $12 $8 $14 $6 Maximum Weekly Output (Tons) 10 20 25 IS B D