Exam Review S15

xlsx

School

Conestoga College *

*We aren’t endorsed by this school

Course

1220

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

22

Uploaded by CommodoreMetalAlpaca39

Report
XYZ Company Statement of Earnings For the year end December 31 ,2023 Revenue 3,250,000 Cost of Good Sold 1,750,000 Gross Profit 1,500,000 Depreciation 60,000 Rent 175,000 Salaries 250,000 Office Supplies 25,000 Utilities 30,000 Fuel 10,000 Advertising 100,000 Total Expenses 650,000 Net Earning Before Tax 850,000 Income Tax 25% 212,500 Net Earnings After Tax 637,500
XYZ Company Statement of Financial Position As at December 31, 2023 Assets Cash 3,000 Accounts Receivable 75,000 Inventory 250,000 Fixed Assets 300,000 Total Assets 628,000 Liabilitites & SH Equity Accounts Payable 86,000 Salary Payable 10,000 Income Tax Payable 212,500 Bank Loan 125,000 Contributed Capital 60,000 Retained Earnings 134,500 Total Liabilities & SH Equity 628,000
XYZ Company Statement of Earnings For the year end December 31 ,2023 $ Component % Revenue 3,250,000 100% Cost of Good Sold 1,750,000 54% Gross Profit 1,500,000 46% Depreciation 60,000 2% Rent 175,000 5% Salaries 250,000 8% Office Supplies 25,000 1% Utilities 30,000 1% Fuel 10,000 0% Advertising 100,000 3% Total Expenses 650,000 20% Net Earning Before Tax 850,000 26% Income Tax 25% 212,500 7% Net Earnings After Tax 637,500 20%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
XYZ Company Statement of Financial Position As at December 31, 2023 Assets Component % Cash 3,000 0.5% Accounts Receivable 75,000 11.9% Inventory 250,000 39.8% Fixed Assets 300,000 47.8% Total Assets 628,000 100.0% Liabilitites & SH Equity Accounts Payable 86,000 13.7% Salary Payable 10,000 1.6% Income Tax Payable 212,500 33.8% Bank Loan 125,000 19.9% Contributed Capital 60,000 9.6% Retained Earnings 134,500 21.4% Total Liabilities & SH Equity 628,000 100.0%
Earnest Enterprises total overhead costs at various levels of activity: Month Direct Labour Hours Total Overhead Costs September 35,000 $ 210,000 October 42,000 $ 330,000 November 66,000 $ 375,000 December 32,000 $ 215,000 Total Overhead consists of utilities, supervisor salaries, and maintenance. The breakdown of these costs at the 42,000 direct labour hours are as follows: Utilities variable $ 65,250 Salaries fixed $ 43,500 Maintenance mixed $ 221,250 $ 330,000 Earnest's management would like to break the maintenance costs into it's varia 1) Overhead costs in November were $375,000. Determine how much of this was 2) By means of the high-low method, estimate a cost formula for maintenance
able and fixed components. s maintenance costs.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Earnest Enterprises total overhead costs at various levels of activity: Month Direct Labour Hours Total Overhead Costs September 35,000 $ 210,000 October 42,000 $ 330,000 November 66,000 $ 375,000 December 32,000 $ 215,000 Total Overhead consists of utilities, supervisor salaries, and maintenance The breakdown of these costs at the 42,000 direct labour hours are as fo Utilities variable $ 65,250 Salaries fixed $ 43,500 Maintenance mixed $ 221,250 $ 330,000 Earnest's management would like to break the maintenance costs into it 1) Overhead costs in November were $375,000. Determine how much of th 2) By means of the high-low method, estimate a cost formula for maintena DLH's Maint Costs High 66,000 $ 228,964 Low 32,000 $ 121,786 Difference 34,000 $ 107,179 Total Maintenance Variable Maintenance Fixed Costs Hi $ 228,964 208,053 Fixed Costs Low $ 121,786 100,874 Y = $20,912 + 3.15 (X)
Variable Fixed Mixed Utilities Salaries Maintenance Total $ 1.55 $ 65,250 $ 43,500 $ 221,250 $ 330,000 102,536 $ 43,500 $ 228,964 $ 375,000 49,714 $ 43,500 $ 121,786 $ 215,000 e. ollows: t's variable and fixed components. his was maintenance costs. Maintenance = $ 228,964 ance 3.15 Variable Rate per DLH Fixed $ 20,912 $ 20,912
Muskoka Bay Company distributes BBQ's that sell f Round to the nearest dollar 1What is the products CM per unit? 2Use the CM per unit to determine Break Even point 3What is the Break even point in Sales? 4How many more BBQ's does the company need to 5If Sales are projected to increase next year by $200 6Assume the following operating results for last year Sales Less Variable Expenses Contribution Margin Less: Fixed Expenses Net Operating Income a) What is the degree of operating leverage at the c b)If sales are expected to increase by 15% next yea
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
c) What is the margin of safety in dollars and %? 7Assume the company sold 1,850 BBQs last year. The sales manager believes that a 10% reduction in a) using the incremental approach determine how b) Would you follow the sale's manager's recomme
for $425 per unit. Variable expenses are 30% of sales and t in Units sell if they want to make a $100,000 of profit? 0,000 how much should Net Operating Income Increase? r: 850,000 255,000 595,000 425,000 170,000 current level of sales? ar, how much will the net operating income increase?
n selling price, combined with $95,000 increase in advertis much net income will change by. endations?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
fixed expenses are $425,000 annually
sing would increase annual unit sales by 30%.
Muskoka Bay Company distributes BBQ's that sell for $42 Round to the nearest dollar 1What is the products CM per unit? 2Use the CM per unit to determine Break Even point 3What is the Break even point in Sales? 4How many more BBQ's does the company need to 5If Sales are projected to increase next year by $200 6Assume the following operating results for last year Sales Less Variable Expenses Contribution Margin Less: Fixed Expenses Net Operating Income a) What is the degree of operating leverage at the c b)If sales are expected to increase by 15% next yea
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
c) What is the margin of safety in dollars and %? 7Assume the company sold 1,850 BBQs last year. The sales manager believes that a 10% reduction in a) using the incremental approach determine how b) Would you follow the sale's manager's recomme New Selling Price $ 425 X New CM per Unit New # of Units 2000X Total New CM $'s Old CM $'s Increase in CM Increase in Advertising Change in Net Income
25 per unit. Variable expenses are 30% of sales and fixed e Selling Price CM $ 425 1-30% t in Units Fixed Exp 425,000 CM / unit $ 298 Fixed Exp 425,000 CM Ratio 0.7 sell if they want to make a $100,000 of profit? 0,000 how much should Net Operating Income Increase? r: # of units 850,000 2,000 255,000 595,000 425,000 170,000 current level of sales? ar, how much will the net operating income increase?
Current Sales - Breakeven Sales $ 850,000 $ 607,143 $ 242,857 Margin of Safety / Current Sales 28.6% n selling price, combined with $95,000 increase in advertis much net income will change by. endations? Yes 90% $ 382.50 100% $ 267.75 70% 130% 2600 $ 696,150 595,000 $ 101,150 $ 95,000 $ 6,150
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
expenses are $425,000 annually Sales x CM $ 298 $ 1,429 $ 607,143 Profit 100,000 336 CM / Unit $ 298 Sales Increase x CM Ratio $ 200,000 0.7 $ 140,000 Cont. Margin 595,000 3.5 Net Op Income 170,000 (Degree of Op Leverage X % Sales Increase
3.5 15% 53% $ 170,000 sing would increase annual unit sales by 30%.
e)X Original NI
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$ 89,250
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help