I need help doing this in excell!!

Madison Inc. is anenvironmentally friendly company which sells packed organic vegetables in biodegradable bags Currently the monthly fixed cost associated with its operation is estimated at 847,000. The variable cost of a bag is $2.20 and it is currently sold for $2.70.Curly, the monthly production volume is 90,000 bags and the maximum operating capacity is 120,000 bags per month. 1. Develop a spreadsheet model on a monthly basis for the situation described above: Be sure to put all numeical values in separate cells from formulas. Format all dollar amounts with $ signs and 0 decimals for all values, except for the variable cost and the selling price (2 decimals). Format all other numerical amounts as Number with thousands separator Name this sheet Madison Model. 2. Write a formula to caleulate the monthly break-even number of vegetable bags on your spreadshe Format thiscell as a number with a comma and 0 decimals. Also write a formula to compute the break-even number of bagsas a percentage of the maximum capacity. Format this cel as a percentage with 0 decimals. 3. The company is considering increasing the eling price per bag. Construct a data table based on your spreadsheet model using Excel's Data Table command to show the monthly break-even number of vegetable bags and percentage of maximum capacity with a price ranging from $2.50 to $3.00 per bag (in increments of $0.10) . Put a border around the contents of the table Format the amount inside the table as a Number with 0 decimals, Format percent values inside the table as Percentage with 0 decimals. 4. The company is considering changing its production process to add an extra layer to the bag to reduce refrigeration times that would increase the cost of a bag. Management want to see how profit reacts to changes in both the variable cost and the selig price. Construct a data table based on your spreadsheet model using Excel's Data Table command to show the net profit associated with the selling price ranging from $2.50 to $3.00 (in increments of $0.10) as the variable cost per bag varies from 81.8 to S2.5 (in increments of $0.10 across the top of the table) [Two Way Data Table] Put a border around the contents of the table Format all dollar amounts as Currency with 0 decimals . Apply conditional formatting to the cells in the table that exceed S11,000. 5. Createie charts showing the et profit for per-bag prices of $2.50, $2.70, $2.90 using the corresponding 8 columns of your data table: three lines in one graph] . Move this chart to a "New Seet . Use appropriate axis titles. . Name each data series with the corresponding price in a chart legend on the right 6. Answer the questions at the end of this document for the company's management This assignment should be completed according to the Instructions for Analytics Exercises (available on Canvas) Please print copies of the following items to turn in: . Cover sheet prepared as described in the instructions. Model worksheet withdata tables . Print with Excel's grid-line and row/column headings Fomat Landscape tofit 1 page Formulas for the Model worksheet .Chart shee, formatted Landscape Neatly handwritten or typed answers to the questions below Place your pages in order listed above and staple them together. Also, submit your Excel file in the Assignment on Canvas Questions 1. If the company changes the selling price per bag from $2.70 to $2.90, this will (increase/decrease) the mont hly break-even volume from 0 bags. 2. The relationship between pric and break-even percentage of maximum production capacity is 3. Raising the selling price to $2.80 per bag will... . . .. . . . . . .. . .. (increase/decrease) monthly net profit om to assuming the variable cost remains 82.20 and monthly sales volume is 90,000 bags