A 335-room hotel property recorded in 2004 a 66.6% occupancy and an ADR of $117.98. What is the property’s franchise fee (1) on a per available room basis and (2) as a percentage of rooms revenue if the agreement required the hotel to pay a reservation fee of $7.65 per available room per month; a royalty fee of 5% of rooms revenue; an advertising fee of 2.3% of rooms revenue; and a frequent traveler program fee of $5.00 per occupied room. The hotel had frequent stay guests totaling 6% of the occupied rooms. The initial fee is a minimum of $45,000 plus $300 per room for each room over 150.
1. Please use the information from Question 1 to calculate the Total franchise fee.
Total franchise fee (round to a whole number) $ ___
2. Please use the information from Question 1 to calculate the Franchise fee on PAR basis.
Franchise fee on PAR basis (round to two decimal places) $___ PAR/yea
3.Please use the information from Question 1 to calculate the Franchise fee as a % of revenue.
Franchise fee as a % of revenue (round to two decimal places) ___%
In: Accounting
The marketing segment sales for Caterpillar, Inc., for a recent year follow:
| Caterpillar, Inc. Machinery and Engines Marketing Segment Sales (in millions) |
||||||||||||||||||||||
| Building Construction Products |
Cat Japan |
Core Components |
Earth moving |
Electric Power |
Excavation |
Large Power Systems |
Logistics |
Marine & Petroleum Power |
Mining |
Turbines |
||||||||||||
| Sales | $2,217 | $1,225 | $1,234 | $5,045 | $2,847 | $4,562 | $2,885 | $659 | $2,132 | $3,975 | $3,321 | |||||||||||
In addition, assume the following information:
| Building Construction Products |
Cat Japan |
Core Components |
Earth moving |
Electric Power |
Excavation |
Large Power Systems |
Logistics |
Marine & Petroleum Power |
Mining |
Turbines |
||||||||||||
| Variable cost of goods sold as a percent of sales | 45% | 55% | 49% | 51% | 54% | 52% | 53% | 50% | 50% | 52% | 48% | |||||||||||
| Dealer commissions as a percent of sales | 9% | 11% | 8% | 8% | 10% | 6% | 5% | 10% | 9% | 7% | 9% | |||||||||||
| Variable promotion expenses (in millions) | 310 | 120 | 150 | 600 | 200 | 600 | 300 | 75 | 270 | 480 | 400 | |||||||||||
a. Use the sales information and the additional assumed information to prepare a contribution margin by segment report. Round answers to two decimal places, except for contribution margin ratio, which should be rounded to one decimal place. Enter all amounts as positive numbers.
| Caterpillar, Inc. | |||||||||||
| Contribution Margin by Segment (assumed) | |||||||||||
| (in millions, except ratio figures) | |||||||||||
| Building Construction Products | Cat Japan | Core Components | Earthmoving | Electric Power | Excavation | Large Power Systems | Logistics | Marine and Petroleum Power | Mining | Turbines | |
| Sales | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Variable cost of goods sold | |||||||||||
| Manufacturing margin | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Dealer commissions | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | |
| Variable promotion expense | |||||||||||
| Variable selling expenses | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Contribution margin | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ |
| Contribution margin ratio | % | % | % | % | % | % | % | % | % | % | % |
Feedback
a. Sales - variable cost of goods sold = manufacturing margin;
Manufacturing margin - variable expenses* = contribution
margin
*Variable expenses = Dealer commissions, variable promotion
expenses, variable selling expenses
To calculate the contribution margin ratio, divide the contribution
margin by sales.
Learning Objective 4.
b. Prepare a table showing the manufacturing margin, dealer commissions, and variable promotion expenses as a percent of sales for each segment. Round percents to one decimal place, if required. Enter all amounts as positive numbers.
| Caterpillar, Inc. | |||||||||||
| Manufacturing Margin by Segment (assumed) | |||||||||||
| (in millions, except ratio figures) | |||||||||||
| Building Construction Products | Cat Japan | Core Components | Earthmoving | Electric Power | Excavation | Large Power Systems | Logistics | Marine and Petroleum | Mining | Turbines | |
| Manufacturing margin | % | % | % | % | % | % | % | % | % | % | % |
| Dealer commissions | % | % | % | % | % | % | % | % | % | % | % |
| Variable promotion expenses | % | % | % | % | % | % | % | % | % | % | % |
| Contribution margin ratio | % | % | % | % | % | % | % | % | % | % | % |
Feedback
b. To calculate relative percentages, divide each item by sales.
Learning Objective 4.
c. All of the following are contributing reasons that Cat Japan is the poorest performing segment except:
The correct answer is:
d
In: Accounting
PART B
Quality Construction Company (QCC) successfully secured the contract to build a new community centre for the City of Burnaby. The total fixed contract price is $25.0 million.
The following schedule indicates (for the three-year period during which construction took place) the costs incurred to date, the estimated costs to complete the community centre complex, and the amount of cash received scheduled to be received from the City of Burnaby. According to normal practice in the industry, the final 10% of the contract price is not paid until a few months after the construction is completed.
|
2019 |
2020 |
2021 |
|
|
Cash payments |
$4,000,000 |
$15,000,000 |
$6,000,000 |
|
Costs incurred to date (cumulative) |
$6,500,000 |
$14,000,000 |
$24,000,000 |
|
Estimated costs to complete at end of applicable year |
$16,000,000 |
$14,000,000 |
$0 |
Required:
Calculate the amount of revenue, costs and any other amounts that QCC should recognize in 2020 and 2021 using the percentage of completion method. Carry calculations of percentage completed to FOUR decimal places.
In: Accounting
Springfield Acting Co. is a professional actor training group that trains stage actors and is headquartered in Los Angeles. The CEO of the company, Milhouse Van Houton, is considering expanding and opening an office in New York City but he just received an interesting business opportunity in the San Francisco area to partner with a movie production company located there. Milhouse knows he can only accept one of these opportunities at the current time. He has already purchased his non-refundable ticket to New York, but his hotel reservation is still cancelable. The cost of each trip is outlined below.
|
Cost of New York trip |
Cost of SanFran trip |
||
|
Airfare |
$525 |
Mileage |
$250 |
|
Meals |
$200 |
Meals |
$300 |
|
Hotel |
$650 |
Hotel |
$500 |
|
Taxis |
$100 |
||
Required:
In: Accounting
It is December 31. Last year, Campbell Construction had sales of $120,000,000, and it forecasts that next year’s sales will be $114,000,000. Its fixed costs have been—and are expected to continue to be—$60,000,000, and its variable cost ratio is 21.00%. Campbell’s capital structure consists of a $15 million bank loan, on which it pays an interest rate of 8%, and 750,000 shares of common equity. The company’s profits are taxed at a marginal rate of 40%. Given this data, complete the following sentences: Note: For these computations, round each EPS to two decimal places.
• The company’s percentage change in EBIT is . -12.26% -13.62% -16.34%
• The percentage change in Campbell’s earnings per share (EPS) is . -11.28% -14.10% -19.74%
• The degree of financial leverage (DFL) at $114,000,000 is . 0.97 1.04 2.82
In: Finance
1. 14 marks Contract price $ 3,140,000 Total estimated construction cost at contract inception $ 2,305,000 2020 2021 2022 Total costs incurred to date $ 691,500 $ 1,540,500 $ 2,350,000 Estimated costs to complete $ 1,613,500 $ 829,500 $ - Customer billings to date $ 625,000 $ 2,175,000 $ 3,140,000 Collections to date $ 600,000 $ 1,790,000 $ 2,899,000 Required: 1. Calculate the gross profit that should be recognized for 2020, 2021, and 2022, using the percentage of completion method. 2. Prepare the journal entries required for the 2021 year assuming that the percentage of completion method is used. 3. Determine the gross profit to be recognized for 2020, 2021, and 2022, using the completed contract method. On February 1, 2020, Kenora Contractors agreed to construct a building. The project was scheduled to be finished in 2022. Information relating to the costs and billings for this contract is as follows:
In: Accounting
On June 15, 2018, Sanderson Construction entered into a long-term construction contract to build a baseball stadium in Washington, D.C., for $410 million. The expected completion date is April 1, 2020, just in time for the 2020 baseball season. Costs incurred and estimated costs to complete at year-end for the life of the contract are as follows ($ in millions):
2018
Costs incurred during the year $ 50
Estimated costs to complete as of December 31 $200
2019 Costs incurred during the year $ 150
Estimated costs to complete as of December 31 $50
2020 Costs incurred during the year $ 45
Estimated costs to complete —
Required:
1. Compute the revenue and gross profit will Sanderson report in its 2018, 2019, and 2020 income statements related to this contract assuming Sanderson recognizes revenue over time according to percentage of completion.
2. Compute the revenue and gross profit will Sanderson report in its 2018, 2019, and 2020 income statements related to this contract assuming this project does not qualify for revenue recognition over time.
3. Suppose the estimated costs to complete at the end of 2019 are $200 million instead of $50 million. Compute the amount of revenue and gross profit or loss to be recognized in 2019 using the percentage of completion method.
| Compute the revenue and gross profit will Sanderson report in its 2018, 2019, and 2020 income statements related to this contract assuming Sanderson recognizes revenue over time according to percentage of completion. (Enter your answers in millions. Loss amounts should be indicated with a minus sign. Use percentages as calculated and rounded in the table below to arrive at your final answer.) |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Compute the revenue and gross profit will Sanderson report in its 2018, 2019, and 2020 income statements related to this contract assuming this project does not qualify for revenue recognition over time. (Enter your answers in millions. Loss amounts should be indicated with a minus sign.)
|
|||||||||||||||||||||
Suppose the estimated costs to complete at the end of 2019 are $200 million instead of $50 million. Compute the amount of revenue and gross profit or loss to be recognized in 2019 using the percentage of completion method. (Enter your answers in millions. Use percentages as calculated and rounded in the table below to arrive at your final answer.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
On June 15, 2018, Sanderson Construction entered into a
long-term construction contract to build a baseball stadium in
Washington, D.C., for $260 million. The expected completion date is
April 1, 2020, just in time for the 2020 baseball season. Costs
incurred and estimated costs to complete at year-end for the life
of the contract are as follows ($ in millions):
| 2018 | 2019 | 2020 | |||||||
| Costs incurred during the year | $ | 60 | $ | 80 | $ | 65 | |||
| Estimated costs to complete as of December 31 | 140 | 60 | — | ||||||
Required:
1. Compute the revenue and gross profit will
Sanderson report in its 2018, 2019, and 2020 income statements
related to this contract assuming Sanderson recognizes revenue over
time according to percentage of completion.
2. Compute the revenue and gross profit will
Sanderson report in its 2018, 2019, and 2020 income statements
related to this contract assuming this project does not qualify for
revenue recognition over time.
3. Suppose the estimated costs to complete at the
end of 2019 are $110 million instead of $60 million. Compute the
amount of revenue and gross profit or loss to be recognized in 2019
using the percentage of completion method.
Required 1
Required 2
Required 3
Compute the revenue and gross profit will Sanderson report in its 2018, 2019, and 2020 income statements related to this contract assuming Sanderson recognizes revenue over time according to percentage of completion. (Enter your answers in millions. Loss amounts should be indicated with a minus sign. Use percentages as calculated and rounded in the table below to arrive at your final answer.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2.
Compute the revenue and gross profit will Sanderson report in its 2018, 2019, and 2020 income statements related to this contract assuming this project does not qualify for revenue recognition over time. (Enter your answers in millions. Loss amounts should be indicated with a minus sign.)
|
|||||||||||||||||||||||
3.
Suppose the estimated costs to complete at the end of 2019 are $110 million instead of $60 million. Compute the amount of revenue and gross profit or loss to be recognized in 2019 using the percentage of completion method. (Enter your answers in millions. Use percentages as calculated and rounded in the table below to arrive at your final answer.)
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
In: Accounting
On February 1, 2018, Arrow Construction Company entered into a
three-year construction contract to build a bridge for a price of
$8,150,000. During 2018, costs of $2,050,000 were incurred with
estimated costs of $4,050,000 yet to be incurred. Billings of
$2,550,000 were sent, and cash collected was $2,300,000.
In 2019, costs incurred were $2,550,000 with remaining costs
estimated to be $3,675,000. 2019 billings were $2,800,000 and
$2,525,000 cash was collected. The project was completed in 2020
after additional costs of $3,850,000 were incurred. The company’s
fiscal year-end is December 31. Arrow recognizes revenue over time
according to percentage of completion.
Required:
1. Compute the amount of revenue and gross profit
or loss to be recognized in 2018, 2019, and 2020 using the
percentage of completion method?
2a. Prepare journal entries for 2018 to record the
transactions described (credit "various accounts" for construction
costs incurred).
2b. Prepare journal entries for 2019 to record the
transactions described (credit "various accounts" for construction
costs incurred).
3a. Prepare a partial balance sheet to show the
presentation of the project as of December 31, 2018.
3b. Prepare a partial balance sheet to show the
presentation of the project as of December 31, 2019.
In: Accounting
On February 1, 2018, Arrow Construction Company entered into a
three-year construction contract to build a bridge for a price of
$8,540,000. During 2018, costs of $2,180,000 were incurred with
estimated costs of $4,180,000 yet to be incurred. Billings of
$2,680,000 were sent, and cash collected was $2,430,000.
In 2019, costs incurred were $2,680,000 with remaining costs
estimated to be $3,870,000. 2019 billings were $2,930,000 and
$2,655,000 cash was collected. The project was completed in 2020
after additional costs of $3,980,000 were incurred. The company’s
fiscal year-end is December 31. Arrow recognizes revenue over time
according to percentage of completion.
Required:
1. Compute the amount of revenue and gross profit
or loss to be recognized in 2018, 2019, and 2020 using the
percentage of completion method?
2a. Prepare journal entries for 2018 to record the
transactions described (credit "various accounts" for construction
costs incurred).
2b. Prepare journal entries for 2019 to record the
transactions described (credit "various accounts" for construction
costs incurred).
3a. Prepare a partial balance sheet to show the
presentation of the project as of December 31, 2018.
3b. Prepare a partial balance sheet to show the
presentation of the project as of December 31, 2019.
In: Accounting