Instructions FRZN Rubber Inc. has hired your employer to provide some profession
ID: 2550508 • Letter: I
Question
Instructions FRZN Rubber Inc. has hired your employer to provide some professional consulting. Your group has been assigned to advise the management of FRZN Rubber on some alternative strategies for their coming fiscal year. A major portion of this consulting will include presenting FRZN Rubber's management with a coming year budget if they continue on with their current business model and to contrast this budget with alternative budgets if the company makes some changes to their future operations You must use an Excel workbook to complete this assignment. Within the workbook there must be separate spreadsheets presenting a budget for the current business model, any alternative business model you are requested to present management with, and any additional alternative business models you desire to present to management. Each of the spreadsheets should draw from a given data section using cell referencing, formulas, functions, and linking (i.e. aside fronm the given data amounts there should be no hard numbers in you budget). There may be hard numbers in any short-term borrowing and repayment cells if need be, but there is an additional up to five bonus marks for groups that are able to compute short-term borrowing and repayment using cell referencing By the due date each group must submit, by email to the instructor, one digital copy of the workbook and one digital copy of a written report to management. The workbook is to be in Excel format and the written report is to be in Word format. Please label both the workbook and written report with the last names and first initials of each group member separated by a hyphen. For example if the group members are Amy Farrah Fowler, Sheldon Cooper, Leonard Hotstadter, and Howard Walowitz, then the document would be labeled Farrah This assignment is due no later than 2:00PM on April 6,2018. No late assignments will be accepted Project FRZN Rubber Inc. (a Canadian company with manufacturing facilities in Saskatoon, SK) is a leading manufacturer of hockey pucks. FRZN Rubber currently provides pucks to the NHI AHL, all of the leagues in the CHL (WHL, OHL, QMJHL), University leagues in Canada and the United States, and retailers throughout North America. Additionally, this year FRZN Rubber will supply pucks for the Winter Olympics. With a growing business and an increasing market share, the management at FRZN Rubber has hired your company to provide them with a detailedExplanation / Answer
1.
Per Chegg guidelines, 4 sub-parts have been answered.
FRZN Rubber Inc. Balance Sheet January 31, 2018 Assets Current assets: Cash 11000 Accounts receivable 41000 Finished goods inventory 4920 Raw materials inventory 5180 Total current assets 62100 Property, plant, and equipment 482900 Accumulated depreciation -45000 Total property, plant, and equipment 437900 Total assets $ 500000 Liabilities and Stockholders' Equity Liabilities Current liabilities Accounts payable 15800 Long-term liabilities Long-term debt 150000 Total liabilities 165800 Stockholder's Equity Common stock 155000 Retained earnings 179200 Total stockholder's equity 334200 Total liabilities and owner's equity 500000