At 30 June 2015, the financial statements of McMaster Ltd showed a building with a cost (net of GST) of $312,000 and accumulated depreciation of $158,000. The business uses the straight-line method to depreciate the building. When acquired, the building's useful life was estimated at 30 years and its residual value at $62,000. On 1 January 2016, McMaster Ltd made structural improvements to the building costing $98,000 (net of GST). Although the capacity of the building was unchanged, it is estimated that the improvements will extend the useful life of the building to 40 years, rather than the 30 years originally estimated. No change is expected in the residual value.
In: Accounting
Campbell Glass Company makes stained glass lamps. Each lamp that it sells for $315.10 per lamp requires $16.70 of direct materials and $70.30 of direct labor. Fixed overhead costs are expected to be $190,500 per year. Campbell Glass expects to sell 1,000 lamps during the coming year. Selling and administrative expenses were zero.
Required
Prepare income statements using absorption costing, assuming that Campbell Glass makes 1,000, 1,250, and 1,500 lamps during the year.
Prepare income statements using variable costing, assuming that Campbell Glass makes 1,000, 1,250, and 1,500 lamps during the year.
Prepare income statements using absorption costing, assuming that Campbell Glass makes 1,000, 1,250, and 1,500 lamps during the year. (Do not round intermediate calculations.)
|
Prepare income statements using variable costing, assuming that Campbell Glass makes 1,000, 1,250, and 1,500 lamps during the year. (Do not round intermediate calculations.)
|
In: Accounting
The following information was drawn from the year-end balance sheets of Jordan Trading Company:
Account Title | 2017 | 2016 | ||||
Investment securities | $ | 36,800 | $ | 28,300 | ||
Equipment | 225,000 | 214,500 | ||||
Buildings | 862,000 | 948,500 | ||||
Land | 88,500 | 49,500 | ||||
Additional information regarding transactions occurring during 2017:
Investment securities that had cost $5,130 were sold. The 2017 income statement contained a loss on the sale of investment securities of $610.
Equipment with a cost of $46,000 was purchased.
The income statement showed a gain on the sale of equipment of $5,300. On the date of sale, accumulated depreciation on the equipment sold amounted to $8,800.
A building that had originally cost $168,000 was demolished.
Land that had cost $25,800 was sold for $20,600.
Required
Determine the amount of cash flow for the purchase of investment securities during 2017.
Determine the amount of cash flow from the sale of investment securities during 2017.
Determine the cost of the equipment that was sold during 2017.
Determine the amount of cash flow from the sale of equipment during 2017.
Determine the amount of cash flow for the purchase of buildings during 2017.
Determine the amount of cash flow for the purchase of land during 2017.
Prepare the investing activities section of the 2017 statement of cash flows.
Determine the amount of cash flow for the purchase of investment, sale of investment, cost of the equipment that was sold, sale of equipment, purchase of buildings and purchase of land during 2017.
|
Prepare the investing activities section of the 2017 statement of cash flows. (Cash outflows should be indicated with minus sign.)
|
Options:
In: Accounting
Benson Brands, Inc. Benson, presents its statement of cash flows using the indirect method. The following accounts and corresponding balances were drawn from Benson’s 2017 and 2016 year-end balance sheets:
Account Title | 2017 | 2016 | ||||
Accounts receivable | $ | 20,000 | $ | 30,000 | ||
Merchandise inventory | 56,000 | 49,600 | ||||
Prepaid insurance | 16,500 | 24,700 | ||||
Accounts payable | 26,800 | 18,500 | ||||
Salaries payable | 4,700 | 4,000 | ||||
Unearned service revenue | 1,000 | 2,900 | ||||
The 2017 income statement is shown below:
Income Statement | |||
Sales | $ | 610,000 | |
Cost of goods sold | (380,000 | ) | |
Gross margin | 230,000 | ||
Service revenue | 4,900 | ||
Insurance expense | (39,000 | ) | |
Salaries expense | (157,000 | ) | |
Depreciation expense | (4,100 | ) | |
Operating income | 34,800 | ||
Gain on sale of equipment | 3,600 | ||
Net income | $ | 38,400 | |
Required
Prepare the operating activities section of the statement of cash flows using the direct method.
Prepare the operating activities section of the statement of cash flows using the indirect method.
Prepare the operating activities section of the statement of cash flows using the direct method. (Cash outflows should be indicated with minus sign.)
|
Prepare the operating activities section of the statement of cash flows using the indirect method. (Amounts to be deducted should be indicated with a minus sign.)
|
In: Accounting
As part of an effort to increase cash and reduce the cash cycle, the connections between the AP and AR processes are often scrutinized to see if the company is fully billing what it is entitled to bill … to this end, folks sometimes ask about "unbilled" and how long that "unbilled" has remained in that state … is number for "unbilled" best derived from what has been declared as revenue under 606 but not yet billed or as what has been billed out to vendors if vendors are involved in the performance?
In: Accounting
Bracken, Louden, and Menser, who share profits and losses in a ratio of 5:3:3, respectively are partners in a home decorating business that has not been able to generate the income the partners had hoped for. They have decided to liquidate the business and have sold all assets except for their decorating equipment. All partnership liabilities have been settled and all the partners are personally insolvent. The decorating equipment has a book value of $51,100, and the partners have capital account balances as follows: Bracken, capital $ 35,700 Louden, capital 5,200 Menser, capital 10,200 Required: Determine the amount of cash each partner will receive as a liquidating distribution if the decorating equipment is sold for the amount stated in each of the following independent cases: (Do not round intermediate calculations.)
a. $39,000
|
b. $29,100
|
c. $18,100
|
In: Accounting
Direct Materials Variances
Bellingham Company produces a product that requires 14 standard pounds per unit. The standard price is $8.5 per pound. If 4,200 units required 57,000 pounds, which were purchased at $8.76 per pound, what is the direct materials (a) price variance, (b) quantity variance, and (c) total direct materials cost variance? Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
a. Direct materials price variance | $ | |
b. Direct materials quantity variance | $ | |
c. Total direct materials cost variance | $ |
Direct Labor Variances
Bellingham Company produces a product that requires 7 standard hours per unit at a standard hourly rate of $22.00 per hour. If 2,600 units required 18,600 hours at an hourly rate of $21.56 per hour, what is the direct labor (a) rate variance, (b) time variance, and (c) total direct labor cost variance? Enter a favorable variance as a negative number using a minus sign and an unfavorable variance as a positive number.
a. Direct labor rate variance | $ | |
b. Direct labor time variance | $ | |
c. Total direct labor cost variance | $ |
In: Accounting
Mastery Problem: Budgeting
LearnCo
LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget.
The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2.
You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets.
Sales Budget
The sales budget often uses the prior year’s sales as a starting point, and then sales quantities are revised for various factors such as planned advertising and promotion, projected pricing changes, and expected industry and general economic conditions. LearnCo has completed reviewing its prior year’s sales and has prepared the following sales budget.
After reviewing LearnCo’s sales budget, you note that three numbers have been omitted. The company’s controller has told you that the units sold for the Basic and Deluxe models are expected to be the same. Fill in the missing amounts.
LearnCo Sales Budget For the Year Ending December 31, 20Y2 |
|||
Product |
Unit Sales Volume |
Unit Selling Price |
Total Sales |
Basic Abacus | $6 | $216,000 | |
Deluxe Abacus | 504,000 | ||
Totals | 72,000 | $720,000 |
Production Budget
The production budget should be integrated with the sales budget to ensure that production and sales are kept in balance during the year. The production budget estimates the number of units to be manufactured to meet budgeted sales and desired inventory levels.
You note that LearnCo has omitted six numbers from the following production budget and fill in the missing amounts. You may need to use numbers from the sales budget you prepared.
LearnCo Production Budget For the Year Ending December 31, 20Y2 |
||
Units Basic | Units Deluxe | |
Expected units to be sold (from Sales Budget) | ||
Desired ending inventory, December 31, 20Y2 | 1,000 | 3,000 |
Total units available | ||
Estimated beginning inventory, January 1, 20Y2 | (1,050) | (2,100) |
Total units to be produced |
Direct Materials Purchases Budget
The direct materials purchases budget should be integrated with the production budget to ensure that production is not interrupted during the year.
Before you make any changes to the budget, you review the information on the following Direct Materials Data Table and enter the units to be produced from the Production Budget. After scanning the direct materials purchases budget (which follows the Direct Materials Data Table), you observe that LearnCo has omitted quite a few numbers from the budget. Fill in the missing amounts. You may need to use numbers from the Direct Materials Data Table, or from the sales budget and production budget you prepared. When required, round your answers to the nearest dollar.
Direct Materials Data Table | ||
Wood Pieces | Beads | |
Packages required per unit: | ||
Basic abacus | 1 | 2 |
Deluxe abacus | 2 | 3 |
Cost per package: | ||
Wood pieces | $0.25 | |
Beads | $0.25 | |
Units to be produced (from Production Budget): | ||
Basic abacus | ||
Deluxe abacus |
LearnCo Direct Materials Purchases Budget For the Year Ending December 31, 20Y2 |
|||
Direct Materials | |||
Wood Pieces | Beads | Total | |
Packages required for production: | |||
Basic abacus | |||
Deluxe abacus | |||
Desired inventory, December 31, 20Y2 | 2,200 | 5,000 | |
Total packages available | |||
Estimated inventory, January 1, 20Y2 | (3,500) | (4,500) | |
Total packages to be purchased | |||
Unit price (per package) | × $ | × $ | |
Total direct materials to be purchased | $ | $ | $72,888 |
Direct Labor Cost Budget
Direct labor needs from the direct labor cost budget should be coordinated between the production and personnel departments so that there will be enough labor available for production.
Before you make any changes to the budget, you review the information on the following Direct Labor Data Table and enter the units to be produced from the Production Budget. After scanning the Direct Labor Cost Budget (which follows the Direct Labor Data Table), you observe that LearnCo has omitted quite a few numbers from the budget. Fill in the missing amounts. You may need to use numbers from the Direct Labor Data Table, or from the sales budget, production budget, and direct materials purchase budget you prepared. When required, round your answers to the nearest dollar.
Direct Labor Data Table | ||
Gluing | Assembly | |
Hours required per unit: | ||
Basic abacus | 0.10 | 0.10 |
Deluxe abacus | 0.10 | 0.20 |
Labor hourly rate: | ||
Gluing | $12 | |
Assembly | $17 | |
Units to be produced (from Production Budget): | ||
Basic abacus | ||
Deluxe abacus |
LearnCo Direct Labor Cost Budget For the Year Ending December 31, 20Y2 |
|||
Gluing | Assembly | Total | |
Hours required for production: | |||
Basic abacus | |||
Deluxe abacus | |||
Total | |||
Hourly rate | × $ | × $ | |
Total direct labor cost | $ | $ | $273,995 |
Factory Overhead Cost Budget
The factory overhead cost budget should be integrated with the production budget to ensure that production is not interrupted during the year. This budget may be supported by departmental schedules, which normally separate factory overhead costs into fixed and variable costs so that department managers may monitor and evaluate costs during the year. For simplicity, LearnCo has not separated costs in this manner.
After reviewing the following factory overhead cost budget, you note that LearnCo has completed the budget with the exception of one amount. Fill in the missing amount.
LearnCo Factory Overhead Cost Budget For the Year Ending December 31, 20Y2 |
|
Indirect factory wages | $5,400 |
Power and light | |
Depreciation of plant and equipment | 1,450 |
Total factory overhead cost | $18,100 |
In: Accounting
Hancock Company, a merchandising company, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter |
a. |
As of December 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances: |
Cash |
$ |
13,100 |
||
Accounts receivable |
55,800 |
|||
Inventory |
18,620 |
|||
Buildings and equipment (net) |
135,000 |
|||
Accounts payable |
$ |
47,000 |
||
Common stock |
115,000 |
|||
Retained earnings |
60,520 |
|||
$ |
222,520 |
$ |
222,520 |
|
b. |
Actual and budgeted sales are as follows: |
December(actual) |
$ 93,000 |
January |
$ 133,000 |
February |
$ 194,000 |
March |
$ 102,000 |
April |
$ 100,000 |
c. |
Sales are 40% for cash and 60% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at December 31 are a result of December credit sales. |
d. |
The company's gross margin percentage is 30% of sales. (In other words, cost of goods sold is 70% of sales.) |
e. |
Each month's ending inventory should equal 20% of the following month's budgeted cost of goods sold. |
f. |
One-quarter of a month's inventory purchases is paid for in the month of purchase; the other three- quarters is paid for in the following month. The accounts payable at December 31 are the result of December purchases of inventory. |
g. |
Monthly expenses are as follows: commissions, $27,500; rent, $4,150; other expenses (excluding depreciation), 8% of sales. Assume that these expenses are paid monthly. Depreciation is $4,050 for the quarter and includes depreciation on new assets acquired during the quarter. |
h. |
Equipment will be acquired for cash: $5,330 in January and $9,600 in February. |
i. |
Management would like to maintain a minimum cash balance of $7,000 at the end of each month. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total loan balance of $50,000. The interest rate on these loans is 1% per month, and for simplicity, we will assume that interest is not compounded. The company would, as far as it is able, repay the loan plus accumulated interest at the end of the quarter. |
Required: |
|
Using the data above, complete the following statements and schedules for the second quarter: |
|
1. |
Schedule of expected cash collections: |
2a. |
Merchandise purchases budget. |
2b. |
Schedule of expected cash disbursements for merchandise purchases: |
*Beginning balance of the accounts payable. |
3. |
Schedule of expected cash disbursements for selling and administrative expenses: |
4. |
Cash budget. (Cash deficiency, repayments and interest should be indicated by a minus sign.) |
5. |
Prepare an absorption costing income statement for the quarter ending March 31. (Losses should be indicated by a minus sign.) |
6. |
Prepare a balance sheet as of March 31.(Round your answers to the nearest whole number.) |
In: Accounting
Problem 3-02A a-c, d1-d3 (Video) (Part Level Submission)
The Tamarisk, Inc. opened for business on May 1, 2020. Its trial balance before adjustment on May 31 is as follows.
Tamarisk, Inc. |
||||||
Account Number | Debit | Credit | ||||
101 | Cash | $ 3,500 | ||||
126 | Supplies | 2,150 | ||||
130 | Prepaid Insurance | 2,400 | ||||
140 | Land | 14,000 | ||||
141 | Buildings | 59,000 | ||||
149 | Equipment | 14,800 | ||||
201 | Accounts Payable | $ 11,400 | ||||
208 | Unearned Rent Revenue | 3,200 | ||||
275 | Mortgage Payable | 40,000 | ||||
311 | Common Stock | 35,500 | ||||
429 | Rent Revenue | 10,350 | ||||
610 | Advertising Expense | 550 | ||||
726 | Salaries and Wages Expense | 3,200 | ||||
732 | Utilities Expense | 850 | ||||
$100,450 | $100,450 |
In addition to those accounts listed on the trial balance, the
chart of accounts for Tamarisk, Inc. also contains the following
accounts and account numbers: No. 142 Accumulated
Depreciation—Buildings, No. 150 Accumulated Depreciation—Equipment,
No. 212 Salaries and Wages Payable, No. 230 Interest Payable, No.
619 Depreciation Expense, No. 631 Supplies Expense, No. 718
Interest Expense, and No. 722 Insurance Expense.
Other data:
1. | Prepaid insurance is a 1-year policy starting May 1, 2020. | |
2. | A count of supplies shows $800 of unused supplies on May 31. | |
3. | Annual depreciation is $2,952 on the buildings and $1,476 on equipment. | |
4. | The mortgage interest rate is 12%. (The mortgage was taken out on May 1.) | |
5. | Two-thirds of the unearned rent revenue has been earned. | |
6. | Salaries of $800 are accrued and unpaid at May 31. |
Journalize the adjusting entries on May 31. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. Round answers to 0 decimal places, e.g. 5,275.)
In: Accounting
In: Accounting
**NEED ASSISTANCE WITH REQ 4,5,6
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation:
The Marketing Department has estimated sales as follows for the remainder of the year (in units):
July | 39,000 | October | 29,000 |
August | 88,000 | November | 15,500 |
September | 57,000 | December | 16,000 |
The selling price of the beach umbrellas is $15 per unit.
All sales are on account. Based on past experience, sales are collected in the following pattern:
30% | in the month of sale |
65% | in the month following sale |
5% | uncollectible |
Sales for June totaled $555,000.
The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.
Each beach umbrella requires 4 feet of Gilden, a material that is sometimes hard to acquire. Therefore, the company requires that the ending inventory of Gilden be equal to 50% of the following month’s production needs. The inventory of Gilden on hand at the beginning and end of the quarter will be:
June 30 | 92,700 | feet |
September 30 | ? | feet |
Gilden costs $0.80 per foot. One-half of a month’s purchases of Gilden is paid for in the month of purchase; the remainder is paid for in the following month. The accounts payable on July 1 for purchases of Gilden during June will be $66,920.
Required:
1. Calculate the estimated sales, by month and in total, for the third quarter.
2. Calculate the expected cash collections, by month and in total, for the third quarter.
3. Calculate the estimated quantity of beach umbrellas that need to be produced in July, August, September, and October.
4. Calculate the quantity of Gilden (in feet) that needs to be purchased by month and in total, for the third quarter.
5. Calculate the cost of the raw material (Gilden) purchases by month and in total, for the third quarter.
6. Calculate the expected cash disbursements for raw material (Gilden) purchases, by month and in total, for the third quarter.
In: Accounting
Dean and Brittany are both 32 years old and have a three-year old child, Eddie. They came to your office and asked you to build a financial statement analysis for 2017, based on the information provided.
Based on the above the information (total 5 points):
1) Make a balance sheet for Dean and Brittany (total asset-0.5 pt; total liabilities-0.5 pt; net worth-1 pt), and
2) Report the following financial ratios: (a) Current Ratio (1 pt); (b) Emergency Fund Ratio (1 pt); and (c) Savings Ratio (1 pt).
Please Show your calculations in excel with functions THANK YOU!
In: Accounting
Match these 10 frauds/schemes with the corresponding definitions/scenarios. On the homework assessment, the definitions will have multiple choice options.
Skimming, payroll fraud scheme, lapping, illegal gratuities, investment scam, expense scheme, disbursement fraud, check tampering, asset misappropriation, billing scheme.
In: Accounting
At the beginning of his current tax year David invests $12,000 in original issue U.S. Treasury bonds with a $10,000 face value that mature in exactly 10 years. David receives $700 in interest ($350 every six months) from the Treasury bonds during the current year and the yield to maturity on the bonds is 5 percent.
a. How much interest income will he report this year if he elects to amortize the bond premium?
b. How much interest will he report this year if he does not elect to amortize the bond premium?
In: Accounting