please provide formulas i need

Problem 4: Estimates A company purchases Olive oil according to this price schedule. For the first 1000 Litres, $7.10 per litre For any of the next 3000 Litres 56.60 per litre For any oil beyond 4,000 Litres, 55 80 per litre The Purchase Estimate spreadsheet calculates the total price of buying x litres of oil, wherexia number input to a cell (Ordered) on the worksheet with values that may fall into any or all of the 3 Tiers of pricing Re-create the model as per below: 1. The model can handle any/all 3 tiers of order scenarios 2. Format with differentiating colors as per example below. Hint: Key functions to use: IF Here are 3 possible output examples you can use to test your solutions: Purchase Estimates Ordered: 6,500 Purchase Price scheduler Oy 1.000 lel First 1000 . t3000 Ltr. Tieri: Tier2 To Figure 6 - Scenario1: Tier 3 Ordered>4000) Purchase Estimates: Ordered: 2.900 Purchase Price schedule First 1000 Lt. Tert: Next 1000 Lt. Tera: Tier 1.000 el 1.100 lei Total Total Price Figure 7 - Scenario2: Tier 2 Ordered (0-1000) Purchase Estimates Ordered: 900 IT Next 1000 Lt. TP Figure 8 - Scenario: Tier 1 Ordered (0-1000 Estimates - Excel Data Review View Page Layout Formulas H AutoSave Off File Home Insert X Cut Copy Paste Format Painter Clipboard Calibri 11. AA== BIU - BA Font SE Alignme F22 A 1 Purchase Estimates: B C D E Ordered: Price Qty Total 3 Purchase Price Schedule: 14 First 1000 Ltrs. Tier1: 5 Next 3000 Ltrs. Tier2: 6 Above 4000 Ltrs. Tier3: @ @ @ Total: Total Price: 5/9 Problem 4: Estimates A company purchases Olive oil according to this price schedule: . For the first 1000 Litres, $7.10 per Litre For any of the next 3000 Litres $6.60 per Litre For any oil beyond 4,000 Litres, $5.80 per Litre The Purchase Estimate spreadsheet calculates the total price of buying x Litres of oil, where x is a number input to a cell (Ordered) on the worksheet with values that may fall into any or all of the 3 Tiers of pricing. Re-create the model as per below: 1. The model can handle any/all 3 tiers of order scenarios. 2. Format with differentiating colors as per example below. Hint: Key functions to use: IF Here are 3 possible output examples you can use to test your solutions: Purchase Estimates Ordered: 6,500 Purchase Preschedule aty Price Tier 1.000 lel 7.10 Tier 1.000 The P 5 .10 14.300 Total Price Figure 6 - Scenario: Tier 3 Ordered >4000) Purchase Estimates Ordered: 2.900 1,000 Perchase Price schedule: Furst 1000 LET. Ter Next 1000 Lt. Above 4000 LOL Teri Total 2.900 Figure 7 - Scenario2: Tier 2 Ordered (0-4000) Parchase times Ordered: 900 harthane Nie wchedule