please help with question 1. please answer question in table format. thank you

the website that was posted in the scenario is attached showing the price of gas in ny harbor. please help with question 1. Thanks

BICI DEL G H I Cal Overhaut operates an ExxonMobil gas station franchise in Fitzhugh, MD. The price of gasoline is volatile and varies significantly from day to day. The price per gallon varies based on the seasonal blend of gasoline, which is determined by clean-air requirements. Cal's pricing options are based on the desired profit margin. Base Addec Conventional Gasoline Regular Spot Prices can be found at https://www.eia.gov/dnav/pet/hist/EER EPMRU_PF4_Y35NY_DPGD.htm. Cal recently raised the price of regular gas by 1 cent per gallon from $2.749 to $2.759, and his profit declined. Cal would like you to explain why that happened. Total Cal competes with another gas station across the street that typically sells regular gas for 2 to 3 cents per gallon less than his station. They are currently selling gasoline for $2.729 per gallon. Recently, regular gasoline for delivery in New York harbor sold for $1.740 per gallon. Cal tells you that his gas station has fixed operating costs of about $250 per day. To the right are the components that determine the cost of a gallon of regular gasoline to Cal's business. mmm Answer the seven questions below. You are required to use Excel for all calculations. Answer Quant _ _ ZA The L M O Q R Base price of unleaded regular delivered in New York harbor (October 21, 2019) $1.740 L Added cost to Cal: Maryland state gasoline tax (Effective July 1, 2018) Federal gasoline tax Distribution & Delivery Advertising and Marketing to ExxonM Additives Total additions $0.353 $0.184 $0.042 $0.042 $0.020 $0.641 | Total cost per gallon $2.381 Answer question 1 below. 1. Last week, Cal sold an average of 4,000 gallons per day at an average price of $2.749 per gallon. This week, he raised the average price by 1 cent to $2.759 per gallon, and both revenues and profits dropped. His station is now selling an average of 3,600 gallons per day. Fixed costs of operating the gas station are $250 per day. What is the price elasticity of demand? Can the demand be characterized as price elastic, price inelastic, or neither? By how much did revenues increase or decrease as a result of the change in price? 3 Answer question 1 below. 4 Quantity Price 5 4000 L 2.749 26 3600 2.759 27 Average Average 3800 2.754 29 % change % change Elasticity of Demand B0 32 Elasticity: Select One 33 By how much did revenues increase or decrease as a result of the change in price? 34 By how much did profits increase or decline? 35 Variable Gallons Revenue (price x Cost (cost Fixed cost per sold per Cost per Gallon gallons) per unit x day day volume) 4000 S 2.749 $ 10,996.00 $ 2.381 S 9,524.00 $ 250.00 $ 38 3600S 2.759 Price Total Cost Daily Profit (Fixed + (revenue - all Variable) costs) 9,774.00 $ 1,222.00 40 Answer question 2 below. 41 Ouantity Drico Supply and Demand Graph Calculate Profit Maximization