Hi, I have an Assignment which make me very confused about making it done. It is about how to make a budget assignment in accounting on Excel file. I have attached all files needs to support the work. If you can help me, I am very appreciated it.

Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Total Marks Your Marks 2 2 1 5 2 2 1 5 1 4 1 4 1 - Inventory should be in $ (not units) (2mks for "Add", 1 for EI in Total, 1 for $, 1 for correct #s) 1 MANUAL ADJ if necessasry MANUAL ADJ - correct formula used - Inventory should be in $ (not units) Summary of Grades 1 11 1 MANUAL ADJ if necessasry 3 1 4 1 4 1 11 1 1 1 1 1 3 1 1 4 2 1 7 1 1 3 1 1 1 3 1 2 14 4 IF stmt used = 3 marks + 1 mark correct #s 2 1 7 1 1 3 1 1 1 3 1 Check for formula accuracy 2 Check for formula accuracy 14 1 2 2 1 1 2 2 1 Inventory should be in $ (not units) MANUAL ADJ if necessasry Inventory should be in $ (not units) MANUAL ADJ if necessasry Check for formula accuracy 02/07/2017 Summary of Grades 02/07/2017 3 2 3 2 16 3 Must link to repayment table 2 3 Must be VLookup or IF Stmt 2 16 2 2 1 5 2 For number format (","), NO decimals! 2 For proper use of "$" (top and bottom only), underlining 1 Test - cell referencing done 5 5 5 See column chart sheet for details 75 59 Summary of Grades Total Marks 02/07/2017 Your Marks 5 5 2 12 - 2 1 1 13 2 Mortgage Loan Repayment - check to see if zero at end of loan. 1 Test - cell referencing done 1 1 Total Marks Manual adj may be required if carrying error from budget tabs Manual adj may be required if carrying error from budget tabs Manual adj may be required if carrying error from budget tabs Your Marks 1 1 1 1 2 2 5 5 See line chart sheet for details 3 3 Memo 10 10 Summary of Grades Inventory should be in $ (not units) (2mks for "Add", 1 for EI in Total, 1 for $, 1 for correct #s) 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Plan A assumptions Plan A - Assumptions Sales - UNITS Peak Diet Peak Jan Ending monthly inventory Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec May Jun Jul Aug Sep Oct Nov Dec Total Jan-18 of the following month's COGS Beginnning Inventory of Cases, January 1, 2017 Peak Diet Peak Sales - PRICES PER CASE Peak Diet Peak Jan Decrease in prices Feb Mar Apr January to March Cost per CASE Peak Diet Peak Operating Expenses: Commissions Commissions Commissions Shipping Rent Office Expense Advertising Expense Advertising Expense Salaries Expense Utilities Expense Insurance Expense Depreciation Expense Mortgage Interest Expense if monthly sales = $ 500,000 and = $ 800,000 of sales per month per month per month per month - except January and February January and February only per month per month per month per month *see mortgage loan repayment schedule Warehouse - building Loan APR Term of loan years Residual value Useful life years Income Taxes: Net income $ $ $ $ $ $ Tax Rate 10,000 20,000 30,000 40,000 50,000 $ 800,000 Jan-18 Plan A Plan A - Budgets Jan Feb Mar Apr May Performance Plus Inc. Sales Budget For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov May Performance Plus Inc. Merchandise Purchases Budget For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov Sales - Peak Sales - Diet Peak Total Sales Jan Peak Cost of Goods Sold Total Needs Purchases of Peak Diet Peak Cost of Goods Sold Total Needs Purchases of Diet Peak Total Purchases Feb Mar Apr May Performance Plus Inc. Operating Expenses Budget For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov May Performance Plus Inc. Budgeted Income Statement For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov Plan A Jan Feb Mar Apr VARIABLE EXPENSES Selling Commissions Shipping Total Variable Expenses FIXED EXPENSES Rent Office Expense Advertising Salaries Utilities Insurance Depreciation Total Fixed Expenses Total Operating Expenses Jan Sales Cost of Goods Sold Gross Profit Operating Expenses Income before interest and taxes Interest expense Income before taxes Income tax (refund) Net Income (loss) Feb Mar Apr Plan A Plan A Plan A Plan A Add: Desired ending inventory Less: Beginning inventory Plan A Performance Plus Inc. Sales Budget For the year ending December 31, 2017 Dec Total Jan-18 Dec Total Jan-18 Performance Plus Inc. Merchandise Purchases Budget For the year ending December 31, 2017 Plan APerformance Plus Inc. Operating Expenses Budget For the year ending December 31, 2017 Dec Total Jan-18 Dec Total Jan-18 Performance Plus Inc. Budgeted Income Statement For the year ending December 31, 2017 Plan A Plan A Plan A Plan A Column Chart Column Chart Loan Calculator Enter Values Loan Amount Annual Interest Rate Loan Period in Years Number of Payments Per Year Start Date of Loan Scheduled Payment Pmt No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 Payment Date Beginning Balance 1/31/2017 1/1/2017 Scheduled Payment Principal Interest Ending Balance 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 Analysis Analysis - Plan A vs. Plan B Net Income Comparison Plan A Plan B Variance Jan Feb Canada Nets Inc. Summary - Plan A vs. Plan B For the year ending December 31, 2017 Plan A Sales Operating Expenses Net Income MEMO To: From: Date: Re: Plan B Mar Apr May Analysis Jun Jul Aug Sep Oct Nov Dec Analysis Total Line Chart Line Chart 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Total Marks Your Marks 2 2 1 5 2 2 1 5 1 4 1 4 1 - Inventory should be in $ (not units) (2mks for "Add", 1 for EI in Total, 1 for $, 1 for correct #s) 1 MANUAL ADJ if necessasry MANUAL ADJ - correct formula used - Inventory should be in $ (not units) Summary of Grades 1 11 1 MANUAL ADJ if necessasry 3 1 4 1 4 1 11 1 1 1 1 1 3 1 1 4 2 1 7 1 1 3 1 1 1 3 1 2 14 4 IF stmt used = 3 marks + 1 mark correct #s 2 1 7 1 1 3 1 1 1 3 1 Check for formula accuracy 2 Check for formula accuracy 14 1 2 2 1 1 2 2 1 Inventory should be in $ (not units) MANUAL ADJ if necessasry Inventory should be in $ (not units) MANUAL ADJ if necessasry Check for formula accuracy 02/07/2017 Summary of Grades 02/07/2017 3 2 3 2 16 3 Must link to repayment table 2 3 Must be VLookup or IF Stmt 2 16 2 2 1 5 2 For number format (","), NO decimals! 2 For proper use of "$" (top and bottom only), underlining 1 Test - cell referencing done 5 5 5 See column chart sheet for details 75 59 Summary of Grades Total Marks 02/07/2017 Your Marks 5 5 2 12 - 2 1 1 13 2 Mortgage Loan Repayment - check to see if zero at end of loan. 1 Test - cell referencing done 1 1 Total Marks Manual adj may be required if carrying error from budget tabs Manual adj may be required if carrying error from budget tabs Manual adj may be required if carrying error from budget tabs Your Marks 1 1 1 1 2 2 5 5 See line chart sheet for details 3 3 Memo 10 10 Summary of Grades Inventory should be in $ (not units) (2mks for "Add", 1 for EI in Total, 1 for $, 1 for correct #s) 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Summary of Grades 02/07/2017 Plan A assumptions Plan A - Assumptions Sales - UNITS Peak Diet Peak Jan Ending monthly inventory Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec May Jun Jul Aug Sep Oct Nov Dec Total Jan-18 of the following month's COGS Beginnning Inventory of Cases, January 1, 2017 Peak Diet Peak Sales - PRICES PER CASE Peak Diet Peak Jan Decrease in prices Feb Mar Apr January to March Cost per CASE Peak Diet Peak Operating Expenses: Commissions Commissions Commissions Shipping Rent Office Expense Advertising Expense Advertising Expense Salaries Expense Utilities Expense Insurance Expense Depreciation Expense Mortgage Interest Expense if monthly sales = $ 500,000 and = $ 800,000 of sales per month per month per month per month - except January and February January and February only per month per month per month per month *see mortgage loan repayment schedule Warehouse - building Loan APR Term of loan years Residual value Useful life years Income Taxes: Net income $ $ $ $ $ $ Tax Rate 10,000 20,000 30,000 40,000 50,000 $ 800,000 Jan-18 Plan A Plan A - Budgets Jan Feb Mar Apr May Performance Plus Inc. Sales Budget For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov May Performance Plus Inc. Merchandise Purchases Budget For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov Sales - Peak Sales - Diet Peak Total Sales Jan Peak Cost of Goods Sold Total Needs Purchases of Peak Diet Peak Cost of Goods Sold Total Needs Purchases of Diet Peak Total Purchases Feb Mar Apr May Performance Plus Inc. Operating Expenses Budget For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov May Performance Plus Inc. Budgeted Income Statement For the year ending December 31, 2017 Jun Jul Aug Sep Oct Nov Plan A Jan Feb Mar Apr VARIABLE EXPENSES Selling Commissions Shipping Total Variable Expenses FIXED EXPENSES Rent Office Expense Advertising Salaries Utilities Insurance Depreciation Total Fixed Expenses Total Operating Expenses Jan Sales Cost of Goods Sold Gross Profit Operating Expenses Income before interest and taxes Interest expense Income before taxes Income tax (refund) Net Income (loss) Feb Mar Apr Plan A Plan A Plan A Plan A Add: Desired ending inventory Less: Beginning inventory Plan A Performance Plus Inc. Sales Budget For the year ending December 31, 2017 Dec Total Jan-18 Dec Total Jan-18 Performance Plus Inc. Merchandise Purchases Budget For the year ending December 31, 2017 Plan APerformance Plus Inc. Operating Expenses Budget For the year ending December 31, 2017 Dec Total Jan-18 Dec Total Jan-18 Performance Plus Inc. Budgeted Income Statement For the year ending December 31, 2017 Plan A Plan A Plan A Plan A Column Chart Column Chart Loan Calculator Enter Values Loan Amount Annual Interest Rate Loan Period in Years Number of Payments Per Year Start Date of Loan Scheduled Payment Pmt No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 Payment Date Beginning Balance 1/31/2017 1/1/2017 Scheduled Payment Principal Interest Ending Balance 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 Analysis Analysis - Plan A vs. Plan B Net Income Comparison Plan A Plan B Variance Jan Feb Canada Nets Inc. Summary - Plan A vs. Plan B For the year ending December 31, 2017 Plan A Sales Operating Expenses Net Income MEMO To: From: Date: Re: Plan B Mar Apr May Analysis Jun Jul Aug Sep Oct Nov Dec Analysis Total Line Chart Line Chart 02/07/2017