FM_Project2
xlsx
keyboard_arrow_up
School
Maasai Mara University *
*We aren’t endorsed by this school
Course
ECO 2103
Subject
Accounting
Date
Nov 24, 2024
Type
xlsx
Pages
9
Uploaded by Ambiro
Using the following information for the Blue Moon hotel:
Rooms
300
ADR
$ 140.00 Occupancy
80%
Revenue
Ratio to sales
Rooms
65.10%
Food
15.90%
Beverage
4.00%
Other food & beverage
8.50%
Other operated department
0.40%
Miscellaneous income
6.10%
Total revenue
100.00%
Departmental expenses
Fixed
Rooms 38.60%
80%
Food & beverage
89.60%
80%
Other department
258.70%
90%
Total department expenses
51.50%
Departmental profits
Rooms
61.40%
Food & beverage
10.40%
Other department -158.70%
Total departmental profit
48.50%
Undistributed operating expenses
Fixed
Administrative & general
7.70%
90%
Information and telecommunication sytems
1.40%
100%
Marketing (excluding franchise)
5.30%
60%
Franchise fees
0.10%
0%
Utility costs
2.10%
90%
Property operation & maintenance 4.30%
90%
Total undistributed operating expenses
20.90%
Gross operating profit
27.60%
Fixed
Base management fees
3.10%
0%
Incentive management fees
1.80%
0%
Income before fixed charges
22.60%
Fixed charges
Fixed
Non-operating income
-
100%
Rent
2.30%
100%
Property taxes
5.50%
100%
Insurance
0.50%
100%
EBITDA
14.20%
Additional information
Depreciation and amortization (year)
$ 500,000 Interest (per year)
$ 200,000 Income taxes
18%
Required:
1. Prepare a profit loss according to the USALI, assuming the hotel operates 365 2. Prepare a profit and loss showing variable costs and fixed costs (you can use a
3. Compute the weighted average CMR for the Blue Moon hotel.
4. Compute the break even point for the Blue Moon hotel. 5. If the B hotel wants to make $1,700,000 of net income, what must its room sa
REQUIREMENT #1
Rooms Revenue $ 12,264,000.00 Food and Beverage Revenue $ 5,350,193.55 Other
$ 75,354.84 Misc. Revenue $ 1,149,161.29 TOTAL REVENUE $ 18,838,709.68 Dept. Expenses
Rooms $ 4,733,904.00 Food & Beverage $ 4,793,773.42 Other Dept.
$ 194,942.97 Variable
Total Dept. Expenses
$ 9,722,620.39 20%
Dept. Profits 20%
Rooms
$ 7,530,096.00 10%
Food & Beverage
$ 556,420.13 Other dept. $ (119,588.13)
Total Dept. Profit
$ 7,966,928.00 Undistributed Operating Exp.
A&G
$ 1,450,580.65 Info & Telecommunications Systems
$ 263,741.94 Marketing (excluding franchise)
$ 998,451.61 Franchise Fees
$ 18,838.71 Utility Costs
$ 395,612.90 Variable
Property Operationg & Maintenance
$ 810,064.52 10%
Total Undist. Operating Expenses
$ 3,937,290.32 0%
Gross Operating Profit
$ 5,178,798.97 40%
Base Mangement Fees
$ 584,000.00 100%
Incentive Mangement Fees
$ 339,096.77 10%
Income Before Fixed Charges
$ 4,255,702.19 10%
Fixed Charges
Non-operating Income
$ - Rent
$ 433,290.32 Variable
Property Taxes
$ 1,036,129.03 100%
Insurance
$ 94,193.55 100%
EBITDA
$ 2,692,089.29 Additional Information
Depreciation & Amortization
$ 500,000
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
Variable
Interest
$ 200,000 0%
income Before Taxes
$ 1,992,089.29 0%
Income Taxes
$ 358,576.07 0%
Net Income
$ 1,633,513.22 0%
$ 1,992,089.29 $ 358,576 days . You have to present three departments: rooms, food and beverage, and other operated dep
a similar presentation than problem 23, p. 391)
ales equal? What is the corresponding occupany rate?
Fixed Costs
Variable Costs
$ 3,787,123.20 $ 946,780.80 $ 3,835,018.74 $ 958,754.68 $ 175,448.67 $ 19,494.30 $ 1,305,522.58 $ 145,058.06 $ 263,741.94 $ - $ 599,070.97 $ 399,380.65 $ - $ 18,838.71 $ 356,051.61 $ 39,561.29 $ 729,058.06 $ 81,006.45 $ - $ 584,000.00 $ - $ 339,096.77 $ 433,290.32 $ - $ 1,036,129.03 $ 94,193.55 Requirement #5
Total Reveenue
$ 19,529,371.35 Rooms Sales
$ 12,713,620.75 248.80
OCC%
82.93%
EBITDA
$ 2,773,170.73 Dep + Amor
$ 500,000.00 Interest $ 200,000.00 Income Before Taxes
$ 2,073,170.73 Net Income $ 1,700,000.00 partment
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
Requirement #2
Revenue
Variable Costs
Rooms
$ 12,264,000.00 $ 946,780.80 Food & Beverage
$ 5,350,193.55 $ 958,754.68 Other
$ 75,354.84 $ 19,494.30 Misc.
$ 1,149,161.29 Total department Profit
Other variable expenses
Other fixed costs
Pretax income
Income Taxes Net Income
Requirement #3
Weighted Average CMR
CMR
Total Revenue
$ 18,838,709.68 Total VC
$ 3,531,971.72 $ 15,306,737.96 CMR
81.25%
$ 3,531,971.72 Requirement #4
Fixed Costs
$ 13,314,648.67 Contribution Margin
81.25%
Breakeven Point
$ 16,386,953.34 Requirement #5
Net Income
$ 1,700,000.00 Get pre tax income + fixed Tax Rate
18% total reve = rooms % by rev
Pretax Income
$ 1,992,089.29 Income Taxes
$ 358,576.07 Tax Rate
0.18
Fixed Costs
$ 13,314,648.67 cmr = (total revenue - total variable costs) / total revenue
Required Sales
$ 18,839,062.11 Room Sales $ 12,264,000.00 Total Sales $ 18,838,709.68 Required Sales for Room Dept.
$ 12,264,229.43 Part 2 of Requirement #5
Tax Rate
82%
Net Income
$ 1,700,000.00
Fixed Costs
Department Income
$ 3,787,123.20 $ 7,530,096.00 $ 3,835,018.74 $ 556,420.13 $ 175,448.67 $ (119,588.13)
$ 1,149,161.29 $ 9,116,089.29 $ 1,606,941.94 $ 5,517,058.06 $ 1,992,089.29 $ 358,576.07 $ 1,633,513.22 costs = total revenue verse egineering
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
Related Documents
Related Questions
The monthly income statement for Jordan Stores is given below:
1st Branch
2nd Branch
Total
Sales
₱ 1,200,000
₱ 800,000
₱ 2,000,000
Less: Variable Expenses
840,000
360,000
1,200,000
Contribution Margin
₱ 0,360,000
₱ 440,000
₱ 0,800,000
Less: Traceable Fixed Expenses
210,000
180,000
390,000
Segment Margin
₱ 0,150,000
₱ 260,000
₱ 0,410,000
Less: Common Fixed Expenses
180,000
120,000
300,000
Profit (Loss)
₱ 0,( 30,000 )
₱ 140,000
₱ 0,110,000
What will be the new company profit (loss) if 1st Branch is eliminated? Show solution
Group of answer choices
₱ ( 040,000
₱ 0( 40,000 )
₱ ( 140,000
₱ ( 250,000 )
arrow_forward
Q6
arrow_forward
The following date relates to Your Company:
Total
Store 1
Store 2
Sales
$2,100,000
$1,300,000
$800,000
VC
$1,065,000
$585,000
$480,000
CM
$1,035,000
$715,000
$320,000
Traceable fixed costs
$497,500
$165,000
$332,500
Segment margin
$537,500
$550,000
($12,500)
Common fixed costs
$370,000
$210,000
$160,000
$167,500
$340,000
($172,500)
NI
Your Company is considering closing Store 2. If Store 2 is closed, 65% of its traceable fixed expenses could be
avoided. Also, the closing of Store 2 would result in a 15% increase in sales in Store 1. Your Company allocates
common fixed expenses on the basis of sales dollars and none of these costs would be saved if a store were shut
down. What is the increase or (decrease) in the net income if Store I is closed?
Enter an increase as a positive number and a decrease wtih a minus sign in front.
arrow_forward
The most recent monthly income statement for Jackson Stores is given below:
Sales
Total
$1,000,000
Variable expenses
Store A
$400,000
580.000 160.000 420.000
Store B
$600,000
Contribution margin
420,000
140.000 180.000
Traceable fixed expenses
300,000
100.000 200.000
Store segment margin
120,000 140.000 (20.000)
Common fixed expenses
Net operating income
50,000 $20,000 30.000
$70,000 $120,000 $150,000)
Due to its poor showing, consideration is being given to closing Store B. Studies show that if
Store B is closed, one-fourth of its traceable fixed expenses will continue unchanged. The studies
also show that closing Store B would result in a 10 percent decrease in sales in Store A. The
company allocates common fixed expenses to the stores on the basis of sales dollars,
Required:
Determine the monthly financial advantage (disadvantage) of closing Store B.
13
arrow_forward
Qw.7.
arrow_forward
Required information
[The following information applies to the questions displayed below]
Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm
has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable
costs. A contribution format segmented income statement for the company's most recent year is given:
Sales
Variable expenses
Contribution margin
Traceable fixed expenses
office segment margin
Common fixed expenses not traceable
to offices
Net operating Income
Total Company
$472,500
236,250
236,250
132,300
103,950
46,150
$ 37,000
Assume that Minneapolis' sales by major market are:
100.00%
50.00%
50.00%
28.00
22.001
14.00%
8.00%
Chicago.
$ 157,500
47,250
110,250
$1,900
$ 28,350
office
100.00%
30.00%
70.00%
52.00
18.00%
Minneapolis
$315,000
199,000
126,000
50,400
$75,600
100.00%
60.00%
40.00%
16.00%
24.00%
arrow_forward
rna.8
arrow_forward
Solve these accounting question
arrow_forward
Ron Company has the following commission schedule:
Commission rate
Sales
2%
Up to $80, 000
Excess of $80,000 to $100,000
More than $100,000
3.5%
4%
Calculate the gross earning.
Employee
Total sales
Gross earning
Lai Xiaodong
%24
146,000
< Prev
6 of 16
Next
..... .....n
.....
arrow_forward
<
Revenues
Cost of goods sold
Gross profit
Gross profit as a percent of sales
Customer 1
$130,000
Customer 2
000 $210,000
(113,400)
$96,600
(81,900)
$48,100
Activity Base
Number of bid requests
Number of shipments
Number of standard items ordered
Number of nonstandard items ordered
Revenues
37%
The administrative records indicated that the activity-base usage quantities for each customer were as follows:
15
25
46%
20
Customer 1 Customer 2 Customer 3
6
40
Customer 3
55
35
$180,000
(90,000)
$90,000
65
50%
60
50
52
85
a. Prepare a customer profitability report dated for the year ended December 31, 20Y8, showing (1) the operating income after customer service activities, (2) the gross
profit as a percent of sales, and (3) the operating income after customer service activities as a percent of sales. Prepare the report with a column for each customer.
Round percentages to the nearest whole percent.
Metroid Electric
Customer Profitability Report
For the Year Ended December 31, 20Y8
Customer 1…
arrow_forward
Roessler Fine Dining has total assets of $310,100 and net fixed assets of $168,500. The average daily operating costs
are $2,980. What is the value of the interval measure?
Multiple Choice
THEY
O
31.47 days
47.52 days
56.22 days
68.05 days
104.62 days
5
Save & Exit Sub
9
arrow_forward
26. Please answer the questions
arrow_forward
Please help me
arrow_forward
Assume a Potbelly's restaurant has the following information available regarding costs at represent- tive
levels of monthly sales:
Monthly sales in units 5,000 8,000 10,000 Cost of food sold.
$10,000 $16,000
$20,000 Wages and fringe benefits.........................4,200 4,320 4,400 Fees paid delivery
help...........................1,100 1,760 2,200 Rent on building.
1,100 1,100 1,100
. 900 900 900 Utilities
Depreciation on equipment...
Supplies (soap, floor wax, etc.)..
1,700 1,700 Total........
.800 920 1,000
...........1,700.
..250 340 400 Administrative costs.....
$20,050 $27,040 $31,700 Required a. Identify each cost as
being variable, fixed, or mixed. b. Use the high-low method to develop a schedule identifying the
amount of each cost that is mixed or variable per unit. Total the amounts under each category
arrow_forward
5. Pong Incorporated's income statement for the most recent month is given below.
Total
Store G
Store H
$150,000
60,000
90,000
60,000
30,000
15,000
$ 15,000
$90,000
Sales.
Variable expenses..
Contribution margin.
Traceable fixed expenses
Segment margin..
Common Fix ed expenses...
Net operating income
$60,000
30,000
30,000
15,000
$15,000
30,000
60,000
45,000
$15,000
...............
If Store G sales increase by $40,000 with no change in fixed costs, the overall company
net operating income should:
A. increase by $8,000
B. increase by $24,000
C. increase by $20,000
D. increase by $4,000
arrow_forward
Work Sample 1: Calculate the profit for this order
Item: 3 chairs
Price (paid by customer)
$2495 per chair
Customer discount = 5%
Our costs
Cost per chair = $1950
Credit card fee = 3% of total customer payment
arrow_forward
The following data relates to Campus Goods Inc:
Amount in $
Revenue 400000
Operating Profit 20%
cost of good sold 55%
Operating Expense ( as % of revenue ) 25%
Required: Based on the above data determine the following:
8A. Cost of Goods Sold in $ is ___________.
250,000
100,000
150,000
220,000
8B. Gross Profit in $ and % is ___________ and ___________ respectively.
250,000 and 20%
180,0000 and 40%
180,000 and 45%
220,000 and 45%
8C. Operating expenses is ___________.
100,000
150,000
200,000
120,000
8D. Operating profit in $ is ___________.
55,000
65,000
80,000
70,000
arrow_forward
Help
arrow_forward
Need help
arrow_forward
k
ces
Bed & Bath, a retailing company, has two departments-Hardware and Linens. The company's most recent monthly contribution format
income statement follows:
Sales
Variable expenses
Contribution margin
Fixed expenses
Net operating income (loss)
Total
$ 4,070,000
1,362,000
2,708,000
2,300,000
$ 408,000
Show All Items
Department
Hardware
$ 3,040,000
952,000
2,088,000
1,410,000
$ 678,000
Required:
What is the financial advantage (disadvantage) of discontinuing the Linens Department?
A study indicates $378,000 of the fixed expenses being charged to Linens are sunk costs or allocated costs that will continue even if
the Linens Department is dropped. In addition, the elimination of the Linens Department will result in a 12% decrease in the sales of the
Hardware Department.
Linens
$ 1,030,000
410,000
620,000
890,000
$ (270,000)
arrow_forward
Calculate gross profit solution general accounting question
arrow_forward
please step by step solution.
arrow_forward
HD marketing channel team estimated Net sales and other expenses and created a profit-and-loss statement. Complete the statement using the following information
(Q4-6).
• Cost of goods sold (50% of net sales)
• Sales salaries : 6 millions
• 8% commission on sales
• advertising and promotion : $10 millions
• 3% of sales for cooperative advertising allowances to retailers
freight and delivery charges (8% of sales)
Managerial salaries and expenses: 3 millions
• Indirect overhead: 2 millions
Profit-and-loss statement
| Net sales
Cost of goods sold
Gross Margin
Marketing Expenses
Sales expenses
Promotion expenses
$238,000,000
$119,000,000
$119,000,000
04
Q5
Freight
General and Administrative
Q6
expenses
Managerial salaries
and expenses
Indirect overhead
$3,000,000
$2,000,000
$5,000,000
$52,780,000
Net Profit before
tax
Q7. What is the total fixed costs?
Q8. What is the total variable costs?
Q9 What is the contribution margin (%) ?
Q10 What is the break-even sales ($)?_
arrow_forward
Give me answer within 30 min plz I will give you upvote immediately its urgent ....
arrow_forward
The most recent monthly income statement for Benner Stores is given below:
Total
Store A
Store B
Sales
$1,000,000
$400,000
$600,000
Variable expenses
580,000
160,000
420,000
Contribution margin
420,000
240,000
180,000
Traceable fixed expenses
300,000
100,000
200,000
Store segment margin
120,000
140,000
(20,000)
Common fixed expenses
50,000
20,000
30,000
Net operating income
$70,000
$120,000
$(50,000)
Due to its poor showing, consideration is being given to closing Store B. Studies show that if Store B is closed, one-half of its traceable fixed expenses will continue unchanged. The studies also show that closing Store B would result in a 20 percent decrease in sales in Store A. The company allocates common fixed expenses to the stores on the basis of sales dollars.
Required:
Determine the monthly financial advantage (disadvantage) of closing Store B. What should…
arrow_forward
Sales 218,000
Gain on sale of equipment $ 6,290
epreciation expense—Office copier $ 530
Office supplies expense 620
Sales discounts 16,700
Insurance expense 1,380
Sales returns and allowances 3,900
TV advertising expense 3,800
Office salaries expense 31,100
Interest revenue 650
Rent expense—Selling space 11,600
Cost of goods sold 91,000
Sales staff wages 23,700
Sales commission expense 13,100
whats the total income profited
arrow_forward
Solve this accounting problem
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- The monthly income statement for Jordan Stores is given below: 1st Branch 2nd Branch Total Sales ₱ 1,200,000 ₱ 800,000 ₱ 2,000,000 Less: Variable Expenses 840,000 360,000 1,200,000 Contribution Margin ₱ 0,360,000 ₱ 440,000 ₱ 0,800,000 Less: Traceable Fixed Expenses 210,000 180,000 390,000 Segment Margin ₱ 0,150,000 ₱ 260,000 ₱ 0,410,000 Less: Common Fixed Expenses 180,000 120,000 300,000 Profit (Loss) ₱ 0,( 30,000 ) ₱ 140,000 ₱ 0,110,000 What will be the new company profit (loss) if 1st Branch is eliminated? Show solution Group of answer choices ₱ ( 040,000 ₱ 0( 40,000 ) ₱ ( 140,000 ₱ ( 250,000 )arrow_forwardQ6arrow_forwardThe following date relates to Your Company: Total Store 1 Store 2 Sales $2,100,000 $1,300,000 $800,000 VC $1,065,000 $585,000 $480,000 CM $1,035,000 $715,000 $320,000 Traceable fixed costs $497,500 $165,000 $332,500 Segment margin $537,500 $550,000 ($12,500) Common fixed costs $370,000 $210,000 $160,000 $167,500 $340,000 ($172,500) NI Your Company is considering closing Store 2. If Store 2 is closed, 65% of its traceable fixed expenses could be avoided. Also, the closing of Store 2 would result in a 15% increase in sales in Store 1. Your Company allocates common fixed expenses on the basis of sales dollars and none of these costs would be saved if a store were shut down. What is the increase or (decrease) in the net income if Store I is closed? Enter an increase as a positive number and a decrease wtih a minus sign in front.arrow_forward
- The most recent monthly income statement for Jackson Stores is given below: Sales Total $1,000,000 Variable expenses Store A $400,000 580.000 160.000 420.000 Store B $600,000 Contribution margin 420,000 140.000 180.000 Traceable fixed expenses 300,000 100.000 200.000 Store segment margin 120,000 140.000 (20.000) Common fixed expenses Net operating income 50,000 $20,000 30.000 $70,000 $120,000 $150,000) Due to its poor showing, consideration is being given to closing Store B. Studies show that if Store B is closed, one-fourth of its traceable fixed expenses will continue unchanged. The studies also show that closing Store B would result in a 10 percent decrease in sales in Store A. The company allocates common fixed expenses to the stores on the basis of sales dollars, Required: Determine the monthly financial advantage (disadvantage) of closing Store B. 13arrow_forwardQw.7.arrow_forwardRequired information [The following information applies to the questions displayed below] Raner, Harris and Chan is a consulting firm that specializes in information systems for medical and dental clinics. The firm has two offices-one in Chicago and one in Minneapolis. The firm classifies the direct costs of consulting jobs as variable costs. A contribution format segmented income statement for the company's most recent year is given: Sales Variable expenses Contribution margin Traceable fixed expenses office segment margin Common fixed expenses not traceable to offices Net operating Income Total Company $472,500 236,250 236,250 132,300 103,950 46,150 $ 37,000 Assume that Minneapolis' sales by major market are: 100.00% 50.00% 50.00% 28.00 22.001 14.00% 8.00% Chicago. $ 157,500 47,250 110,250 $1,900 $ 28,350 office 100.00% 30.00% 70.00% 52.00 18.00% Minneapolis $315,000 199,000 126,000 50,400 $75,600 100.00% 60.00% 40.00% 16.00% 24.00%arrow_forward
- rna.8arrow_forwardSolve these accounting questionarrow_forwardRon Company has the following commission schedule: Commission rate Sales 2% Up to $80, 000 Excess of $80,000 to $100,000 More than $100,000 3.5% 4% Calculate the gross earning. Employee Total sales Gross earning Lai Xiaodong %24 146,000 < Prev 6 of 16 Next ..... .....n .....arrow_forward
- < Revenues Cost of goods sold Gross profit Gross profit as a percent of sales Customer 1 $130,000 Customer 2 000 $210,000 (113,400) $96,600 (81,900) $48,100 Activity Base Number of bid requests Number of shipments Number of standard items ordered Number of nonstandard items ordered Revenues 37% The administrative records indicated that the activity-base usage quantities for each customer were as follows: 15 25 46% 20 Customer 1 Customer 2 Customer 3 6 40 Customer 3 55 35 $180,000 (90,000) $90,000 65 50% 60 50 52 85 a. Prepare a customer profitability report dated for the year ended December 31, 20Y8, showing (1) the operating income after customer service activities, (2) the gross profit as a percent of sales, and (3) the operating income after customer service activities as a percent of sales. Prepare the report with a column for each customer. Round percentages to the nearest whole percent. Metroid Electric Customer Profitability Report For the Year Ended December 31, 20Y8 Customer 1…arrow_forwardRoessler Fine Dining has total assets of $310,100 and net fixed assets of $168,500. The average daily operating costs are $2,980. What is the value of the interval measure? Multiple Choice THEY O 31.47 days 47.52 days 56.22 days 68.05 days 104.62 days 5 Save & Exit Sub 9arrow_forward26. Please answer the questionsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning