MGT555: In 2021, the price charged for bottled drinks/box is RM10 for passion fruit, RM8 for mango, and RM6 for calamansi: Business analytics Report, UiTM, Malaysia
University | Universiti Teknologi MARA (UiTM) |
Subject | MGT555: Business Analytics |
Based on the S&S Sales data set, write an analysis based on the following questions:
- In 2021, the price charged for bottled drinks/boxes is RM10 for passion fruit, RM8 for mango, and RM6 for calamansi. This price is 50% higher than the price charged in 2020. Find the following and all works/formulas must be shown in the MS Excel worksheet.
Are You Searching Answer of this Question? Request Malaysian Writers to Write a plagiarism Free Copy for You.
Questions
- Lowest number of orders of passion fruit, mango and calamansi in 2021.
- Highest number of orders of each type of juice in 2021.
- Average quantity sold of each type of juice in 2021
- Total quantity sold of each type of juice in 2021
- Monthly percentage change of each type of juice in 2021.
- In 2021, classify the unit sold less or equal to 300 000 units as low, greater than 300 000 but less than 600 00 units as a medium, and greater than 600 000 units as high.
- The Differences of Total Revenue of each type of juice in RM 2021 and 2020.
2. The director-owner is planning to increase the sales of the fruit juice division by 20% within six months. Based on the given data, you are assigned to recommend the most outstanding brand to achieve the objective.
The report must encompass the following items:
- Cover page
- Executive summary
- Table of Content
- List of abbreviations and symbols (if any)
- Introduction
- The main body
- Recommendation (if any)
- Conclusion
- Reference list
- Appendices (including plagiarism report)
- Font: Arial 11, margin 1.5, justify alignment, apply heading and sub-heading.
Get Solution of this Assessment. Hire Experts to solve this assignment for you Before Deadline.
Get Help By Expert
Can I pay someone to do my assignment online? Yes, you can. At Malaysia Assignment Help With a team of highly qualified writers are skilled to provide all types of management assignment solutions at a pocket-friendly price.

Recent Solved Questions
- EMOM5103: enable the student to demonstrate their understanding and skills in the change management plan process to resolve the issue in managing the change: Change Management Assignment, OUM, Malaysia
- It is commonly assumed that GREs produce scores with a mean of 500 In October 2020 the mean verbal score of 5701 Malaysian students: Statistics Assignment, UM, Malaysia
- You are Working as a Counselor at Gleneagles Hospital Kuala Lumpur In the Recent Management Meeting: English for occupational purpose Report, UTHM, Malaysia
- CBS1323: Identify the components of business information system And Identify technologies in supporting decision: Management Information Systems Assignment, SU, Malaysia
- Mark, aged 36 years, is a sales executive who presents with a 5-hour history of right loin pain of moderate intensity associated with nausea and urinary frequency: renal medicine Assignment, USW, Malaysia
- Pengenalan ISU Semasa Kesan covid 19 terpap hobungan social social kalangan masyarakat iyitu hubun antara masyarakat semakin pudar: Moral Education Assignment, OUM, Malaysia
- PDS0101:A farmer wants to cross a river and take with him a wolf, a goat, and a cabbage: Intro to Digital Systems, Assignment, MMU, Malaysia
- Discuss and justify the potential market structure for your business that you are about to enter: Economic Assignment, UNMC, Malaysia
- CHE4161: You are appointed as the project manager for a construction project You were informed that your team engineer: Engineer in Society Essay, MUM, Malaysia
- you will be asked to implement a Python program to solve the following puzzles described below: Introduction to Artificial Intelligence Assignment, APU, Malaysia