Question
Question: 1. What will be the projected income statements, balance sheets, and cash budgets for Utensil Box Inc. up to July 31, 2020 for all
Question: 1. What will be the 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?
(1 mark)
3.
If you were Mr. Reid, would you invest in Utensil Box Inc. at July 31
st
2019? If
yes, how much considering the parameters provided? Why or why not?
Information:
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 2017was 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
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, $4,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
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 units. 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
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 $.017 per unit was recommended for the package mold 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 $1.90 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 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
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 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 $.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 decided what amount they would request from
Mr. Reid, they would submit a formal information package and drop in to see Mr. Reid
with their complete pro-forma financial statements.
Exhibit 2:
UTENSIL BOX
BALANCE SHEET
As of July 15, 2017
Assets
Current
$ -
Total Current Assets
-
Equipment
Single Cavity Mold
23,300
Tools and Dies
4,200
Blister Package Mold
4,430
Office Equipment
865
32,795
Other
Patent
13,800
Total Assets
$ 46,595
Liabilities
Current
Accounts Payable
12,200
Equity
Common Stock
34,395
Total liabilities and Equity
$ 46,595
Exhibit 3:
JACOBS Personal Balance Sheet
As of July 15, 2017
Assets
Cash
$ 345
Real Estate
69,000
Automobile
12,075
Stocks, Bonds, Etc.
-
Household & Personal Effects
43,125
Invested in Chef's Toolkit
34,395
Total Assets
$ 158,940
Liabilities
Bank & Finance Co. Loans
20,700
Mortgages
51,750
Other Liabilities
6,775
79,225
Net Worth
79,715
Total liabilities and Net Worth
$ 158,940
Exhibit 4:
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started