Wednesday, February 8, 2023

SPARTA’s SPCapstone001: Data Analyst Capstone Course: CONCEPT PAPER for Covid-19 Business Impact

 TRUSTING IN DIGITAL PIVOT FOR BUSINESS RECOVERY

INTRODUCTION

Background

Doctors are more concerned with COVID-19. Unlike Spanish Flu, there are asymptomatic carriers of the disease. That one detail makes it harder to mitigate the spread of the virus by simply taking temperatures, (Amenabar, 2020). On that note, it is hard to foretell when we can live without the fear of exposing ourselves to COVID-19 virus and its variants. This concept paper builds upon insights from various firms who commenced surveys in the businesses and to strategically focus on the economic problem caused by this pandemic.

Need for this Study

Time is a luxury that all country leaders don’t have. Making the right decisions not only to health factors but also the economic risks will be vital in the recovery of the Philippines and its people. The concept will identify the relationship between demand and supply factor in job security, effective rollout of the vaccine and digital solutions across businesses.

Problem Statement

Does pivoting digitally alone can help to recover business during pandemic?

Objective

The research paper seeks to verify the relationship of economic shock and consumer’s behavior in spending. The second objective is to determine the influence of upskilling and digitalization of firms in gaining competitiveness in this time of pandemic.

LITERATURE REVIEW

COVID-19 and Its Unprecedented Crisis

From 1918’s Spanish Flu pandemic, the American Public Health Association (APHA) stated that mixing of bodies and sharing of breath in crowded rooms, was dangerous (Billings, 1997). The lockdown aims to reduce the transmission of the virus by limiting contact between people. Thus, officials all over the world strictly implement different kinds of confinement and mitigation measures like social distancing. However, this measure implicated a profound impact not only socially but also created an unprecedented economic impact.

GDP plunged to negative 9.5 which is the lowest since 1980 and unemployment rate doubled from 5.1 of 2019 to 10.4%.


Figure 1 — Source: International Monetray Fund, 2021
Figure 1 — Source: International Monetray Fund, 2021

The main contributors to the decline were: Construction: -24.2 percent
Other Services: -38.0 percent
Real Estate and Ownership of Dwellings: -13.2 percent


Figure 2 — Source: Philippine Statistics Authority, 2021
Figure 2 — Source: Philippine Statistics Authority, 2021


Economic Shock of Lockdown

Economy works when money moves and during lockdown people stopped moving and so is the money. Philippine Government borrows, allotted and spend trillions of pesos to mitigate the supply- demand shocks of COVID-19. A supply shock is when public health authorities and employers prevent service workers from doing their jobs and a demand shock, on the other hand, is something that reduces consumers’ ability or willingness to purchases goods and services at given prices (Brinca, Duarte, & e Castro, 2020).

More than Php200-billion were allotted by the government to cover, sustain and fund the declines as seen above in figure 2, procurement, trainings and projects in response of the COVID-19 pandemic under Bayanihan II project.


Figure 3 — Source: Department of Budget and Management, 2021
Figure 3 — Source: Department of Budget and Management, 2021

Vaccine. Job. New Reality.

Vaccine hesitancy is not only an arising problem in Philippines but also declared one of the ten threats to global health by WHO (World Health Organization, 2019). Spreading correct information such as efficacy, side effects and the benefit of the vaccine to face the new normal helped the Philippine Government in doubling the people vaccinated on May 2021.


Figure 4 — Source: World Health Organization, 2021
Figure 4 — Source: World Health Organization, 2021

Successfully educating the citizens that vaccine is not the 100% solution in fight against actively mutating COVID virus and due to uncertainty when this pandemic will end, Philippine consumers became very conservative with their buying habits despite government injected funds for citizens to spend (Figure 2).

Cautious spending resulted a demand and supply shock which causes job loss and insecurity. Based on Inter-Agency Task Force for the Management of Emerging Infectious Diseases, 2020 report, 50% of private companies’ workers experienced decline in income and 80% of which is due to job loss.


Figure 5 — Source: Inter-Agency Task Force for the Management of Emerging Infectious Disease, 2020
Figure 5 — Source: Inter-Agency Task Force for the Management of Emerging Infectious Disease, 2020

Due to left and right retrenchment, Filipinos are looking for ways to acquire extra income and/or serve their clients contactless. And the outcome is digitalization. This is the latest competition now in the upcoming new reality of the world. Consumers are already aware of food delivery services and shopping online since pre-pandemic but how about the telecommuting or working from home?

ASIAN DEVELOPMENT BANK SURVEY, 2020 resulted that 57.3% of micro, 12% of small and 11.1% of medium firms’ workers are not possible to work from home. The same survey shows that financial assistance and tax incentives may help their businesses to adopt the new normal.


Figure 6 — Source: Asian Development Bank, 2020
Figure 6 — Source: Asian Development Bank, 2020


Digitalisation to Solve the Problem

Consumer confidence is expected to remain low even after the ECQ is lifted. Expectation of a worse family income situation is especially pronounced among the low-income group (Inter-Agency Task Force for the Management of Emerging Infectious Diseases, 2020). And that is a significant economic problem.

Digitalisation for businesses will not only attract consumers to buy their goods or services but it will generate a well of data that can help them dive and perform the analytics. Analytics will solve in managing of inventories and will also help to know more about erratic decision changes of Filipinos due to this never-ending battle cause of pandemic.

METHODOLOGY

Quantitative

In cross-sectional design, we will use descriptive and categorical analysis and prescriptive analysis will be utilized to determine the next policies to be developed by the government.

Qualitative

For qualitative data it will undergo transcriptions and reported on themes.

REFERENCES

1. Amenabar, T. (4 September, 2020). The Washington Post. Retrieved from The Washington Post:

https://www.washingtonpost.com/history/2020/09/01/1918-flu-pandemic-end/

2. Billings, M. (June, 1997). The Influenza Pandemic of 1918. Retrieved from Stanford University: https://virus.stanford.edu/uda/fluresponse.html

3. Brinca, B., Duarte, J. B., & e Castro, M. (17 June, 2020). Decomposing demand and supply shocks during COVID-19. Retrieved from VoxEU.org : https://voxeu.org/article/decomposing-demand-and-supply-shocks- during-covid-19

4. Department of Budget and Management. (31 May, 2021). COVID-19 Budget Utilization Reports as of May 31, 2021. Retrieved from Department of Budget and Management: https://www.dbm.gov.ph/index.php/programs-projects/status-of-covid-19-releases#bayanihan-2

5. International Monetary Fund. (April, 2021). International Monetary Fund. Retrieved from World Economic Outlook (April 2021): https://www.imf.org/external/datamapper/datasets

6. Inter-Agency Task Force for the Management of Emerging Infectious Diseases. (2020). WE RECOVER AS ONE. Manila: National Economic and Development Authority (NEDA).

7. World Health Organization. (2019). Top Ten Threats to Global Health in 2019. Retrieved from World Health Organization: https://www.who.int/news-room/spotlight/ten-threats-to-global-health-in-2019

8. World Health Organization. (2021). COVID-19 Explorer. Retrieved from World Health Organization: https://worldhealthorg.shinyapps.io/covid/

9. ASIAN DEVELOPMENT BANK. (17 July, 2020). ADB Philippine Enterprise Survey on COVID-19 Impact. Retrieved from ADB Data Library: https://data.adb.org/dataset/adb-philippine-enterprise-survey-covid-19-impact

10. Philippine Statistics Authority. (11 May, 2021). National Accounts. Retrieved from Republic of the Philippines — Philippine Statistics Authority: https://psa.gov.ph/national-accounts/base-2018/estimates



Tuesday, February 7, 2023

SPARTA’s SP601 Data-Driven Research Fundamentals: ANALYTICS SOLUTION FOR DOOR-TO-DOOR SIM CARD DISTRIBUTION

CHAPTER 1 : INTRODUCTION

Background

The growing population of Philippines with regards to mobile phone usage as primary source of communication is a good sign of business for telecommunication companies but it comes with a massive competition not only with each other but also with the noise of other products.

Internet has pivoted many accustomed activities, and marketing is no exception. As more and more people are attached to their phones, companies develop a new era of advertising, the digital marketing. This study aims to solve the problems of marketing in the narrowing attention span of consumers and highlight the effectiveness of door-to-door marketing.

Smarta, a local telecommunications company, is considering to hire a marketing agency to do a door-to-door sampling caravan project to give out free prepaid SIM cards to households. The objective is to increase the subscriber base of the company while obtaining a net profit from this project by hoping that the free SIM card samples will eventually be activated in the future and revenue will flow from the activated SIMs.

Research Question

From the above background, the following question can be drawn the following main question.

- Is the door-to-door SIM card distribution effective to attract new customers?

Scope and Limitation

-The scope of this research is related to the business process proposal of sampling system given by the marketing agency to SMARTA.

-The study is limited to the population report published at the Philippine Statistics Authority website dated 2015.

CHAPTER 2 : LITERATURE REVIEW

Marketing and Its Growing Problem

Marketing refers to activities a company undertakes to promote the buying or selling of a product or service, (TWIN, 2020). Marketing evolves hand-in-hand with technology and thus produced digital marketing. But a problem arises on that, fierce competition on consumer attention (A new study in Nature Communications finds that our collective attention span is indeed narrowing, and that this effect occurs not only on social media but also across diverse domains including books, web searches, movie popularity, and more, (Technical University of Denmark, 2019)) and developing trust (Digital enables them to voice their concerns or dissatisfaction in an amplified way. In fact, we found that 40% of global consumers posted negative comments about an experience with a company via social media. Their digital distrust can easily influence thousands of potential customers to stay away (BENDER, BARTON, & MARQUE, 2017)).

Marketers Backtracked Towards Sampling

Marketers came up with different styles of product sampling and below are the two with direct access to household (University of Missouri, 2015):

Table 1: Product Sampling Method

SPARTA’s SP601 Data-Driven Research Fundamentals
Product Sampling Method

Product sampling continues to rank among the most effective tactics in the history of marketing because of its ability to do what no other medium can. Put the product directly in the customer’s hands.

Improved Door-to-Door Sampling

As above table portrays, available data and results are limited for marketers to implement the direct mail sampling. It also leaves a negative impact on potential clients due to the feeling of intrusiveness. Thus on reports of DMA UK Ltd (2014), door-to-door sampling is an extremely effective and impactful method of reaching and communicating with your target audience — which is why some 80% of the UK’s top advertisers use the medium.

Gap Analysis

Aim to further explore the relationships and effects in implementing the two marketing style (Door-to-door Sampling and Direct Mail Sampling) in the same adequate sample household.

CHAPTER 3: PROPOSED RESEARCH DESIGN

Research Design

This research applied quantitative and qualitative methods. The quantitative method was used to meet a reasonable cost for marketing with a time bound study of 100 days. Qualitative method used to explore the pertinent data to their conceptual framework that quantitative data could not facilitate (Crick, 2020).

Population and Sample

The door-to-door caravan used a non-probability quota sampling that was conducted around the City of Taguig and nearby city with a distance not more than 10-Kilometer and with approximate travel period that is not more than one hour.

Instruments

The data for this door-to-door caravan were collected by giving a standardized form for recipients to affix their signature to prove the acceptance of the SIM card.

Data Gathering

The instrument of this door-to-door caravan was administered and personally collected by the samplers. The SIM card distribution took 100 days.

PROPOSED DATA ANALYSIS METHOD

Quantitative

In cross-sectional design, we will use the descriptive and categorical analysis to illustrate the mean and deviation, percentage and frequency. In this study, prescriptive analysis will be utilized to determine the next decision to be taken by SMARTA.

Qualitative

On qualitative data, content analysis will be used to analyse the data from the door-to-door caravan marketing sampling conducted by 10 samplers.

CHAPTER 4: IMPLEMENTATION

Proposed Sampling System by Marketing Agency

The marketing agency proposed a Php5,000,000.00 contract (SIM card exclude SIM card costs) for SMARTA’s 100 day SIM card distribution. The marketing agency proposes the below sampling system.

Table 2: Marketing Agency Proposed Activity

SPARTA’s SP601 Data-Driven Research Fundamentals
Marketing Agency Proposed Activity

The above marketing agency’s proposed sampling system shows that the 10 samplers only have 6 hours per day to distribute SIM cards. Assuming that all the barangay that marketing agency will visit a population of 26,213 (average household size of 4 (Lungsod ng Makati, 2019)) that covers a lot area of 0.88km2 with approximately 5,698 of household like Barangay Bangkal of Makati (Lungsod ng Makati, 2018), samplers approximately 70.809 kilometers to cover per day.

Equation 1: Household Lot Length

SPARTA SP601 Capstone

Equation 2: Kilometers To Cover Per Barangay


SPARTA SP601 Capstone

In order to estimate the number of household that a sampler can visit in an hour, the marketing agency provided a 40km/hour as the velocity of the one sampler. Estimated of forty-five seconds spiel talk time (accepts/declines SIM card) and 30 seconds for household that do not answered the door was also provided by the marketing agency will total an average of 37.50 seconds. With the help Household Lot Length equation, the number of household per hour can be solved.

Equation 3: Number of Households Visited Per Minute

SPARTA SP601 Capstone

Equation 4: Walk Time Per Minute Per Household


SPARTA SP601 Capstone

Equation 5: Target Household Visits Per Hour


SPARTA SP601 Capstone

A target of sixty five (65) households visiting per hour with a six (6) working hours each for ten (10) samplers for one hundred days (100) days, there are 390,000 households could get in touch for the given sampling period.

Below chart is the expected hit and estimated conversion by the marketing agency:

Number of Expected Hit and Estimated Conversion
Number of Expected Hit and Estimated Conversion

Exclusion of SIM card Php40.00 manufacture and Php50.00 credit with total cost of Php35,100,000.00, the marketing agency estimated an average return of revenue of Php13,162,600 yearly for SMARTA’s newly acquired customers.

SMARTA Implementation Plan

The objective of this SMARTA implementation plan is to increase the estimated new subscribers advised by the marketing agency. With the current situation, home-based learning was on effect to minimize and stop the spread of the virus. Unlike the marketing agency’s proposal, this plan targets consumers not only the close proximity barangays but students with demographics of 5 to 24 years that currently attending online school.

As one of the parents told (REUTERS, 2021) “Sometimes we change the SIM card to a different provider so he doesn’t have to study on the roof, but there’s rarely enough money to spare for that”. Consumers are now resulting to be more engaged on benefits offered by different telecommunication providers (Pew Research Center, 2019). Based on a study (Capistrano, 2013), the overall data shows that promotions and giveaways rated the highest level of involvement. This implies that generally speaking, mobile phone users exert more effort in learning about the promotions and giveaways being offered to them by the service providers more than the other service offerings. Thus, the SMARTA’s is on the right time to pursue door-to-door sampling caravan and target the students that are definitely at home.

The sampling will a benefit student and parents on budget and a contribution to the government for its campaign to promulgate online classes.

With the above socio-economic objective, the target barangays that has a 25% and above students on their population and the visit should not be per barangay per day but to visit the number households as reported from PSA (Philippine Statistics Authority, 2017). Below are the list of barangay and corresponding number of target students and days need to spend in a barangay given the rates from marketing agency.


SMARTA Implementation Plan

SMARTA Implementation Plan

The above barangays are projected to get in touch on a total of 502,190 students in 100 days. On such case, it is not needed to push outside of NCR for a door-to-door caravan.

If SMARTA pushes to reach 500,000 hits with a hit rate of 75% (answered the door) we will need 19 samplers to knock 740,741 doors in 100 days or 10 samplers conducting the door-to-door in 190 days.

Equation 6 : Household Visits


SPARTA SP601 Capstone

Equation 7: Household Visits Per Hour Per Sampler


SPARTA SP601 Capstone

Equation 8: Calculating How Many Samplers Needed for 100 Days


SPARTA SP601 Capstone

Equation 9: Calculate How Many Days Needed for 10 Samplers


SPARTA SP601 Capstone

Table 4: SMARTA Strategic Sampling with Cost

SPARTA Strategic Sampling with Cost
Strategic Sampling with Cost


Inaccuracy and incompleteness of sourced out data from Philippine Statistics Office is not enough to analyse it. This is one of the foreseeing reasons that may change the result of this study. Weather changes, samplers’ attitude towards the public, problems over the van’s travel time, which may lead to a bigger problem of under coverage that will take an effect on the feasibility of this project.

To avoid these problems and yet reach the target hit of 500,000, this study strongly recommend that the SMARTA or marketing agency will based on the number of acceptance target number rather than the per day in to pursue this door-to-door sampling.


SPARTA’s SP601 Data-Driven Research Fundamentals CAPSTONE


Clearly, with a 53% ROI (marketing agency 46%) it will be cost efficient for SMARTA to take this study on their own. Sensitive variables will as mentioned above will be fully under control.

CHAPTER 5: BIBLIOGRAPHY

1. Technical University of Denmark. (2019, April 15). Abundance of information narrows our collective attention span. Retrieved from ScienceDaily: www.sciencedaily.com/releases/2019/04/190415081959.htm

2. TWIN, A. (2020, Aug 17). BUSINESS ESSENTIALS. Retrieved from Investopedia: https://www.investopedia.com/terms/m/marketing.asp

3. BENDER, M., BARTON, R., & MARQUE, F. (2017). Trust in the Digital Age .ACCENTURE. ACCENTURE.

4. University of Missouri. (2015, April 8). Course Hero. Retrieved from Course Hero: https://www.coursehero.com/file/p6o95um/Door-to-door-sampling-a-type-of-sampling-in-which-samples-are-brought-directly/

5. Frost & Sullivan. (2012). Research into the Door-to- Door Sales Industry in Australia. Frost & Sullivan for the Australian Competition and Consumer Commission (ACCC).

6. Lewis, J., & Ling, P. (2016). “Gone Are the Days of Mass-media Marketing Plans and Short Term Customer Relationships”: Tobacco Industry Direct Mail and Database Marketing Strategies. Tobacco Control.

7. Morimoto, M., & Chang, S. (2013, Jul 01). Consumers’ Attitudes Toward Unsolicited Commercial E-mail and Postal Direct Mail Marketing Methods. Journal of Interactive Advertising .

8. DMA UK Ltd. (2014). Door drop guide.

9. Crick, J. M. (2020, March). Qualitative research in marketing: what can academics do better? Journal of Strategic Marketing .

10. Lungsod ng Makati. (2018). Barangays. Retrieved January 2021, from Makati Portal: https://www.makati.gov.ph/assets/uploads/staticmenu/docs/1579227221918.pdf

11. Lungsod ng Makati. (2019). Facts and Figures. Retrieved January 2021, from Makati Portal: https://www.makati.gov.ph/cms/content/facts%20and%20figures/3241

12. REUTERS. (2021, Jan 7). ASIA. Retrieved from AsiaONe: https://www.asiaone.com/asia/scaling-roofs-and-mountains-philippine-students-battle-take-online-classes

13. Pew Research Center. (2019, November 20). Internet and Technology. Retrieved from Pew Research Center: https://www.pewresearch.org/internet/2019/11/20/mobile-owners-what-they-struggle-to-do/

14. Capistrano, E. (2013). Investigating Product Involvement Issues for Mobile Phone Services: A Study of Filipino Mobile Phone Users. Philippine Management Review 2013 .

15. Philippine Statistics Authority. (2017, June 30). Philippine Population Surpassed the 100 Million Mark (Results from the 2015 Census of Population). Retrieved from Philippine Statistics Authority: https://psa.gov.ph/population-and-housing/statistical-tables

16. Marikina City. (n.d.). The Shoe Capital of the Philippines. Retrieved from Marikina City: https://www.marikina.gov.ph/Our-City.html


Monday, February 6, 2023

Evolution of Logistics Analyst

Antoine-Henri, Baron Jomini a French officer defined logistics (1838; Summary of the Art of War, 1868) as “the practical art of moving armies,” The word clearly describes the movement of services of people and supplies to provide requirements in winning a war. Now, the word logistics is widely use by companies in defining their process of managing and planning goods and resources to serve its purpose.

Evolution of Logistics Analyst by Wilma Lapuz



The Progressing Role in Logistics:
1. Logistics Customer Service — this first line of defence in logistics. They are the one handling calls and emails. This role not only supports import/export/local department but also ad hoc jobs required by accounts or sales. They are the ones also responsible in general filing or other administrative duties.

2. Logistics Officer — this position ensures to support international/local order fulfilment and deliveries in a timely and efficiently manner. Sounds easy? Think again. They are the ones responsible in stock inventory and data entry, sometimes not only their own companies but some of the clients too.

3.Logistics Analyst — due to automation and rapid change of technology, you may notice some of the online job postings of companies are combining the two above roles and adding up analytics expertise on it.


Company Benefits Having a Logistics Analyst
Data is the New GOLD. In that case, logistics companies even freight forwarding businesses are seating unknowingly in a pot of gold.

So how logistics or freight forwarding companies can take advantage and stay afloat in the Fourth Industrial Revolution? If you will observe companies like DHL or Bollore they are actively hiring analysts now. Why? Because companies do not want to run their companies through gut-feel or crystal ball. Data companies like Google proved that many business will be more productive if decisions will be made using data.

Imagine, using the historical data of your clients you can anticipate the volume of materials they needed, from which supplier and what mode of transport. You can provide them quotations even if they are not asking. Wink-wink! That’s a customised customer service.

What else? Do you know why you keep on losing in bidding to get the project? Do you remember why are you winning? In aggregating your data you can anticipate the moves of your competitors.

Remember building relationship with your client and suddenly no more business calls from them? As a salesperson, will you meet them for lunch just to know what went wrong? Well, have you taken care of the KPIs of their stakeholder and provided customer experience? Remember customer experience now is valuable as getting your service on a lower price.

Of course, logistics analysts monitors not only the KPIs but also the procedures and practices to identify developments in planning and execution.


Do you need a Logistics Analyst even you are a Small/Local Company?
I want you to answer this question, are you competing with multinational company by giving quotations to your perspective importer/exporter? How can you compete if they their logistics analysts research the expectations of the clients in a certain project? Remember, some companies are willing to pay the price as long as you can meet their deadlines and KPIs.

Another thing to think of.. do you know that many start-ups that’s armed with data are now entering the logistics industry? They are providing quotes more quickly and offers an agile bid on clients. You know that in logistics/freight forwarding time is of the essence.

The line of difference in Logistics/Freight Forwarding industry is getting thinner and thinner. Competition is evolving fundamentally and companies should always examine whether they have the capacity and capabilities to change and compete.

Will you emerge and develop solutions to move forward and upward or you will just stay where you are because.. well I know, it is tough to change.
Get this gadget at facebook popup like box