a large hotel chain, has been using activity-based costing to determine the cost of a night's stay at their hotels.
One of the activities, "Inspection," occurs after a customer has checked out of a hotel room.
Fitzgerald
inspects every
10th
room and has been using "number of rooms inspected" as the cost driver for inspection costs. A significant component of inspection costs is the cost of the supplies used in each inspection.
Dawn
McAdams,
the chief inspector, is wondering whether inspection labor-hours might be a better cost driver for inspection costs.
Dawn
gathers information for weekly inspection costs, rooms inspected, and inspection labor-hours as follows:
|
Week |
Rooms Inspected |
Inspection Labor-Hours |
Inspection Costs |
|---|---|---|---|
|
Week 1 |
260 |
85 |
$1,800 |
|
Week 2 |
328 |
129 |
2,560 |
|
Week 3 |
341 |
101 |
2,310 |
|
Week 4 |
437 |
142 |
2,850 |
|
Week 5 |
200 |
67 |
1,460 |
|
Week 6 |
245 |
80 |
1,750 |
|
Week 7 |
258 |
127 |
1,780 |
|
Week 8 |
331 |
146 |
2,260 |
Dawn
runs regressions on each of the possible cost drivers and estimates these cost functions:
Inspection
Costs=$246.60
+
($6.17
x Number of rooms inspected)
Inspection
Costs=$787.71
+
($11.94
x Inspection labor-hours)
|
1. |
Explain why rooms inspected and inspection labor-hours are plausible cost drivers of inspection costs. |
|
2. |
Plot the data and regression line for rooms inspected and inspection costs. Plot the data and regression line for inspection labor-hours and inspection costs. Which cost driver of inspection costs would you choose? Explain. |
|
3. |
Dawn expects inspectors to inspect306 rooms and work for124 hours next week. Using the cost driver you chose in requirement 2, what amount of inspection costs shouldDawn budget? Explain any implications ofDawn choosing the cost driver you did not choose in requirement 2 to budget inspection costs. |
In: Accounting
Keller Construction is considering two new investments. Project
E calls for the purchase of earthmoving equipment. Project H
represents an investment in a hydraulic lift. Keller wishes to use
a net present value profile in comparing the projects. The
investment and cash flow patterns are as follows: Use Appendix B
for an approximate answer but calculate your final answer using the
formula and financial calculator methods.
| Project E | Project H | |||||||
| ($37,000 Investment) | ($35,000 Investment) | |||||||
| Year | Cash Flow | Year | Cash Flow | |||||
| 1 | $ | 9,000 | 1 | $ | 17,000 | |||
| 2 | 12,000 | 2 | 18,000 | |||||
| 3 | 18,000 | 3 | 17,000 | |||||
| 4 | 20,000 | |||||||
a. Determine the net present value of the projects
based on a zero percent discount rate.
Project E - ____________________
Project H - _____________________
b. Determine the net present value of the projects
based on a discount rate of 9 percent. (Do not round
intermediate calculations and round your answers to 2 decimal
places.)
Project E - ____________________
Project H - _____________________
c. If the projects are not mutually exclusive,
which project(s) would you accept if the discount rate is 9
percent?
| Project E | |
| Project H | |
| Both H and E |
In: Accounting
During the first month of its current fiscal year, Green Co. incurred repair costs of $24,000 on a machine that had 4 years of remaining depreciable life. The repair cost was inappropriately capitalized. Green Co. reported operating income of $164,000 for the current year.
a. Assuming that Green Co. took a full year's straight-line depreciation expense in the current year, calculate the operating income that should have been reported for the current year.
b. Assume that Green Co.'s total assets at the end of the prior year and at the end of the current year were $932,000 and $1,012,000, respectively. Calculate ROI (based on operating income) for the current year using the originally reported data and then using corrected data. (Round your answers to 1 decimal place.)
c. Indicate the effect on ROI of subsequent years if the error is not corrected.
| ROI will be too low. | |
| ROI will be too high. | |
| ROI will remains the same. |
In: Accounting
Wolsey Industries Inc. expects to maintain the same inventories at the end of 2016 as at the beginning of the year. The total of all production costs for the year is therefore assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs for their departments during the year. A summary report of these estimates is as follows:
|
1 |
Estimated Fixed Cost |
Estimated Variable Cost (per unit sold) |
|
|
2 |
Production costs: |
||
|
3 |
Direct materials |
— |
$58.00 |
|
4 |
Direct labor |
— |
38.00 |
|
5 |
Factory overhead |
$194,000.00 |
20.00 |
|
6 |
Selling expenses: |
||
|
7 |
Sales salaries and commissions |
102,000.00 |
8.00 |
|
8 |
Advertising |
42,000.00 |
— |
|
9 |
Travel |
8,000.00 |
— |
|
10 |
Miscellaneous selling expense |
7,800.00 |
1.00 |
|
11 |
Administrative expenses: |
||
|
12 |
Office and officers’ salaries |
135,200.00 |
— |
|
13 |
Supplies |
10,000.00 |
2.00 |
|
14 |
Miscellaneous administrative expense |
14,600.00 |
1.00 |
|
15 |
Total |
$513,600.00 |
$128.00 |
It is expected that 21,400 units will be sold at a price of $160 a unit. Maximum sales within the relevant range are 26,000 units.
| Required: | |
| A. | Prepare an estimated income statement for 2016. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries. |
| B. | What is the expected contribution margin ratio? |
| C. | Determine the break-even sales in units and dollars. Round your answers to the nearest whole number. |
| D. | Construct a cost-volume-profit chart on your own paper. What is the break-even sales? |
| E. | What is the expected margin of safety in dollars and as a percentage of sales? Round your answers to the nearest whole number. |
| F. | Determine the operating leverage. Round to one decimal place. |
Income Statement
A. Prepare an estimated income statement for 2016. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.
|
Wolsey Industries Inc. |
|
Estimated Income Statement |
|
For the Year Ended December 31, 2016 |
|
1 |
||||
|
2 |
||||
|
3 |
||||
|
4 |
||||
|
5 |
||||
|
6 |
||||
|
7 |
||||
|
8 |
||||
|
9 |
Selling expenses: |
|||
|
10 |
||||
|
11 |
||||
|
12 |
||||
|
13 |
||||
|
14 |
||||
|
15 |
Administrative expenses: |
|||
|
16 |
||||
|
17 |
||||
|
18 |
||||
|
19 |
||||
|
20 |
Total expenses |
|||
|
21 |
Additional Questions
B. What is the expected contribution margin ratio?
C. Determine the break-even sales in units and dollars. Start by using the contribution margin ratio (part B.) and then round your answers to the nearest whole number.
| Units | units |
| Dollars | $ |
D. Construct a cost-volume-profit chart on your own paper. What is the break-even sales?
$
Final Questions
E. What is the expected margin of safety in dollars and as a percentage of sales? If applicable, use amounts previously computed and then round your answers to the nearest whole number.
| Dollars | $ |
| Percentage |
F. Determine the operating leverage. Round to one decimal place.
| Labels and Amount Descriptions | |
| Advertising | |
| Contribution margin | |
| Cost of goods sold | |
| Direct labor | |
| Direct materials | |
| Expenses | |
| Factory overhead | |
| Gross profit | |
| Income from operations | |
| Manufacturing margin | |
| Miscellaneous administrative expense | |
| Miscellaneous selling expense | |
| Office and officers’ salaries | |
| Sales | |
| Sales salaries and commissions | |
| Supplies | |
| Total administrative expenses | |
| Total expenses | |
| Total selling expenses | |
| Travel | |
| Variable cost of goods sold |
In: Accounting
18.(Determination of property tax rate)The City of Weston is preparing its budget for calendar year 2009. After estimating revenues from all other sources, the City calculates that it must raise $7,000,000 from property taxes. You are given the following information regarding the tax rate:
| Property taxes to be collected | $ 7,000,000 |
| Allowance for uncollectible property taxes = | 1% of the levy |
| Total assessed value of property at beginning of 2009 | $ 65,000,000 |
| Expected reduction in assessed value from appeals | $ 200,000 |
| Assessed value of City property, not subject to tax | $ 1,400,000 |
| Adjustments to assessed values for senior citizen exemptions | $ 1,000,000 |
a. Compute the gross amount of property taxes required to be levied.
b. Compute the tax rate per $100 of net assessed valuation.
c. Determine the amount of property tax that a home owner whose property is assessed at $35,000 will have to pay.
In: Accounting
In: Accounting
Why is it critical to reconcile the bank statement on a timely basis each month?
In: Accounting
Corp. had 468,000 shares of common stock outstanding. During 2021, it had the following transactions that affected the Common Stock account.
|
On January 1, 2021, Coronado Corp. had 468,000 shares of common stock outstanding. During 2021, it had the following transactions that affected the Common Stock account.
Determine the weighted-average number of shares outstanding as of December 31, 2021.
Assume that Coronado Corp. earned net income of $3,288,000 during 2021. In addition, it had 105,000 shares of 9%, $100 par nonconvertible, noncumulative preferred stock outstanding for the entire year. Because of liquidity considerations, however, the company did not declare and pay a preferred dividend in 2021. Compute earnings per share for 2021, using the weighted-average number of shares determined in part (a). (Round answer to 2 decimal places, e.g. $2.55.)
Assume the same facts as in part (b), except that the preferred stock was cumulative. Compute earnings per share for 2021. (Round answer to 2 decimal places, e.g. $2.55.)
Assume the same facts as in part (b), except that net income included a loss from discontinued operations of $411,000 (net of tax). Compute earnings per share for 2021. |
||||||||||||||||||||||||||
In: Accounting
Natalie has prepared the balance sheet and income statement of Cookie & Coffee Creations Inc. and would like you to prepare the cash flow statement. The comparative balance sheet of Cookie & Coffee Creations Inc. at October 31, 2020 for the years 2020 and 2019 and the income statement for the year ended October 31, 2020, are presented below.
Additional information:
1. Equipment (cost $4,500 and book value $3,000) was disposed of at the beginning of the year for $500 cash and replaced with new equipment purchased for $4,000 cash.
2. Additional equipment was bought for $14,000 on November 1, 2019. A $12,000 note payable was signed. The terms provide for equal semi-annual installment payments of $2,000 on May 1 and November 1 of each year, plus interest of 5% on the outstanding principal balance.
3. Other equipment was bought for $13,000 cash.
4. Dividends were declared on the preferred and common stock on October 15, 2020, to be paid on November 15, 2018.
5. Accounts payable relate only to merchandise creditors.
6. Prepaid expenses relate only to other operating expenses.
Instructions:
(a) Prepare a statement of cash flows for Cookie & Coffee Creations Inc. for the year ended October 31, 2020, using the indirect method.
*(b) Prepare a statement of cash flows for Cookie & Coffee Creations Inc. for the year ended October 31, 2020, using the direct method.
COOKIE & COFFEE CREATIONS INC.
Balance Sheet
October 31,
|
Assets |
2020 |
2019 |
|
Cash |
$ 22,324 |
$5,550 |
|
Accounts receivable |
3,250 |
2,710 |
|
Inventory |
7,897 |
7,450 |
|
Prepaid expenses |
5,800 |
6,050 |
|
Equipment |
102,000 |
75,500 |
|
Accumulated depreciation— |
||
|
equipment |
(25,200) |
(9,100) |
|
Total assets |
$116,071 |
$88,160 |
COOKIE & COFFEE CREATIONS INC.
Balance Sheet
October 31,
|
Liabilities and Stockholders’ Equity |
2020 |
2019 |
|
|
Accounts payable |
$ 1,150 |
$ 2,450 |
|
|
Income taxes payable |
9,251 |
7,200 |
|
|
Dividends payable |
27,000 |
27,000 |
|
|
Salaries and wages payable |
7,250 |
1,280 |
|
|
Interest payable |
188 |
0 |
|
|
Note payable |
10,000 |
0 |
|
|
Preferred stock, no par, $6 cumulative, |
|||
|
3,000 and 2,800 shares issued, |
|||
|
respectively |
15,000 |
14,000 |
|
|
Common stock, $1 par—25,180 shares |
|||
|
issued and outstanding |
25,180 |
25,180 |
|
|
Additional paid-in capital—treasury stock |
250 |
250 |
|
|
Retained earnings |
20,802 |
10,800 |
|
|
Total liabilities and stockholders’ equity |
$116,071 |
$88,160 |
COOKIE & COFFEE CREATIONS INC.
Income Statement
Year Ended October 31, 2020
|
Sales |
$485,625 |
|
|
Cost of goods sold |
222,694 |
|
|
Gross profit |
262,931 |
|
|
Operating expenses |
||
|
Salaries and wages expense |
$147,979 |
|
|
Depreciation expense |
17,600 |
|
|
Other operating expenses |
48,186 |
213,765 |
|
Income from operations |
49,166 |
|
|
Other expenses |
||
|
Interest expense |
$ 413 |
|
|
Loss on disposal of plant |
||
|
assets |
2,500 |
2,913 |
|
Income before income tax |
46,253 |
|
|
Income tax expense |
9,251 |
|
|
Net income |
$ 37,002 |
In: Accounting
What does liquidity mean for accounting purposes?
In what order should assets be listed on the balance sheet?
Can an account that is not listed in the chart of accounts be used to prepare journal entries? Why or why not?
What does posting to the general ledger mean?
What is the purpose of the trial balance?
In: Accounting
IceCap Hotels operates a series of northern European hotels and reports under IFRS. On June 30, 2016, IceCap purchased land for €3,000,000. IceCap reports land values on the balance sheet under Property, plant, and equipment. The appraisal value for the land (which you can assume is the same as the recoverable amount) was reported as:
| Appraisal Date | Land Value | ||
| 12/31/2016 | € | 3,150,000 | |
| 12/31/2017 | € | 2,750,000 | |
| 12/31/2018 | € | 2,850,000 | |
Required:
In: Accounting
Branif Leasing leases mechanical equipment to industrial consumers under sales-type leases that earn Branif a 10% rate of return for providing long-term financing. A lease agreement with Branson Construction specified 20 annual payments beginning December 31, 2018, the beginning of the lease. The estimated useful life of the leased equipment is 20 years with no residual value. Its cost to Branif was $936,492. The lease qualifies as a finance lease to Branson. Maintenance of the equipment was contracted for through a 20-year service agreement with Midway Service Company requiring 20 annual payments of $3,000 beginning December 31, 2018. Progressive Insurance Company charges Branif $3,000 annually for hazard insurance coverage on the equipment. Both companies use straightline depreciation or amortization. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)
Required:
Prepare the appropriate entries for both the lessee and lessor to record the second lease payment and depreciation on December 31, 2019, under each of three independent assumptions:
1. The lessee pays maintenance costs as
incurred. The lessor pays insurance premiums as incurred. The lease
agreement requires annual payments of $100,000.
2. The contract specifies that the lessor pays
maintenance costs as incurred. The lessee’s lease payments were
increased to $103,000 to include an amount sufficient to reimburse
these costs.
3. The lessee’s lease payments of $103,000
included $3,000 for hazard insurance on the equipment rather than
maintenance.
In: Accounting
Write a paragraph explaining the income statement and the balance sheet, write how the company is doing, and anything to note or watch for. Note any differences from the previous quarter's balance sheet.
|
Supplies Company |
|||||
|
Budgeted Income Statement |
|||||
|
For the Quarter Ended September 30th |
|||||
|
Sales |
1,985,000 |
||||
|
Cost of Goods Sold |
(893,250) |
||||
|
Gross Margin |
1,091,750 |
||||
|
Selling and Administrative Expenses |
|||||
|
Shipping |
99,250 |
||||
|
Other |
158,800 |
||||
|
Salaries and Wages |
255,000 |
||||
|
Advertising |
150,000 |
||||
|
Prepaid Insurance |
9,000 |
||||
|
Depreciation |
75,000 |
||||
|
Net Operating Incomes |
747,050 |
||||
|
Less Interest Expense |
344,700 |
||||
|
Net Income |
(4,270) |
||||
|
340,430 |
|||||
|
Supply Company |
|||||
|
Balance Sheet |
|||||
|
September 30th |
|||||
|
Assets |
|||||
|
Current Assets: |
|||||
|
Cash |
$120,105 |
||||
|
Accounts receivable |
332,500 |
||||
|
Inventory |
34,650 |
||||
|
Prepaid Insurance |
9,000 |
||||
|
Total Current Assets |
496,255 |
||||
|
Buildings and Equipment (Net) |
1,075,000 |
||||
|
Total Assets |
$1,571,255 |
||||
|
Liabilities and Equity |
|||||
|
Accounts Payable |
102,825 |
||||
|
Notes Payable |
102,825 |
||||
|
Stockholder's Equity |
|||||
|
Capital Stock |
420,000 |
||||
|
Retained Earnings |
1,048,430 |
||||
|
Total Liability and Equity |
1,571,255 |
||||
|
Supply Company |
||
|
Balance Sheet |
||
|
Previous Year End |
||
|
Assets |
||
|
Current assets: |
||
|
Cash |
$ 40,000 |
|
|
Accounts receivable |
$ 340,000 |
|
|
Inventory |
$ 50,000 |
|
|
Prepaid insurance |
$ 18,000 |
|
|
Total current assets |
$ 448,000 |
|
|
Buildings and equipment (net) |
$ 860,000 |
|
|
TOTAL ASSETS |
$ 1,308,000 |
|
|
Liabilities and Equity |
||
|
Liabilites |
||
|
Accounts payable |
$ 130,000 |
|
|
Notes payable |
$ - |
|
|
Total liabilities |
$ 130,000 |
|
|
Stockholder's equity |
||
|
Capital stock |
$ 420,000 |
|
|
Retained earnings |
$ 758,000 |
|
|
Total equity |
$ 1,178,000 |
|
|
TOTAL LIABILITIES AND EQUITY |
$ 1,308,000 |
|
In: Accounting
PLEASE POST EXCEL SPREADSHEET
|
MICROSOFT CORPORATION Income Statements For the years ended June 30, |
||
|
(in millions) |
2016 |
2015 |
|
Revenue |
||
|
Product |
$61,502 |
$75,956 |
|
Service |
23,818 |
17,624 |
|
Total revenue |
85,320 |
93,580 |
|
Cost of revenue |
||
|
Product |
17,880 |
21,410 |
|
Service and other |
14,900 |
11,628 |
|
Total cost of revenue |
32,780 |
33,038 |
|
Gross margin |
52,540 |
60,542 |
|
Research and development |
11,988 |
12,046 |
|
Sales and marketing |
14,697 |
15,713 |
|
General and administrative |
4,563 |
4,611 |
|
Impairment, integration, and restructuring |
1,110 |
10,011 |
|
Operating income |
20,182 |
18,161 |
|
Other income (expense), net |
(431) |
346 |
|
Income before taxes |
19,751 |
18,507 |
|
Provision for income taxes |
2,953 |
6,314 |
|
Net income |
$16,798 |
$ 12,193 |
|
MICROSOFT CORPORATION Balance Sheet As of June 30, |
||
|
(in millions) |
2016 |
2015 |
|
Current assets: |
||
|
Cash and cash equivalents |
$ 6,510 |
$ 5,595 |
|
Short-term investments |
106,730 |
90,931 |
|
Accounts receivable, net |
18,277 |
17,908 |
|
Inventories |
2,251 |
2,902 |
|
Other current assets |
5,892 |
5,461 |
|
Total current assets |
139,660 |
122,797 |
|
Property and equipment, net |
18,356 |
14,731 |
|
Equity and other investments |
10,431 |
12,053 |
|
Goodwill |
17,872 |
16,939 |
|
Intangible assets, net |
3,733 |
4,835 |
|
Other long-term assets |
3,642 |
3,117 |
|
Total assets |
$193,694 |
$174,472 |
|
Current liabilities: |
||
|
Accounts payable |
$ 6,898 |
$ 6,591 |
|
Short-term debt |
12,904 |
4,985 |
|
Current portion of long-term debt |
0 |
2,499 |
|
Accrued compensation |
5,264 |
5,096 |
|
Income taxes |
580 |
606 |
|
Short-term unearned revenue |
27,468 |
23,223 |
|
Other current liabilities |
6,243 |
6,647 |
|
Total current liabilities |
59,357 |
49,647 |
|
Long-term debt |
40,783 |
27,808 |
|
Long-term unearned revenue |
6,441 |
2,095 |
|
Deferred income taxes |
1,476 |
1,295 |
|
Other long-term liabilities |
13,640 |
13,544 |
|
Total liabilities |
121,697 |
94,389 |
|
Stockholders' equity: |
||
|
Common stock and paid-in capital |
68,178 |
68,465 |
|
Retained earnings |
2,282 |
9,096 |
|
Accumulated other comprehensive income |
1,537 |
2,522 |
|
Total stockholders' equity |
71,997 |
80,083 |
|
Total liabilities and stockholders' equity |
$193,694 |
$ 174,472 |
Required:
PLEASE POST EXCEL SPREADSHEET
In: Accounting
The
Gold Plus
Company manufactures windows. Its manufacturing plant has the capacity to produce
6,000
windows each month. Current production and sales are
5,000
windows per month. The company normally charges
$200
per window.
|
Variable costs that vary with number of units produced |
|
|
Direct materials |
$150,000 |
|---|---|
|
Direct manufacturing labor |
75,000 |
|
Variable costs (for setups, materials handling, quality control, and so on) that vary with number of batches, 200 batches × $1,000 per batch |
200,000 |
|
Fixed manufacturing costs |
200,000 |
|
Fixed marketing costs |
25,000 |
|
Total costs |
$650,000 |
Gold Plus
has just received a special one-time-only order for
1,000
windows at
$175
per window. Accepting the special order would not affect the company's regular business or its fixed costs.
Gold Plus
makes windows for its existing customers in batch sizes of
25
windows
(200
batches ×
25
windows per batch =
5,000
windows). The special order requires
Gold Plus
to make the windows in
10
batches of
100
windows.
|
1. |
Should
Gold Plus accept this special order? Show your calculations. |
|
2. |
Suppose plant capacity were only
5,500 windows instead of6,000 windows each month. The special order must either be taken in full or be rejected completely. ShouldGold Plus accept the special order? Show your calculations. |
|
3. |
As in requirement 1, assume that monthly capacity is
6,000 windows.Gold Plus is concerned that if it accepts the special order, its existing customers will immediately demand a price discount of$5 in the month in which the special order is being filled. They would argue thatGold Plus's capacity costs are now being spread over more units and that existing customers should get the benefit of these lower costs. ShouldGold Plus accept the special order under these conditions? Show your calculations. |
In: Accounting