MDA HOMEWORK - J&R Total Company For the Year Ending(in US...

Info icon This preview shows pages 1–8. Sign up to view the full content.

J&R Total Compan For the Year Ending Dece (in US $ Millions) Total Company 2015 Current % of Net Rev 2014 Prior Year% of Net Rev Revenue Retail Revenue $520,000.00 58% 500,000.00 59% Wholesale Revenue 370,000.00 42% 350,000.00 41% Total Revenue 890,000.00 100% 850,000.00 100% COGS Product Costs 155,000.00 17% 150,000.00 18% Labor 125,000.00 14% 120,000.00 14% Overhead 10,000.00 1% 10,000.00 1% COGS Other 5,000.00 1% 5,000.00 1% Total COGS 295,000.00 33% 285,000.00 34% Gross Profit 595,000.00 67% 565,000.00 66% Operating Expenses Compensation 431,375.00 48% 395,125.00 46% Marketing Cost 15,000.00 2% 10,000.00 1% Legal Fees 2,000.00 0% 2,000.00 0% Audit/Accountancy Fees 8,000.00 1% 8,000.00 1% Bank Charges 500.00 0% 500.00 0% Corporate Events 10,000.00 1% 10,000.00 1% Increase In Bad Debt Provisio 13,350.00 2% 12,750.00 2%
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

IT 42,500.00 5% 42,500.00 5% Rent 60,000.00 7% 60,000.00 7% Utilities 300.00 0% 300.00 0% Data Communications 350.00 0% 350.00 0% Insurance 150.00 0% 150.00 0% Office Supplies 75.00 0% 75.00 0% Depreciation 12,100.00 1% 12,100.00 1% Total Operating Expenses 595,700.00 67% 553,850.00 65% Operating Profit Before Taxes (700.00) 0% 11,150.00 1% Taxes at 35% (245.00) 0% 3,902.50 0% Net Income ($455.00) 0% $7,247.50 1% check 0.00 0.00
Image of page 2
ny ember 31, 2015 Act vs PY % Var Comments: $20,000.00 4% 20,000.00 6% $40,000.00 5% 5,000.00 3% 5,000.00 4% 0.00 0% 0.00 0% 10,000.00 4% 30,000.00 5% 36,250.00 9% 5,000.00 50% 0.00 0% 0.00 0% 0.00 0% 0.00 0% 600.00 5% Wholesale revenue was higher than prior year due to the increasing sales of the new products. The product cost is higher than the forecast because the company brought many new machines for new products,but it will not cost any more in next year. Labor was higher than prior year because the company hired more waitresses when they started to sell these new products, the company also opened many branches in other area. Compensation was higher than prior year due to laying off some higher level managers and company needed to pay the compensation for them. Marketing cost was higher than prior year due to the advertisement for new products. The investment to the new branch in North Bay became bad debts in this year, can not receieve the profit from the new branch.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

0.00 0% 0.00 0% 0.00 0% 0.00 0% 0.00 0% 0.00 0% 0.00 0% 41,850.00 8% ($11,850.00) -106% ($4,147.50) -106% ($7,702.50) -106% Net income was lower than the prior year because the increase in operating expenses was much more than the increase in revenue.
Image of page 4
J& Balanc For the Year Ending (in US Millions) 2015 Current % of Total 2014 Prior Year Assets Cash and Cash Equivalents Bank of America - Checking $750,000.00 61% $650,000.00 Total Cash and Cash Equivalents 750,000.00 61% 650,000.00 Current Assets Accounts Receivable 185,000.00 15% 175,000.00 Inventory 206,500.00 17% 199,500.00 Prepaid Insurance 150.00 0% 150.00 Prepaid Rent 5,000.00 0% 5,000.00 Total Cash and Cash Equivalents 396,650.00 32% 379,650.00 Fixed Assets Office Equipment 3,500.00 0% 3,500.00 Furniture and Fixtures 13,000.00 1% 13,000.00 Computer Equipment 25,000.00 2% 25,000.00 Accumulated Depr - Office E 3,166.67 0% 2,000.00 Accumulated Depr - Furniture 7,800.00 1% 5,200.00 Accumulated Depr - Compute 25,000.00 2% 16,666.67 Total Fixed Assets 77,466.67 6% 65,366.67 Total Assets 1,224,116.67 100% 1,095,016.67 Liabilities Current Liabilities
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Accounts Payable 149,174.17 12% 170,019.17 Accrued Liabilities 750.00 0% 750.00 Unearned Revenue 7,400.00 1% 7,000.00 Total Current Liabilities 157,324.17 13% 177,769.17 Long Term Debt Note Payable 200,000.00 16% 200,000.00 Total Long Term Debt 200,000.00 16% 200,000.00 Total Liabilities 357,324.17 29% 377,769.17 Equity Common Stock 350,000.00 29% 300,000.00 Additional Paid-In Capital 500,000.00 41% 400,000.00 Retained Earnings 16,792.50 1% 17,247.50 Total Equity 866,792.50 71% 717,247.50 Total Liabilities and Equity $1,224,116.67 100% $1,095,016.67 check A=L+SE 0.00 0.00 check 0.00 0.00
Image of page 6
&R ce Sheet g December 31, 2015 % of Total Act vs PY % Var Comments: 59% $100,000.00 15% 59% $100,000.00 15% 16% 10,000.00 6% 18% 7,000.00 4% 0% 0.00 0% 0% 0.00 0% 35% 17,000.00 4% 0% 0.00 0% 1% 0.00 0% 2% 0.00 0% 0% 1,166.67 58% 0% 2,600.00 50% 2% 8,333.33 50% 6% 12,100.00 19% 100% 129,100.00 12% Cash was higher than prior year due to equity funding and Retail revenue coming in more favorably.
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern