Old MathJax webview

Old MathJax webview

Please use whatever you need to help me figure this out.

Please help me figure this out.

That is the full question what information do you need

You have all the information you need you figure these out....

a 3) Complete the forecasting for a 2 month moving average, a 3 month moving average, a weighted moving average and exponential smoothing. Find the MAD for all four forecasting models. Select which model is the most accurate. Instructions: Enter your formulas Round to two decimals places for Income Statement January 46,062 545 45,517 13,841 31,676 Percents February January Vertical Analysis February Vertical Analysis 44,759 685 44,074 11,583 32,491 Total Revenues Returns & Allowances Net Sales Cost of Goods Solo Gross Profit Operating Expenses Officer's Salary Salanes Payroll Taxes Rent Janitorial TABLE 2,500 15,750 3,623 2,000 150 2,500 14,250 3,278 2,000 4-1 150 Utilities 512 485 Depreciation Sales Taxes Total Operating Expenses Operating Proft/Loss Interest Expense Net Profit/ Loss 500 2.994 28,029 3,647 500 2.909 26,072 6.419 150 150 3,497 6,259 Income Statement January 46,062 Instri Entei Perct Total Revenues Returns & Allowances 545 February Horizontal Analysis in % 44,759 685 44,074 11,583 32,491 Net Sales Cost of Goods Sold Gross Profit 45,517 13,841 31,676 Operating Expenses Officer's Salary Salaries Payroll Taxes Rent 2,500 14,250 2,500 15,750 3,623 2,000 3,278 2,000 Janitorial 150 150 512 485 500 500 Utilities Depreciation Sales Taxes Total Operating Expenses Operating Profit/Loss Interest Expense Net Profit/Loss 2,994 28,029 3,647 2,909 26,072 6,419 150 150 3,497 6,269 Table 4-2. Income Statement and Balance Sheet for Sam's Appliances Income Statement Balance Sheet Years Ending December 31 January 1 through December 31 Years Years ACCOUNT 2006 2007 2008 CATEGORY 2006 2007 2008 Net Sales $ 330 $ 441 $ 462 Current Assets 825 94 $ 111 Cost of Goods Sold 148 200 235 Fixed Assets 215 208 195 Gross Profit 182 $ 241 227 Total Assets 2975 3025 306 Operating Expenses 148 163 181 Liabilities and Owner's Equity EBIT $ 34 78 $ 46 Current Liabilities $ 27 $ 79 $ 87 Interest 7 5 70 68 8 Total Long Tem Debt 77 $ 29 $ EBT 71 38 Total Liabilities $ 156$ 95$ 157 Taes 8 149 18 10 Owner's Equity 202 146 $ 53 $ 21 $ Net Profit 28 Total Liabilities & OE 306 297 $ 302$ lea NO 7 Abs Diff Weights 1,3 and .6 Abs Diff 3 Month Moving Average 2 Month Moving Average Abs Diff Actual Time Period Sales 1 345 2. 378 3 425 4 450 5 470 6 500 7 532 8 No 548 9 590 10 625 11 650 MAD Cost Category Cost Rent *HINT: check for changes in time fra $3,000 1,100 Utilities Payment Period Monthly Monthly Quarterly Annually Per Shelf 1,200 Insurance 6,000 Property Taxes Steel 9 0.25 Forming Labor Per Shelf Per Shelf 0.75 Price 20 Per Shelf a 3) Complete the forecasting for a 2 month moving average, a 3 month moving average, a weighted moving average and exponential smoothing. Find the MAD for all four forecasting models. Select which model is the most accurate. Instructions: Enter your formulas Round to two decimals places for Income Statement January 46,062 545 45,517 13,841 31,676 Percents February January Vertical Analysis February Vertical Analysis 44,759 685 44,074 11,583 32,491 Total Revenues Returns & Allowances Net Sales Cost of Goods Solo Gross Profit Operating Expenses Officer's Salary Salanes Payroll Taxes Rent Janitorial TABLE 2,500 15,750 3,623 2,000 150 2,500 14,250 3,278 2,000 4-1 150 Utilities 512 485 Depreciation Sales Taxes Total Operating Expenses Operating Proft/Loss Interest Expense Net Profit/ Loss 500 2.994 28,029 3,647 500 2.909 26,072 6.419 150 150 3,497 6,259 Income Statement January 46,062 Instri Entei Perct Total Revenues Returns & Allowances 545 February Horizontal Analysis in % 44,759 685 44,074 11,583 32,491 Net Sales Cost of Goods Sold Gross Profit 45,517 13,841 31,676 Operating Expenses Officer's Salary Salaries Payroll Taxes Rent 2,500 14,250 2,500 15,750 3,623 2,000 3,278 2,000 Janitorial 150 150 512 485 500 500 Utilities Depreciation Sales Taxes Total Operating Expenses Operating Profit/Loss Interest Expense Net Profit/Loss 2,994 28,029 3,647 2,909 26,072 6,419 150 150 3,497 6,269 Table 4-2. Income Statement and Balance Sheet for Sam's Appliances Income Statement Balance Sheet Years Ending December 31 January 1 through December 31 Years Years ACCOUNT 2006 2007 2008 CATEGORY 2006 2007 2008 Net Sales $ 330 $ 441 $ 462 Current Assets 825 94 $ 111 Cost of Goods Sold 148 200 235 Fixed Assets 215 208 195 Gross Profit 182 $ 241 227 Total Assets 2975 3025 306 Operating Expenses 148 163 181 Liabilities and Owner's Equity EBIT $ 34 78 $ 46 Current Liabilities $ 27 $ 79 $ 87 Interest 7 5 70 68 8 Total Long Tem Debt 77 $ 29 $ EBT 71 38 Total Liabilities $ 156$ 95$ 157 Taes 8 149 18 10 Owner's Equity 202 146 $ 53 $ 21 $ Net Profit 28 Total Liabilities & OE 306 297 $ 302$ lea NO 7 Abs Diff Weights 1,3 and .6 Abs Diff 3 Month Moving Average 2 Month Moving Average Abs Diff Actual Time Period Sales 1 345 2. 378 3 425 4 450 5 470 6 500 7 532 8 No 548 9 590 10 625 11 650 MAD Cost Category Cost Rent *HINT: check for changes in time fra $3,000 1,100 Utilities Payment Period Monthly Monthly Quarterly Annually Per Shelf 1,200 Insurance 6,000 Property Taxes Steel 9 0.25 Forming Labor Per Shelf Per Shelf 0.75 Price 20 Per Shelf