Operational Excellence Case Study

Case Study: Blackberry Hill Farm

page 384

Read the case study and answer the following questions. Provide an introduction, a conclusion, and refrences.

Key issues

  • Capacity management in both services and manufacturing in a seasonal business
  • Quality – service trade-offs
  • Inventory – availability trade-offs
  • Marketing/operations interaction
  • Strategy in small businesses.

Questions

1. How do the overall objectives of the business impact on the capacity management of the

various parts of the farm?

2. How important is demand variation to this business as a whole and to each of its separate

attractions?

3. How could the farm as a whole and each of its separate attractions cope with demand

fluctuations?

4. What are the strengths and weaknesses of the proposed new ventures (Schoolroom vs. Maize

maze)? What advice would you give Jim and Mandy regarding this year’s new venture?

Use APA format.

Provide a cover page.

384 Part tHrEE DELIVER

casE study blackberry Hill Farm

‘ Six years ago I had never heard of agri-tourism. As far as I was concerned, I had inherited the farm and I would be a farmer all my life .’ ( Jim Walker, Blackberry Hill Farm)

the ‘agri-tourism’ that Jim was referring to is ‘a commer- cial enterprise at a working farm, or other agricultural cen- tre, conducted for the enjoyment of visitors that generates supplemental income for the owner’. ‘ Farming has become a tough business ’, says Jim. ‘ Low world prices, a reduction in subsidies, and increasingly uncertain weather patterns have made it a far more risky business than when I first inherited the farm. Yet, because of our move into the tourist trade we are flourishing. Also … I’ve never had so much fun in my life .’ But, Jim warns, agri-tourism is not for everyone. ‘ You have to think carefully. Do you really want to do it? What kind of life style do you want? How open-minded are you to new ideas? How business-minded are you? Are you willing to put a lot of effort into marketing your business? Above all, do you like working with people? If you had rather be around cows than people, it isn’t the business for you .’

History Blackberry Hill Farm was a 200-hectare mixed farm in the south of England when Jim and mandy Walker inher- ited it 15 years ago. It was primarily a cereal growing operation with a small dairy herd, some fruit and veg- etable growing and mixed woodland that was protected by local preservation laws. Six years ago it had become evident to Jim and mandy that they may have to rethink how the farm was being managed. ‘ We first started a pick-your-own (PYO) operation because our farm is close to several large centres of population. Also the quantities of fruit and vegetables that we were producing were not large enough to interest the commercial buyers. Entering the PYO market was a reasonable success and in spite of mak- ing some early mistakes, it turned our fruit and vegetable growing operation from making a small loss to making a small profit. Most importantly, it gave us some experience of how to deal with customers face-to-face and of how to cope with unpredictable demand. The biggest variable in PYO sales is weather. Most business occurs at the week- ends between late spring and early autumn. If rain keeps customers away during part of those weekends, nearly all sales have to occur in just a few days .’

Within a year of opening up the pyO operation Jim and mandy had decided to reduce the area devoted to cereals and increase their fruit and vegetable growing capability. at the same time they organized a petting zoo that allowed children to mix with, feed and touch various animals.

‘ We already had our own cattle and poultry but we extended the area and brought in pigs and goats. Later we also introduced some rabbits, ponies and donkeys, and even

a small bee keeping operation .’ at the same time the farm started building up its collection of ‘farm heritage’ exhib- its. these were static displays of old farm implements and ‘recreations’ of farming processes together with information displays. this had always been a personal interest of Jim’s and it allowed him to convert two existing farm outbuild- ings to create a ‘museum of Farming Heritage’.

the year after, they introduced tractor rides for vis- itors around the whole farm and extended the petting zoo and farming tradition exhibits further. But the most significant investment was in the ‘preserving kitchen’. ‘ We had been looking for some way of using the surplus fruits and vegetable that we occasionally accumulated and also for some kind of products that we could sell in a farm shop. We started the Preserving Kitchen to make jams and fruit, vegetables and sauces preserved in jars. The venture was an immediate success. We started making just fifty kilo- grammes of preserves a week, within three months that had grown to three hundred kilogrammes a week and we are now producing around a thousand kilogrammes a week, all under the “Blackberry Hill Farm” label .’ the following year the preserving kitchen was extended and a viewing area added. ‘ It was a great attraction from the beginning ’, says mandy. ‘ We employed ladies from the local village to make the preserves. They are all extrovert characters, so when we asked them to dress up in tradi- tional “farmers wives” type clothing they were happy to do it. The visitors love it, especially the good natured repartee with our ladies. The ladies also enjoy giving informal his- tory lessons when we get school parties visiting us .’

So ur

ce : S

hu tt

er st

oc k.

co m

: K ar

el g

al la

s

M11_SLAC8678_08_SE_C11.indd 384 06/02/16 7:20 PM

 

 

cHaPtEr 11 CapaCIty managEmEnt 385

Within the last two years the farm had further extended its preserving kitchen, farm shop, exhibits and petting zoo. It had also introduced a small adventure playground for the children, a café serving drinks and its own produce, a pic- nic area and a small bakery. the bakery was also open to view by customers and staffed by bakers in traditional dress. ‘It’s a nice little visitor attraction’, says mandy, ‘and it gives us another opportunity to squeeze more value out of our own products.’ table 11.4(a) shows last year’s visitor numbers, and table 11.4(b) shows the farm’s opening times..

demand the number of visitors to the farm was extremely sea- sonal. From a low point in January and February, when most people just visited the farm shop, the spring and summer months could be very busy, especially on public holidays. the previous year mandy had tracked the num- ber of visitors arriving at the farm each day. ‘It is easy to

record the number of people visiting the farm attractions, because they pay the entrance charge. What we had not done before is include the people who just visited the farm shop and bakery that can be accessed both from within the farm and from the car park. We estimate that the number of people visiting the shop but not the farm ranges from 74 per cent in February down to around 15 per cent in August.’ Figure 11.17 shows the number of visitors in the previous year ’s august. ‘What our figures do not include are those people who visit the shop but don’t buy anything. This is unlikely to be a large number.’ Figure 11.18 shows visitor arrivals on a public holiday in august and a Wednesday in February.

mandy had also estimated the average stay at the farm and/or farm shop. She reckoned that in winter time the aver- age stay was 45 minutes, but in august in climbed to 3.1 hours.

current issues Both Jim and mandy agreed that their lives had funda- mentally changed over the last few years. Income from visitors and from the Blackberry Hill brand of preserves now accounted for 70 per cent of the farm’s revenue. more importantly, the whole enterprise was significantly

table 11.4(a) number of visitors last year

month total visitors

January February march april may June July august September October november December total average

1,006 971

2,874 6,622 8,905

12,304 14,484 15,023 12,938

6,687 2,505 3,777

88,096 7,341.33

table 11.4(b) Farm opening times*

January–mid-march Wednesday–Sunday 10:00–16:00

mid-march–may tuesday–Sunday 09:00–18:00

may–September all week 08:30–19:00

October–november tuesday–Sunday 10:00–16:00

December tuesday–Sunday 09:00–18:00

*Special evening events Easter, summer weekends and Christmas.

Figure 11.17 daily number of visitors in august last year

1 5 201510 3025

500

1000

1500

M11_SLAC8678_08_SE_C11.indd 385 06/02/16 7:20 PM

 

 

386 Part tHrEE DELIVER

more profitable than it had ever been. nevertheless, the farm faced a number of issues.

the first was the balance between its different activities. Jim was particularly concerned that the business remained a genuine farm. ‘When you look at the revenue per hectare, visitor and production activities bring in far more revenue than conventional agricultural activities. However, if we push the agri-tourism too far we become no better than a theme park. We represent something more than this to our visitors. They come to us partly because of what we represent as well as what we actually do. I am not sure that we would want to grow much more. Anyway, more visitors would mean that we have to extend the car park. That would be expensive, and although it would be necessary, it does not directly bring in any more revenue. There are already parking problems during peak periods and we have had complaints from the police that our visitors park inappropriately on local roads.

‘There is also the problem of complexity. Every time we introduce a new attraction, the whole business gets that little bit more complex to manage. Although we enjoy it tremen- dously, both Mandy and I are spreading ourselves thinly over an ever widening range of activities [mandy was also con- cerned over this]. I’m starting to feel that my time is being taken up in managing the day-to-day problems of the busi- ness. This does not leave time either for thinking about the overall direction in which we should be going, or spending time talking with the staff. That is why we both see this com- ing year as a time for consolidation and for smoothing out the day-to-day problems of managing the business, particularly the queuing, which is getting excessive at busy times. That is why this year we are limiting ourselves to just one new ven- ture for the business.’

Staff management was also a concern for mandy. the business had grown to over 80 (almost all part-time and seasonal) employees. ‘We have become a significant

employer in the area. Most of our employees are still local people working part-time for extra income but we are also now employing 20 students during the summer period and, last year, 8 agricultural students from Eastern Europe. But now, labour is short in this part of the country and it is becoming more difficult to attract local people, especially to produce Blackberry Hill Farm Preserves. Half of the Preserving Kitchen staff work all year, with the other employed during the summer and autumn periods. But most of them would prefer guaranteed employment throughout the year’

table 11.5 gives more details of some of the issues of managing the facilities at the farm, and table 11.6 shows the preserve demand and production for the previous year.

where next? By the ‘consolidation’ and improvement of ‘day-to-day ’ activities Jim and mandy meant that they wanted to increase their revenue, while at the same time reducing the occasional queues that they knew could irritate their visitors, preferably without any significant investment in extra capacity. they also were concerned to be able to offer more stable employment to the preserving kitchen ‘ladies’ throughout the year, who would produce at a near constant rate. However, they were not sure if this could be done without storing the products for so long that their shelf life would be seriously affected. there was no prob- lem with the supply of produce to keep production level – less than 2 per cent of the fruit and vegetables that go into preserves are actually grown on the farm. the remainder were bought at wholesale markets, although this was not generally understood by customers.

Of the many ideas being discussed as candidates for the ‘one new venture’ for next year, two were emerging as particularly attractive. Jim liked the idea of develop- ing a maize maze, a type of attraction that had become

Figure 11.18 Visitor arrivals, public holiday in august and a wednesday in February

8.00

100

200

10.00 12.00 14.00 16.00 18.00 20.00

300

400

Public holiday in August

Wednesday in February

M11_SLAC8678_08_SE_C11.indd 386 06/02/16 7:20 PM

 

 

cHaPtEr 11 CapaCIty managEmEnt 387

table 11.5 the farm’s main facilities and some of the issues concerned with managing them

Facility issues

car park ● 85 car parking spaces, 4 * 40-seater tour bus spaces

Fixed exhibits etc. Recreation of old farmhouse kitchen, recreation of barnyard, old-fashioned milking parlour, various small exhibits on farming past and present, adventure playground, ice cream and snack stands

● most exhibits in, or adjacent to, the farm museum ● at peak times have helpers dressed in period costume to entertain

visitors ● Feedback indicates customers find exhibits more interesting than they

thought they would ● Visitors free to look when they wish absorbs demand from busy facilities

tractor rides One tractor towing decorated covered cart with maximum capacity of 30 people, tour takes around 20 minutes on average (including stops). Waits 10 minutes between tours except at peak times when tractor circulates continuously

● tractor acts both as transport and entertainment, approximately 60% of visitors stay on for the whole tour, 40% use it as ‘hop-on, hop-off’ facility

● Overloaded at peak times, long queues building ● Feedback indicates it is popular, except for queuing ● Jim reluctant to invest in further cart and tractor

Pick-your-own area Largest single facility on the farm. Use local press, dedicated telephone line (answering machine) and website to communicate availability of fruit and vegetables. Checkout and weighing area next to farm shop, also displays picked produce, preserves, etc., for sale

● Very seasonal and weather dependent, both for supply and demand ● Farm plans for a surplus over visitor demand, uses surplus in preserves ● Six weighing/paying stations at undercover checkout area ● Queues develop at peak times. Feedback indicates some

dissatisfaction with this ● Can move staff from farm shop to help with checkout in busy periods,

but farm shop also tends to be busy at the same time ● Considering using packers at pay stations to speed up the process

Petting zoo accommodation for smaller animals including sheep and pigs. Large animals (cattle, horses) brought to viewing area daily. Visitors can view all animals and handle/stroke most animals under supervision

● approximately 50% of visitors view petting zoo ● number of staff in attendance varies between 0 (off-peak) and 5

(peak periods) ● the area can get congested during peak periods ● Staff need to be skilled at managing children

Preserving kitchen Boiling vats, mixing vats, jar sterilizing equipment, etc. Visitor viewing area can hold 15 people comfortably. average length of stay 7 minutes in off-season, 14 minutes in peak season

● Capacity of kitchen is theoretically 4,500 kilograms per month on a 5-day week and 6,000 kilograms on a 7-day week

● In practice, capacity varies with season because of interaction with visitors. Can be as low as 5,000 kilograms on a 7-day week in summer, or up to 5,000 kilograms on a 5-day week in winter

● Shelf life of products is on average 12 months ● Current storage area can hold 16,000 kilograms

bakery Contains mixing and shaping equipment, commercial oven, cooling racks, display stand, etc. Just installed doughnut making machine. all pastries contain farm’s preserved fruit

● Starting to become a bottleneck since doughnut making machine installed – visitors like watching it

● products also on sale at farm shop adjacent to bakery ● Would be difficult to expand this area because of building constraints

Farm shop and café Started by selling farm’s own products exclusively. now sells a range of products from farms in the region and wider. Started selling frozen menu dishes (lasagne, goulash, etc.) produced off-peak in the preserving kitchen

● the most profitable part of the whole enterprise, Jim and mandy would like to extend the retailing and café operation

● Shop includes area for cooking displays, cake decoration, fruit dipping (in chocolate), etc.

● Some congestion in shop at peak times but little visitor dissatisfaction ● more significant queuing for café in peak periods ● Considering allowing customers to place orders before they tour the

farm’s facilities and collect their purchases later ● Retailing more profitable per square metre than café

M11_SLAC8678_08_SE_C11.indd 387 06/02/16 7:20 PM

 

 

388 Part tHrEE DELIVER

table 11.6 Preserve demand and production (previous year)

month demand (kg) cumulative demand (kg) Production (kg) cumulative product (kg) inventory (kg)

January February march april may June July august September October november December average demand

682 794

1,106 3,444 4,560 6,014 9,870

13,616 5,040 1,993 2,652 6,148 4,660

682 1,476 2,582 6.026

10,586 16,600 26,470 40,086 45,126 47,119 49,771 55,919

4,900 4,620 4,870 5,590 5,840 5,730 5,710 5,910 5,730 1,570* 2,770* 4,560

4,900 9,520

14,390 19,980 25,820 31,550 37,260 43,170 48,900 50,470 53,240 57,800

average inventory

4,218 8,044

11,808 13,954 15,234 14,950 10,790

3,084 3,774 3,351 3,467 1,881 7,880

*technical problems reduced production level.

increasingly popular in Europe and north america in the last five years. It involved planting a field of maize (corn) and, once grown, cutting through a complex serious of paths in the form of a maze. Evidence from other farms indicated that a maze would be extremely attractive to visitors and Jim reckoned that it could account for up to an extra 10,000 visitors during the summer period. Designed as a separate activity with its own admis- sion charge, it would require an investment of around £20,000, but generate more than twice that in admis- sion charges as well as attracting more visitors to the farm itself.

mandy favoured the alterative idea – that of building up their business in organized school visits. ‘ Last year we joined the National Association of Farms for Schools. Their advice is that we could easily become one of the top school attractions in

this part of England. Educating visitors about farming tradition is already a major part of what we do. And many of our staff have developed the skills to communicate to children exactly what farm life used to be like. We would need to convert and extend one of our existing underused farm outbuildings to make a ‘school room’ and that would cost between and £30,000 and £35,000. And although we would need to discount our admis- sion charge substantially, I think we could break even on the investment within around two years .’

quEstions 1 How could the farm’s day-to-day operations be

improved?

2 what advice would you give Jim and mandy regarding this year’s ‘new venture’?

a local government office issues hunting licences. Demand for these licences is relatively slow in the first part of the year but then increases after the middle of the year before slowing down again towards the end of the year. the department works a 220-day year on a basis of 5 days a week. Between working days 0 and 100, demand is 25 per cent of demand during the peak period that lasts between day 100 and day 150. after day 150, demand reduces to about 12 per cent of the demand during the peak period. In total, the department processes 10,000 applications per year. the department has two permanent members of staff who are capable of processing 15 licence applications per day. If an untrained temporary member of

1

ProbLEms and aPPLications

M11_SLAC8678_08_SE_C11.indd 388 06/02/16 7:20 PM

Mini Case Study – Enterprise Architecture At Nationstate Insurance

i CAse

Enterprise Architecture 5 at Nationstate Insurance

Jane Denton looked around at her assembled senior IT leadership team waiting to hear what she was going to say. Most were leaning forward eagerly, though some appeared more cautious. They were a good team, she knew, and she wanted to lead them well. A seasoned CIO, with a whole career behind her in IT, Jane was the newly appointed global CIO of Nationstate Insurance. This would be her last job before retirement in three years and she wanted to find a way to make a lasting difference in this company. Nationstate was an excellent company—Jane had done her homework. It was one of the largest in the United States, with a worldwide presence in personal and commercial insurance, and had recently been voted one of Forbes’ “Best Big Companies.” It had good systems, good user–IT relationships, and good people. But the company aspired to be great and Jane wanted to help them by taking IT to the next level. She knew that the world was changing—largely as a result of technology—and she knew that IT and its traditional approach to systems development was also going to have to change. “Our IT function needs to become more cutting edge in adopting emerging technolo- gies,” she had told the CEO shortly after she was hired, “and we need to become more flexible and agile in our approach to development work.” Now she had this time and this team to accomplish her goals.

However, it was much easier said than done. Like almost every large organiza- tion, Nationstate had a hodgepodge of different systems, data, and processes—most serving just one of its six business units (BUs). Nationstate’s decentralized structure had served it well in the past by enabling individual BUs to respond quickly to chang- ing market needs but a couple of years before Jane’s arrival, recognizing the need for some enterprise thinking, the CEO had created a federated structure with some central- ized functions, including parts of IT. So some of IT was now centralized and shared by all the BUs (e.g., operations) and reported directly to Jane, while the rest (e.g., system development) was decentralized. Each BU had its own CIO and IT staff who reported jointly to the BU’s president and to Jane.

This potentially unwieldy structure was made more palatable by the fact that the business unit CIOs had great business knowledge and were well trusted by their presi- dents. In fact, it was central IT that was often seen as the roadblock by the BUs. She had never led an IT organization like it, she reflected, and in her first few months, she had made a considerable effort to understand the strengths and weaknesses of this model and how responsibilities had been divided between centralized enterprise services and the decentralized IT groups (each quite large themselves) in the business units.

5 Smith, H. A., and J. D. McKeen. “Enterprise Architecture at Nationstate Insurance.” #1-L11-1-001, Queen’s School of Business, September 2007. Reproduced by permission of Queen’s University, School of Business, Kingston, Ontario, Canada.

160

Enterprise Architecture at Nationstate Insurance 161

Now she thought she had a good enough handle on these that she could begin work with her senior leadership team (the BU CIOs) to develop a plan to transform IT into the kind of technology function Nationstate would need in the years to come.

“I know you are both enthusiastic and apprehensive about transformation,” she said. “We have a great organization and no one wants to lose that. We need to be responsive to our business needs but we also need to incorporate new development techniques into our work, do a better job with emerging technologies, and begin to rationalize our application and technology portfolios. We have duplicate systems, data and software all over the place. Our CEO and the BU Presidents want to see us use our technology resources more efficiently, but more than that, they want our leadership in using technology effectively for the organization as a whole. We can’t do this if we’re all working in separate silos.”

Heads began nodding around the room as she continued. “At present, every busi- ness unit has its own IT architecture and architects and each of you believe you are mak- ing the ‘right’ technology decisions but you are all doing it differently.” The head nodding stopped and a mood of wariness took over. “No one in our organization has the big pic- ture of what we have and where we need to go. We have to learn what makes sense for us to do at an enterprise level and what’s best left in the business units. Architecting our technology, information, business and applications properly is the key to doing it right.”

“What exactly are you proposing?” asked Owen Merton, CIO of the Casualty Division. “I think you’re right that we need an enterprise architecture, but I don’t want to lose the good work we’ve done at the BU level.”

“Well, I really want to centralize all architecture,” said Jane. “I think that’s what works best in other organizations and that’s going to be the most effective way to make it work here. BUT…” she added, “I’d like to speak with each of you individually and with your senior architects before I do. I’m open to your ideas as long as they address the needs that I’ve just outlined.”

Over the next two weeks, Jane listened carefully to what the divisional CIOs had to say. They all agreed with Merton that the relationships with the BUs were extremely important and centralizing architecture had to be done carefully. All of them had heard horror stories about the “architecture police” in other companies—hard-line techies who set standards and created blueprints and insisted on them being followed in spite of the difficulties their policies caused for the business.

“Architecture can’t live in an ivory tower,” explained Vic Toregas, CIO of Claims. “It has to be rooted in the reality of our business and it can’t be seen to slow things down.” Jane agreed. “We must make sure that our architecture function is designed and managed to ensure rapid delivery to the business.”

On the other hand, Nick Vargo, CIO of Group Health, was concerned that without a strong enforcement mechanism, standards wouldn’t be followed. “What’s the point of having standards if we don’t enforce them?” he asked.

Jane’s head whirled. It wasn’t going to be easy to strike the right balance between developing a good, sustainable process that would provide a blueprint for where the company needed to go and enable the company to build the common capa- bilities it would need for the future, while delivering solutions quickly and flexibly for the BUs. “What we don’t need is a ‘Winchester Mystery House’,” she reflected, recalling the famous local house whose owners kept adding to it over many years with no overall plan.

162 Section II • IT Governance

She became more worried when she began to speak with the BU architects, with an eye to appointing one of them as her chief enterprise architect. They seemed to be technically competent but were not what she would call “relationship people” or busi- ness strategists. The job, as she envisioned it, would combine strong leadership skills, a good understanding of the business, and excellent communication skills to translate why the business should care about architecture, with strong technical skills. Her day became a bit brighter when she began her final interview with Seamus O’Malley, the senior architecture manager of the commercial BU.

As they spoke, Jane was impressed with his vision and pragmatism, as well as his strong communication skills. By the end of the hour she knew she had found her new chief enterprise architect. “I’d like you to take this new job,” she told him. “I think you are the right person to ensure we have the standards, tools and practices in place to develop a common architecture for Nationstate.” Seamus thought for a moment before replying. It was a great offer but he had his doubts that Jane’s plan would work and this situation had to be carefully handled.

“Thank you for your faith in me,” he began diplomatically, “but I would like to suggest a slight modification to your plan. You see, I’ve been an architect in central- ized organizations and there has always been an ‘us versus them’ mentality between the architecture group and both the rest of IT and the business units.” Jane recalled the horror stories of the “architecture police.” “So what I’d like to propose is a com- promise. I would become Chief Enterprise Architect but I would also remain Senior Architecture for Commercial and involve the other BU Senior Architects in creating a strong enterprise architecture that works for us all. That way, no one will see me as just ‘the enterprise guy’ and whatever standards we set and decisions we make centrally will affect me in Commercial, just like they’ll affect all the other BUs. When the other business units see that I’m willing to eat my own dog food, I think they’ll be more ready to accept the standards and changes we’ll be introducing.”

While not sure the compromise would work, Jane agreed to try it for a year and Seamus set out to build a centralized architecture function from scratch. With the authority given to him by Jane, all of the BU senior architects now had a dual reporting relationship—to their CIO and to him as the chief architect.

At their first weekly meeting with the BU senior architects, Seamus outlined his role and agenda. “As you know, each of us has been individually responsible for developing an effective IT architecture for our business units but we haven’t done any coordination between them. That is no longer good enough for our business needs and I, with your help, have been given the job of establishing an enterprise architecture that will create an enterprise technology blueprint for Nationstate, which we will all have to follow in the business units. I want to work collaboratively with you so that we come up with a plan and processes that will work for each of us in the business units, as well as for the enterprise as a whole. We will need to build our enterprise architecture slowly but steadily so that people will trust us, and that means having good governance, good processes and a collaborative approach to this work,” he stated. “Our first priority is building strong relationships with both Jane and the other CIOs and our BU Presidents. Enterprise Architecture sits in the middle between these groups, so good relationships are essential.” “However,” he continued. “We are going to need a way to establish and enforce standards—enterprise ones, not the ones you have now—and this is going to be difficult to explain.”

Enterprise Architecture at Nationstate Insurance 163

“I’ll say,” remarked Sarah Jensen, the senior architecture manager from Personal Insurance. “What do we say when the business asks why they can’t do something that’s important to them because our ‘standards’ won’t let them?”

“That’s a good question Sarah,” said Seamus. “And it gets right to the heart of why architecture is important. We need to present architecture in ways that are easy for the business to understand, without scaring or threatening them. For example, we need an application reduction strategy designed to eliminate duplication, reduce complexity and save money. The business already understands the pain of having to jump from system to system and knows that owning two cars is more expensive than one. If we explain it to them in this way, they will understand the advantages of having a single system and a single workflow.”

“But isn’t good architecture about more than cost savings?” asked Michael Lee, senior architecture manager from Claims. “We need to develop a foundation of com- mon information, tools and processes so that we’re not reinventing the wheel going into the future. And someone needs to decide what new technologies we’re going to need and where we’re going to use them. There are so many new applications and devices coming out every day now, we’re going to be in a real mess if we don’t do this properly.”

“You’re exactly right,” said Seamus. “These things do have to be managed for the good of the enterprise—both to make it more effective and more efficient. But it’s how we manage them that’s important. If we put lots of bureaucracy in place and don’t add value, no one is going to support us and they’ll find ways to undermine what we are trying to do. We can’t take a ‘field of dreams’ approach to architecture. We need to attach our work to real business value and real projects. Once our leaders understand this, we’ll get their support.”

“So here’s our challenge,” Seamus told his assembled team a few minutes later. “We need to design an Enterprise Architecture function that does all these things. It’s got to be a process that comes up with the standards and guidelines that each of you can live with and support in the BUs. And, as you know, I myself will have to live with them in Commercial as well.”

“Here’s what I believe we need to accomplish as soon as possible,” he stated, flashing a PowerPoint slide on the screen:

1. An enterprise governance process to set architecture strategy, policies and stan- dards for technology, applications, and information that reflects the federated struc- ture in the organization. 


2. A means of monitoring that all new projects comply with the agreed-upon archi- tecture while ensuring that this process doesn’t present an obstacle to getting IT projects completed quickly. 


3. A process for allowing “variances” to the current standards, if necessary, and a way to manage them back to the agreed-on standards. 


4. A means of identifying important new IT capabilities and services that should be shared by the enterprise. 


5. A means of evaluating emerging new technologies and setting standards for them. 


6. Identifying roles and responsibilities for the enterprise architecture function and 
the LOB architecture functions. 


7. Developing a means of incorporating feedback and continuous improvement into 


our work.

164 Section II • IT Governance

“I want to blend and weave our work into the architecture teams we already have in the business units as much as possible,” Seamus concluded. “This will keep us close to business needs and enable us to get enterprise value from the teams we have in place. And I don’t want to add any more process than we need to at an enterprise level. For example, if the Claims group needs a new technology, their architecture group could do the preliminary evaluation and make recommendations for what we should do. But we need to ensure that the resulting decision is a good one for the entire enterprise.”

“I’ve got to report back to Jane in a month, so I’d like you to think about what might and might not work for your division and for us as an enterprise. I’ve scheduled a couple of working sessions for us over the next two weeks so we can hash this out. We have an exciting opportunity to take IT to the next level at Nationstate if we do this right, so let’s not mess this up.”

Discussion Questions

1. List and describe all of the potential benefits (and costs) that Nationstate would realize from the establishment of an enterprisewide architecture as envisioned by Jane Denton? 


2. Build a business case for Seamus O’Malley to present to the senior management team at Nationstate in order to get their buy-in. In addition to benefits and costs, the business case must answer the “what’s in it for me” question that the BU 3presidents all have. 


3. Seamus O’Malley is rightfully worried about governance (i.e., making sure that the enterprise architectural standards are adopted by all BUs). Both he and Jane are wary of forced compliance because such measures lead to “architecture police.” What governance procedures could they put in place that would win “hearts and minds”; that is, BU architects would comply with the enterprise architecture stan- dards because they believe in them —not because they are forced to comply with them ? 


Literature Review On Cyber Crime

1200 words  (harvad style)

 

Bibliography

Moore, R 2010, Cybercrime : Investigating High-Technology Computer Crime, Cincinnati : Taylor and Francis, 2010.

Wall, D 2007, Cybercrime : the transformation of crime in the information age, Cambridge, UK ; Malden, MA : Polity, 2007.

‘Security operations centre: Situation awareness, threat intelligence and cybercrime’, 2017, 2017 International Conference On Cyber Situational Awareness, Data Analytics And Assessment (Cyber SA), Cyber Situational Awareness, Data Analytics And Assessment (Cyber SA), 2017 International Conference On, p. 1. Available from: 10.1109/CyberSA.2017.8073384. [3 May 2018].

Clifford, RD 2011, Cybercrime : the investigation, prosecution and defense of a computer-related crime, Durham, N.C. : Carolina Academic Press, c2011.

Furnell, S 2002, Cybercrime : vandalizing the information society, Boston ; London : Addison-Wesley, 2002.

Stanciu, V, & Tinca, A 2017, ‘Exploring cybercrime – realities and challenges’, Accounting & Management Information Systems / Contabilitate si Informatica de Gestiune, vol. 16, no. 4, pp. 610-632.

Balajanov, E 2018, ‘Setting the minimum age of criminal responsibility for cybercrime’, International Review of Law, Computers and Technology, vol. 32, no. 1, p. 2-20. Available from: 10.1080/13600869.2018.1417764. [3 May 2018].

‘Cybercriminals, cyberattacks and cybercrime’, 2016, 2016 IEEE International Conference on Cybercrime and Computer Forensic (ICCCF), Cybercrime and Computer Forensic (ICCCF), IEEE International Conference on, p. 1. Available from: 10.1109/ICCCF.2016.7740434. [3 May 2018].

Elaine, F 2014, ‘The EU’s Cybercrime and Cyber-Security Rulemaking: Mapping the Internal and External Dimensions of EU Security’, European Journal of Risk Regulation, no. 1, p. 46.

Florida Tech Online. (2018). A Brief History of Cyber Crime – Florida Tech Online. [online] Available at: https://www.floridatechonline.com/blog/information-technology/a-brief-history-of-cyber-crime

Nagpal, R. (2008). evolution of cyber crimes. [online] Asclonline.com. Available at: http://asclonline.com/images/7/74/Evolution_of_Cyber_Crime.pdf

Acs.org.au. (2016). cyber Security. [online] Available at: https://www.acs.org.au/content/dam/acs/acs-publications/ACS_Cybersecurity_Guide.pdf

Vincent, L. (2017). The 5 current cyber security issues Australian companies face. [online] Savv-e.com.au. Available at: https://www.savv-e.com.au/blog/current-cyber-security-issues-australia

Das, S. and Nayak, T. (2013). IMPACT OF CYBER CRIME: ISSUES AND CHALLENGES. [online] Ijeset.com. Available at: http://www.ijeset.com/media/0002/2N12-IJESET0602134A-v6-iss2-142-153.pdf

Anon, (2018). National Plan to Combat Cybercrime. [online] Available at: https://www.ag.gov.au/CrimeAndCorruption/Cybercrime/Documents/national-plan-to-combat-cybercrime.pdf

Anon, (2017). As It Is. [online] Available at: https://pavuk-legal.leapwp.com.au/wp-content/uploads/sites/813/0001/01/Cybercrime-Law-in-Australia.pdf

Real_Estate_Instructions

Grader – Instructions Excel 2019 Project

Exp19_Excel_Ch07_Cap_Real_Estate

 

Project Description:

You are the office manager for a real estate company in northern Utah County. You tracked real estate listings, including city, agent, listing price, sold price, etc. Agents can represent a seller, a buyer, or both (known as dual agents). Your assistant prepared the spreadsheet structure with agent names, agent types, the listing and sold prices, and the listing and sold dates. You want to complete the spreadsheet by calculating the number of days each house was on the market before being sold, agent commissions, and bonuses. In addition, you will use conditional functions to calculate summary statistics. For further analysis, you will insert a map chart to indicate the average house selling price by city. Finally, you will create a partial loan amortization table and calculate cumulative interest and principal to show a potential buyer to help the buyer make decisions.

 

Steps to Perform:

Step Instructions Points Possible
1 Start Excel. Download and open the file named Exp19_Excel_Ch07_Cap_RealEstate.xlsx. Grader has automatically added your last name to the beginning of the filename. 0
2 The spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyer’s Agent, Dual Agent, Seller’s Agent). You want to switch the codes for the actual descriptions. In cell E12 of the Details sheet, insert the SWITCH function to evaluate the agent code in cell D12. Include mixed cell references to the codes and roles in the range J2:K4 for the values and results arguments. use all cell references in the function. Copy the function to the range E13:E39. 5
3 Now you want to calculate the number of days between the list date and sale date. In cell J12, insert the DAYS function to calculate the number of days between the Listing Date and the Sale Date. Copy the function to the range J13:J39. 5
4 You want to calculate agent commissions based on their role. In cell K12, insert the IFS function to calculate the agent’s commission based on the agent code and the applicable rates in the range L2:L4. Use relative and mixed references correctly. Copy the function to the range K13:K39. 5
5 You want to calculate a bonus if the sold price was at least equal to the listing price, and if the house sold within 30 days after being listed. In cell L12, insert an IF function with a nested AND function to calculate a bonus. The AND function should ensure both conditions are met: Sold Price divided by the Listing Price is greater than or equal to 100% (cell L7) and the Days on Market are less than or equal to 30 (cell L8). If both conditions are met, the bonus is $1,000 (cell L9). Otherwise, the bonus is $0. Use mixed cell references to the input values in the range L7:L9. Copy the function to the range L12:L39. 5
6 The top-left section of the spreadsheet is designed for summary statistics for one condition. You will calculate average selling prices and the number of houses sold in each city (the condition). In cell B2, insert the AVERAGEIF function to calculate the average Sold Price for houses in the city of Alpine. Use mixed references for the range; use a relative reference to cell A2. Copy the function and use the Paste Formulas option to paste the function in the range B3:B5 so that the bottom border in cell B5 is preserved. 5
7 You want to count the number of houses in one city. In cell C2, insert the COUNTIF function to count the number of houses in the city of Alpine. Use mixed references for the range; and use a relative reference to cell A2. Copy the function and use the Paste Formulas option to paste the function in the range C3:C5 so that the border in cell C5 is preserved. 5
8 You want to calculate the total commissions for each agent (the condition). In cell B7, insert the SUMIF function to total the commissions by agent. Use mixed references for the ranges; and use a relative reference to cell A7. Copy the function and use the Paste Formulas option to paste the function in the range B8:B9 so that the borders are preserved. 5
9 The top-middle section of the spreadsheet is designed for summary statistics for multiple conditions. You will calculate the number of houses sold for each agent when he or she served as a Dual Agent (DA). Use mixed references for ranges and the agent code condition in cell J3. Use relative cell references to the agent condition in cell E2. When you copy the formulas, use the paste Formulas options to preserve border formatting. In cell F2, insert the COUNTIFS function in cell F2 to count the number of houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for that house. Use all cell references in the function. Copy the function to the range F3:F4 and preserve the bottom border for cell F4. 5
10 You are ready to calculate the total value of those houses for each agent when he or she served as a Dual Agent (DA). Use mixed references for ranges and the agent code condition in cell J3. Use relative cell references to the agent condition in cell E2. When you copy the formulas, use the paste Formulas options to preserve border formatting. In cell G2, insert the SUMIFS function to sum the selling prices of the houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for that house. Copy the function to the range G3:G4 and preserve the bottom border for cell G4. 5
11 Now, you will calculate the highest-price house highest-price house sold for each agent when he or she served as a Dual Agent (DA). Use mixed references for ranges and the agent code condition in cell J3. Use relative cell references to the agent condition in cell E2. When you copy the formulas, use the paste Formulas options to preserve border formatting. In cell H2, insert the MAXIFS function in cell H2 to display the highest-price house sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for that house. Copy the function to the range H3:H4 and preserve the borders in the range H3:H4. 5
12 The Map worksheet contains a list of cities, postal codes, and average house sales. You will insert a map chart to depict the averages visually using the default gradient fill colors. Display the Map worksheet, select the range B1:C5 and insert a map chart. 5
13 Cut the map chart and paste it in cell A7. Set a 2.31″ height and 3.62″ width. 5
14 You want to enter a meaningful title for the map. Change the map title to Average Selling Price by Zip Code. 2
15 Display the Format Data Series task pane, select the option to display only regions with data, and show all labels. Close the task pane. 3
16 You are ready to start completing the loan amortization table. Display the Loan worksheet. In cell B8, type a reference formula to cell B1. The balance before the first payment is identical to the loan amount. Do not type the value; use the cell reference instead. In cell B9, subtract the principal from the beginning balance on the previous row. Copy the formula to the range B10:B19. 5
17 Now, you will calculate the interest for the first payment. In cell C8, calculate the interest for the first payment using the IPMT function. Copy the function to the range C9:C19. 5
18 Next, you will calculate the principal paid. In cell D8, calculate the principal paid for the first payment using the PPMT function. Copy the function to the range D9:D19. 5
19 Rows 21-23 contain a summary section for cumulative totals after the first year. In cell B22, insert the CUMIPMT function that calculates the cumulative interest after the first year. Use references to cells A8 and A19 for the period arguments. 5
20 The next summary statistic will calculate the principal paid after the first year. In cell B23, insert the CUMPRINC function that calculates the cumulative principal paid after the first year. Use references to cells A8 and A19 for the period arguments. 5
21 Rows 25-28 contain a section for what-if analysis. In cell B27, use the RATE financial function to calculate the periodic rate using $1,400 as the monthly payment (cell B26), the NPER, and loan amount in the original input section. 5
22 In cell B28, calculate the APR by multiplying the monthly rate (cell B27) by 12. 2
23 Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side of each worksheet. 3
24 Save and close Exp19_Excel_Ch07_Cap_RealEstate.xlsx. Exit Excel. Submit the file as directed. 0
Total Points 100

 

Created On: 11/02/2020 1 Exp19_Excel_Ch07_Cap – Real Estate 1.5