Question

In: Accounting

You have a revenue data set of a Metro Area, where a node represents an office,...

You have a revenue data set of a Metro Area, where a node represents an office, the value associated with every node is the annual revenue of this office. The data set includes 2000 offices in that Metro Area. Now, I would like to partition the Philadelphia Metro Area to 10 business sub-areas. Each of these 10 business sub-areas has one or more offices. The total anual revenue from each sub-area should equal or almost equals to others. How to partition these 10 business sub-areas?

-its like a Routing algorithm problem (for example- 8 queens problem). We have to distribute these nodes, such way,on average all sub-area get same revenue, and nearby nodes are in same sub area, but one sub-area can have, 100 nodes, other one can have 300 nodes, that does not matter.

Solutions

Expert Solution

Let me frame the Data flow for you here.

1. Start by dividing your total revenue by 10. You will need the revenues to be near this Amount. Call this ar (average revenue).

2. Now assign all of your offices a number in ascending or descending order via loop. Now total no. Of offices = n = 2,000

3. Start by adding 1+n and then check if it is within 10%(you can change this as per the materiality you need), if it is than it is your one group.

4. If not then add the revenue of 2nd office to it, if it is than it is your one group.

5. If not then add the revenue of (n-1)th office to it, if it is than it is your one group.

6. If not than repeat 4th & 5th step, make it into a loop.

Note as per the segregation of the data maybe at some point a data fail to enter in the category of 10% in that case you may need to add another loop in it for checking the absolute difference between your group revenue & ar. Use multiple loops.

Hope this meets your purpose.

Kindly Like the answer if it was helpful. This motivates the experts.

Thanks.


Related Solutions

10.2 Suppose we a data set where each data point represents a single student's scores on...
10.2 Suppose we a data set where each data point represents a single student's scores on a math test, a physics test, a reading comprehension test, and a vocabulary test. We find the first two principal components, which capture 90% of the variability in the data, and interpret their loadings. We conclude that the first principal component represents overall academic ability, and the second represents a contrast between quantitative ability and verbal ability. What loadings would be consistent with that...
1) Suppose you have the following data, which represents the area codes of 50 randomly selected...
1) Suppose you have the following data, which represents the area codes of 50 randomly selected students from endicott. Area code: 617,508,857 other. # of students 25,10,10,5 a) is the area code variable quantitative or categorical? Explain your reasoning. b) Create a bar graph to represent the area code data, using percents as the y-axis. Draw a sketch below, or attach a labeled graph from excel to the end of this exam. Make sure to label your graphs' axes and...
Are SF Bay Area households less likely to have real Christmas trees than LA Metro Area...
Are SF Bay Area households less likely to have real Christmas trees than LA Metro Area households? 189 of the 350 SF Bay Area households surveyed had real Christmas trees whereas 220 of the 400 LA Metro Area surveyed had real Christmas Trees. What can be concluded at the 0.05 level of significance? H0: PSF = PLA Ha: PSF <, >, or not equal to? PLA Test statistic: t, F, Z, or Chi-square? Which of these is the critical value(s)?:...
The following data set represents the test scores of the freshmen on the first in a...
The following data set represents the test scores of the freshmen on the first in a statistics course at a local university. 62 67 74 48 100 93 49 57 77 63 82 10 78 88 99 44 51 80 71 39 58 76 89 94 70 41 66 82 18 73 a. Calculate the z-score for the observation 63 and interpret it. b. Find the median of the data set. If the z-score for an observation is -1.22, the...
can i get the Data of metro Nashville Area in Excel please Unemployment Median Home Price...
can i get the Data of metro Nashville Area in Excel please Unemployment Median Home Price Population Taxes Floreclosure GDP
Below is a table that represents price, output, cost, revenue and profit data for a monopoly....
Below is a table that represents price, output, cost, revenue and profit data for a monopoly. Price Q TR MR MC TC Profit $290 0 --- --- -$1,000 $280 1 $100 $270 2 $1,180 $260 3 $60 $250 4 $240 5 $60 $230 6 $1,420 $220 7 $1,540 $210 8 $200 9 $1,980 (a) Fill in the missing numbers for Firm B. Note: there are no numbers for MR and MC when Q=0. When output level is 4, the Average...
The data set below on the left represents the annual rate of return? (in percent) of...
The data set below on the left represents the annual rate of return? (in percent) of eight randomly sampled bond mutual? funds, and the data set below on the right represents the annual rate of return? (in percent) of eight randomly sampled stock mutual funds. Use the information in the table below to complete parts ?(a) through ?(d). Then complete part e Bond mutual funds 3.1 1.7 1.8 3.3 2.3 2.6 1.5 1.9 Stock mutual funds 9.3 9.0 8.3 8.0...
The following set of data represents the distribution of annual salaries of a random sample of...
The following set of data represents the distribution of annual salaries of a random sample of 100managers in a large multinational company: Salary range (£` 000' ) Managers 20 but under 25 25 but under 30 30 but under 35 35 but under 40 40 but under 45 45 but under 50 5 10 25 35 25 5 Calculate the mean and standard deviation. [5 Marks] The company chairman claims that the managers in the company earn on average annual...
The data set represents the number of movies that a sample of 20 people watched in...
The data set represents the number of movies that a sample of 20 people watched in a year. 121 148 94 142 170 88 221 106 18 67 149 28 60 101 134 168 92 154 53 66 a.) construct a frequency distribution for the data set using six classes. Include class limits, midpoints, frequencies, relative frequencies, and cumulative frequencies. b.) Display the data using a frequency histogram (Must use EXCEL) c.) Describe the shape of the distribution as symmetric,...
5. You are planning a water supply scheme in an area where you have both surface...
5. You are planning a water supply scheme in an area where you have both surface and sub-surface water resources. Disucss the factors which you will take into account to seclect one of the soruces for your scheme/project.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT