MOD006887 International Operations Management

MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 1 of 10
Case materials:
Pálinka International Unlimited
Assignment deadline: TBA

Assignment: 011 Group coursework: operations consultancy
simulation and report
MOD006887 International Operations Management
Module:

Module leader: Tom Farnsworth
Semester/Trimester: Tri 1
Academic year: 2019-20
MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 2 of 10
(0) Background
Pálinka is a traditional alcoholic beverage produced in Eastern Europe, principally Hungary
and Romania. It is distilled from fermented soft fruits – there is a common saying in Hungary
that, if you can make jam or conserve from it, you can make pálinka with it.
Pálinka International Unlimited (PIU) is a small distillery based in Kent, UK. It was established
eighteen months ago by two entrepreneurs, Erzsébet Nagy and Dacian Iridescu. They had
identified an opportunity to distil and supply pálinka to the sizeable diaspora populations of
Hungarians and Romanians in the UK, on three grounds:
§ The likely Brexit restrictions to be placed on freedom of movement between the
European Union and the UK would make it more difficult for visiting family members to
bring home-distilled pálinka to relatives living in the UK;
§ The likely increase in tariffs accompanying the UK’s exit from the European Union free
trade area would make formal importation of pálinka much less commercially
attractive;
§ Owing to the undeveloped market for fruit spirits in the UK, much of the soft fruit grown
in Kent below market grade or conserve grade, is simply turned into animal feed or
compost rather than being fermented and distilled.
After eighteen months of trading, the optimism of PIU’s founders about the commercial viability
of a UK-based pálinka distillery has largely been justified. The fruit growers’ co-operatives in
Kent are only too delighted to sell their utility-grade stone fruits to PIU, because they get a
better price from PIU than they would from animal feed manufacturers. The quality of the PIU
product and the efficiency of its distribution channels have won many retail and wholesale
customers.
In fact, sales have increased considerably to the point at which the capacity of the operation
must be increased; specifically:
§ a second pot still was installed and brought on line three weeks ago;
§ a climate-controlled warehouse extension has been built to improve inbound logistics;
§ new marketing channels have been established;
§ new staff members have joined the production team;
§ a new distribution centre is needed to cope with the volume of sales.
Unfortunately, all of these novel developments are causing problems. The day-to-day running
of the PIU operation is handled by Erzsébet, and she has her hands full training the new staff
and supervising production and outbound logistics. Dacian is the salesman and needs to be
on the road visiting account customers and signing new business. They agree that a little extra
investment in operations management consultancy is justified, and they call in your team to
help.

MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 3 of 10
(1) The strange case of Still no.2
From: Nagy, Erzsébet <e.nagy@piupalinka.co.uk>
Subject: URGENT: fusel alcohols from Still #2
Date: 23 September 2019 at 14:20
To: PIU Quality Team <qcteam@piupalinka.co.uk>
Hi all
I am very concerned by some of the readings for fusel alcohols arising from the second
distillations using the new still. As you know, we need SOME fusel alcohols in the
középpárlat [middle cut] for flavour and mouthfeel in the finished spirit, but some of the
readings seem crazy variable by comparison with Still #1.
Still #2 has been running since the beginning of the month, including 4 September when the
gas supply was interrupted by those idiot builders up the road and we had to restart the
burners. I attach the readings for parts per million of amyl alcohol, which as you know should
be between 10ppm and 30ppm.
I know you are busy with packaging inspections, but there are now three of you, so please
could you find time to check whether we need to take further action over this possible quality
issue.
Thanks,
E.
[Should show in control except for 4
th which is special cause]
MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 4 of 10
(2) Warehouse wisdom
From: Nagy, Erzsébet <e.nagy@piupalinka.co.uk>
Subject: Results from infrared thermometer gauge testing
Date: 23 September 2019 at 17:52
To: PIU Inbound Logistics <ilteam@piupalinka.co.uk>
Dear Adam and Jill
Tunbridge Instruments have finished their analyses of the new infrared thermometers you
have been testing. As you know, we will get a discount on these and the other instruments
for the new climate-controlled warehouse in exchange for testing prototypes 1, 21, 38 and
59.
I attach the results of the Gauge R&R and ANOVA output from their analysis. It looks pretty
good to me. I am out of the office tomorrow but the operations consultants from ARUL will be
here and they can explain the results.
Regards,
E.

MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 5 of 10
MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 6 of 10
(3) Lean on me (when you’re not strong)
From: Nagy, Erzsébet <e.nagy@piupalinka.co.uk>
Subject: Making better use of our space!
Date: 23 September 2019 at 19:36
To: PIU Inbound Logistics <ilteam@piupalinka.co.uk>
Dear all
While I am away tomorrow the consultants from ARUL will be looking at the efficiency of our
operation in terms of how we use our space and where our equipment is set up, so don’t be
alarmed by strangers with clipboards wandering about.
It occurred to me that, now we have the new still and the climate controlled warehouse
room, we could probably make things more efficient in terms of the way our equipment is
arranged. We can’t move the stills, the chillers, or the mains water supply, but we can move
anything else if we need to.
Inbound logistics
Inspection (pre storage)
Humidification
Weighing
Production
Inspection (post storage)
Grading
Washing
Stoning
Weighing
Fermentation
First distillation (Still #1)
Second distillation (Still #2)
Cooling (heat exchanger)
Bottling
Labelling
Packaging
Outbound logistics
Picking and packing
Palleting (large loads)
Please see below for a floorplan of the unit. I have only included the transforming resources
which cannot be physically moved (i.e. the climate-controlled warehouse, the pot stills, and
the mains water supply).

MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 7 of 10
MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 8 of 10
(4) How to get ahead in advertising
From: Iridescu, Dacian <d.iridescu@piupalinka.co.uk>
Subject: Cost v benefits – marketing B2B and B2C
Date: 25 September 2019 at 10:40
To:
Nagy, Erzsébet <e.nagy@piupalinka.co.uk>
Hi Erzsi
I’m just looking at the sales figures for the last seven quarters in comparison with our
marketing spend, and also at the number of visits I’ve made to each wholesaler in
comparison with their average monthly orders. I want to know how effective our marketing
activities have been: overall, and in terms of whether we should focus on B2C or B2B
markets. Eight wholesalers is a lot to manage, you know? Especially given the lower
margins.
Can you ask those eggheads from ARUL to run some kind of analysis?
Dacian

Sales
meetings
held with
each
wholesaler
12 9 7 6 4 3 2 2
A/c spend
per month
(£)
5,770 6,120 5,730 5,460 6,470 5,530 5,220 5,410

 

Social media
advertising spend (£)
B2C sales (£ 000)
2,200 230
1,800 193
3,300 400
1,500 160
2,900 220
1,800 670
4,300 845

MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 9 of 10
(5) Defying gravity?
From: Nagy, Erzsébet <e.nagy@piupalinka.co.uk>
Subject: New distribution centre, PIU Ltd
Date: 30 September 2019 at 09:12
To:
Lywood, Henry <henry.lywood@bexleysurveyors.co.uk>
Dear Henry
Further to our recent initial discussion about possible sites for our new distribution centre,
please find below some additional information about our existing sites. As you know, space
for outbound logistics is at a premium in our production facility now that we have added the
second pot still and the climate-controlled warehouse.
Our three most significant wholesalers are all located around the M25, in Rickmansworth,
Cheshunt and Orpington:

MOD006887 International Operations Management. Case materials for Assignment 011, Tri 1 2019-20 10 of 10
The grid location and pallets processed per month for the three existing locations are given
in the table below:

Facility Cx Cy Pallets/month
Rickmansworth 1.5 83.0 45
Cheshunt 63.5 95.0 32
Orpington 80.5 22.0 19

What we need to know as a matter of urgency, is the ideal location for a fourth distributor.
Thanks very much for your initial research and the identification of potential sites in Watford,
South Croydon and Mitcham.
We have some MBA students from ARU London working with us at the moment doing some
operations consultancy; I will ask them if they can work out which of these three potential
sites would be optimal considering the volume of business we are doing at the existing
three.
Kind regards
Erzsébet

WEEK 4 PSY6802 Assignment: Examine Current Research On Personal And Social Development

Instructions

For this assignment, write an essay about personal and social development in childhood and adolescence related to diverse populations in educational settings. You must review and include at least two peer-reviewed articles that are current (within the last 5 years) to demonstrate current research and thinking in the field of educational psychology.

Be sure to include the following points in your essay:

  • What hereditary and environmental factors are likely to contribute to your student’s distinctive personalities during personal and social development?
  • How will your students’ beliefs about themselves affect their classroom behavior and academic achievement?
  • How do peer relationships change with age?
  • What ways might students act (i.e., behaviors demonstrated) that will benefit others and themselves during personal and social development?

Length: 5-7 pages, not including the title and reference pages

Reference: Include a minimum of three scholarly resources.

Your essay should demonstrate thoughtful consideration of the ideas and concepts presented in the course by providing new thoughts and insights relating directly to this topic. Your response should reflect graduate-level writing in APA standards. Be sure to adhere to Northcentral University’s Academic Integrity Policy

Business Outcomes Ethics Questions

You are the general manager of a regional chemical company. In the course of producing your bulk chemicals, large amounts of particles and smoke are emitted through your plant’s smokestack.

· The level of pollutants is below current EPA regulations, and you are violating no laws,

· but neighborhood groups are complaining about minor health problems caused by the smoke.

After investigating numerous alternatives, you find the most effective solution would be to install a “scrubber” system which will remove 90% of the pollutants and ash. Coat =$1 million. Do you install the system?

Identify three stakeholders and at least two specific ethical considerations or questions for each of the stakeholders you select.

SQL Programming

1/3
region_id (p) region_name super_region_id (f)
101 North America
102 USA 101
103 Canada 101
104 USA-Northeast 102
105 USA-Southeast 102
106 USA-West 102
107 Mexico 101
Region
Product
product_id (p) product_name
1256 Gear – Large
2/3
4437 Gear – Small
5567 Crankshaft
7684 Sprocket
Sales_Totals
product_id (p)(f) region_id (p)(f) year (p) month (p) sales
1256 104 2020 1 1000
4437 105 2020 2 1200
7684 106 2020 3 800
1256 103 2020 4 2200
4437 107 2020 5 1700
7684 104 2020 6 750
1256 104 2020 7 1100
4437 105 2020 8 1050
7684 106 2020 9 600
1256 103 2020 10 1900
4437 107 2020 11 1500
7684 104 2020 12 900
Answer the following questions using the above tables/data:

3/3
1. The database designer included columns for Year and Month in the Sales_Totals table, but forgot to
include a column for Quarter. Write a CASE expression which can be used to return the quarter number
(1, 2, 3, or 4) using other column values from the table.
2. Write a query which will pivot the Sales_Totals data so that there is a column for each of the 4 products
containing the total sales across all months of 2020. It is OK to include the product_id values in your
query, and the results should look as follows:

tot_sales_large_gears tot_sales_small_gears tot_sales_crankshafts tot_sales_sprockets
6200 5450 0 3050

3. Write a query which retrieves all columns from the Sales_Totals table, along with a column called
sales_rank which assigns a ranking to each row based on the value of the Sales column in descending
order.
4. Write a query which retrieves all columns from the Sales_Totals table, along with a column called
product_sales_rank which assigns a ranking to each row based on the value of the Sales column in
descending order, with a separate set of rankings for each product.
5. Expand on the query from question #4 by adding logic to return only those rows with a
product_sales_rank of 1 or 2.
6. Write a set of SQL statements which will add a row to the Region table for Europe, and then add a row to
the Sales_Total table for the Europe region and the Sprocket product (product_id = 7684) for October 2020,
with a sales total of $1,500. The statements should be executed as a single unit of work.
7. Write a statement to create a view called Product_Sales_Totals which will group sales data by product
and year. Columns should include product_id, year, product_sales, and gear_sales, which will contain the
total sales for the “Gear – Large” and “Gear Small” products (should be generated by an expression, and it is
OK to use the product_id values in the expression).
8. Write a query to return all sales data for 2020, along with a column showing the percentage of sales for
each product. Columns should include product_id, region_id, month, sales, and pct_product_sales.
9. Write a query to return the year, month, and sales columns, along with a 4th column named
prior_month_sales showing the sales from the prior month. There are only 12 rows in the sales_totals table,
one for each month of 2020, so you will not need to group data or filter/partition on region_id or product_id.
10. If the tables used in this prompt are in the ‘sales’ database, write a query to retrieve the name and type
of each of the columns in the Product table.

Assignment 5: Evaluation of the Agency’s Budgeting and Cumulative Report

Assignment 5: Evaluation of the Agency’s Budgeting and Cumulative Report
Due Week 10 and worth 290 points

As a consultant, you need to develop an in-depth analysis and evaluation of the selected agency’s budgeting and then provide recommendations for improvement. Therefore, you will conduct interviews with agency representatives and research-related academic sources and Websites. The analysis will be read by the VP of Accounts and Client Support as well as by the leaders of the agency for whom you are working.

Write a five to six (5-6) page paper in which you:

  1. Analyze the agency’s (or department’s) budget by following these six (6) steps and including the results of the analysis in your paper by: (a) identifying the agency’s budget as executive department or an independent agency; (b) determining which of the appropriation subcommittees has jurisdiction over each agency’s budget request; (c) determining where each agency’s operations fall in the functional classification of the federal budget; (d) determining the budget authority and outlays proposed for the agency; and (e) determining the actual outlays and budget authority for the agency in that year. (Title this section Budget Overview.)
  2. Analyze two (2) major political influences on and primary accountability areas required of program administrators after reviewing FY2012 regarding mandatory and discretionary budgets. (Title this section Budgeting Assessment.)
  3. Explain which intergovernmental agency, or agencies, contributes to and / or influences the budgetary decisions for the current and future budget over the next five (5) years. (Title this section Analysis of Budgeting Plans and Actual Expenditures.)
  4. Analyze the impact of international policy making on the current year’s budgets and possible impact on future budget line items. (Title this section Implications of Foreign Policy.)
  5. Recommend two (2) robust ways in which the agency could improve the budget for the next fiscal year. (Title this section Budget Request and Recommendations.)
  6. Provide proof of one to two (1-2) interviews by submitting the completed interview form with a list of questions for and responses from each interviewee. (Put this in the Appendix under Interview Forms.)
  7. Provide four to five (4-5) relevant and credible outside resources that support the content of this assignment. (Include no more than one (1) non-government Website.)

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The sections must have appropriate titles. The cover page, interview forms, reference page, and the appendices are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

  • Recommend ways to improve specific areas of public administration.
  • Analyze the fundamental components of effective budgeting, including sources of revenue, political influences, purposes, types, and accountability of program administrators.
  • Use technology and information resources to research issues in public administration.
  • Write clearly and concisely about public administration using proper writing mechanics.

Assignment 4: Evaluation of Agency’s Human Resources Management

Assignment 4: Evaluation of Agency’s Human Resources Management
Due Week 8 and worth 240 points

As a consultant, you need to develop an in-depth analysis and evaluation of the selected agency’s human resources management system and processes and then provide recommendations for improvement. Therefore, you will conduct interviews with agency representatives and research related academic sources and Websites. The analysis will be read by the VP of Accounts and Client Support as well as by the leaders of the agency for whom you are working.

Write a five to six (5-6) page paper in which you:

  1. Analyze three to four (3-4) of the major components of the agency’s human resource system, processes, and performance evaluation plan for hiring and retaining a diversified workforce. (Title this section Human Resource Processes.)
  2. Analyze and describe the implications impacting the agency’s current employment trend, growth, and delivery of its products and services. (Title this section Implications of Human Resource Workforce.)
  3. Recommend two to three (2-3) managerial and professional skills and competencies required to improve the agency’s workforce by explaining each recommendation, providing reasons each recommendation would bring about improvement, providing two to three (2-3) ways the agency could implement programs in preparation for those skills not visible within the agency’s workforce as a method of promotion and advancement for current employees. (Title this section Succession Planning for Human Resource Management.)
  4. Describe the consultant position you are performing by (a) giving it a title; (b) explaining two to three (2-3) major specifications required of the job and how each will be measured in a performance evaluation; and by (c) explaining two to three (2-3) ways this position will be used within the various departments of the agency and for meeting the specific goals / objectives of the agency. (This job description will be provided to the Agency Director who has requested it. As a resource, you are to use the Dictionary of Occupational Titles, located at http://www.occupationalinfo.org/ and published by the U. S. Department of Labor located at www.usajobs.gov. (Title this section Job Analysis and Design.)
  5. Provide proof of one to two (1-2) interviews submitting the completed interview form with a list of questions for and responses from each interviewee. (Put this in the Appendix under Interview Forms.)
  6. Provide four to five (4-5) relevant and credible outside resources that support the content of this assignment. (Include no more than one (1) non-government Website.)

Your assignment must follow these formatting requirements:

  • Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA format. Check with your professor for any additional instructions.
  • Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The sections must have appropriate titles. The cover page, reference page, and appendix pages are not included in the required assignment page length. The assignment must be submitted as a Microsoft Word document.

The specific course learning outcomes associated with this assignment are:

  • Recommend ways to improve specific areas of public administration.
  • Analyze the major components of the system, processes, and methods for effective human resource management in the public sector.
  • Assess external organizational and employee conditions, trends, and implications of these factors for human resource management of the private sector.
  • Use technology and information resources to research issues in public administration.
  • Write clearly and concisely about public administration using proper writing mechanics.

Grading for this assignment will be based on answer quality, logic/organization of the paper, and language and writing skills, using the following rubric.