Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to solve it with explanation as soon as possible. Regional Expense Data January February March April Mag June Month July August September October

I need to solve it with explanation as soon as possible. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Regional Expense Data January February March April Mag June Month July August September October November December Region South East (astern Centr North Eastern North West South Vest Midvest $133.555 $104.332 $129,768 $137431 $136.496 $140,990 311321 $123.560 $130,367 $18.301 $150561 $115.151 $164.94 $99.92 $155,130 $160.459 $150.057 $109.200 $16,439 $16.684 3100,843 $159,635 $109.823 7.929 $104,892 $122.966 $170,706 $154,846 $170.680 $160,657 $154,505 $172,900 3108,384 $99,186 161736 $1.505 $115,889 $148,180 3137.100 3134.938 $135,589 $128.592 $168.420 $127.155 3102.306 0.602 $117.154 $169402 168,076 $127,537 $165.233 94.983 $80.235 $160906 12:30 $12,067 $117.558 $134.400 $119,830 1167 463 $172,366 310161 $88.216 $169,732 11.071 107.6.29 197434 $15.02 $152.166 $140 742 1126,732 $110.161 June Regional Revenue Data North Eastern Eastern Central Region South East Midvest North West South Vest Januarg $803,186 1146,749 $144,337 159.394 195,371 19238 February $133.641 $117,379 $104.733 8,094 1952.405 $1257 March $133.IN 152362 $137.32 $116.827 302,370 1103360 April 596, $108.308 3156,658 1H2,770 1802.186 1147818 Sales Data For 2013 May 196032 3150.057 119,890 136 $109.823 $14.071 398,106 170.680 $126,784 1112,709 $161736 $129,561 126,036 3075.589 $115,158 145.789 1.117 156 1199 200 August September October November December $1239 $168,094 $99.186 $136.96 1127155 $172,856 $152.405 300400 3151561 $127.537 $107.629 $103.257 $96,602 $150.057 $12,067 110,161 12.16 1,800 309.823 10LT $100,106 152.962) 1034.400 $170.00 1150 16749 $137.802 169.783 136738 Car Profitability (Revenue Expense) Analysis December Eastern Central The only calls you are allowed to change we the yellow and blue cells This sheet contains monthly revenue and expense data for 2019 for the six sales regions in a company. Develop a query that will allow you to observe the profitability of a particular region in a particular month in cell G32 (the yellow cell) by selecting the region name in cell F32 and the month in cell G31. Use the MATCH and OFFSET commands to create a single formula in cell G32 that computes the profitability (Revenue minus Expense) of the region and month specified in cells F32 and G31 respectively. Use Data Validation to provide a drop-down list of permissible entries for the cells F32 and G31. . Notes: you will need to subtract the results of two OFFSET/MATCH functions in the same formula. Observe that the tables refer to the same regions and months, but the orientations of the tables differ and the regions in the two tables are not in the same sequence. You are not able to change the orientation or sequence of either table. All your work must be done in the single yellow cell - no other modifications to the workbook are allowed except the data validation changes. Make sure the answer is in correct currency format (with dollar sign and parenthesis if the value is negative) Check 1. In November, the North Eastern region gained $28,280. Hence format = $28,280. Check 2. In November, the South East lost $17.406. Hence format -S(17.406) or -17.406. D N Regional Expense Data January February March April May Month June July August September October November December Region South East Eastern Centre North Eastern North West South West Midwest $133,555 $104,332 $129,760 $137,431 5136,496 $129,561 5140990 5111,321 $133.987 5116,331 5151,561 5115, 151 5164,914 599 392 5155,133 5160.450 3150057 5139.200 $110.439 $116.884 5100,849 5150635 310023 5127920 5104.032 3122,906 5170,700 5154,840 S170,000 315450 $160.657 5172.000 $100,304 $99.100 5161.730 $115 30 5116 506 5143.100 $137.100 51349 5135 5168420 5125.582 5127.155 5102.300 59000 5111 516402 $168.070 5127537 310529 594903 5983 $111,230 $161.00 142.007 5117,550 5134.400 5118.290 $17.900 $107483 5101011 $100.210 $169.792 5114071 5107,620 1511102 51118 5140 $12 5110 101 Regional Revenue Data North Eastern Eastern Central Region South East Midwest North West South West January 3103,100 3141749 3144337 5153.384 595371 February 5133/641 5117379 5104.730 $168.04 5153405 3112257 March 5135.110 3152.982 $137.993 April SO 140 $130.300 $158858 5142.770 5102.10 51470 Sales Data For 2019 May June July August Sentember October November December 595,032 $150,057 5119.859 5111230 1180,094 300 180 SIM 512715 $111.310 5108 023 5114,071 5172.sed $1534051134.00 tiste 598 106 $170600 5127 5107.629113.257 300.000 112 3112700 3161.73 5110161 343100 10 $120,000 $135 500 5115155103180 51000 5134405170.00 151 3117 1198 2005146279 3132370 SICOMO Profitability (Revenue-Expense) Analysis December Eastern Central The only cels you are allowed to change are the yellow and blue cells

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Good Better Best A Guidebook For Performance Auditing

Authors: Gary Blackmer

1st Edition

131265869X, 978-1312658691

More Books

Students also viewed these Accounting questions