Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Case Study :- Taxi KL Company (a reputable taxi service company in Kuala Lumpur) employs you in the accounting department. Your employer has asked you
Case Study :- Taxi KL Company (a reputable taxi service company in Kuala Lumpur) employs you in the accounting department. Your employer has asked you to create a spreadsheet to see total May Week 1 2020 revenue. Create an Excel spreadsheet the same as shown in the following picture. (In Excel Sheet using format) Taxi KL Revenue Detail Week 1 of May 2020 $ $ $ S $ 5/4/2020 $ 5/5/2020 5/6/2020 5/7/2020 5/8/2020 5/9/2020 5/10/2020 12 Total 5 13 14 Percent of total 12,172.65 11,946.90 13,300.35 12,104.40 14,650.65 15,249.15 11,829.30 91,253.40 16,718.10 16,742.25 14,466.90 12,892.95 18,106.20 20,927.55 14,397.60 114,251.55 13,392.75 11,063.85 12,014.10 12,574.80 1 4, 182.35 14,763,00 12,449.85 90,440.70 19,215.00 18,526.20 18,158.70 19,516.35 19,895.40 22,793.40 20,333.25 138,438.30 17,439,45 $ 18,361.35 16,344.30 15,450.75 18,834.90 19,916.40 17,994.90 124,342.05 $ 20,143.20 21,325.50 18,919.95 14,222.86 22,506.75 20,685.00 21,723.45 139,526.71 19,825.05 $ 18,628.05 19,746.30 20,698.65 23,292.15 23,528.40 21,784.35 147,502.95 $ 19,364.10 $ 17,719,80 18,569.25 19,428.15 19,637.10 21,450.45 19,988.85 136,157.70 $ 15,888.60 13,327.65 15,422.40 14,879.55 18,232.20 18,816.00 18,816,00 17,417.40 113,983.80 $147,641.55 $146,942.25 $141.768.46 $169,337.70 $178,129.35 $157,918.95 $1,095,897.16 $ $ S S $ 10% 13% 11% 13% 10% Share of Total Revenue Revenue Per District Charts 160,000.00 140,000.00 120,000.00 100,000.00 30,000.00 60,000.00- 40,000.00 20,000.00 0.00 - W.maju - Cheras L pantai - bintang - Batu - Kepong Seputeh - Segambut - Trazak 5/4/2020 25/5/2020 5/6/2020 5/7/2020 25/8/2020 25/9/2020 25/10/2020
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started