Show formulas please

OHNSMITH'S NEWBUSNESS John Smith is about to launch a new e-commerce business, and has decided to offer his customers a 25% discount for subsequent purchases of three or more additional units made after the purchase of first unit at full price. The region he wishes to serve has 1,000,000 potential customers, and John believes that 5% of these may make an initial purchase if he initially sells his product at $55 per unit. He also believes that 40% of the customers who buy one unit of the product at full price will buy three additional units at the planned discount of 25%. He thinks that any customer making a subsequent purchase is unlikely to buy just one or two additional units (since the 25% discount only applies for a subsequent purchase of three or more units) or four additional units (since most people need at most four units of his product in total). John currently estimates his fixed costs at $600,000; selling price at $55 per unit, and variable costs at $19 per unit. He can of course change the selling price and the discount percentage if this change can increase his profit. (44 points 1) Create a spreadsheet model (using MS-Excel) that clearly shows assumptions / inputs, intermediate calculations, and final result. 30 points (25 points for correct model, 5 points for making the model look presentable) 2) Perform a sensitivity analysis by creating a tornado chart covering +/-10% change in the values of the following variables. 10 points (8 points for correct tornado chart, 2 points for proper formatting and labeling) a) % of potential customers who make the initial purchase b) % of initial purchases that lead to a subsequent purchase c) % discount offered for the subsequent purchase d) Fixed costs e) Variable costs 3) Name and print-format your file EXACTLY as instructed. 4points 664 words English (United States) F3 FS F7 F8