BUS 503 Accounting Information for Decision-Making-Assignment 1 – Cost of Goods Manufactured Decision Model Winter 2015

BUS 503 Accounting Information for Decision-MakingAssignment #1 – Cost of Goods Manufactured / Decision ModelWinter 2015Page 2 of 3Design your spreadsheets so that the probabilities are located in an “input parameters” section. When you use the probabilities, you will reference the cells in which they are located rather than entering them directly into the spreadsheets. For all other data fields, you will enter them directly into the spreadsheets or if they already exist in other cells, then simply reference them rather than re-entering them into the spreadsheets.Your spreadsheet printouts must include grid lines and row/column labels. Include all of your spreadsheets in one file by setting up separate sheets for the original data case and the two alternative cases in the normal view.Business memorandum (One page only)Prepare a one-page business memorandum for the president of Superior Metals Corporation. Your memorandum will describe your decision model and explain what the results mean to the Company.Required Format and Labeling• For the one-page business memo, use Word, Times New Roman font size 12 and single line spacing.• For the spreadsheets, use Excel, Times New Roman and at least font size 10.• Type your full name in the upper right corner of every page of the memo and spreadsheets.• Show all your calculations and make sure all pages and fields are properly labeled.• Utilize the Sheets function in Excel so that your original data case, case 1 and case 2 are set up as separate sheets (3) within the same file and labeled accordingly.Due DateYour decision model (spreadsheet) and business memo is due on Saturday, January 17, 2015.At the start of class on Saturday, January 17, 2015, you will provide the professor with a paper copy of your business memo and spreadsheet.No late work will be accepted.Grade and Score SheetThis is an individual assignment and must be your own work. The assignment is worth 15% of your course grade as indicated in the syllabus. The grade for this assignment comprises the following:• Business memo (50%)• Decision model design (20%)• Spreadsheet content: (30%)BUS 503 Accounting Information for Decision-MakingAssignment #1 – Cost of Goods Manufactured / Decision ModelFall 2014Page 3 of 3Here is the score sheet:Business memorandumContent: ___________________ (30 points)Description of decision modelInterpretation of what the numbers meanOrganization ___________________ (10 points)Proper language ___________________ (10 points)Decision model designDesign is complete and logical ___________________ (10 points)Parameter-driven ___________________ (5 points)Proper labeling ___________________ (5 points)(Data fields, calculations, headings,page numbers, case numbers, etc.)Spreadsheet content Complete and accurate• Original data case ___________________ (10 points)• Alternative Case 1 ___________________ (10 points)• Alternative Case 2 ___________________ (10 points)