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.
- The lowest number of orders of passion fruit, mango and calamansi in 2021.
- The 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 in 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)
- The main body
- Recommendation (if any)
- 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
- You work in Labuan for a well-known hotel chain You are needed to write a report on the COVID 19 pandemic: Business Communication Assignment, UTAR, Malaysia
- The construction materials would be used in the design of the structure should be selected based on the requirements: Reinforce Concrete Design Assignment, UMP, Malaysia
- PSY207: Your task is to “find a gap” in relation to one of these articles and write a proposal for research based on that gap: Social Psychology Report, UOT, Malaysia
- FIT1047: Your name as a MARIE string This is the first task you need to submit It’s just a little warm-up so you can get familiar with strings: Introduction to computer systems, networks Assignment, MUM, Malaysia
- CBMS4303: Organizational integration happens when a company’s internal and external factors successfully mesh: Management Information System Assignment, OUM, Malaysia
- The stock market is one of the popular places in Malaysia where retail investors come to make investments: Bachelor of Accounting & Finance Research Paper, SU, Malaysia
- FIN30014: Russia’s failure to pay a slice of interest on one of its bonds will trigger $2.5bn of insurance-like contracts used to protect against: Financial Risk Management Case Study, SUT, Malaysia
- BBM103/03: You have been asked to form a task force to deal with an issue at your workplace: Principles and Practice of Management Assignment, WOU, Malaysia
- With respect to the money and capital markets, money market securities generally have, while capital market securities are typically expected to have a: Financial Institution Monetary Theory Other, UTN, Malaysia
- KMC3264: The media industry is constantly evolving, and companies often need to be able to adapt to thrive or survive: Managing Media and Business Assignment, SUT, Malaysia