Dixie Showtime Movie Theaters, Inc., owns and operates a chain of cinemas in several markets in the southern U.S. The owners would like to estimate weekly gross revenue as a function of advertising expenditures. Data for a sample of eight markets for a recent week follow.
Market |
Weekly Gross Revenue ($100s) |
Television Advertising ($100s) |
Newspaper Advertising ($100s) |
|
| Mobile | 101.3 | 4.9 | 1.4 | |
| Shreveport | 52.9 | 3.1 | 3.2 | |
| Jackson | 75.8 | 4.2 | 1.5 | |
| Birmingham | 127.2 | 4.5 | 4.3 | |
| Little Rock | 137.8 | 3.6 | 4.0 | |
| Biloxi | 102.4 | 3.5 | 2.3 | |
| New Orleans | 236.8 | 5.0 | 8.4 | |
| Baton Rouge | 220.6 | 6.8 | 5.9 | |
| (a) | Use the data to develop an estimated regression equation with the amount of television advertising as the independent variable. |
| Let x represent the amount of television advertising. | |
| If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) | |
| = + x | |
| Test for a significant relationship between television advertising and weekly gross revenue at the 0.05 level of significance. What is the interpretation of this relationship? | |
| The input in the box below will not be graded, but may be reviewed and considered by your instructor. | |
| (b) | How much of the variation in the sample values of weekly gross revenue does the model in part (a) explain? |
| If required, round your answer to two decimal places. | |
| % | |
| (c) | Use the data to develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables. |
| Let x1 represent the amount of television advertising. | |
| Let x2 represent the amount of newspaper advertising. | |
| If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300) | |
| = + x1 + x2 | |
| Test whether each of the regression parameters β0, β1, and β2 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? | |
| The input in the box below will not be graded, but may be reviewed and considered by your instructor. | |
| (d) | How much of the variation in the sample values of weekly gross revenue does the model in part (c) explain? |
| If required, round your answer to two decimal places. | |
| % | |
| (e) | Given the results in part (a) and part (c), what should your next step be? Explain. |
| The input in the box below will not be graded, but may be reviewed and considered by your instructor. | |
| (f) | What are the managerial implications of these results? |
| The input in the box below will not be graded, but may be reviewed and considered by your instructor. | |
In: Advanced Math
Companies in the U.S. car rental market vary greatly in terms of the size of the fleet, the number of locations, and annual revenue. In 2011, Hertz had 320,000 cars in service and annual revenue of approximately $4.2 billion. The following data show the number of cars in service (1000s) and the annual revenue ($millions) for six smaller car rental companies (Auto Rental News website, August 7, 2012).
|
Company |
Cars (1000s) |
Revenue ($millions) |
|
U-Save Auto Rental System, Inc. |
11.5 |
118 |
|
Payless Car Rental System, Inc. |
10 |
135 |
|
ACE Rent A Car |
9 |
100 |
|
Rent-A-Wreck of America |
5.5 |
37 |
|
Triangle Rent-A-Car |
4.2 |
40 |
|
Affordable/Sensible |
3.3 |
32 |
In: Statistics and Probability
The Smith Engineering Company began operations on December 1, 2017. The unadjusted trial balance of the Smith Engineering Company as of December 31, 2017 is found on the trial balance tab. The following information is required to prepare the necessary adjusting entries for the Smith Engineering Company found in chapter 3.
1) The balance in Prepaid insurance represents a 24-month policy that went into effect on December 1, 2017. Review the unadjusted balance in Prepaid insurance, and prepare the necessary adjusting entry, if any.
2) Based on a physical count, supplies on hand total $3,300. Review the unadjusted balance in Supplies, and prepare the necessary adjusting entry, if any.
3) The equipment is expected to have a 4-year useful life, and be worth about $9,000 at the end of four years. Review the unadjusted balance in Accumulated depreciation, and prepare the necessary adjusting entry, if any.
4) On December 26, the client paid a $3,600 60-day fee in advance, covering December 27 to February 24. Review the unadjusted balance in Unearned Consulting Revenue, and prepare the necessary adjusting entry, if any.
5) Smith Engineering's sole employee earns $80 per day for a five-day workweek beginning on Monday and ending on Friday. The employee was last paid on Friday, December 26. Review the unadjusted balance in Salaries payable, and prepare the necessary adjusting entry, if any.
6) In the second week of December, Smith Engineering agreed to provide 30 days of consulting services to a local fitness club for a fixed fee of $2,940. The terms of the initial agreement call for Smith Engineering to provide services from December 12, 2017, through January 10, 2018, or 30 days of service. The club agrees to pay Smith Engineering $2,940 on January 10, 2018, when the service period is complete. Review the unadjusted balance in Consulting revenue, and prepare the necessary adjusting entry, if any.
Prepare the required adjusting and closing entries for the Smith Engineering Company.
Prepare a general journal, income statement, and balance sheet.
Unadjusted
| ~a(39)~ | ||
| Trial Balance | ||
| December 31, 2017 | ||
| Account Title | Debit | Credit |
|---|---|---|
| Cash | 13,525 | |
| Supplies | 4,400 | |
| Prepaid insurance | 3,000 | |
| Equipment | 25,800 | |
| Accounts payable | 8,200 | |
| Unearned consulting revenue | 3,600 | |
| S. Smith, Capital | 32,000 | |
| S. Smith, Withdrawals | 800 | |
| Consulting revenue | 6,100 | |
| Rental revenue | 350 | |
| Salaries expense | 1,360 | |
| Rent expense | 1,050 | |
| Utilities expense | 315 | |
| Total | 50,250 | 50,250 |
In: Accounting
The board of directors of Metlock Corporation is considering
whether or not it should instruct the accounting department to
shift from a first-in, first-out (FIFO) basis of pricing
inventories to a last-in, first-out (LIFO) basis. The following
information is available.
| Sales | 20,800 | units @ | $55 | |
| Inventory, January 1 | 5,600 | units @ | 22 | |
| Purchases | 6,000 | units @ | 24 | |
| 10,100 | units @ | 28 | ||
| 7,200 | units @ | 33 | ||
| Inventory, December 31 | 8,100 | units @ | ? | |
| Operating expenses | $220,000 |
Prepare a condensed income statement for the year on both bases for
comparative purposes.
|
Metlock Corporation |
||||||||
|
First-in, first-out |
Last-in, first-out |
|||||||
|
Cost of Goods AvailableCost of Goods SoldDividendsExpensesGross ProfitInventory, Jan. 1Inventory, Dec. 31Net Income / (Loss)Operating ExpensesPurchasesSales RevenueTotal Revenues |
$ | $ | ||||||
|
Cost of Goods AvailableCost of Goods SoldDividendsExpensesGross ProfitInventory, Jan. 1Inventory, Dec. 31Net Income / (Loss)Operating ExpensesPurchasesSales RevenueTotal Revenues : |
||||||||
|
Cost of Goods Available Cost of Goods Sold Dividends Expenses Gross Profit Inventory, Jan. 1 Inventory, Dec. 31 Net Income / (Loss) Operating Expenses Purchases Sales Revenue Total Revenues |
$ | $ | ||||||
|
Cost of Goods Available Cost of Goods Sold Dividends Expenses Gross Profit Inventory, Jan. 1 Inventory, Dec. 31 Net Income / (Loss) Operating Expenses Purchases Sales Revenue Total Revenues |
||||||||
|
Cost of Goods Available Cost of Goods Sold Dividends Expenses Gross Profit Inventory, Jan. 1 Inventory, Dec. 31 Net Income / (Loss) Operating Expenses Purchases Sales Revenue Total Revenues |
||||||||
|
Cost of Goods Available Cost of Goods Sold Dividends Expenses Gross Profit Inventory, Jan. 1 Inventory, Dec. 31 Net Income / (Loss) Operating Expenses Purchases Sales Revenue Total Revenues |
||||||||
|
Cost of Goods Available Cost of Goods Sold Dividends Expenses Gross Profit Inventory, Jan. 1 Inventory, Dec. 31 Net Income / (Loss) Operating Expenses Purchases Sales Revenue Total Revenues |
||||||||
|
Cost of Goods AvailableCost of Goods SoldDividendsExpensesGross ProfitInventory, Jan. 1Inventory, Dec. 31Net Income / (Loss)Operating ExpensesPurchasesSales RevenueTotal Revenues |
||||||||
|
Cost of Goods AvailableCost of Goods SoldDividendsExpensesGross ProfitInventory, Jan. 1Inventory, Dec. 31Net Income / (Loss)Operating ExpensesPurchasesSales RevenueTotal Revenues |
||||||||
|
Cost of Goods AvailableCost of Goods SoldDividendsExpensesGross ProfitInventory, Jan. 1Inventory, Dec. 31Net Income / (Loss)Operating ExpensesPurchasesSales RevenueTotal Revenues |
$ | $ | ||||||
In: Accounting
Curtiss Construction Company, Inc., entered into a fixed-price
contract with Axelrod Associates on July 1, 2018, to construct a
four-story office building. At that time, Curtiss estimated that it
would take between two and three years to complete the project. The
total contract price for construction of the building is
$4,540,000. Curtiss concludes that the contract does not qualify
for revenue recognition over time. The building was completed on
December 31, 2020. Estimated percentage of completion, accumulated
contract costs incurred, estimated costs to complete the contract,
and accumulated billings to Axelrod under the contract were as
follows:
At 12-31-2018
At 12-31-2019
At 12-31-2020
Percentage of completion
10
%
60
%
100
%
Costs incurred to date
$
368,000
$
2,898,000
$
4,889,000
Estimated costs to complete
3,312,000
1,932,000
0
Billings to Axelrod, to date
729,000
2,350,000
4,540,000
Required:
1. Compute gross profit or loss to be recognized as a result of
this contract for each of the three years.
2. Assuming Curtiss recognizes revenue over time according to
percentage of completion, compute gross profit or loss to be
recognized in each of the three years.
3. Assuming Curtiss recognizes revenue over time according to
percentage of completion, compute the amount to be shown in the
balance sheet at the end of 2018 and 2019 as either cost in excess
of billings or billings in excess of costs.
1. Compute gross profit or loss to be recognized as a result of this contract for each of the three years. 2. Assuming Curtiss recognizes revenue over time according to percentage of completion, compute gross profit or loss to be recognized in each of the three years. (Leave no cells blank - be certain to enter "0" wherever required. Loss amounts should be indicated with a minus sign.)
Show less
Year
Req 1 Gross Profit (Loss) Recognized ("Upon Completion")
Req 2 Gross Profit (Loss) Recognized ("Over Time")
2018
$0
$86,000
2019
$(290,000)
$(376,000)
2020
$(59,000)
$(86,000)
Total project profit (loss)
$(349,000)
$(376,000)
Req 3
2.Assuming Curtiss recognizes revenue over time according to percentage of completion, compute the amount to be shown in the balance sheet at the end of 2018 and 2019 as either cost in excess of billings or billings in excess of costs.
Balance Sheet (Partial)
2018
2019
Current assets:
Costs less loss in excess of billings
Current liabilities:
Billings in excess of costs and profit
$275,000
Please calculate Costs less loss in excess of billings in 2019.
In: Accounting
308 Chapter 11 CASE STUDYCase stUDYCollege and professional sports are economy boosters for their host cities. The stream of revenue to the local economy generated by excited fans comes from the sale of tickets, hotel room rentals, car rentals, restaurant meals served, gasoline sales, park-ing fees, and vendor sales. The sales become even greater when a team is winning.Cities such as Lincoln, Nebraska; Columbus, Ohio; Tallahassee, Florida; and Baton Rouge, Louisiana count on the revenue generated by sell-out crowds during the college football season. Stadiums that hold from 82,000 to 102,000 fans provide an eco-nomic windfall for the college com-munities where they are located.Some fans of professional sports teams, such as the Chicago Cubs and Green Bay Packers, are loyal no mat-ter how well their team is performing. These faithful fans provide a steady flow of revenue to the sports program and surrounding communities.College World Series Wars?Cities that host major sporting events understand the financial benefits. Omaha, Nebraska, appreciates the millions of dollars poured into the city during the annual College World Series. Zesto’s, a popular fast-food restaurant, has truckloads of food rolling in each day to meet the demands of customers from all over the United States.The event has been voted the Best Annual Local Event and ranks as the third-most important state tourist attraction, according to a survey conducted by Omaha Magazine. The revenue from this two-week event has attracted the attention of other cities, such as Oklahoma City, that would like the opportunity to host the event in the future. Economic experts estimate that the College World Series generates more than $40 million for the Omaha economy. It is no wonder that other cities would like to host thisevent.Omaha tore down Rosenblatt Stadium, the former home of the College World Series, to build the new $131-million TD Ameritrade Park Omaha that has 24,505 seats. Omaha must continue to demonstrate top-notch hospitality so that the College World Series event planners continue to choose Omaha as its host city.Think Critically
1. Why is it important for Omaha to continue hosting the College World Series? Consider both financial and nonfinancial benefits.
2. What are some of the greatest sources of revenue for cities that are home to popular college and professional sports teams?
3. How can hosting a major event like the College World Series help a city develop a national image? Explain your answer.
4. List ten good food items for ven-dors to sell at the College World Series
In: Economics
Chapter 2, #4
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below.
| Account Title | Debits | Credits | ||
| Cash | 32,000 | |||
| Accounts receivable | 40,600 | |||
| Supplies | 1,800 | |||
| Inventory | 60,600 | |||
| Notes receivable | 20,600 | |||
| Interest receivable | 0 | |||
| Prepaid rent | 1,200 | |||
| Prepaid insurance | 6,600 | |||
| Office equipment | 82,400 | |||
| Accumulated depreciation | 30,900 | |||
| Accounts payable | 31,600 | |||
| Salaries payable | 0 | |||
| Notes payable | 50,600 | |||
| Interest payable | 0 | |||
| Deferred sales revenue | 2,300 | |||
| Common stock | 64,200 | |||
| Retained earnings | 30,000 | |||
| Dividends | 4,600 | |||
| Sales revenue | 149,000 | |||
| Interest revenue | 0 | |||
| Cost of goods sold | 73,000 | |||
| Salaries expense | 19,200 | |||
| Rent expense | 11,300 | |||
| Depreciation expense | 0 | |||
| Interest expense | 0 | |||
| Supplies expense | 1,400 | |||
| Insurance expense | 0 | |||
| Advertising expense | 3,300 | |||
| Totals | 358,600 | 358,600 | ||
Information necessary to prepare the year-end adjusting entries appears below.
5. Prepare closing entries. (If no
entry is required for a particular transaction, select "No journal
entry required" in the first account field. Do not round
intermediate calculations. Round your final answers to nearest
whole dollar.)
1. revenue accounts
2. expense accounts
3. dividend accounts
In: Accounting
The Smith Engineering Company began operations on December 1, 2017. The unadjusted trial balance of the Smith Engineering Company as of December 31, 2017 is found on the trial balance tab. The following information is required to prepare the necessary adjusting entries for the Smith Engineering Company found in chapter 3.
1) The balance in Prepaid insurance represents a 24-month policy that went into effect on December 1, 2017. Review the unadjusted balance in Prepaid insurance, and prepare the necessary adjusting entry, if any.
2) Based on a physical count, supplies on hand total $3,300. Review the unadjusted balance in Supplies, and prepare the necessary adjusting entry, if any.
3) The equipment is expected to have a 4-year useful life, and be worth about $9,000 at the end of four years. Review the unadjusted balance in Accumulated depreciation, and prepare the necessary adjusting entry, if any.
4) On December 26, the client paid a $3,600 60-day fee in advance, covering December 27 to February 24. Review the unadjusted balance in Unearned Consulting Revenue, and prepare the necessary adjusting entry, if any.
5) Smith Engineering's sole employee earns $80 per day for a five-day workweek beginning on Monday and ending on Friday. The employee was last paid on Friday, December 26. Review the unadjusted balance in Salaries payable, and prepare the necessary adjusting entry, if any.
6) In the second week of December, Smith Engineering agreed to provide 30 days of consulting services to a local fitness club for a fixed fee of $2,940. The terms of the initial agreement call for Smith Engineering to provide services from December 12, 2017, through January 10, 2018, or 30 days of service. The club agrees to pay Smith Engineering $2,940 on January 10, 2018, when the service period is complete. Review the unadjusted balance in Consulting revenue, and prepare the necessary adjusting entry, if any.
Prepare the required adjusting and closing entries for the Smith Engineering Company.
Prepare a general journal, income statement, and balance sheet.
Unadjusted
| Smith Engineering | ||
| Trial Balance | ||
| December 31, 2017 | ||
| Account Title | Debit | Credit |
|---|---|---|
| Cash | 13,525 | |
| Supplies | 4,400 | |
| Prepaid insurance | 3,000 | |
| Equipment | 25,800 | |
| Accounts payable | 8,200 | |
| Unearned consulting revenue | 3,600 | |
| S. Smith, Capital | 32,000 | |
| S. Smith, Withdrawals | 800 | |
| Consulting revenue | 6,100 | |
| Rental revenue | 350 | |
| Salaries expense | 1,360 | |
| Rent expense | 1,050 | |
| Utilities expense | 315 | |
| Total | 50,250 | 50,250 |
In: Accounting
Variable cost (per pound)
Direct materials $3.75
Direct manufacturing labor 8.00
Variable overhead (manufacturing, marketing, distribution and customer service) 2.05
Total variable cost per bowl $13.80
Fixes costs
Manufacturing $12,000
Marketing, distribution, and customer service 214,800
Total fixed cost $226,800
Selling price $30
Expected sales, 19,500 units $585,000
Income tax rate 40%
S.L. Brook and Company, a manufacturer of quality handmade walnut bowls, has had a steady growth in sales for the past 5 years. However, increased competition has led Mr. Brooks, the president, to believe that an aggressive marketing campaign will be necessary next year to maintain the company's present growth. To prepare for next year's marketing campaign, the company's controller has prepared and presented Mr. Brooks with the following data for the current year, 2017:
Requirement 1. What is the projected net income for 2017?
|
Revenues |
- |
Variable costs |
- |
Fixed costs |
= |
Target net income |
/ |
1 – Tax rate |
Compute the target net income for 2017 using the above formula. The Net Income is: ?
Requirement 2. What is the breakeven point in units for 2017?
Compute how many bowls are needed to break even using this formula (Enter applicable values to the nearest cent, $X.XX.)
|
Fixed costs |
/ |
Contribution margin per bowl |
= |
Bowls needed to break even |
|
$ ? / |
$ ? |
= |
? |
Requirement 3. Mr. Brooks has set the revenue target for 2018 at a level of$ 690,000 (or 23,000 bowls). He believes an additional marketing cost of $19,440 for advertising in 2018, with all other costs remaining constant, will be necessary to attain the revenue target. What is the net income for 2018 if the additional $19,440 is spent and the revenue target is met?
|
The target net income for 2018 is: $ |
? |
Requirement 4. What is the breakeven point in revenues for 2018 if the additional $19,440 is spent for advertising? (Do not round any of your calculations.)
|
The breakeven point in revenues for 2018 is: $ |
? |
Requirement 5. If the additional $19,440 is spent, what are the required 2018 revenues for 2018 net income to equal 20172017 net income?
Using the basic formula determined in requirement 1, compute the required number of units first, then the required revenue. (Do not round any of your calculations.)
|
The required number of units is: |
? |
|
The required revenue is: $ |
? |
Requirement 6. At a sales level of 23,000 units, what maximum amount can be spent on advertising if a 2018 net income of $75,516 is desired? (Do not round any of your calculations.) Use the basic formula determined in requirement 1.
|
The maximum amount that can be spent on advertising is: $ |
? |
In: Accounting
Identifying a Contract
Consider each of the following scenarios:
| a. | A seller orally agrees with one of its best customers to deliver goods in exchange for $10,000. While the seller's practice is to obtain a written sales agreement, the seller delivered these goods to the customer without a written agreement due to the customer's urgent need. |
| b. | A seller agrees to provide accounting services to a customer for the next year in exchange for $40,000. While the two parties are negotiating the terms of the agreement and the specific services to be performed, the seller begins to perform some services as a gesture of good faith. |
| c. | A seller has a written agreement to deliver goods to a customer for $50 per unit. The price will drop to $45 per unit if the customer purchases more than 2,000 units per month. |
| d. | A seller had a written agreement and provided custodial services to a customer for $2,000 per month in a previous year. The contract expired on December 31, 2016. During negotiations for a new contract in January 2017, custodial services were provided at the previous monthly rate and paid for by the buyer. The seller and the customer agree to a new contract on February 1, 2017. The seller is concerned whether a contract existed in January 2017 and whether revenue can be recognized. |
Required:
1. Determine if a contract exists for each of the scenarios.
| a. | , a contract . An oral contract represent an enforceable contract the contract is approved by both parties, each party's rights can be identified, the payment terms can be identified, the contract has commercial substance, and it's probable that the company will collect the consideration to which it is entitled. All of these conditions appear to be in this scenario. |
| b. | , a contract . A company able to identify each party's rights regarding the goods or services to be transferred. Because these rights have established and be identified, a company assess when control has been transferred and, therefore, revenue be recognized. |
| c. | , this represent a contract. The payment terms to be fixed but can vary due to sales incentives such as rebates. |
| d. | , a contract exist in January 2017. While this requires judgment, the fact that the seller performed services and the customer paid for these services implies that enforceable rights and obligations existed in January 2017. , revenue be recognized even though final contract negotiations were not complete. |
2. If it is determined that a contract exists but the seller believes it is probable that it will not collect the expected consideration, how does this affect the seller's ability to recognize revenue?
If it is probable that the seller will not collect the expected consideration in exchange for goods or services that it has promised to transfer to the customer, any amounts that the seller does not expect to collect will the transaction price. This adjusted transaction price will be the starting point to apply the remaining steps of the revenue recognition model.
Check My Work1 more Check My Work uses remaining.
In: Operations Management