please Answer for all part i'm needed 3-9 hours max.... please answer... thank u... for information data in Image ( photo )

Question : A. Make a chart of incoming unit targets and actual incoming units along with their attractive and informative achievement ratios, making it easier for you to analyze

B. Make an analysis of Service Advisor needs for each dealer (standard service advisor is 10 units/customer and the number of working days is 25 days for each month). Explain whether the service advisor is sufficient, not, or excessive. Give a solution

C. With the number of Service Advisors calculated in June, how long will it take to receive if 6 customers come together. Make it for each dealer (Ideal reception of 1 service advisor 15 minutes)

D. As a Field Operation, out of the three dealers, which one has decreased battery sales? How to improve it.

E. If the profit of 1 pcs battery is Rp. 125,000, what is the total profit from the sale of batteries for the month of Jan - Oct with a note, in June and July there is a cashback of Rp. 25,000 for buyers

F. In your opinion, which of the three dealers is the best and the worst dealer

Media for settlement: Excel (source or supporting data)

As the capital of the province of South Sulawesi, Makassar is the 8th largest city in Indonesia. Main dealer Cikarang has 3 dealer networks in the city. Following are dealer data: Incoming Customer Target Unit Data Dealer Jan Feb Mar Apr May Jun Jul Aug Sep Oct Kyoto 700 600 600 600 650 900 700 700 700 800 Nagoya 400 300 450 400 400 600 400 400 400 400 Osaka 1700 1600 1600 1600 1700 1700 1600 1600 1600 1600 Incoming Unit/Customer Actual Data Dealer Jan Feb Mar Apr May Jun Jul Aug Sep Oct Kyoto 760 833 885 821 868 839 846 844 804 800 Nagoya 389 398 383 493 480 509 542 552 451 450 Osaka 1698 1614 1690 1620 1753 1547 1816 1485 1568 1600 Service Advisor Actual Data Dealer Jan Feb Mar Apr May Jun Kyoto 3 2 2 2 3 4 Nagoya 1 2 2 2 2 Osaka 7 6 6 6 7 7 Jul Aug Sep Oct 3 3 3 3 2 2 2 2 2 2 mlac malo 6 6 Battery Stock Data Dealer Jan Feb Mar Apr May Jun Kyoto 20 15 10 0 16 15 Nagoya 8 10 15 12 0 Osaka 40 0 20 20 25 30 Jul Aug Sep Oct 16 0 15 12 0 8 40 20 25 30 Battery Sales Target Data Dealer Jan Feb Mar Apr May Jun Kyoto 10 8 9 9 10 Nagoya 6 4 5 5 6 Osaka 20 15 17 17 17 20 al an Jul Aug Sep 9 9 5 5 5 16 17 17 Oct 10 6 20 Battery Sales Data Oct 11 Dealer Kyoto Nagoya Osaka Jan 12 7 12 Feb Mar Apr May Jun 7 10 12 15 5 6 2 0 9 15 20 17 25 25 Jul Aug Sep 5 10 8 6 7 7 13 19 18 4 22 As the capital of the province of South Sulawesi, Makassar is the 8th largest city in Indonesia. Main dealer Cikarang has 3 dealer networks in the city. Following are dealer data: Incoming Customer Target Unit Data Dealer Jan Feb Mar Apr May Jun Jul Aug Sep Oct Kyoto 700 600 600 600 650 900 700 700 700 800 Nagoya 400 300 450 400 400 600 400 400 400 400 Osaka 1700 1600 1600 1600 1700 1700 1600 1600 1600 1600 Incoming Unit/Customer Actual Data Dealer Jan Feb Mar Apr May Jun Jul Aug Sep Oct Kyoto 760 833 885 821 868 839 846 844 804 800 Nagoya 389 398 383 493 480 509 542 552 451 450 Osaka 1698 1614 1690 1620 1753 1547 1816 1485 1568 1600 Service Advisor Actual Data Dealer Jan Feb Mar Apr May Jun Kyoto 3 2 2 2 3 4 Nagoya 1 2 2 2 2 Osaka 7 6 6 6 7 7 Jul Aug Sep Oct 3 3 3 3 2 2 2 2 2 2 mlac malo 6 6 Battery Stock Data Dealer Jan Feb Mar Apr May Jun Kyoto 20 15 10 0 16 15 Nagoya 8 10 15 12 0 Osaka 40 0 20 20 25 30 Jul Aug Sep Oct 16 0 15 12 0 8 40 20 25 30 Battery Sales Target Data Dealer Jan Feb Mar Apr May Jun Kyoto 10 8 9 9 10 Nagoya 6 4 5 5 6 Osaka 20 15 17 17 17 20 al an Jul Aug Sep 9 9 5 5 5 16 17 17 Oct 10 6 20 Battery Sales Data Oct 11 Dealer Kyoto Nagoya Osaka Jan 12 7 12 Feb Mar Apr May Jun 7 10 12 15 5 6 2 0 9 15 20 17 25 25 Jul Aug Sep 5 10 8 6 7 7 13 19 18 4 22