Donald Duque owns a small family stationery business in Northern France. By his own admission, Donald “knows next to nothing about business data analysis and how it affects small business” but he does realise that he needs to use analysis as an aid to better decision making.
You are a student at the University of Roehampton who has obtained a summer placement with Duque Papetiers Gros. You are keen to do well in this placement as it could lead to a permanent post at the end of your degree course.
Duque do not sell stationery items directly to the public. The business has built a customer base over more than fifty years, comprising wholesale trade with other businesses in Northern France. Currently, Duque does not sell across the French border.
The customer base can be categorised into small shops, local schools and small offices.
The product base can be categorised into printer cartridges, general office supplies, low-cost printers, office furniture, shredders, paper-based supplies and writing/drawing materials. Currently, Duque does not sell computers.
Although there are other wholesale stationers in Northern France, Duque has established itself as a trustworthy, reliable and prompt supplier. Any product that is not in stock can normally be obtained and supplied within 48 hours of the order being placed. Furthermore, Donald is well known as a businessman who gives generously to local charities in the region, particularly those relating to primary schools.
Donald would specifically like to understand better the annual spending on writing/drawing materials per capita in European countries and potential areas of expansion for his France-based business into neighbouring countries, including Germany.
You have been set a number of tasks which should be presented in report format (word length 2000 excluding graphs/figures/references) and written in English for the management of Duque. These tasks are detailed in the following pages and generally concern:
• Summary information
• Product information
• Customer information
• Recommendations for expansion
• Financial Information
Using relevant sources of information, you have been asked to write an overview of the wholesale stationers market in Germany, including in your discussion a brief explanation of trends in this area. In researching the topic, you have identified a good reference (MGCC Perspectives – A Chamber of Commerce magazine, pp. 7-8, which is available in Moodle). Prepare your overview and include a list of additional references in Harvard style (including the MGCC reference) at the end of your report. Note that you should not copy verbatim the overview and trends contained in MGCC, 2016 report (10 marks)
Using an EXCEL spreadsheet, produce an appropriate graph to represent annual spending on writing/drawing materials per capita in precisely seven European countries in 2015, two of which should be France and Germany. You can use some of the data for twelve countries shown in MGCC, 2016, p. 8. (10 marks)
Having gained a better understanding of the wholesale stationery market in Europe, you decide to start analysing Duque’s last three financial years of sales data (2015-2017). Although incomplete, the sales data (see figure T3) does provide some basic data including sales (€) of printer cartridges, general office supplies, low-cost printers, office furniture, shredders, paper-based supplies and writing/drawing materials.
Product item 2015 Sales (€) 2016 Sales (€) 2017 Sales (€)
printer cartridges 25000 26000 22000
general office supplies 25000 27000 23000
low-cost printers 15000 18000 18000
office furniture 25000 25000 27000
shredders 25000 29000 29000
paper-based supplies 25000 27000 27000
writing/drawing materials 25000 30000 32000
Figure T3. Product item sales by Year (2015 to 2017, inclusively).
a) Using an EXCEL spreadsheet, adjust the above table by appending a Total Sales (€) row. Include a table printout or screenshot as an appendix to your report. You must also show in your appendix, the formulae behind your columns. (5 marks)
b) Using an appropriate mixed pie chart, represent the 2016 and 2017 sales (€) by product item. (5 marks)
c) By representing Total Sales (€) and Year in an appropriate scatter diagram, find the associated correlation coefficient and write down your resulting interpretation. (5 marks)
d) Using the same scatter diagram, forecast the total sales for 2018 and 2019, assuming continuing sales trends. (5 marks)
(Task 3 total: 20 marks)
Currently, all of Duque’s operations are carried out in Northern France. The business has never operated across the border in Germany. In order to initially answer Donald’s question “Should I expand my business to Germany”, you have decided to use a ‘pros and cons method’ table (see figure T4).
Should I expand my business to Germany?
Pros Score/10 Cons Score/10
Total Pros Total Cons
Average Pros Average Cons
Figure T4. A ‘pros and cons method’ table for expanding to Germany & Belgium.
a) Complete the table. (10 marks)
b) Many of the business activities carried out by European companies need to comply with international standards. Research and list a few of the international standards that apply to Duque’s activities. You can use information contained at www.iso.org. (5 marks)
(Task 4 total: 15 marks)
If Donald does decide to expand, he knows that the extended internal operations will require improved facilities and, as it happens, a highly-suitable building is available for sale nearby. He always has been averse to interest-only mortgages and would only realistically consider a repayment mortgage. Also, he thinks that the asking price of €220,000 might be negotiable closer to €200,000.
a) Calculate the monthly cost of a 30-year repayment mortgage of €200,000, where interest is applied to the loan outstanding at the beginning of each year and the mortgage rate is 10% per annum. (5 marks)
b) Re-calculate the monthly cost assuming that the interest is applied to the loan every month.
(Task 5 total: 10 marks)
Donald believes that the mean value of orders received by his firm is about €240. Since his accounts office receives hundreds of orders each month, there is insufficient time to check every one. The accounts office decides on a strategy of randomly selecting a sample of 50 accounts and finds a sample mean of €230 and sample standard deviation of €43. Does this evidence support his belief? Assume a 5% significance level. (10 marks)
a) Each year Duque has regularly sent out customer questionnaires in the form of email attachments each December. The typical format of the questionnaires is shown in figure T7a. Historically, responses have been disappointing with less than five percent bothering to return a completed questionnaire. What advice could you give to improve the situation? (5 marks)
Figure T7a. The 2017 questionnaire emailed to customers.
In 2017, twenty questionnaires were returned completed. Results for Question 3 (“Please rate us on the following … “) are shown in figure T7b. Names of respondents have been anonymised.
ID CUST_SERV QUAL_P&S SALES_STAFF PRICE_VALUE
01 3 3 3 3
02 3 3 3 2
03 4 4 4 2
04 4 3 4 1
05 2 3 2 2
06 4 4 4 2
07 4 3 4 2
08 4 3 4 2
09 2 3 2 2
10 4 3 4 1
11 4 3 4 2
12 4 3 4 2
13 4 3 4 2
14 4 3 4 1
15 2 3 2 2
16 4 3 4 2
17 4 4 4 2
18 3 3 3 3
19 4 3 4 2
20 3 3 2 2
ID 01 … 99: ANONYMISING IDENTIFIER
CUST_SERV 1 … 4: RATING
QUAL_P&S 1 … 4: RATING
SALES_STAFF 1 … 4: RATING
PRICE_VALUE 1 … 4: RATING
Figure T7b. Results for Question 3 of the 2017 Questionnaire.
b) Obtain the descriptive statistics (mean, standard deviation) for the four variables CUST_SERV, QUAL_P&S, SALES_STAFF and PRICE_VALUE. Do think any of these might give cause for concern? (10 marks)
Based on all the data you have considered in Tasks 1-7, summarise in just one paragraph your most important findings. Also check the overall structure and presentation of your report (see the Brief in Moodle for more details). (10 marks)
Presentation It isn't unordinary for representatives to approach hierarchical change with the mindset they acquired from their social-social condition. The impulse for moment change isn't evident in any way. Behavioral change does not occur on the grounds that it is proposed, suggested, or authorized by a chief (or any other person). Change happens in light of the fact that one sees esteem and individual advantage in rolling out the improvement. Thus, it is basic that change specialists comprehend the power they apply in endeavoring to execute authoritative change activities. Change specialists are impetuses for work environment conduct adjustment. They devise motivational plans that trigger the motivation for representatives to take after specialist mandates. Consequently, it isn't sufficient for administration groups to consider change as far as hierarchical prerequisites. Supervisors who look for the aptitude of progress specialists are astute in this manner. Master change specialists are learned in understanding potential barricades that hinder workers from making the vital adjustments to new activities. Social and social situations contribute towards the multifaceted nature of conduct alteration. This paper exhibits a change activity whereby the change operators use successful correspondence as a device to make a dream and the validity important to move willful investment in behavioral change. Making Vision and Credibility Through Effective Communication Compelling correspondence is instrumental to the achievement of association change activities. At the point when done deliberately well the enthusiastic prizes are tasteful. Be that as it may, when it neglects to give the messages important to finish extends the outcomes can be disastrous (Hunt, 2014). Misconceptions, hatred, and a large group of other negative feelings could truly harm business connections. Great correspondence contributes towards operational and process efficiencies (Hunt, 2014). Thusly, it takes after that the estimation of utilizing viable correspondence as a device can never be over-accentuated or underrated for the effect it makes on fruitful results. This paper introduces the correspondence procedure attempted by an essential change operator with a twenty supervisor group. The objective is to build up a change administration arrange for that advances the association from a conventional work-gathering to a group based culture. Dialogs incorporate the channels of correspondence, customary work-bunches versus group based associations, the part of the essential change operator, the correspondence group, presumptions made, the progress procedure, change activity correspondence, group believability, confidence creation, and noting extreme inquiries. The paper closes with a reiteration of the substance. Conventional Working Groups Versus Team Based Organizations This segment recognizes working gatherings from group based associations. They don't work in a similar limit, thus, the need to separate them here. Conventional working gatherings (WG) inside associations work freely. Cases of conventional WGs are bookkeeping and human asset offices or new item divisions. These divisions work free of each other. Work is individualized (Zaharia, Dogaru, and Boaja, 2014). Conversely, group construct associations center with respect to various aptitudes and skills that meet up to meet a shared objective. Groups are not constrained to useful prerequisites. Groups utilize a cross-practical structure to work in a shared objective situation. People don't work free of the gathering objectives. Everybody cooperating accomplish the objective (Zaharia, Dogaru, and Boaja, 2014). Essential Change Agent Leadership Role Buono and Subbiah (2014) recommend that essential change operators (PCA) are powerful to the degree that they comprehend the social condition, can distinguish persuasive key players, and have the capacity to give mentorship, and additionally, positive part demonstrating. Buono and Subbiah (2014) recommend facilitate that PCAS are influencers. They spur and motivate change in others. Moreover, PCAS have inside frameworks information and can investigate issues as they emerge. Buono and Subbiah (2014) propose a case of PCA as somebody who can recognize unobtrusive unsettling influences that could conceivably meddle with change forms. A supervisor who is discerning, careful, and strategic is viewed as a viable PCA. Another illustration is an administrator who comprehends the business and how it gains income from start to finish. Still another case is a director who can make associations and cooperations all through the association (Tan and Kaufman, 2015). The Communication Team Lira, Ripoll, Peiró, and Zornoza (2013) propose that group ubiquity includes expanded inside the previous decade. They state assist that groups are successful just to the degree that they can finish extend related assignments on time utilizing different advanced innovations, for example, interpersonal organizations, and modernized mediums. Groups must end up proficient in creating successful relational connections. Lira et al. (2013) suggest that Human Resources encourage progressing initiative advancement preparing to expand amass viability and competency. The correspondence group serves to encourage the collaborations amongst administration and the workforce. Their designs will incorporate educatory forms that will enable the workforce to comprehend the change procedure. Bolman and Deal (2008) instruct on the intricacy with respect to association change and the ambiguities that are ever present in the informative procedure. They prescribe that the supervisors ponder their pictures to end up mindful of potential wrong points of view. They urge supervisors to be natural and consider that disappointment is one segment of progress. Setting Assumptions Displayed here are the presumptions made concerning the PCA. The PCA is knowledgeable about issues of compelling authoritative change. The PCA comprehends the correspondence procedure. The PCA is capable in positions of authority. At long last, the PCA is extremely knowledgeable in group elements and association political procedures. The accompanying suppositions are made inside the setting of the topic contained in this: the Organization Change Team (OCT; twenty administrators) doled out to this extend is certain and energetic about this change activity. They ooze a soul of investment with proactive dispositions. They see this undertaking from a worker authority viewpoint. They expect challenges and comprehend that each venture has unexpected conditions that must be tended to specially appointed (Kotter and Cohen, 2002). Progressing To A Team-Based Environment Progressing the social condition from that of a working gathering to a group based one requires the affirmation and acknowledgment that the outside condition has always showed signs of change the way associations learn new aptitudes (Katzenbach and Smith, 2003). Exact research on group progress from conventional work gatherings to groups is inadequate. The general accord is that change is vital, however actualizing a change activity is testing. Gardner (2009) recommends that representative protection and absence of administration bolster top the rundown of explanations behind venture disappointments. Bolman and Deal (2008) examine the significance of giving chances to find out about enthusiastic insight. Enthusiastic knowledge as it has been introduced by Goleman (1995) demonstrates the significance of compassion and recognizing the feelings of others. Goleman places that passionate insight has more noteworthy centrality than does scholarly capacities. Indicating sympathy and compassion is instrumental in worker engagement forms (Goleman, 1995). Idris, Dollard, and Tuckey (2015) suggest that associations can do much as far as contributing towards worker prosperity. They propose that businesses make situations helpful for learning openings. Idris et al. (2015) found a solid connection between's sheltered psychosocial conditions and occupation fulfillment. Idris et al. (2015) propose that representatives who feel mentally invigorated will probably ooze more grounded inherent inspiration boost. Such boost turns into the main impetus that makes motivation to take part in the change activity. >GET ANSWER