logo

N1504 – Research Enquiry for Managers, Case Study

9 Pages2474 Words232 Views
   

University of Susexx

   

Research Enquiry for Managers (N1504)

   

Added on  2020-03-04

About This Document

In the N1504 Case Study, we will discuss Research Enquiry for Managers. Evidence for the solutions given will be provided by workings from Excel. The datasets provided will be investigated using the BADIR methodology to find the most appropriate and useful information required from the datasets. BADIR stands for the Business Question, Analysis plan, Data Collection, Deriving of Insights and Recommendations.

N1504 – Research Enquiry for Managers, Case Study

   

University of Susexx

   

Research Enquiry for Managers (N1504)

   Added on 2020-03-04

ShareRelated Documents
STAT201A – Research Enquiry for ManagersA case analysis on Sublime DelightA pitch perfect summary is required whenever one aims at selling an idea to a potential investor.[ CITATION Eri10 \l 1033 ]. It is read before a decision is made in whether the investor will bother reading the rest of the document.[ CITATION Eri10 \l 1033 ]Executive SummarySublime delight is a rapidly growing coffee roaster and coffee supplier and a supply outlet owned by David Geoffs. Three main products were produced with time, Espresso Delight, Mocha Delight, and Sublime Delight. The products have admirable qualities such as long shelf lives, consistent in flavor and are easy to grind. The company has been able to maintain an outstanding coffee product and has experienced a more manageable and cost effective process of production. Eighteen months ago the management branched out into coffee cart operations and three mobile units. The main use of the mobile units being supply to building sites, commercial areas and office suits on a regular basis and event catering.The company has however faced challenges in the general management. Geoff discovered that he was increasingly spending a lot of time on the general business management. He therefore decided to recruit a general manager who later left for Australia leaving a big mess at Sublime DelightThe distribution of sales reveals that the external customers have the highest sales record from March to December. The Internal carts outlets records the highest sale in the month ofJanuary and February. The mobile outlet has the lowest number of sales all through the year. The company should therefore consider concentrating on the External outlet and the Internal carts and close down the mobile outlet as a way of managing their resources.Considering the distribution of profits across the three outlets, the internal carts contribute the highest profits to the company in the month of January and February. However, as fromMarch to December, the external customers outlet contributes to the highest profits level with a maximum of $20000 in the month of December. Throughout the year, the mobile outlet has the lowest contribution to the company’s profits. Since the main purpose of everybusiness is to maximize on the profits[ CITATION Sal09 \l 1033 ], Sublime delight should
N1504 – Research Enquiry for Managers, Case Study_1
therefore concentrate more on the External customer outlet where they can make more profits and also on the internal carts outlets. Resources should therefore not be wasted on the mobile outlets whose profit margin is very low.IntroductionEvidence for the solutions given will be provided by workings from Excel. The datasets provided will be investigated using the BADIR methodology in order to find the most appropriate and useful information required from the datasets. BADIR stands for the Business question, Analysis plan, Data collection, deriving of insights and Recommendations.Task 1(I) Sales distribution among the outletsJanFebMarAprMayJunJulAugSepOctNovDec01002003004005006007008009001000Distribution of sales across outlets per month.External CustomersInternal CartsMobilesResults above show the distribution of sales across all the three outlets. The external customer outlet is on average high across the months compared to the internal carts and the mobiles. The maximum distribution of sales in the External customers is 905 kg and the minimum is 626kg. Sales in the internal carts are highest in the months of January and February. The maximum sales are 837kg and the minimum is 665kg. The mobile outlet has
N1504 – Research Enquiry for Managers, Case Study_2
the least sale distributions all along the year with an average sale distribution of 200kg. Thelowest sale distribution for this outlet is 186kg and the highest is 238kg. Highest sales are inthe month of December for all the outlets.We recommend the company to invest more in the external customer outlet since it records the highest sales in the month of March to December. They should also concentrate on the internal carts since they record the highest sale in the month of January and February.In conclusion, the external customer and internal cart outlets seem to record highest sales inthe month of December. The company should either find more building sites, commercial areas and office suits to supply to or close down the mobile outlets in order to increase salesin the other two outlets.(ii)Distribution of profits among the different outletsJanFebMarAprMayJunJulAugSepOctNovDec0.05000.010000.015000.020000.025000.0Distribution of profitsExternmal CustomersInternal cartsMobilesMonthProfitsThe figure above shows the profits distribution among the three outlets. In the months of January and February, Internal carts bring in most profits compared to the other outlets. As from march to December, the external Customers record the highest profits with a maximum of $20362.5 and a minimum of 11581.0.Internal carts outlet contributes a maximum of $18825.0 to the Company’s profits and a minimum of $13965.0. The mobile outlet is seemingly a low source of profits at an average of $3415.1 for this
N1504 – Research Enquiry for Managers, Case Study_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Report on Statistics and Probability
|13
|2477
|108

Research Enquiry for Managers
|10
|2501
|265

Sublime Delight Company Case Analysis
|12
|2671
|36