Question
Franchise taxes are levied on businesses that gain a franchise right of doing business in a jurisdictions territory. The data in Table 9.1 are franchise
Franchise taxes are levied on businesses that gain a franchise right of doing business in a jurisdiction’s territory. The data in Table 9.1 are franchise tax revenues in the city of Sunbelt, Florida, from Year 1 to Year 9. During forecasting, you are informed that BellSouth’s (the local telephone service provider) current franchise contract with the city ends in Year 11. The city will seek a 10 percent franchise tax increase from the previous year basis from BellSouth in Year 12. The franchise tax revenues from BellSouth during the last nine years are shown in Table 9.2. Forecast the franchise tax revenues of Years 10 to 12. Write short summary on your findings. You should be using all four forecasting techniques (SMA, TMA, EXS, and regression).
Table 9.1--Franchise Taxes in Sunbelt
Year | Revenues |
1 | $12,442,000.00 |
2 | $12,427,000.00 |
3 | $13,091,000.00 |
4 | $13,743,000.00 |
5 | $14,306,000.00 |
6 | $15,089,000.00 |
7 | $15,257,000.00 |
8 | $16,749,000.00 |
9 | $17,655,000.00 |
Table 9.2--Franchise Taxes from BellSouth in Sunbelt
Year | Revenues |
1 | $3,727,000.00 |
2 | $4,100,000.00 |
3 | $3,927,000.00 |
4 | $4,435,000.00 |
5 | $5,722,000.00 |
6 | $6,036,000.00 |
7 | $5,950,000.00 |
8 | $6,700,000.00 |
9 | $7,062,000.00 |
Step by Step Solution
3.46 Rating (143 Votes )
There are 3 Steps involved in it
Step: 1
Data Franchise Taxes Year Sunbelt BellSouth in Sunbelt Revenues Revenues 1 1244200000 372700000 2 1242700000 410000000 3 1309100000 392700000 4 137430...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 1 attachment)
60e3feddc2b34_81308.xlsx
300 KBs Excel File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started