I need help with Pacific Manufacturing Company Computations Excel chart

Student Name: Class: Problem 1-14A HOUSE OF ORGANS, INC. Traditional Income Statement For the Month Ended November 30 Sales Cost of goods sold Gross margin Selling and administrative expenses: Selling expenses: Total selling expenses Administrative expenses: Total administrative expenses Total selling and administrative expenses Net operating income HOUSE OF ORGANS, INC. Contribution Format Income Statement For the Month Ended November 30 Sales Variable expenses: Total variable expenses Contribution margin Fixed expenses: Total fixed expenses Net operating income Total $150,000 Per organ $2,500 Given Data P01-14A: HOUSE OF ORGANS, INC. Costs Selling: Advertising Delivery of organs Sales salaries and commissions Utilities Depreciation of sales facilities Administrative: Executive salaries Depreciation of office equipment Clerical Insurance Average sales price of organ Average cost of organ Organs sold & delivered in November Cost Formula $ $ $ $ $ 950 60 4,800 650 5,000 per month per organ sold per month plus per month per month $ $ $ $ 13,500 900 2,500 700 per month per month per month plus per month $ $ 2,500 1,500 60 4% of sales $40 per organ sold Student Name: Class: Problem 1-18A FRANKEL LTD. Analysis of Expenses Cost of goods sold Shipping expense Advertising expense Salaries and commissions Insurance expense Depreciation expense Analysis of the mixed expenses: Units Shipping Expense Salaries & Comm. Exp. Change in Cost Change in Activity Variable Rate Shipping Expense Salaries & Comm. Exp. High level of activity Low level of activity Change Variable cost element: Shipping expense Salaries and commission expense Fixed cost element: Cost at high level of activity Less variable cost element The cost formulas are: Shipping expense Salaries and commission expense FRANKEL LTD. Income Statement For the Month Ended June 30 Sales in units Sales revenue Variable expenses: Cost of goods sold Shipping expense Salaries & comm. expense Contribution margin Fixed expenses: Shipping expense Advertising expense Salaries and commissions exp. Insurance expense Depreciation expense Net operating income - Given Data P01-18A: FRANKEL LTD. Comparative Income Statements For the Three Months Ended June 30 Sales in units Sales revenue Cost of goods sold Gross margin Selling and administrative expenses: Shipping expense Advertising expense Salaries and commissions Insurance expense Depreciation expense Total selling and administrative expenses: Net operating income (loss) - April 3,000 420,000 168,000 252,000 44,000 70,000 107,000 9,000 42,000 272,000 20,000 May 3,750 525,000 210,000 315,000 50,000 70,000 125,000 9,000 42,000 296,000 19,000 June 4,500 630,000 252,000 378,000 56,000 70,000 143,000 9,000 42,000 320,000 58,000 Student Name: Class: Problem 1-22A ALDEN COMPANY Expenses Quarter Year 1-1st 2nd 3rd 4th Year 2-1st 2nd 3rd 4th Totals Units Sold (X) (000) 16,000 18,000 23,000 19,000 17,000 20,000 25,000 22,000 160,000 Shipping (Y) Expense $ 160,000 175,000 217,000 180,000 170,000 185,000 232,000 208,000 $ 1,527,000 Units Sold Shipping Expense High activity level Low activity level Change Variable cost per unit Fixed cost element: Total shipping expense at high activity level Less variable element Fixed cost element Cost formula: ALDEN COMPANY Budgeted Contribution Format Income Statement For the First Quarter, Year 3 Sales Variable expenses: Cost of goods sold Shipping expense Sales commission Total variable expenses Contribution margin Fixed expenses: Shipping expense Advertising expense Administrative salaries Depreciation expense Total fixed expenses Net operating income Given Data P01-22A: ALDEN COMPANY Cost formulas: Cost Cost of goods sold Advertising expense Sales commissions Administrative salaries Shipping expense Depreciation expense Cost Formula 20 per unit sold 170,000 per quarter 5% of sales 80,000 per quarter ? 50,000 per quarter $ $ $ $ Units sold and related shipping expenses: Quarter Year 1: First Second Third Fourth Year 2: First Second Third Fourth Sales forecast for 1st Quarter, Year 3: Units Price per unit Shipping Expense Units Sold $ 16,000 18,000 23,000 19,000 $ $ $ $ 160,000 175,000 217,000 180,000 17,000 20,000 25,000 22,000 $ $ $ $ 170,000 185,000 232,000 208,000 21,000 50