CD-ROM Exercise 2.2
Use the figures givenbelow to complete
the statement of income for the Blackburn...
CD-ROM Exercise 2.2
Use the figures givenbelow to complete
the statement of income for the Blackburn Tavern, calculate
percentages for each catagory as illustrated in Figure 2.1
Food Sales $723,556.00
Salariesand
Wages $228,456.00
Beverage
Sales $224,945.00
Other
Controllable $145,532.00
Beverage Cost $
57,534.00
Employee
Benefits $ 14,667.00
Food Cost $265,998.00
Occupancy Costs $
44,860.00
Depreciation Expense $
74,856.00
Interest $ 21,790.00
Exercise 2.2
Blackburn Tavern
INCOME STATEMENT
Percent of Sales
YEAR
ENDED DECEMBER 31, 20XX
Sales
Food
$
%
Beverage
%
Total
Sales
$ -
%
Cost of
Sales
Food
$
%
Beverage...
please use Excel if you can, thank you very much.
Income Statement with Budget
Please complete...
please use Excel if you can, thank you very much.
Income Statement with Budget
Please complete the change and upcoming year columns
based on the following information:
Food and beverage sales will both increase by
5%
Food and beverage cost percentages will remain the
same
Salaries and wages will increase by 4%
The cost of employee benefits will increase, but will
continue to be the same percentage of salaries and
wages
Other controllable costs will increase by
$6,500
Occupancy costs...
Given the information below find net profit/loss in dollars
for the month of June
Guest Hotel...
Given the information below find net profit/loss in dollars
for the month of June
Guest Hotel Inc.
Income Statement
for the period ending June 30, 2019
Sales
Food 193,864
Beverage 87,408
Total Sales -
Cost of Sales
Food 74,381
Beverage 28,467
Total cost of goods sold -
Gross Profit -
Controllable Expenses
Salaries & Wages 112,112
Occupancy 36,875
Office & General 14,642
Utilities 9,170
Transportation 7,472
Kitchen supplies 5,715
Professional fees 5,257
Advertising 8,088
Insurance 10,673
Vehicle 5,724
Total Controllable...
Complete the skeletal profit and loss statement below, using the
following figures:
Gross
sales &nbs
Complete the skeletal profit and loss statement below, using the
following figures:
Gross
sales $234,000
Customer
returns 18,000
Billed cost of
goods 100,000
Inward
freight 2,000
Opening
inventory 90,000
Closing
inventory 80,000
Alterations
charges 500
Cash
discounts 4%
Advertising 6,000
Salaries 55,000
Occupancy
expenses 21,000
Miscellaneous
expenses 2,000
$
%
Net Sales
Cost of Merchandise Sold
Gross Margin
Operating Expenses
Profit/Loss
Please show the work. I know the answers just can't figure out
how to get there. Thank you!
The Statistics Project
assignment has been broken down into multiple parts and you will
complete these...
The Statistics Project
assignment has been broken down into multiple parts and you will
complete these parts throughout the course. This week's assignment
allows you to become familiar with opening data and viewing it in
Microsoft® Excel® and using the Analysis
Toolpak. In research, the individual data points are entered into
databases, but for the purpose of this course, the data is provided
in a spreadsheet for you in the Happiness and Engagement
Dataset.
Imagine you have been asked to...
How do I complete this income statement?
The following information pertains to a Hotel for the...
How do I complete this income statement?
The following information pertains to a Hotel for the year
2016:
Net rooms revenue: $1,050,000
Food and beverage revenue: $650,000
Telephone: revenue: $45,000; cost of sales: $15,000; payroll:
$18,000
F&B Info: Beg. Inv = $75,000; End. Inventory = $55,000;
Purchases =$190,000
There were no employee meals or complimentary meals given.
F&B Payroll: $200,000; F&B Other Expense: $125,000
Maintenance payroll: $75,000; other expense: $90,000
Rooms payroll: $150,000; other rooms expense: $120,000
A&G Payroll: $105,000;...
Based on the trial balance below create an Income Statement:
Dividends Given: $1,607,500
ACCT #
Account...
Based on the trial balance below create an Income Statement:
Dividends Given: $1,607,500
ACCT #
Account Name
Debit
Credit
1000
Cash
$402,575
1030
Treasury Bills
$100,000
1031
Municiple Bonds
$104,425
1032
Investments
$770,500
1210
Accounts Receivable
$30,000
1400
Inventory
$20,000
1500
Furniture and Fixtures
$0
1599
Accumulated Depreciation
$30,000
2000
Accounts Payable
$40,000
3000
Common Stock
$0
3500
Retained Earnings
$65,000
4000
Gross Sales
$3,900,000
4100
Sales Returns
$20,000
5000
Cost of Goods Sold
$1,080,000
6000
Legal and Professional Fees...
A comparative income statement
is given below for McKenzie Sales, Ltd., of Toronto:
McKenzie Sales, Ltd....
A comparative income statement
is given below for McKenzie Sales, Ltd., of Toronto:
McKenzie Sales, Ltd.
Comparative Income Statement
This Year
Last Year
Sales
$
7,370,000
$
5,601,200
Cost of goods
sold
4,620,000
3,515,000
Gross margin
2,750,000
2,086,200
Selling and
administrative expenses:
Selling expenses
1,394,000
1,080,000
Administrative expenses
709,000
613,500
Total expenses
2,103,000
1,693,500
Net operating
income
647,000
392,700
Interest
expense
97,000
92,000
Net income before
taxes
$
550,000
$
300,700
Members of the company’s board of
directors...
A comparative income statement is given below for McKenzie
Sales, Ltd., of Toronto:
McKenzie Sales, Ltd....
A comparative income statement is given below for McKenzie
Sales, Ltd., of Toronto:
McKenzie Sales, Ltd.
Comparative Income Statement
This Year
Last Year
Sales
$
7,320,000
$
5,563,200
Cost of goods sold
4,770,000
3,509,500
Gross margin
2,550,000
2,053,700
Selling and administrative expenses:
Selling expenses
1,395,000
1,081,000
Administrative expenses
709,000
617,500
Total expenses
2,104,000
1,698,500
Net operating income
446,000
355,200
Interest expense
100,000
88,000
Net income before taxes
$
346,000
$
267,200
Members of the company’s board of directors are surprised...
A comparative income statement
is given below for McKenzie Sales, Ltd., of Toronto:
McKenzie Sales, Ltd....
A comparative income statement
is given below for McKenzie Sales, Ltd., of Toronto:
McKenzie Sales, Ltd.
Comparative Income Statement
This Year
Last Year
Sales
$
7,350,000
$
5,586,000
Cost of goods
sold
4,780,000
3,509,500
Gross margin
2,570,000
2,076,500
Selling and
administrative expenses:
Selling expenses
1,394,000
1,076,000
Administrative expenses
706,000
611,500
Total expenses
2,100,000
1,687,500
Net operating
income
470,000
389,000
Interest
expense
100,000
89,000
Net income before
taxes
$
370,000
$
300,000
Members of the company’s board of
directors...