Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Fraud Casebook Lessons From The Bad Side Of Business

Authors: Joseph T. Wells

1st Edition

0470134682, 978-0470134689

More Books

Students also viewed these Accounting questions