Having trouble understanding how to put the layout for my


Question Description:

35

Having trouble understanding how to put the layout for my spreadsheet, I understand the uploading aspect but I’m unlcear on the rest of the steps being requested with taking the POS in formation and using it in a table. CaseStudy_V2.pdf Skinny Joe’s Coffee House 1 Kirby savored the combined sensory input of a crisp summer morning, the scent of his personal blend of custom roast coffee brewing the first espresso of the day and the stunning panorama of the rising sun illuminating the Rocky Mountains. Within the next few minutes Kirby would unlock the doors of his cafe, Skinny Joe’s Coffee House, and welcome his regular customers and the travelers and tourists he hoped would be out on such a fine day. Carstairs, a town of several thousand, was located on the Trans-Canada Highway about a half hour from Calgary. This leg of the Trans-Canada was the south and west entry paths into the city, bringing traffic from Eastern Canada, much of the Southern US and Northern Alberta past Kirby’s shop. Today was the first Friday in July, the opening day of the world famous Calgary Stampede and that meant it was parade day. Traditionally the Stampede parade was the largest draw of the 10 day event. In the 9 months since the terrorist events of September 11th, the travel plans of most Canadians and more importantly the American tourists had changed mate rially. Kirby had seen an immediate decline in traffic to his shop and it had him concerned. How would he keep Skinny Joe’s viable in an unpredictable and changing marketplace? Introducing Quality Coffee to Farm Country Kirby, his wife and family had moved from Toronto to rural Alberta at the turn of the new millennium. Kirby left behind his software product management job to be closer to family. He had watched the stock market first continue to grow, fueled by the technology and telecommunication stocks that had shaped the bull market of the 90’s, but as 2000 continued the markets sharply turned and entered a steep multi-year decline wiping out a large portion of his saving and the savings of most other North Americans. Since there wasn’t much of a technology community in the Southern Alberta area at the time, Kirby elected to open a coffee and baked goods shop in a store front he found on main street Carstairs, just off the Trans-Canada highway. His signage for Skinny Joe’s Coffee House, a play on words since the baked goods he planned to serve were low fat, would be visible from the highway with an exit ramp for both north and south bound traffic available to interested motorists. 1 This case has been prepared to provide material for class discussion; it is not intended to illustrate effective or ineffective handling of a managerial situation. Certain names and events may have been a ltered to protect confidentiality or to aid in illustration. Kirby had acquired a taste for freshly roasted, high quality coffee during his time in Toronto and for several years he had roasted beans in his kitchen, perfecting a private blend of his own design. The constant encouragement of guests and family had helped Kirby develop a confidence in the quality and taste of his private b lend coffee. Kirby was sure he could scale coffee production to large enough volume that he could serve his private blend coffee to customers of Skinny Joe’s. A coffee wholesaler in Calgary could provide the correct fresh green coffee beans for Kirby’s private blend, and the wholesaler would also roast the coffee to his custom recipe in volume. The first few weeks after opening Skinny Joe’s were educational to Kirby. His store was a draw for the local community, and the social nature of rural Alberta meant that people came to visit and wanted to support the business. Kirby quickly found that his growth plans were accelerated and he raced to keep pace with demand. The POS System Kirby’s initial plan allowed for the use of a notebook, coil bound not electronic, a pencil and a cash box to manage sa

Answer

35