On a late Friday afternoon in 2013, Jim Norris stared at his computer screen, his tired...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
On a late Friday afternoon in 2013, Jim Norris stared at his computer screen, his tired mind racing. Norris had been having the time of his life converting his chocolate making passion into a business venture, Aztek Chocolate (Aztek), but he was exhausted. Over the past 30 days, he had managed to set up a functional commercial kitchen in Winnipeg, Manitoba, while successfully navigating the required inspections. Sales were starting to flow in, and chocolates were starting to ship out (see Exhibit 1). He was on the way to realizing his dream! Attending to the financial details of the new operation had been troubling. It was not as though record keeping was an afterthought. As a business school graduate, Norris understood how important it was to stay in tune with his firm's financial performance, and so he'd kept detailed paper records during the first weeks of Aztek's operations. But with customer orders starting to accumulate and financial transactions growing in complexity, he was already starting to feel as though he might be missing things. He glanced furtively at the accordion file folder perched on his desk. All receipts were carefully organized in there sales invoices, equipment purchases, payables, receivables-all nicely separated in different pockets with detailed sticky notes attached. But when exactly should the data from those receipts be entered, and how should he extract and use the resulting financial information? Norris knew the answer to that question: the time was now. THREE ALTERNATIVES As he had repeatedly turned to this question over the past couple of weeks, Norris had arrived at three possible solutions. First, he could hire an accountant to process the receipts and prepare financial statements. Many small businesses took this approach and had their books prepared once per year for tax purposes, at a cost in the neighbourhood of $1,200. This annual approach did not sit well with Norris, however, since it meant having to wait until year-end to properly understand how Aztek was performing. A related option was to hire a bookkeeper to maintain the books on a monthly basis, at a cost of about $200 per month with a 50 per cent reduction in the year- end tax preparation costs. Monthly statements would be preferable, but Norris worried that the information would still not be as timely as necessary, and he questioned whether these precious dollars would not be better spent on advertising to boost top line sales (see assumptions and pro forma projections in Exhibit 2). Page 2 9B14E004 Second, a technology solution could be implemented in-house. Since the company's initial needs were quite basic and Norris already possessed strong spreadsheet skills, he believed he should be able to build and maintain a simple set of financial statements in Microsoft Excel. His girlfriend Shannon Hunter had repeatedly offered to help with the business, and he was sure she would not mind spending a few hours each week updating the books. This would provide much more up-to-date information, and it would be free! On the other hand, Norris vaguely recalled something from an introductory accounting course about the importance of "double entry" bookkeeping, and he was concerned about getting drawn into developing a homegrown system that might become increasingly complex to maintain over time. A related option was to purchase and install a commercial accounting software package on the company desktop computer. For example, QuickBooks claimed to "easily organize your business finances so that you can keep track of sales and expenses" (see Exhibit 3). Of course, Norris recognized that some set-up time would still be required to configure the software according to Aztek's needs. With either the spreadsheet or accounting software approaches, Hunter would either have to travel to the company office to access the necessary files, or Norris would have to copy and transport the files to her, probably via a thumb drive. A third solution was to use an online Software-as-a-Service (SaaS) provider. Norris was attracted to the "anyone, anytime, anyplace" accessibility of this option, both in terms of entering transactions and reviewing results. The idea of being able to directly link bank and other electronic transactions to the accounting system also seemed to be a great way to ensure up-to-date reporting. With services residing in the "cloud," however, Norris wondered whether his financial data would be secure. A Google search had revealed a number of SaaS bookkeeping options (see Exhibit 4). Norris's attention shifted as his computer speaker chimed. It was his online web store notifying him by email: an event planner had just ordered 200 boxes for a corporate party in Toronto early next week. This was outstanding news, but moulding 5,000 chocolates meant a busy weekend lay ahead. He fished out his smartphone; perhaps he could talk Hunter into lending a hand. Page 3 Source: Case writer Source: Case writer EXHIBIT 1: MOULDED CHOCOLATES AND CONFECTIONS EXHIBIT 2: ASSUMPTIONS AND PRO FORMA AZTEK CHOCOLATE STUDIO Assumptions and pro forma ASSUMPTIONS: Pieces per box Price per piece Expected boxes year 1 Cost per piece (chocolate, ganache, etc.) Cost per box (packaging) Average shipping & handling cost per box GST rate Equipment (melters, moulds, utensils) Depreciation rate 2-month materials inventory (chocolate, packaging) Advertising & promotion (% gross sales) Provision for income taxes (% of NIBT) Personal stake Rent per month AZTEK Pro Forma Income Statement Year One Sales (excl. shipping, taxes) Cost of goods sold Gross profit Advertising & promotion Amortization of property, plant, equipment Operating expenses Net income (loss) before tax Provision for income taxes Net income (loss) after tax 25 $1.25 6,000 $0.30 $1.50 $2.00 13% $12,000 20% $9,000 20% 33% $24,000 $600 187,500 54,000 133,500 37,500 2,400 39,900 93,600 30,888 62,712 9B14E004 0000 0000 Page 4 Name Quickbooks quickbooks.intuit.ca. accessed 23 Feb, 2104 Sage 50 na.sage.com/ca accessed 23 Feb, 2014 EXHIBIT 3: SOME CANADIAN COMMERCIAL ACCOUNTING SOFTWARE APPLICATIONS Web page pitch AccountEdge ca.accountedge.com accessed 23 Feb, 2014 Source: Company web pages Name Wave Accounting www.waveapps.com accessed 23 Feb, 2014 Xero Kashoo www.kashoo.com accessed 23 Feb, 2014 Company Intuit Inc. Source: Company web pages Sage Software EXHIBIT 4: SOME CANADIAN SAAS BOOKKEEPING OPTIONS Company Web page pitch "With invoicing, accounting, payroll and even payment processing in one application, you're always organized and up to date. As your business grows, Wave grows with you. Use only what you need today, don't pay for anything you don't want. Doesn't that just make more sense?" "Sales and purchases, inventory, payroll, time billing and contact management just scratch Acclivity Group the surface of what AccountEdge can do for your small business." Wave Inc. (Canada) "Business runs better with QuickBooks, the #1 accounting solution for small business." Kashoo Inc. (Canada) Xero Limited www.xero.com accessed 23 Feb, 2014 (New Zealand) "Sage 50 Accounting (formerly Simply Accounting) is easy-to-use accounting and business management software that provides you with the tools you need to manage your financial transactions and to streamline your business tasks. "A simple accounting solution with a simple and affordable price. All your business accounting needs for the price of one lunch or four lattes. And that includes our award- winning iPad app! 9B14E004 "Try the world's easiest accounting software and you'll see why so many people around the world love Xero-online accounting. bank reconciliation, invoicing, add-ons. Price $249.99 (1 user) $229.99 (1 user) $399.00 (many users) Price Free tools (adware) Payroll $5/month + $4 per employee $20/month $20 to $40/month L For the Ivey case on Aztex chocolate studio-Accounting software system. Kindly answer the following questions: 1. Summary of the case 2. What challenge is Jim Norris facing? 3. What options does he have? what are the trade-offs? 4. which option do you recommend and justify? 5. submit a reports of accounting transactions based on those transactions given in the case study. On a late Friday afternoon in 2013, Jim Norris stared at his computer screen, his tired mind racing. Norris had been having the time of his life converting his chocolate making passion into a business venture, Aztek Chocolate (Aztek), but he was exhausted. Over the past 30 days, he had managed to set up a functional commercial kitchen in Winnipeg, Manitoba, while successfully navigating the required inspections. Sales were starting to flow in, and chocolates were starting to ship out (see Exhibit 1). He was on the way to realizing his dream! Attending to the financial details of the new operation had been troubling. It was not as though record keeping was an afterthought. As a business school graduate, Norris understood how important it was to stay in tune with his firm's financial performance, and so he'd kept detailed paper records during the first weeks of Aztek's operations. But with customer orders starting to accumulate and financial transactions growing in complexity, he was already starting to feel as though he might be missing things. He glanced furtively at the accordion file folder perched on his desk. All receipts were carefully organized in there sales invoices, equipment purchases, payables, receivables-all nicely separated in different pockets with detailed sticky notes attached. But when exactly should the data from those receipts be entered, and how should he extract and use the resulting financial information? Norris knew the answer to that question: the time was now. THREE ALTERNATIVES As he had repeatedly turned to this question over the past couple of weeks, Norris had arrived at three possible solutions. First, he could hire an accountant to process the receipts and prepare financial statements. Many small businesses took this approach and had their books prepared once per year for tax purposes, at a cost in the neighbourhood of $1,200. This annual approach did not sit well with Norris, however, since it meant having to wait until year-end to properly understand how Aztek was performing. A related option was to hire a bookkeeper to maintain the books on a monthly basis, at a cost of about $200 per month with a 50 per cent reduction in the year- end tax preparation costs. Monthly statements would be preferable, but Norris worried that the information would still not be as timely as necessary, and he questioned whether these precious dollars would not be better spent on advertising to boost top line sales (see assumptions and pro forma projections in Exhibit 2). Page 2 9B14E004 Second, a technology solution could be implemented in-house. Since the company's initial needs were quite basic and Norris already possessed strong spreadsheet skills, he believed he should be able to build and maintain a simple set of financial statements in Microsoft Excel. His girlfriend Shannon Hunter had repeatedly offered to help with the business, and he was sure she would not mind spending a few hours each week updating the books. This would provide much more up-to-date information, and it would be free! On the other hand, Norris vaguely recalled something from an introductory accounting course about the importance of "double entry" bookkeeping, and he was concerned about getting drawn into developing a homegrown system that might become increasingly complex to maintain over time. A related option was to purchase and install a commercial accounting software package on the company desktop computer. For example, QuickBooks claimed to "easily organize your business finances so that you can keep track of sales and expenses" (see Exhibit 3). Of course, Norris recognized that some set-up time would still be required to configure the software according to Aztek's needs. With either the spreadsheet or accounting software approaches, Hunter would either have to travel to the company office to access the necessary files, or Norris would have to copy and transport the files to her, probably via a thumb drive. A third solution was to use an online Software-as-a-Service (SaaS) provider. Norris was attracted to the "anyone, anytime, anyplace" accessibility of this option, both in terms of entering transactions and reviewing results. The idea of being able to directly link bank and other electronic transactions to the accounting system also seemed to be a great way to ensure up-to-date reporting. With services residing in the "cloud," however, Norris wondered whether his financial data would be secure. A Google search had revealed a number of SaaS bookkeeping options (see Exhibit 4). Norris's attention shifted as his computer speaker chimed. It was his online web store notifying him by email: an event planner had just ordered 200 boxes for a corporate party in Toronto early next week. This was outstanding news, but moulding 5,000 chocolates meant a busy weekend lay ahead. He fished out his smartphone; perhaps he could talk Hunter into lending a hand. Page 3 Source: Case writer Source: Case writer EXHIBIT 1: MOULDED CHOCOLATES AND CONFECTIONS EXHIBIT 2: ASSUMPTIONS AND PRO FORMA AZTEK CHOCOLATE STUDIO Assumptions and pro forma ASSUMPTIONS: Pieces per box Price per piece Expected boxes year 1 Cost per piece (chocolate, ganache, etc.) Cost per box (packaging) Average shipping & handling cost per box GST rate Equipment (melters, moulds, utensils) Depreciation rate 2-month materials inventory (chocolate, packaging) Advertising & promotion (% gross sales) Provision for income taxes (% of NIBT) Personal stake Rent per month AZTEK Pro Forma Income Statement Year One Sales (excl. shipping, taxes) Cost of goods sold Gross profit Advertising & promotion Amortization of property, plant, equipment Operating expenses Net income (loss) before tax Provision for income taxes Net income (loss) after tax 25 $1.25 6,000 $0.30 $1.50 $2.00 13% $12,000 20% $9,000 20% 33% $24,000 $600 187,500 54,000 133,500 37,500 2,400 39,900 93,600 30,888 62,712 9B14E004 0000 0000 Page 4 Name Quickbooks quickbooks.intuit.ca. accessed 23 Feb, 2104 Sage 50 na.sage.com/ca accessed 23 Feb, 2014 EXHIBIT 3: SOME CANADIAN COMMERCIAL ACCOUNTING SOFTWARE APPLICATIONS Web page pitch AccountEdge ca.accountedge.com accessed 23 Feb, 2014 Source: Company web pages Name Wave Accounting www.waveapps.com accessed 23 Feb, 2014 Xero Kashoo www.kashoo.com accessed 23 Feb, 2014 Company Intuit Inc. Source: Company web pages Sage Software EXHIBIT 4: SOME CANADIAN SAAS BOOKKEEPING OPTIONS Company Web page pitch "With invoicing, accounting, payroll and even payment processing in one application, you're always organized and up to date. As your business grows, Wave grows with you. Use only what you need today, don't pay for anything you don't want. Doesn't that just make more sense?" "Sales and purchases, inventory, payroll, time billing and contact management just scratch Acclivity Group the surface of what AccountEdge can do for your small business." Wave Inc. (Canada) "Business runs better with QuickBooks, the #1 accounting solution for small business." Kashoo Inc. (Canada) Xero Limited www.xero.com accessed 23 Feb, 2014 (New Zealand) "Sage 50 Accounting (formerly Simply Accounting) is easy-to-use accounting and business management software that provides you with the tools you need to manage your financial transactions and to streamline your business tasks. "A simple accounting solution with a simple and affordable price. All your business accounting needs for the price of one lunch or four lattes. And that includes our award- winning iPad app! 9B14E004 "Try the world's easiest accounting software and you'll see why so many people around the world love Xero-online accounting. bank reconciliation, invoicing, add-ons. Price $249.99 (1 user) $229.99 (1 user) $399.00 (many users) Price Free tools (adware) Payroll $5/month + $4 per employee $20/month $20 to $40/month L For the Ivey case on Aztex chocolate studio-Accounting software system. Kindly answer the following questions: 1. Summary of the case 2. What challenge is Jim Norris facing? 3. What options does he have? what are the trade-offs? 4. which option do you recommend and justify? 5. submit a reports of accounting transactions based on those transactions given in the case study.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
On a late Friday afternoon in 2013, jim norris Read case: 1. What challenge is Jim Norris facing? 2. What options does he have? 3. What are the trade-off? 4. What option would you recommend?
-
What are the main technical challenges faced by firms that wish to internationalise their selection and assessment approaches?
-
Sally looks at her college transcript and asks you, "How is this possible? My grade point average for this semester's courses is higher than my grade point average for last semester's courses, but my...
-
Amazon has been a pioneer in developing cashierless technology in retail stores. In Amazon Go supermarkets, sensors detect which products shoppers have put in their baskets and charge the shoppers...
-
On January 1, 2020, Landry Inc. issued a three-year, \(\$ 5,000\), zero-interest-bearing note to Dillon LLP, and received \(\$ 4,198\). The implied interest rate is \(6 \%\) on this note transaction....
-
The ledger and trial balance of Wizard Services Co. as of July 31, 2012, the end of the first month of its current fiscal year, are presented in the working papers. Data needed to determine the...
-
4. Pete collects the necessary data and prepares the Table 6 (shown below.) Accordingly, calculate the component costs of debt, preferred stock, and common stock. Will these costs be constant...
-
Darden Restaurants, Inc. (DRI) is the largest full-service restaurant company in the world. It operates over 2,200 restaurants under a variety of brand names, including Olive Garden, Bahama Breeze,...
-
Answer the following concerns when performing an assurance engagement: 1. What are the consequences of identifying too many or too few key process-level risks in performing an assurance audit? 2....
-
Solve the following using related rates and show all steps of working 1. A cylindrical tank with radius5m is being filled with water at a rate of 2m 3 /min. How fast is the height of the water...
-
A rectangular poster is to contain 512 square inches of print. The margins at the top and bottom of the poster are to be 2 inches, and the margins on the left and right are to be 1 inch. What should...
-
What are four key policies, programs and/or initiatives that led to healthcare reform in the US healthcare system. You will need to specifically identify (by name) and describe each of the four key...
-
Abe has led multiple teams that are too cohesive. He has decided he needs someone who will be willing to be a devils advocate on his next team. What follower type is likely to take on and be the...
-
On November 1 , 2 0 2 1 , Uptown Bookstore borrowed $ 2 0 9 , 0 0 0 , by signing a 6 % , six - month note payable. The amount borrowed plus accrued interest is due six months later on May 1 , 2 0 2 2...
-
Regarding financial rights, shareholders have a right to Question 17 options: some discrimination in the payment of dividends within a class dividends paid in the order of preferences assigned to...
-
Find the APR in each of the following cases: NUMBER OF TIMES COMPOUNDED Semiannually Monthly Weekly Infinite EAR APR 10.4% 8.9 11.6 15.4
-
Hinton Property Management Company (HPMC) owns several properties that it rents to major hotel chains such as The Westin and Holiday Inn. HPMC does not operate the hotels but instead simply provides...
-
Wahlberg Design Partners (WDP) uses the aging method for its accounts receivable. On January 1, the balance in the allowance for doubtful accounts was $25,000. For the year, WDP made $2,560,000 of...
-
Community Care Services (CCS) is a not-for-profit organization formed in January 2013 and is located in the rural community of Thomas County. CCS is dedicated to serving the needs of seniors. CCSs...
-
After several weeks of searching for a new home, Rene has found a house that seems to be in good shape and is located in a nice neighborhood. The listing price is \($125,000,\) which is about...
-
Imagine that you are a condominium owner attending a meeting of the condominium association. What should the association do about a homeowner who leaves garbage in the hallway? Should the association...
-
Evaluate the various housing alternatives that are available.
Study smarter with the SolutionInn App