No Paperwork. Please do it in excel step by step with formulas to understand

Q1. (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 A Weekly Operating Costs ($1000's) $5 $6 $2 $7 Mining Costs Per Ton ($1000's) $12 $ 8 $14 $6 Maximum Weekly Output (Tons) 10 20 25 15 B D