1) Bustillo Company operates sight-seeing buses. Management has identified two cost drivers—the number of buses in operation and the number of passengers served —that it uses in its budgeting and performance reports. Data concerning the company’s cost formulas appear below:
|
Fixed Cost per Month |
Cost per Bus |
Cost per Passenger |
|||||||
|
Vehicle operating costs |
$ |
6,800 |
$ |
476 |
$ |
4.5 |
|||
|
Advertising |
$ |
2,500 |
|||||||
|
Administrative costs |
$ |
5,300 |
$ |
38 |
$ |
1.5 |
|||
|
Insurance |
$ |
3,900 |
|||||||
For example, vehicle operating costs should be $6,800 per month plus $476 per bus plus $4.5 per passenger. The company’s sales revenue should average $31 per passenger. In July, the company operated 54 buses and served a total of 3,300 passengers. How much is the company’s flexible budget operating income for July?
2)
A cash budget for the first three quarters of Brister Incorporated is given below (000 omitted). The company requires a minimum cash balance of at least $5,000 to start each quarter. If necessary, the company will borrow money from its bank to maintain this balance. The company will pay no interest in Quarters 1, 2, and 3. It will repay as much of its borrowings as possible as soon as it has more than $5,000 in cash in a given quarter. Suppose the company starts the first quarter with no bank debt. How much total bank debt does the company expect to have at the end of the third quarter?
|
Cash Budget |
Quarter (000 omitted) |
||
|
1 |
2 |
3 |
|
|
Cash balance, beginning |
$9 |
? |
? |
|
Add collections from customers |
88 |
127 |
88 |
|
Total cash available |
? |
? |
? |
|
Less disbursements: |
|||
|
Purchase of inventory |
55 |
65 |
65 |
|
Selling and administrative expenses |
40 |
45 |
51 |
|
Equipment purchases |
8 |
10 |
11 |
|
Dividends |
2 |
2 |
2 |
|
Total disbursements |
? |
? |
? |
|
Excess (deficiency) of cash available over disbursements |
? |
? |
? |
|
Financing: |
|||
|
Borrowings |
? |
? |
? |
|
Repayments |
? |
? |
? |
|
Total financing |
? |
? |
? |
|
Cash balance, ending |
? |
? |
? |
In: Accounting
Analyzing Unearned Revenue Disclosures
The following disclosures (excerpted) are from the September 2,
2018, annual report of Costco Wholesale Corporation.
The Company generally recognizes sales, net of returns, at the time the member takes possession of merchandise or receives services. When the Company collects payments from members prior to the transfer of ownership of merchandise or the performance of services, the amounts received are generally recorded as deferred sales, included in other current liabilities in the consolidated balance sheets, until the sale or service is completed. The Company reserves for estimated sales returns based on historical trends in merchandise returns and reduces sales and merchandise costs accordingly. The Company accounts for membership fee revenue, net of refunds, on a deferred basis, ratably over the one-year membership.
The Company’s Executive members qualify for a 2% reward on qualified purchases (up to a maximum reward of approximately $1,000 per year), which can be redeemed only at Costco warehouses. The Company accounts for this reward as a reduction in sales. The sales reduction and corresponding liability (classified as accrued member rewards in the consolidated balance sheets) are computed after giving effect to the estimated impact of non-redemptions, based on historical data. The net reduction in sales was $1,394, $1,281, and $1,172 in 2018, 2017, and 2016, respectively.
| Revenue ($ millions) |
Sept. 2, 2018 | Sept. 3, 2017 | Aug. 28, 2016 |
|---|---|---|---|
| Net Sales | $138,434 | $126,172 | $116,073 |
| Membership fees | 3,142 | 2,853 | 2,646 |
| Total revenue | $141,576 | $129,025 | $118,719 |
| Current Liabilities ($ millions) | Sept. 2, 2018 | Sept. 3, 2017 |
|---|---|---|
| Accounts payable | $11,237 | $9,608 |
| Accrued salaries and benefits | 2,994 | 2,703 |
| Accrued member rewards | 1,057 | 961 |
| Deferred membership fees | 1,624 | 1,498 |
| Other current liabilities | 3,014 | 2,725 |
| Total current liabilities | $19,926 | $17,495 |
(a) Which of the following statements best explains in layman terms
how Costco accounts for the cash received for its membership
fees?
Because Costco does not know how many of its members will continue to the end of the year, cash received from members is recorded as a liability and recognized as revenue only at year-end.
When it receives cash, the company records it as a current liability. Then, it recognizes revenue evenly over the year.
The company records revenue when the cash is received.
Because Costco has a refund policy, the company records revenue when the cash is received, less an allowance for expected membership terminations.
(b) Use the balance sheet information on Costco's Deferred
Membership Fees liability account and its income statement revenues
related to Membership Fees earned during fiscal 2018 to compute the
cash that Costco received during fiscal 2018 for membership
fees.
Total cash received (in $ millions) = $Answer
(c) Use the financial statement effects template to show the effect
of the cash Costco received during fiscal 2018 for membership fees
and the recognition of membership fees revenue for fiscal 2018.
Use negative signs with answers, when appropriate.
|
Balance Sheet |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Transaction ($ millions) |
Cash Asset | + | Noncash Assets | = | Liabilities | + | Contributed Capital | + | Earned Capital | |
| Receive cash in advance for membership fees | Answer | Answer | Answer | Answer | Answer | |||||
| Recognized membership fees earned | Answer | Answer | Answer | Answer | Answer | |||||
|
Income Statement |
||||
|---|---|---|---|---|
| Revenue | - | Expenses | = | Net Income |
| Answer | Answer | Answer | ||
| Answer | Answer | Answer | ||
(e) Complete the following sentences:
Costco recorded sales of at least $_____ from the Company’s
Executive members, during fiscal 2018.
In: Accounting
Using the random digit assignment from part a), and starting at line 106 simulate a class of 20 students.
|
Student |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
|
Random digit |
||||||||||||||||||||
|
Pass or fail |
b) Which students was the first in the list to fail the exam?
c) What percentage of these 20 students passed on their first try?
In: Statistics and Probability
Use the following information to complete the subtotals for current assets, long-term investments, property plant and equipment, other assets, current liabilities and long-term liabilities.
The following represents a December 31, 2016, post-closing trial balance for Excell Company.
|
Account Title |
Debits |
Credits |
CA |
LTI |
PPE |
OA |
CL |
LTL |
|
Cash |
$ 83,000 |
|||||||
|
Accounts Receivable (net of Allowance) |
$280,000 |
|||||||
|
Prepaid Expenses |
$ 32,000 |
|||||||
|
Investments |
$ 65,000 |
|||||||
|
Land |
$175,000 |
|||||||
|
Buildings (net) |
$160,000 |
|||||||
|
Equipment (net) |
$145,000 |
|||||||
|
Accounts payable |
$ 73,000 |
|||||||
|
Accrued expenses payable |
$ 45,000 |
|||||||
|
Unearned Revenue |
$150,000 |
|||||||
|
Notes payable |
$300,000 |
|||||||
|
Common Stock |
$200,000 |
|||||||
|
Retained Earnings |
$172,000 |
Additional Information:
The cash account includes $22,000 set aside in a legally restricted fund to pay bonds payable that mature in 2024 and $15,000 cash surrender value of a life insurance policy on the company's CEO.
2. The accounts receivable balance consists of the following:
a. Amounts owed by customers
with debit
balances
$ 217,100
b. Allowance for uncollectible
accounts - trade
customers
(9,400)
d. Non-trade note receivable
due in three equal payments on
June 25 over the next 3
years
64,500
e. Interest receivable on note
due in nine
months
7,800
Total
$ 280,000
3. The prepaid expenses include $18,000 that will be consumed during 2017 and $14,000 that will be consumed during 2018.
4. The investments account is classified as Available for Sale Securities and includes an investment of $25,000 in bonds that mature July 1, 2017. Of the remaining investments balance, management intends to hold for at least the next three years. All investments in the portfolio have already been marked-to-market and are reported at Fair Value.
5. The land account includes land which cost $75,000 that the company purchased for speculative purposes and is currently held for sale. The remaining $100,000 is the cost of land on which the company's office building resides. The equipment account includes idle machinery with a book value of $45,000.
6. The unearned revenue represents customer prepayments for magazine subscriptions. Subscriptions are for five years and will be earned evenly over each of the years beginning January 1, 2017.
7. The notes payable account consists of the following:
a $50,000 note due in six months
a $100,000 bond due in eight year
a $150,000 note due in six annual installments of $25,000 each,
with the next installment due Nov. 1, 2017.
*Interest on all notes has been properly accrued and is included in
accrued expenses.
In: Accounting
Based on the following case study answer two of the questions
a. Dell is a pioneer in stimulating exchanges with customers through social media. With reference to Dell, discuss the differences between e-marketing and traditional marketing activities.
b. As more companies are moving towards green businesses, should Dell adopt a similar strategy to market its products? Justify your answer
Dell Direct and Not-So-Direct Case Study:
When Michael Dell started his Texas-based computer business in
1984, he chose a distribution strategy that was radically different
from that of other computer marketers. Instead of selling through
wholesalers and retailers, the company dealt directly with
customers. This kept costs low and allowed Dell to cater to
customers' needs by building each computer to order. Using a direct
channel also minimized inventory costs and reduced the risk that
parts and products would become obsolete even before customers
placed their orders, a constant concern in high-tech
industries.
By 1997, Dell's website alone was responsible for $1 million a day in sales. Relying on the strength of its online sales, catalogs, and phone orders, Dell expanded beyond the United States and added new products for four target markets: consumers, large corporations, small businesses, and government agencies. Meanwhile, Apple, Hewlett-Packard, and other competitors were reaching out to many of the same segments with a combination of direct and indirect channels. Apple Stores, for example, proved to be major customer magnets and gave a significant boost to sales of Macintosh computers and other Apple electronics. Hewlett-Packard forged strong ties with value-added resellers (VARs), intermediaries that assemble systems of computers, servers, and other products customized to meet the special needs of business buyers.
Although Dell tested retail distribution on a number of
occasions, it never let the experiments go on too long. In the
1990s, it tried selling PCs through a few big U.S. retail chains,
but soon discontinued the arrangement because the profit margins
weren't as healthy as in the direct channel. Later, it opened a
series of branded retail kiosks in major U.S. markets to display
its products and answer customers' questions. Unlike stores,
however, the kiosks didn't actually sell any-thing: Customers could
only place orders for future delivery. Dell ultimately closed the
kiosks down. By 2007, with competitors coming on strong, Dell was
ready to rethink its worldwide channel strategy. As convenient as
online shopping was for many U.S. computer buyers, it was much less
popular in many other countries. To gain market share domestically
and internationally, Dell would have to follow consumers into
stores, malls, and downtown shopping districts. The company began
selling a few models through Walmart's U.S. stores, Carphone
Warehouse's U.K. stores,. Bic Camera's Japanese stores, and Gome's
Chinese stores. In addition, it opened Dell stores in Moscow,
Budapest, and other world capitals.
By 2010, sales through retailers had gained enough momentum that
Dell sought out other retail deals. In another channel change, it
began selling through VAR partners that serve small- and
medium-sized businesses and lined up wholesalers to distribute its
products in Europe, Latin America, and elsewhere. When Dell
introduced a new line of smart-phones, it needed a new channel
arrangement to reach buyers. Therefore, it arranged for cell phone
carriers such as AT&T to sell the new models to their
customers.
As successful as Dell has been in revamping its indirect channels, selling directly to customers remains a top priority. Dell invites orders around the clock through Web pages tailored to the needs of each 'target market. It also maintains an online outlet store to sell 4 discontinued and refurbished products. It mails millions of catalogs and direct-mail pieces every year. And its sales force calls on government officials and big businesses that buy in volume. Dell's website notes, with pride, that the 10 largest U.S. corporations and five largest U.S. commercial banks "run on Dell."
Moreover, the company is a pioneer in stimulating exchanges with
customers through social media. Dell has 139,000 fans on Facebook,
for example, and regularly posts offers that drive customers to its
various websites. It's become a pioneer in selling directly to
customers via the micro blog site Twitter. In less than three
years, it generated $6.5 million in revenue from sales transactions
that originated on Twitter. That may be a tiny sliver of Dell's $53
billion in annual revenue, but it demonstrates the company's
flexibility in adapting to shifts in customer behavior and
environmental forces, such as technological advances. With market
share and profit-margin challenges still facing the company, and
global demand just picking up steam after a long, difficult
recession, watch for Dell to make more channel adjustments in the
coming years.
In: Operations Management
Oriole Company’s balance sheet at December 31, 2021, is presented below.
|
Oriole Company |
|||||||
|---|---|---|---|---|---|---|---|
|
Cash |
$13,680 |
Accounts payable |
$8,900 | ||||
|
Accounts receivable |
21,100 |
Common stock |
21,800 | ||||
|
Allowance for doubtful accounts |
(740) |
Retained earnings |
13,330 | ||||
|
Inventory |
9,990 | ||||||
| $44,030 | $44,030 | ||||||
During January 2022, the following transactions occurred. Oriole
uses the perpetual inventory method.
| Jan. 1 | Oriole accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $4,800 account. | |
| 3 | Oriole wrote off as uncollectible the accounts of Walter Corporation ($500) and Drake Company ($300). | |
| 8 | Oriole purchased $18,800 of inventory on account. | |
| 11 | Oriole sold for $25,700 on account inventory that cost $16,020. | |
| 15 | Oriole sold inventory that cost $730 to Jack Rice for $1,100. Rice charged this amount on his Visa First Bank card. The service fee charged Oriole by First Bank is 3%. | |
| 17 | Oriole collected $24,400 from customers on account. | |
| 21 | Oriole paid $17,100 on accounts payable. | |
| 24 | Oriole received payment in full ($300) from Drake Company on the account written off on January 3. | |
| 27 | Oriole purchased advertising supplies for $1,540 cash. | |
| 31 | Oriole paid other operating expenses, $2,910. |
Adjustment data:
| 1. | Interest is recorded for the month on the note from January 1. | |
| 2. | Bad debts are expected to be 6% of the January 31, 2022, accounts receivable. | |
| 3. | A count of advertising supplies on January 31, 2022, reveals that $510 remains unused. | |
| 4. | The income tax rate is 30%. (Hint: Prepare the income statement up to Income before taxes and multiply by 30% to compute the amount; round to whole dollars.) |
Prepare journal entries for the transactions listed above and adjusting entries. (Include entries for cost of goods sold using the perpetual inventory system.)
Prepare an adjusted trial balance at January 31, 2022
Prepare an income statement for the month ending January 31, 2022.
Prepare a retained earnings statement for the month ending January 31, 2022.
Prepare a classified balance sheet as of January 31, 2022
In: Accounting
Sheridan Company’s balance sheet at December 31, 2021, is
presented below.
|
Sheridan Company |
|||||||
|---|---|---|---|---|---|---|---|
|
Cash |
$13,500 |
Accounts payable |
$8,300 | ||||
|
Accounts receivable |
20,600 |
Common stock |
21,900 | ||||
|
Allowance for doubtful accounts |
(860) |
Retained earnings |
12,710 | ||||
|
Inventory |
9,670 | ||||||
| $42,910 | $42,910 | ||||||
During January 2022, the following transactions occurred. Sheridan
uses the perpetual inventory method.
| Jan. 1 | Sheridan accepted a 4-month, 8% note from Betheny Company in payment of Betheny’s $3,600 account. | |
| 3 | Sheridan wrote off as uncollectible the accounts of Walter Corporation ($400) and Drake Company ($200). | |
| 8 | Sheridan purchased $18,870 of inventory on account. | |
| 11 | Sheridan sold for $24,200 on account inventory that cost $15,790. | |
| 15 | Sheridan sold inventory that cost $760 to Jack Rice for $1,000. Rice charged this amount on his Visa First Bank card. The service fee charged Sheridan by First Bank is 3%. | |
| 17 | Sheridan collected $20,900 from customers on account. | |
| 21 | Sheridan paid $15,300 on accounts payable. | |
| 24 | Sheridan received payment in full ($200) from Drake Company on the account written off on January 3. | |
| 27 | Sheridan purchased advertising supplies for $1,290 cash. | |
| 31 | Sheridan paid other operating expenses, $2,940. |
Adjustment data:
| 1. | Interest is recorded for the month on the note from January 1. | |
| 2. | Bad debts are expected to be 6% of the January 31, 2022, accounts receivable. | |
| 3. | A count of advertising supplies on January 31, 2022, reveals that $610 remains unused. | |
| 4. | The income tax rate is 30%. (Hint: Prepare the income statement up to Income before taxes and multiply by 30% to compute the amount; round to whole dollars.) |
(You may want to set up T-accounts to determine ending
balances.)
Prepare journal entries for the transactions listed above and adjusting entries. (Include entries for cost of goods sold using the perpetual inventory system.) AND Prepare an adjusted trial balance at January 31, 2022. AND Prepare an income statement for the month ending January 31, 2022.
In: Accounting
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is traded at $5.60. The put option's delta is -0.65 and the call option's delta is 0.7.
A) On October 3rd, XOM stock price changed to $71.15 on Oct 3rd, what will be the values of the put and call options?
B) Consider a portfolio composed of:
1,005 XOM stocks
20 Dec XOM Call options
37 Dec XOM Put options
What is the portfolio position delta?
C) Using the portfolio position delta, calculate the portfolio value before AND after the stock price change.
In: Finance
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is traded at $5.60. The put option's delta is -0.65 and the call option's delta is 0.7.
A) On October 3rd, XOM stock price changed to $71.15 on Oct 3rd, what will be the values of the put and call options?
B) Consider a portfolio composed of:
1,005 XOM stocks
20 Dec XOM Call options
37 Dec XOM Put options
What is the portfolio position delta?
C) Using the portfolio position delta, calculate the portfolio value before AND after the stock price change.
In: Finance
On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is traded at $5.60. The put option's delta is -0.65 and the call option's delta is 0.7.
A) On October 3rd, XOM stock price changed to $71.15 on Oct 3rd, what will be the values of the put and call options?
B) Consider a portfolio composed of:
1,005 XOM stocks
20 Dec XOM Call options
37 Dec XOM Put options
What is the portfolio position delta?
C) Using the portfolio position delta, calculate the portfolio value before AND after the stock price change.
In: Finance