这个作业是计算一个公司的盈亏平衡点、市场份额、生产预算等
COMM 200 FINANCE & FORECASTING ASSIGNMENT S20
盈亏平衡点问题（20分）
枫叶制造（MLM）是一家加拿大公司，生产坚固耐用的家具
–由枫树制成。他们专注于国内市场，并根据其需求量身定制产品
由于公司将战略重点放在生产高品质产品上而愿意支付额外费用的客户
优质的产品。
当前是2020年1月1日。该公司估计平均需要两个小时
生产一件家具。他们平均付给工人每小时35美元。约
一件家具生产中使用了3/4棵枫树。他们可以获得一个
树为$ 250。木材到达MLM的工厂时已预先切割。预计固定费用
本月总计$ 600,000。该公司最多可生产600件家具
一月份的预期利润为$ 50,000。
一月份，公司聘请了一位新经理，对工厂进行了几处变更。他非常
专注于提高净收入，但是却在削减成本而不是增加销售。他
预期利润每月增加20,000美元。新经理进行的一些更改包括：
•取消人力资源经理。虽然这每月可节省$ 9,000
在头顶上，工人们对这一决定感到愤怒，旷工也增加了。的
额外的加班需要将人工成本提高到每小时45美元。
•填补其他缺勤工人的工人效率通常较低。平均而言
现在需要花费三个小时来生产一件家具。
•研发部门的预算削减了50％。这样每月可以节省$ 11,000
固定开销。同时，
制造失败。这台机器使该公司的工作效率更高
使用原料。由于该部门失去了可以解决的关键人员
设备，预计将停用几个月。
因此，每件家具需要1.5棵树才能生产。
每件家具的平均售价为1400美元。
1.根据传销原件计算一月的盈亏平衡点（BEP）
估计1月1日。（3分）
2.考虑新经理在一月份所做的更改。必须有多少个单位
为了实现MLM修订后的利润目标而在一月份生产和销售？你认为
公司将能够达到这个目标？ （4分）
3. MLM应该向客户收取的最佳价格是多少，以达到其修订后的利润
假设1月的产量达到最大，则该目标为1月？你认为应该吗
将其价格更改为您计算的价格？解释为什么能或者为什么不能。 （5分）
4.计算一月估算值和一月变化的边际收益率，
两者都使用案例中提供的售价。传销如何增加贡献
保证金，不增加价格？ （3分）
5. Consider the changes made by the new manager in January. Overall, do you think the
changes made are in line with MLM’s strategy? Explain why or why not. (5 marks)
Balance Sheet Question (20 marks)
Jake has been operating his farm, State Farm, traditionally since April 2017. At the end of March
2019, he had the following financial data:
Description Value
Building – Farm house 180,000
Cash 1,969
Long Term Debt (bonds, due in 20 years) 181,300
Accounts Receivable (due within the year) 1,490
Land 140,000
Retained Earnings 15,200
Equipment 49,316
Accumulated Depreciation – Equipment 1,000
Bank Loan ($10,000 payable each year, with
the first $10,000 due March 2020)
50,000
Jake State, Capital 128,475
Inventory – Seeds 3,200
Throughout the 2019-20 fiscal year (April 1 2019 – March 31 2020), Jake experienced the
following events:
• He collected the outstanding Accounts Receivables of $1,490 in cash.
• He used up all his seed inventory, which he used to plant fruits and vegetables and then
sell to a combination of Farmer’s Market customers and restaurant clients.
• From these sales, he earned $50,000, of which $45,000 was cash and $5,000 was
accounts receivable.
• Jake had an additional $500 worth of equipment depreciation expense this year.
• As a result of his net income this year, retained earnings increased by $46,300.
• To get ready for next year, Jake purchased another $5,000 of seed inventory using cash.
• At the end of the year, he decided to pay off his entire outstanding bank loan. He used
some of the Farm’s cash for the transaction and paid the rest with his own money. His
outstanding bank loan amounts (current and long-term) are now $0.
• Total assets at the end of the 2020 fiscal year equal $391,275.
Please answer the following questions.
1. Prepare a balance sheet for Jake’s Fiscal 2019 (year ended March 2019). Ensure you
categorize your accounts into Current Assets, Long-Term Assets, Current Liabilities, LongTerm Liabilities, and Owner’s Equity. (5 marks)
2. Using the above events, prepare an updated balance sheet for Jake’s Fiscal 2020 (year ended
March 2020). Hint: to make your balance sheet balance, you will need to calculate the
additional amount of capital Jake contributed to the business to pay off the bank loan, as
well as what portion of that payment was paid with the Farm’s cash. (7 marks)
3. Jake has decided to invest in a new fixed asset – a digital platform for online selling and
online delivery. His organic, locally grown fresh food is in high demand among both
customers and restaurants, and this will help him manage his customers and accounts
receivables better. The new system will cost him an up-front payment of $20,000, so he has
decided to take out a short-term loan with his bank.
Comment on Jake’s overall financial position if he proceeds with this transaction and use
ratio analysis to support your answer. Consider Jake’s current business process and industry.
Should Jake consider alternative means of financing this new system? Explain why or why
not. (8 marks)
Capsim Advanced Forecasting Question (10 marks)
Refer to the FastTrack posted in the Finance & Forecasting Assignment tab on the course
website. Assume you are part of Team Andrews and are responsible for making forecasting
decisions for its product, Able. You are forecasting for Round 3.
Please answer the following questions.
1. Identify the primary segment of the product at the end of Round 2. What was the total
industry unit demand for this segment in Round 2? What will be the total demand for the
segment in Round 3? (2 marks)
2. Using the advanced forecasting method only, what is the worst-case market share that the
product should achieve in Round 3? Calculate the worst-case demand in units for Round 3
using this market share. (4 marks)
3. Are there any factors that make you believe that the worst-case market share calculated in
step 2 is too low, or too high? Identify at least two factors which may have an impact and
explain if each factor should increase or decrease the worst-case market share (you do not
need to specify by how much). (4 marks)