Requirement 1: Design an excel worksheet to calculate the necessary intend in question 3-12. You should design a DATA tab that includes exhibit 1 and exhibit 2 from the case. Then design an analysis tab to answer the questions using formula only.Requirement 2.In a memo, communicate the results from requirement 1. Answer all questions from 3-12 from the case requirement in your memo. Make sure you use your data visualization to communicate your computational answers in the forms of chart, tables, graph etc

Exhibit 1 Selected product grades with production and financial data Product (Grade) Average Caliper Material Cost Coated/Uncoated Selling Price Slit Reels per Batch per Reel A 013 per Reel Coated yes 50 $4,800 $12,600 B 014 Uncoated no 2 $5,200 $13,500 C 015 Coated yes 35 $5,600 $14,200 D .920 Coated no 175 $7,400 $19,500 Exhibit 2 Overhead Structure Total Grade Change Slitting Net Depreciation $800,000 $8,000 $70,000 $722,000 Labor 300,000 3,000 25,000 272,000 Energy 500,000 5,000 80,000 415,000 Other 198,470 1,000 20,000 177,470 Unrecoverable Clay and Chemicals from Grade Changeovers 30,000 30,000 -0- Total $1,828,470 $47,000 $195,000 $1,586,470