Please help out

Cash Budget & Pro-forma Statements Case Case: Utensil Box Inc. Due Date: Friday December 11,2020 - This assignment is worth (10 %)of your course grade. Required: 1 Produce projected income statements balance sheets and cash budgets for Utensil Box Inc up to July 31, 2020 for all three production scenarios -5,000 10 000 and 30 000 units (7 marks) 2 Based on your analysis of the information provided in the case what concerns do you have with their business plan? What changes would you suggest? (400 - 500 words) (1 mark) 3. If you were Mr Reid would you invest in Utensil Box Inc at July 31 2019? If yes how much considering the parameters provided? Why or why not? (400 - 500 words) (1 mark) 4 Submit an electronic copy of all documents in the electronic drop box via Econestoga. The integrity checker (Turn-it-in) will automatically check your work for plagiarism GROUP SIZE: Groups of 1 to 4 persons are allowed Format: Yamakamust be continenssima This incisis and Utensil Box Inc. (2020) Paul Jacob, president of Utensil Box Inc. (Utensil Box), required funding to start manufacturing and marketing a new invention of his, a pasta server. He was uncertain how much funding he would need since the amount was dependent on sales. He wanted to start production in two weeks, on August 1, 2019. Since his distribution system was already arranged, he believed he could start selling as soon as the units were produced. He approached several venture capitalists after being turned down by the Metropolitan Bank, a Canadian charted bank, but was reluctant to agree to what he considered excessive demands for their capital investment. He had just returned from a meeting with Dale Reid, a private investor from Toronto, who had expressed an interest in the firm. In order that he could evaluate his potential investment, Mr. Reid asked Jacob to produce projected income statements, balance sheets, and cash flow statements for Utensil Box Inc. up to July 31, 2020. History Utensil Box, founded in May 2017 was owned jointly by Paul and Sally Jacob. The company was formed to design, develop, manufacture and to market a unique household utensil, a pasta server. The specially curved patented plastic apparatus, to be sold retail for $4 30. could be used to stir, pick up and to serve all varieties of pasta Paul who was 35, had conceived the idea for the device while working for the Food Research Institute of Agriculture Canada as a research biologist As a recent MBA graduate he was confident that he could bring his idea to fruition. His enthusiasm was echoed by his wife Sally aged 30, who after having worked as a professional teacher, was to enter an MBA program in September. In addition to her studies she planned to act as vice-president and secretary of Utensil Box Inc. while Paul would be President and Treasurer The Jacobs had already spent $13,800 before incorporation on obtaining patent approval for their invention in Canada and the United States Patents were also being processed in The Jacobs had already spent $13,800 before incorporation on obtaining patent approval for their invention in Canada and the United States Patents were also being processed in Italy, Germany, France and Britain. With initial capital of $20,700 raised from personal loans of $12,000 from the Metropolitan Bank and $8,700 from Best Finance Ltd., the Jacobs had established an office at their home in Kitchener and had purchased production equipment. Capital expenditures consisted of $865 for office equipment, $23,300 for a single cavity production mold, 54,200 for tools and dies and $4,430 for a blister pack mold. Development costs incurred on the molds were included in these amounts. By July, Utensil Box was ready to begin production. An agreement was made with Perfect Plastics, Inc. in Cambridge to manufacture the utensil under contract, using Utensil Box Inc, molds, at a cost of $ 70 per unit Packaging arrangements were concluded with B Crawford & Sons Lithographic Ltd of Kitchener to package the products the same month coa go to bolo 1 as produced Distribution agreements were made with Household Ware Sales Inc Cooker Ltd. and Firenzo Sales Ltd Unfortunately, by this time initial funds had been exhausted on capital expenditures and the final payment of $12 200 was due in August on the production mold Cash was also required for monthly administrative expenses of $4 315 for salaries office expenses maatalanilamaantaandahallaamainilamani automahilaananana as produced. Distribution agreements were made with Household Ware Sales Inc., Cooker Ltd., and Firenzo Sales Ltd. Unfortunately, by this time, initial funds had been exhausted on capital expenditures and the final payment of $12,200 was due in August on the production mold. Cash was also required for monthly administrative expenses of $4 315 for salaries, office expenses, insurance, telephone, internet and website maintenance, utilities, automobile expenses, and miscellaneous supplies once production started Perfect Plastics would not begin production without a 50 per cent deposit and the remainder was due before any units would be released for sale. The packaging company also required cash payments on delivery. Without additional funding, the Jacobs could not start production or distribution. Production The pasta server would be manufactured by an injection molding process. The process made possible the rapid production of highly finished and detailed plastic ulots. Plastic was melted and then injected under thousands of kilograms of pressure into a mold which was held closed by a clamping mechanism. The devices were formed into a cavity, the two halves of the mold separated allowing the formed part to fall free. In injection molding, parts could be formed in either single or multiple cavity molds, depending on total production production rate size and weight of the part, size of machine available and the mold cost Utensil Box initially planned to use a single cavity production mold (one device per cycle). Since four cycles could be completed per minute monthly production capacity was about 40,000 units Paul feared a stock-out and planned an initial production run of 40.000 units His production strategy was to order sufficient units to replace units sold and to maintain a minimum of 10,000 units inventory Perfect Plastics required production runs of at least 5000 units Paul planned initially to store inventory in the basement and garage of his home but if inventory exceeded 10 000 units he would have to rent warehouse space at a cost of $240 per month The warehouse space with a capacity of 35 000 units could be Paul feared a stock-out and planned an initial production run of 40,000 units. His production strategy was to order sufficient units to replace units sold, and to maintain a minimum of 10,000 units inventory. Perfect Plastics required production runs of at least 5,000 units. Paul planned, initially, to store inventory in the basement and garage of his home, but if inventory exceeded 10,000 units he would have to rent warehouse space at a cost of $240 per month. The warehouse space, with a capacity of 35,000 units, could be leased on a monthly basis as needed and no annual lease was required. Lease payments were due the month following Paul had also discussed with his accountant the problem of depreciation of the production mold. The life of a mold depended on the type of steel used the number of cycles, the type of material to be molded and the complexity of the part to be manufactured. Handled properly, molds used to manufacture devices similar to the pasta server lasted for millions of units. However, from a practical viewpoint Paul recognized that his single cavity mold could be obsolete after producing only 162,000 units if he decided to buy the new two cavity mold. His accountant suggested that a depreciation charge of $. 145 per unit be used in pro-forma statements to account for wear and tear and obsolescence of the mold. A combined depreciation charge of S 017 per unit was recommended for the package mold 2 and tool and dies. In addition, $10 per month was allowed for depreciation of office equipment, which was to be considered as an administrative expense. The products would be blister packaged on an attractive backing which would clearly show the consumer various applications for the device. Products would be packaged the same month as they were produced. Packaging costs for the product were $.43 per unit. Material costs were included in these prices. Utensil Box would pay for shipping expenses of $.085 per unit, incurred when units were sold. Marketing The Jacobs suggested that every family in North America was a potential purchaser, since they believed all families ate some variety of pasta. The Canadian population consisted of 15 million families (2016 Census dataSimilar data is provided for Ontario, Toronto and Kitchener The United States market was about 10 times larger Household Ware Sales Inc would handle the accounts of the Hudson's Bay Company Wal-Mart and Target Cooker Ltd. was to handle Sears and independent boutiques, Firenzo Sales Ltd would handle grocery outlets such as Sobeys Loblaws and Freshco. The wholesale price by Utensil Box to the distributors was $190 per unit, net 30 days. Paul believed 50 per cent of receipts would be paid the month following the sale and the remainder within the second month Wholesalers would sell the product to retail outlets for $2 30 Utensil Box was also considering expanding distribution to the United States and once patents were approved to Europe Although no identical products used specifically for pasta were on the market similar plastic kitchen utensils were occasionally used for pasta serving these devices sold for $3 45 to $5 15 with retailers generally receiving a 100 per cent markup Promotion by Utensil Box Inc would consist of an attractive blister package for the product and free guest appearances on television talk and cooking shows such as "Canada AM Although no identical products used specifically for pasta were on the market, similar plastic kitchen utensils were occasionally used for pasta serving. These devices sold for $3.45 to $5.15, with retailers generally receiving a 100 per cent markup. Promotion by Utensil Box Inc. would consist of an attractive blister package for the product and free guest appearances on television talk and cooking shows such as "Canada A.M." and "Celebrity Cooks" Free press exposure was anticipated through editorial statements and consumer goods articles. Retail stores would be encouraged to conduct in-store promotions and to display the device with pasta products Consumer questionnaires would be made available to ascertain public reaction A web-site was planned and would be maintained by Sally. The website would have videos of the pasta server in use and testimonials from happy customers. Initially the product would not be available for sale online. However, Paul had contacted an online distributor of kitchen wares and was investigating the possibilities Considerable reliance was placed on the distributors to promote the product. The Jacobs anticipated that 500 units would be given away monthly for the first four months for promotional purposes Paul's accountant suggested that these should be counted as sales expenses at their cost of $1 292 per unit ($ 70 for mold manufacturing, $ 43 for 3 packaging, plus $.162 for depreciation), the same amount as would be used to value inventory. The other suggestion was to delay amortization of the patent until Utensil Box had two profitable years. Financial Implications Exhibit 2 shows the balance sheet for Utensil Box as of July 15, 2019. Dale Reid was considering investing up to $85,000 for a 50 per cent share of the equity and profits of the new company. Reid stated that he may be willing to settle for a smaller ownership stake but his investment would be disproportionately lower. He would not consider investing an amount greater than $85,000 unless the Jacobs increased their investment in the company significantly. However, before he made any commitments, he wanted to examine, very carefully, a set of pro-forma statements for the venture. Reid suggested that the Jacobs calculate the total amount of financing required each month and from those calculations determine the total amount of financing that he would need to invest The Jacobs did not believe that they could invest any more personal funds in the company since their personal assets were tied up in the business their home and personal possessions (Exhibit 3) Monthly sales of the pasta serving devices were difficult to project. Paul's reasonable expectation was 10,000 units and he had prepared a production schedule based on this sales level (Exhibit 4) His most pessimistic and optimistic monthly sales forecasts were 5,000 units and 30,000 units respectively if sales were 30,000 units or more per month for two consecutive months, he planned to order a lliger two-cavity production mold (two devices per cycle) The capital cost including development would be $63,000 payable in three monthly installments, starting the month the equipment was ordered A three month lead time from the time of ordering was required before this mold would be operational When operational the mold would not only double production capacity but also cut costs in hall to $ 35 per unit Paul's accountant suggested a depreciation allowance of $ 062 per possessions (Exhibit 3). Monthly sales of the pasta serving devices were difficult to project. Paul's reasonable expectation was 10,000 units and he had prepared a production schedule based on this sales level (Exhibit 4). His most pessimistic and optimistic monthly sales forecasts were 5,000 units and 30,000 units respectively. If sales were 30,000 units or more per month, for two consecutive months, he planned to order a larger two cavity production mold (two devices per cycle). The capital cost, including development, would be $63,000 payable in three monthly installments, starting the month the equipment was ordered. A three month lead time, from the time of ordering, was required before this mold would be operational. When operational, the mold would not only double production capacity, but also cut costs in half to $ 35 per unit. Paul's accountant suggested a depreciation allowance of $.062 per unit for the two cavity mold. With the reduction in material and depreciation costs inventory would be costed at 5.859 per unit Paul believed that the first fiscal year's results ending July 31, 2020 were critical for the success of Utensil Box He required forecasted cash flow income statements and balance sheets for these three different sales projections Paul planned to use a 20 per cent tax rate. If taxes were payable they would be due 45 days after Utensil Box year end of July 31 2020 The Jacobs wished to limit the amount of money required from Mr Reid. They wanted to retain as much control over the business as possible. However they recognized the danger of being under financed Once they decide what amount they would request from Mr Reid they would complete a formal information package and drop in to see Mr Reid with their complete pro forma financial statements Exhibit 4 Production schedule in Units - 10,000 per month Production Sales Promotion Molded Packaged Month Inventory Home Warehouse 40,000 40,000 500 500 500 500 19,500 9,000 3,500 August September October November December Uanauary February March April May June July 5,000 7,000 10,000 10,000 10,000 10.000 10.000 10,000 10,000 10,000 5,000 7,000 10,000 10,000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 ELE+ case Utensil Box Cash Flow Volume For the year ended July 31, 2017 10,000 August Sept 1.90 19,000 19,000 Sales Collections One month after sale (50%) Two months after sale (50%) Total Cash Receipts 9,500 9,500 0.70 0.43 0.085 Cash Payments Production cost Packaging cost Shipping expenses Administrative Expenses Warehouse expense Accounts Payable Total Cash Davments 28,000 17,200 893 4,315 893 4,315 240 12,200 52609 5.449 RUTIIVI I WAO Two months after sale (50%) Total Cash Receipts 9,500 0.70 0.43 0.085 Cash Payments Production cost Packaging cost Shipping expenses Administrative Expenses Warehouse expense Accounts Payable Total Cash Payments 28,000 17,200 893 4,315 893 4,315 240 12,200 62,608 5,448 Net Cash Flow (62,608) 4,053 Beginning cash balance Cumulative cash balance (62,608) (62,608) (58,555) Monthly loan or (repayment) 62,608 58,555 EXAMPLE BALANCE SHEET CHECK NUMBERS 10,000 UNITS YOU MAY ASSETS TOTAL CURRENT ASSETS 41,420 NET EQUIPMENT PATENT 11,291 13,800 TOTAL ASSETS 66,511 LIABILITIES CURRENT REQUIRED FINANCING TAX PAYABLE ACCOUNTS PAYABLE TOTAL CURRENT LIABILITIES 26,207 EQUITY COMMON STOCK RETAINED EARNINGS TOTAL LIABILITIES AND EQUITY 66,511 EXAMPLE INCOME STATEMENT 10,000 UNITS SALES 1.9 x 120,000 228,000 COST OF GOODS SOLD PRODUCTION PPACKAGING .7x132,000 SINGLE MOULD DEPRECIATION PACKAGING DEPRECIATION SUBTOTAL 170,544 LESS: PROMO UNITS INVENTORY COST OF GOODS SOLD ho GROSS PROFIT 72,960 OPERATING EXPENSES OFFICE FURNITURE DEPRECIATION ADMINISTRATION SHIPPING WAREHOUSE PROMO UNITS 65,574 m/d21/le/content/381239/viewContent/8311611/View o SUBTOTAL 170,544 LESS : PROMO UNITS INVENTORY COST OF GOODS SOLD GROSS PROFIT 72,960 OPERATING EXPENSES OFFICE FURNITURE DEPRECIATION ADMINISTRATION SHIPPING WAREHOUSE PROMO UNITS 65,574 EBIT N TAX 5,909 NET INCOME Exhibit 2 Balance Sheet UTENSIL BOX BALANCE SHEET As of July 15, 2017 $ Assets Current Total Current Assets Equipment Single Cavity Mold Tools and Dies Blister Package Mold Office Equipment 23,300 4,200 4,430 865 32,795 Other Patent Total Assets 13,800 $ 46,595 12 200 Liabilities Current Accounts Payable Equity Common Stock Total liabilities and Equity 34,395 S46.595 Exhibit 3 JACOBS Personal Balance Sheet As of July 15, 2017 Assets Cash Real Estate Automobile Stocks, Bonds, Etc. Household & Personal Effects Invested in Chef's Toolkit Total Assets 345 69,000 12,075 43,125 34,395 $ 158,940 Liabilities Bank & Finance Co. Loans Mortgages Other Liabilities 20,700 51.750 6,775 79,225 79.715. $ 158,940 Net Worth Total liabilities and Net Worth Exhibit 4 Production schedule in Units - 10.000 per month Production Sales Promotion Molded Packaged Month Inventory Home Warehouse 40,000 40,000 500 500 500 500 19,500 9,000 3,500 August September October November December Janauary February March April 5,000 7,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10.000 5,000 7,000 10,000 10,000 10,000 10,000 10,000 10.000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 10.000 10,000 10,000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 May June July 2020FALLincomestatementformat Q Utensil Box Ltd Pro Forma Income Statement. For the period ending July Sales Cost of Goods Sold Units produced Units packaged Depreciation Single Mold Birch Tools Subtotal L: Pronouns Ending inventory Toticos Grass Profit Operating wenses Oficit dem Shine Adin situt units El Man 2020FALLbalance sheetformat V Utensil Box Ltd. Projected Balance Sheet - As at July 31, Based on 10000 UN Assets Current Cash Accounts Receivable ventory Total Current Assets quipment Single Cavity Mold se Pac Mond Tools/les Office Equipment Accurated Depreciation Sicily Mold Pack Mold Tool/ble attient Other Asset Punt Total Arts Cabi Current Accounts Required finance ulty that Canon Total Los adquy Cash Budget & Pro-forma Statements Case Case: Utensil Box Inc. Due Date: Friday December 11,2020 - This assignment is worth (10 %)of your course grade. Required: 1 Produce projected income statements balance sheets and cash budgets for Utensil Box Inc up to July 31, 2020 for all three production scenarios -5,000 10 000 and 30 000 units (7 marks) 2 Based on your analysis of the information provided in the case what concerns do you have with their business plan? What changes would you suggest? (400 - 500 words) (1 mark) 3. If you were Mr Reid would you invest in Utensil Box Inc at July 31 2019? If yes how much considering the parameters provided? Why or why not? (400 - 500 words) (1 mark) 4 Submit an electronic copy of all documents in the electronic drop box via Econestoga. The integrity checker (Turn-it-in) will automatically check your work for plagiarism GROUP SIZE: Groups of 1 to 4 persons are allowed Format: Yamakamust be continenssima This incisis and Utensil Box Inc. (2020) Paul Jacob, president of Utensil Box Inc. (Utensil Box), required funding to start manufacturing and marketing a new invention of his, a pasta server. He was uncertain how much funding he would need since the amount was dependent on sales. He wanted to start production in two weeks, on August 1, 2019. Since his distribution system was already arranged, he believed he could start selling as soon as the units were produced. He approached several venture capitalists after being turned down by the Metropolitan Bank, a Canadian charted bank, but was reluctant to agree to what he considered excessive demands for their capital investment. He had just returned from a meeting with Dale Reid, a private investor from Toronto, who had expressed an interest in the firm. In order that he could evaluate his potential investment, Mr. Reid asked Jacob to produce projected income statements, balance sheets, and cash flow statements for Utensil Box Inc. up to July 31, 2020. History Utensil Box, founded in May 2017 was owned jointly by Paul and Sally Jacob. The company was formed to design, develop, manufacture and to market a unique household utensil, a pasta server. The specially curved patented plastic apparatus, to be sold retail for $4 30. could be used to stir, pick up and to serve all varieties of pasta Paul who was 35, had conceived the idea for the device while working for the Food Research Institute of Agriculture Canada as a research biologist As a recent MBA graduate he was confident that he could bring his idea to fruition. His enthusiasm was echoed by his wife Sally aged 30, who after having worked as a professional teacher, was to enter an MBA program in September. In addition to her studies she planned to act as vice-president and secretary of Utensil Box Inc. while Paul would be President and Treasurer The Jacobs had already spent $13,800 before incorporation on obtaining patent approval for their invention in Canada and the United States Patents were also being processed in The Jacobs had already spent $13,800 before incorporation on obtaining patent approval for their invention in Canada and the United States Patents were also being processed in Italy, Germany, France and Britain. With initial capital of $20,700 raised from personal loans of $12,000 from the Metropolitan Bank and $8,700 from Best Finance Ltd., the Jacobs had established an office at their home in Kitchener and had purchased production equipment. Capital expenditures consisted of $865 for office equipment, $23,300 for a single cavity production mold, 54,200 for tools and dies and $4,430 for a blister pack mold. Development costs incurred on the molds were included in these amounts. By July, Utensil Box was ready to begin production. An agreement was made with Perfect Plastics, Inc. in Cambridge to manufacture the utensil under contract, using Utensil Box Inc, molds, at a cost of $ 70 per unit Packaging arrangements were concluded with B Crawford & Sons Lithographic Ltd of Kitchener to package the products the same month coa go to bolo 1 as produced Distribution agreements were made with Household Ware Sales Inc Cooker Ltd. and Firenzo Sales Ltd Unfortunately, by this time initial funds had been exhausted on capital expenditures and the final payment of $12 200 was due in August on the production mold Cash was also required for monthly administrative expenses of $4 315 for salaries office expenses maatalanilamaantaandahallaamainilamani automahilaananana as produced. Distribution agreements were made with Household Ware Sales Inc., Cooker Ltd., and Firenzo Sales Ltd. Unfortunately, by this time, initial funds had been exhausted on capital expenditures and the final payment of $12,200 was due in August on the production mold. Cash was also required for monthly administrative expenses of $4 315 for salaries, office expenses, insurance, telephone, internet and website maintenance, utilities, automobile expenses, and miscellaneous supplies once production started Perfect Plastics would not begin production without a 50 per cent deposit and the remainder was due before any units would be released for sale. The packaging company also required cash payments on delivery. Without additional funding, the Jacobs could not start production or distribution. Production The pasta server would be manufactured by an injection molding process. The process made possible the rapid production of highly finished and detailed plastic ulots. Plastic was melted and then injected under thousands of kilograms of pressure into a mold which was held closed by a clamping mechanism. The devices were formed into a cavity, the two halves of the mold separated allowing the formed part to fall free. In injection molding, parts could be formed in either single or multiple cavity molds, depending on total production production rate size and weight of the part, size of machine available and the mold cost Utensil Box initially planned to use a single cavity production mold (one device per cycle). Since four cycles could be completed per minute monthly production capacity was about 40,000 units Paul feared a stock-out and planned an initial production run of 40.000 units His production strategy was to order sufficient units to replace units sold and to maintain a minimum of 10,000 units inventory Perfect Plastics required production runs of at least 5000 units Paul planned initially to store inventory in the basement and garage of his home but if inventory exceeded 10 000 units he would have to rent warehouse space at a cost of $240 per month The warehouse space with a capacity of 35 000 units could be Paul feared a stock-out and planned an initial production run of 40,000 units. His production strategy was to order sufficient units to replace units sold, and to maintain a minimum of 10,000 units inventory. Perfect Plastics required production runs of at least 5,000 units. Paul planned, initially, to store inventory in the basement and garage of his home, but if inventory exceeded 10,000 units he would have to rent warehouse space at a cost of $240 per month. The warehouse space, with a capacity of 35,000 units, could be leased on a monthly basis as needed and no annual lease was required. Lease payments were due the month following Paul had also discussed with his accountant the problem of depreciation of the production mold. The life of a mold depended on the type of steel used the number of cycles, the type of material to be molded and the complexity of the part to be manufactured. Handled properly, molds used to manufacture devices similar to the pasta server lasted for millions of units. However, from a practical viewpoint Paul recognized that his single cavity mold could be obsolete after producing only 162,000 units if he decided to buy the new two cavity mold. His accountant suggested that a depreciation charge of $. 145 per unit be used in pro-forma statements to account for wear and tear and obsolescence of the mold. A combined depreciation charge of S 017 per unit was recommended for the package mold 2 and tool and dies. In addition, $10 per month was allowed for depreciation of office equipment, which was to be considered as an administrative expense. The products would be blister packaged on an attractive backing which would clearly show the consumer various applications for the device. Products would be packaged the same month as they were produced. Packaging costs for the product were $.43 per unit. Material costs were included in these prices. Utensil Box would pay for shipping expenses of $.085 per unit, incurred when units were sold. Marketing The Jacobs suggested that every family in North America was a potential purchaser, since they believed all families ate some variety of pasta. The Canadian population consisted of 15 million families (2016 Census dataSimilar data is provided for Ontario, Toronto and Kitchener The United States market was about 10 times larger Household Ware Sales Inc would handle the accounts of the Hudson's Bay Company Wal-Mart and Target Cooker Ltd. was to handle Sears and independent boutiques, Firenzo Sales Ltd would handle grocery outlets such as Sobeys Loblaws and Freshco. The wholesale price by Utensil Box to the distributors was $190 per unit, net 30 days. Paul believed 50 per cent of receipts would be paid the month following the sale and the remainder within the second month Wholesalers would sell the product to retail outlets for $2 30 Utensil Box was also considering expanding distribution to the United States and once patents were approved to Europe Although no identical products used specifically for pasta were on the market similar plastic kitchen utensils were occasionally used for pasta serving these devices sold for $3 45 to $5 15 with retailers generally receiving a 100 per cent markup Promotion by Utensil Box Inc would consist of an attractive blister package for the product and free guest appearances on television talk and cooking shows such as "Canada AM Although no identical products used specifically for pasta were on the market, similar plastic kitchen utensils were occasionally used for pasta serving. These devices sold for $3.45 to $5.15, with retailers generally receiving a 100 per cent markup. Promotion by Utensil Box Inc. would consist of an attractive blister package for the product and free guest appearances on television talk and cooking shows such as "Canada A.M." and "Celebrity Cooks" Free press exposure was anticipated through editorial statements and consumer goods articles. Retail stores would be encouraged to conduct in-store promotions and to display the device with pasta products Consumer questionnaires would be made available to ascertain public reaction A web-site was planned and would be maintained by Sally. The website would have videos of the pasta server in use and testimonials from happy customers. Initially the product would not be available for sale online. However, Paul had contacted an online distributor of kitchen wares and was investigating the possibilities Considerable reliance was placed on the distributors to promote the product. The Jacobs anticipated that 500 units would be given away monthly for the first four months for promotional purposes Paul's accountant suggested that these should be counted as sales expenses at their cost of $1 292 per unit ($ 70 for mold manufacturing, $ 43 for 3 packaging, plus $.162 for depreciation), the same amount as would be used to value inventory. The other suggestion was to delay amortization of the patent until Utensil Box had two profitable years. Financial Implications Exhibit 2 shows the balance sheet for Utensil Box as of July 15, 2019. Dale Reid was considering investing up to $85,000 for a 50 per cent share of the equity and profits of the new company. Reid stated that he may be willing to settle for a smaller ownership stake but his investment would be disproportionately lower. He would not consider investing an amount greater than $85,000 unless the Jacobs increased their investment in the company significantly. However, before he made any commitments, he wanted to examine, very carefully, a set of pro-forma statements for the venture. Reid suggested that the Jacobs calculate the total amount of financing required each month and from those calculations determine the total amount of financing that he would need to invest The Jacobs did not believe that they could invest any more personal funds in the company since their personal assets were tied up in the business their home and personal possessions (Exhibit 3) Monthly sales of the pasta serving devices were difficult to project. Paul's reasonable expectation was 10,000 units and he had prepared a production schedule based on this sales level (Exhibit 4) His most pessimistic and optimistic monthly sales forecasts were 5,000 units and 30,000 units respectively if sales were 30,000 units or more per month for two consecutive months, he planned to order a lliger two-cavity production mold (two devices per cycle) The capital cost including development would be $63,000 payable in three monthly installments, starting the month the equipment was ordered A three month lead time from the time of ordering was required before this mold would be operational When operational the mold would not only double production capacity but also cut costs in hall to $ 35 per unit Paul's accountant suggested a depreciation allowance of $ 062 per possessions (Exhibit 3). Monthly sales of the pasta serving devices were difficult to project. Paul's reasonable expectation was 10,000 units and he had prepared a production schedule based on this sales level (Exhibit 4). His most pessimistic and optimistic monthly sales forecasts were 5,000 units and 30,000 units respectively. If sales were 30,000 units or more per month, for two consecutive months, he planned to order a larger two cavity production mold (two devices per cycle). The capital cost, including development, would be $63,000 payable in three monthly installments, starting the month the equipment was ordered. A three month lead time, from the time of ordering, was required before this mold would be operational. When operational, the mold would not only double production capacity, but also cut costs in half to $ 35 per unit. Paul's accountant suggested a depreciation allowance of $.062 per unit for the two cavity mold. With the reduction in material and depreciation costs inventory would be costed at 5.859 per unit Paul believed that the first fiscal year's results ending July 31, 2020 were critical for the success of Utensil Box He required forecasted cash flow income statements and balance sheets for these three different sales projections Paul planned to use a 20 per cent tax rate. If taxes were payable they would be due 45 days after Utensil Box year end of July 31 2020 The Jacobs wished to limit the amount of money required from Mr Reid. They wanted to retain as much control over the business as possible. However they recognized the danger of being under financed Once they decide what amount they would request from Mr Reid they would complete a formal information package and drop in to see Mr Reid with their complete pro forma financial statements Exhibit 4 Production schedule in Units - 10,000 per month Production Sales Promotion Molded Packaged Month Inventory Home Warehouse 40,000 40,000 500 500 500 500 19,500 9,000 3,500 August September October November December Uanauary February March April May June July 5,000 7,000 10,000 10,000 10,000 10.000 10.000 10,000 10,000 10,000 5,000 7,000 10,000 10,000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 ELE+ case Utensil Box Cash Flow Volume For the year ended July 31, 2017 10,000 August Sept 1.90 19,000 19,000 Sales Collections One month after sale (50%) Two months after sale (50%) Total Cash Receipts 9,500 9,500 0.70 0.43 0.085 Cash Payments Production cost Packaging cost Shipping expenses Administrative Expenses Warehouse expense Accounts Payable Total Cash Davments 28,000 17,200 893 4,315 893 4,315 240 12,200 52609 5.449 RUTIIVI I WAO Two months after sale (50%) Total Cash Receipts 9,500 0.70 0.43 0.085 Cash Payments Production cost Packaging cost Shipping expenses Administrative Expenses Warehouse expense Accounts Payable Total Cash Payments 28,000 17,200 893 4,315 893 4,315 240 12,200 62,608 5,448 Net Cash Flow (62,608) 4,053 Beginning cash balance Cumulative cash balance (62,608) (62,608) (58,555) Monthly loan or (repayment) 62,608 58,555 EXAMPLE BALANCE SHEET CHECK NUMBERS 10,000 UNITS YOU MAY ASSETS TOTAL CURRENT ASSETS 41,420 NET EQUIPMENT PATENT 11,291 13,800 TOTAL ASSETS 66,511 LIABILITIES CURRENT REQUIRED FINANCING TAX PAYABLE ACCOUNTS PAYABLE TOTAL CURRENT LIABILITIES 26,207 EQUITY COMMON STOCK RETAINED EARNINGS TOTAL LIABILITIES AND EQUITY 66,511 EXAMPLE INCOME STATEMENT 10,000 UNITS SALES 1.9 x 120,000 228,000 COST OF GOODS SOLD PRODUCTION PPACKAGING .7x132,000 SINGLE MOULD DEPRECIATION PACKAGING DEPRECIATION SUBTOTAL 170,544 LESS: PROMO UNITS INVENTORY COST OF GOODS SOLD ho GROSS PROFIT 72,960 OPERATING EXPENSES OFFICE FURNITURE DEPRECIATION ADMINISTRATION SHIPPING WAREHOUSE PROMO UNITS 65,574 m/d21/le/content/381239/viewContent/8311611/View o SUBTOTAL 170,544 LESS : PROMO UNITS INVENTORY COST OF GOODS SOLD GROSS PROFIT 72,960 OPERATING EXPENSES OFFICE FURNITURE DEPRECIATION ADMINISTRATION SHIPPING WAREHOUSE PROMO UNITS 65,574 EBIT N TAX 5,909 NET INCOME Exhibit 2 Balance Sheet UTENSIL BOX BALANCE SHEET As of July 15, 2017 $ Assets Current Total Current Assets Equipment Single Cavity Mold Tools and Dies Blister Package Mold Office Equipment 23,300 4,200 4,430 865 32,795 Other Patent Total Assets 13,800 $ 46,595 12 200 Liabilities Current Accounts Payable Equity Common Stock Total liabilities and Equity 34,395 S46.595 Exhibit 3 JACOBS Personal Balance Sheet As of July 15, 2017 Assets Cash Real Estate Automobile Stocks, Bonds, Etc. Household & Personal Effects Invested in Chef's Toolkit Total Assets 345 69,000 12,075 43,125 34,395 $ 158,940 Liabilities Bank & Finance Co. Loans Mortgages Other Liabilities 20,700 51.750 6,775 79,225 79.715. $ 158,940 Net Worth Total liabilities and Net Worth Exhibit 4 Production schedule in Units - 10.000 per month Production Sales Promotion Molded Packaged Month Inventory Home Warehouse 40,000 40,000 500 500 500 500 19,500 9,000 3,500 August September October November December Janauary February March April 5,000 7,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10.000 5,000 7,000 10,000 10,000 10,000 10,000 10,000 10.000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 10.000 10,000 10,000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10.000 10,000 10,000 May June July 2020FALLincomestatementformat Q Utensil Box Ltd Pro Forma Income Statement. For the period ending July Sales Cost of Goods Sold Units produced Units packaged Depreciation Single Mold Birch Tools Subtotal L: Pronouns Ending inventory Toticos Grass Profit Operating wenses Oficit dem Shine Adin situt units El Man 2020FALLbalance sheetformat V Utensil Box Ltd. Projected Balance Sheet - As at July 31, Based on 10000 UN Assets Current Cash Accounts Receivable ventory Total Current Assets quipment Single Cavity Mold se Pac Mond Tools/les Office Equipment Accurated Depreciation Sicily Mold Pack Mold Tool/ble attient Other Asset Punt Total Arts Cabi Current Accounts Required finance ulty that Canon Total Los adquy