I have this homework needed to be done asap on excel sheet

Autosave .w 'n' E r3: V3 Assignmentz Home Insert Draw Design Layout References Mailings Review '7 Tell me E? Share Cl Comments 1 i n ' '. L V ' ' AaBchodEe AaBchDdEe AaBchD( AaBchDdEt AaBchDd Ee ) l 7' l 7'} V Paste ; .7 , : ' . . Normal No Spac Head 1 He: g 2 Sum Styles Dictate Pane Suppose your company produces perfume which is sold at $105 per ounce. Producing one ounce of perfume requires 2.5 units of chemical C and 3.5 units of chemical E, which are purchased from two different vendors. The vendor of chemical C charges based on the following policy: Units of C to urchase Unit Price 1 unit ~ 9,000 units $25 9,001 units or more $25 for the rst 9000 units and then $12 for each remaining unit For example, if you buy 9,005 units of C, then the purchasing cost will be 25*9000+12*5. The vendor of chemical E charges based on the following quantity discount policy: + Units of E to urchase Unit Price 11,000 units or above $22 5,000 units ~ 10,999 units $25 Below 5,000 units $30 For example, if you buy 6,000 units of E, your cost of purchasing will be 525'6000. Your profit will be: How many ounces of perfume * price of perfume purchasing costs of chemical A purchasing cost of chemical B. Tasks: 1. Build a model that calculate profit giving ounces of perfume to produce. pageiore 7awo : E13 English(UnitedStateS) Autosave .w 'n' E r3: V3 Assignmentz Home Insert Draw Design Layout References Mailings Review '7 Tell me E? Share Cl Comments 1 . , l-t a * L v Calibn (Bo... v 1'l v H . AthCchEe AaBchDdEe AaBchD( AaBchDdEt a Bb AaBchDdEe ) l A ' Paste /, B y I l V y? x X ' . Normal No Spac 9 He: g1 Head g 2 lle Sub 6 Styles Dictate Pane Your profit will be: How many ounces of perfume * price of perfume - purchasing costs of chemical A purchasing cost of chemical B. Tasks: 1. Build a model that calculate profit giving ounces of perfume to produce. As shown above, you can enter any number in El, and then the model automatically calculates the corresponding profit. Of course, you can use other cells for intermediate calculations. For example, you can calculate how many units of C and how many units of E are needed. 2. Create a data table (a what-if analysis tool). Let the first column be how many ounces of perfume produced and let this column change from 1000 to 9,000 with an increment of 200 (Le, 1000, 1200, ..., 9000). For each row calculate the corresponding profit in column 2 based on the model you build in task 1. Note that you need to use data table. Name this worksheet as "Ql". Page i of 6 7 Words E13 Erigl 1 (United State