You have just been hired by FAB Corporation, the manufacturer of a revolutionary new garage door opening device. The president has asked that you review the company’s costing system and “do what you can to help us get better control of our manufacturing overhead costs.” You find that the company has never used a flexible budget, and you suggest that preparing such a budget would be an excellent first step in overhead planning and control.
After much effort and analysis, you determined the following cost formulas and gathered the following actual cost data for March:
Cost Formula | Actual Cost in March | ||
Utilities | $16,300 plus $0.13 per machine-hour | $ | 20,960 |
Maintenance | $38,100 plus $1.60 per machine-hour | $ | 67,100 |
Supplies | $0.50 per machine-hour | $ | 10,800 |
Indirect labor | $94,600 plus $1.70 per machine-hour | $ | 132,900 |
Depreciation | $68,300 | $ | 70,000 |
During March, the company worked 20,000 machine-hours and produced 14,000 units. The company had originally planned to work 22,000 machine-hours during March.
Required:
1. Calculate the activity variances for March.
2. Calculate the spending variances for March.
Milano Pizza is a small neighborhood pizzeria that has a small area for in-store dining as well as offering take-out and free home delivery services. The pizzeria’s owner has determined that the shop has two major cost drivers—the number of pizzas sold and the number of deliveries made.
The pizzeria’s cost formulas appear below:
Fixed Cost per Month |
Cost per Pizza |
Cost per Delivery |
||||||||
Pizza ingredients | $ | 4.40 | ||||||||
Kitchen staff | $ | 5,910 | ||||||||
Utilities | $ | 610 | $ | 0.30 | ||||||
Delivery person | $ | 3.10 | ||||||||
Delivery vehicle | $ | 630 | $ | 1.50 | ||||||
Equipment depreciation | $ | 400 | ||||||||
Rent | $ | 1,870 | ||||||||
Miscellaneous | $ | 730 | $ | 0.15 | ||||||
In November, the pizzeria budgeted for 1,560 pizzas at an average selling price of $15 per pizza and for 220 deliveries.
Data concerning the pizzeria’s actual results in November appear below:
Actual Results | |||
Pizzas | 1,660 | ||
Deliveries | 200 | ||
Revenue | $ | 25,450 | |
Pizza ingredients | $ | 7,210 | |
Kitchen staff | $ | 5,850 | |
Utilities | $ | 885 | |
Delivery person | $ | 620 | |
Delivery vehicle | $ | 986 | |
Equipment depreciation | $ | 400 | |
Rent | $ | 1,870 | |
Miscellaneous | $ | 790 | |
Required:
1. Complete the flexible budget performance report that shows both revenue and spending variances and activity variances for the pizzeria for November. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Average Rate of Return Method, Net Present Value Method, and Analysis
The capital investment committee of Ellis Transport and Storage Inc. is considering two investment projects. The estimated income from operations and net cash flows from each investment are as follows:
Warehouse | Tracking Technology | |||||||||
Year | Income from Operations |
Net Cash Flow |
Income from Operations |
Net Cash Flow |
||||||
1 | $44,100 | $145,000 | $93,000 | $232,000 | ||||||
2 | 44,100 | 145,000 | 71,000 | 196,000 | ||||||
3 | 44,100 | 145,000 | 35,000 | 138,000 | ||||||
4 | 44,100 | 145,000 | 15,000 | 94,000 | ||||||
5 | 44,100 | 145,000 | 6,500 | 65,000 | ||||||
Total | $220,500 | $725,000 | $220,500 | $725,000 |
Each project requires an investment of $420,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 10% for purposes of the net present value analysis.
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1a. Compute the average rate of return for each investment. If required, round your answer to one decimal place.
Average Rate of Return | |
Warehouse | % |
Tracking Technology | % |
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value.
Warehouse | Tracking Technology | |
Present value of net cash flow total | $ | $ |
Less amount to be invested | $ | $ |
Net present value | $ | $ |
2. The warehouse has a smaller net present value as tracking technology cash flows occur earlier in time. Thus, if only one of the two projects can be accepted, the tracking technology would be the more attractive.
In: Accounting
Sassafras Yacht Corporation began operations on December 1, 2017. The company uses normal
costing as part of a job-order cost system. During December, the company purchased $75,000 of
direct material, and then used $60,000 of these direct materials to start Job 450. The company
charged total conversion costs of $80,000 (direct labor and overhead) to Job 450 during December.
As of the end of December Job 450 was not complete. There was no underapplied or overapplied
overhead for December.
The company charges overhead to jobs using direct labor HOURS (careful!). The estimated direct
labor hours for 2018 are 25,000 hours and the estimated overhead cost for 2018 is $600,000. During
2018, the following transactions occurred.
1.
There were 5 jobs that had work completed on them in 2018. Some of the data for these jobs
are shown below:
Job 450
Job 500
Job 550
Job 600
Job 650
Direct Material Cost
$8,000
$60,000
$80,000
$20,000
$12,000
Direct Labor
Hours
5,000 hrs.
6,000 hrs.
10,000 hrs. 2,000 hrs.
3,000 hrs.
2.
The Direct Labor Rate for 2018 is $40 per hour.
3.
The company purchased $200,000 of direct materials.
4.
At the end of 2018, the jobs that were not finished were Jobs 600 and 650. Job 450 consisted
of 5,000 units of which 4,200 sold in 2018 at a selling price of $200 each. Job 550 consisted of
15,000 units of which 10,000 sold in 2018 at a selling price of $100 each. Job 500 consisted of
10,000 units, none of which sold at the end of 2018.
5.
Other costs incurred during 2018 include the following:
Advertising Expense
$125,000
Indirect Labor
$275,000
Maintenance- Factory
$ 75,000
Factory Insurance
$ 45,000
Administrative Expense
$450,000
Corporate General Expenses
$150,000
Depreciation- Factory
$60,000
F.G. Warehouse Depreciation
$ 40,000
Utilities- Factory
$110,000
Miscellaneous Overhead
$ 60,000
Selling Expense
$200,000
Indirect Materials
$ 75,000
Your Task:
A.
Prepare, in good form, a Schedule of Cost of Goods Manufactured for 2018.
B.
Add up the total costs of Jobs A, B and C. Does this total equal your Cost of Goods
Manufactured from Part A? Should it?
C.
Compute the underapplied or overapplied overhead for 2018. Is it under or overapplied?
D.
Assume that any underapplied or overapplied overhead is closed totally to Cost of Goods Sold
at the end of 2018. Prepare, in good form, an Income Statement for 2018.
In: Accounting
Ecola Company uses a job order costing system. Manufacturing overhead is applied on the basis of direct labor cost. Total manufacturing overhead was estimated to be $142,560 for the year; direct labor was estimated to total $162,000.
(1/1) | (12/31) | |||||
Raw Materials Inventory | $ | 13,800 | $ | 10,800 | ||
Work in Process Inventory | $ | 29,800 | $ | 22,800 | ||
Finished Goods Inventory | $ | 41,800 | $ | 32,800 | ||
The following transactions have occurred during the year.
Raw materials purchases | $ | 138,000 |
Direct materials used | $ | 75,600 |
Direct labor | $ | 143,000 |
Indirect materials used | $ | 16,800 |
Indirect labor | $ | 19,800 |
Factory equipment depreciation | $ | 28,800 |
Factory rent | $ | 15,800 |
Factory utilities | $ | 12,300 |
Other factory costs | $ | 9,300 |
(a) Calculate the predetermined overhead rate.
(b) Calculate cost of goods manufactured.
(c) Calculate the over- or underapplied overhead.
(Input the amount as positive value.)
(d) Calculate adjusted cost of goods
sold.
In: Accounting
Pierce & Company provides the following information concerning
the work in process at its plant:
• Beginning inventory was partially complete
(materials are 100 percent complete; conversion costs are 59
percent complete).
• Started this month, 60,700 units.
• Transferred out, 49,300 units.
• Ending inventory, 21,700 units (materials are 100
percent complete; conversion costs are 14 percent
complete).
Required:
a. Compute the equivalent units for
materials using FIFO.
b. Compute the equivalent units for
conversion costs using FIFO.
In: Accounting
Argentina Partners is concerned about the possible effects of inflation on its operations. Presently, the company sells 79,000 units for $30 per unit. The variable production costs are $15, and fixed costs amount to $890,000. Production engineers have advised management that they expect unit labor costs to rise by 20 percent and unit materials costs to rise by 15 percent in the coming year. Of the $15 variable costs, 40 percent are from labor and 20 percent are from materials. Variable overhead costs are expected to increase by 25 percent. Sales prices cannot increase more than 10 percent. It is also expected that fixed costs will rise by 7 percent as a result of increased taxes and other miscellaneous fixed charges. The company wishes to maintain the same level of profit in real dollar terms. It is expected that to accomplish this objective, profits must increase by 8 percent during the year. Required: a. Compute the volume in units and the dollar sales level necessary to maintain the present profit level, assuming that the maximum price increase is implemented. (Do not round intermediate calculations. Round up your answer for "Volume in units" to the nearest whole number and round your answer for "Sales" to the nearest whole dollar amount.)
Volume Unit | |
Sales |
b. Compute the volume of sales and the dollar sales level necessary to provide the 8 percent increase in profits, assuming that the maximum price increase is implemented. (Do not round intermediate calculations. Round up your answer for "Volume in units" to the nearest whole number and round your answer for "Sales" to the nearest whole dollar amount.)
Volume Unit | |
Sales |
c. If the volume of sales were to remain at 79,000 units, what price increase would be required to attain the 8 percent increase in profits? Calculate the new price. (Round your answer to 2 decimal places.)
New Price |
In: Accounting
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month:
Cost Formulas | |
Direct labor | $16.60q |
Indirect labor | $4,200 + $1.50q |
Utilities | $5,200 + $0.80q |
Supplies | $1,700 + $0.40q |
Equipment depreciation | $18,200 + $3.00q |
Factory rent | $8,600 |
Property taxes | $2,500 |
Factory administration | $13,300 + $0.80q |
The Production Department planned to work 4,500 labor-hours in March; however, it actually worked 4,300 labor-hours during the month. Its actual costs incurred in March are listed below:
Actual Cost Incurred in March | |||
Direct labor | $ | 73,020 | |
Indirect labor | $ | 10,130 | |
Utilities | $ | 9,190 | |
Supplies | $ | 3,710 | |
Equipment depreciation | $ | 31,100 | |
Factory rent | $ | 9,000 | |
Property taxes | $ | 2,500 | |
Factory administration | $ | 16,130 | |
Required:
1. Prepare the Production Department’s planning budget for the month.
2. Prepare the Production Department’s flexible budget for the month.
3. Prepare the Production Department’s flexible budget performance report for March, including both the spending and activity variances.
In: Accounting
Northwood Company manufactures basketballs. The company has a ball that sells for $36. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $21.60 per ball, of which 60% is direct labor cost. |
Last year, the company sold 59,000 of these balls, with the following results: |
Sales (59,000 balls) | $ | 2,124,000 |
Variable expenses | 1,274,400 | |
Contribution margin | 849,600 | |
Fixed expenses | 705,600 | |
Net operating income | $ | 144,000 |
Required: |
1-a. |
Compute last year's CM ratio and the break-even point in balls. (Do not round intermediate calculations. Round up your final break even answers to the nearest whole number.) |
1-b. |
Compute the the degree of operating leverage at last year’s sales level. (Round your answer to 2 decimal places.) |
2. |
Due to an increase in labor rates, the company estimates that next year's variable expenses will increase by $2.88 per ball. If this change takes place and the selling price per ball remains constant at $36.00, what will be next year's CM ratio and the break-even point in balls? (Do not round intermediate calculations. Round up your final break even answers to the nearest whole number.) |
3. |
Refer to the data in (2) above. If the expected change in variable expenses takes place, how many balls will have to be sold next year to earn the same net operating income, $144,000, as last year? (Do not round intermediate calculations. Round your answer to the nearest whole unit.) |
4. |
Refer again to the data in (2) above. The president feels that the company must raise the selling price of its basketballs. If Northwood Company wants to maintain the same CM ratio as last year (as computed in requirement 1a), what selling price per ball must it charge next year to cover the increased labor costs? (Do not round intermediate calculations. Round your answer to 2 decimal places.) |
5. |
Refer to the original data. The company is discussing the construction of a new, automated manufacturing plant. The new plant would slash variable expenses per ball by 40%, but it would cause fixed expenses per year to increase by 80%. If the new plant is built, what would be the company’s new CM ratio and new break-even point in balls? (Do not round intermediate calculations. Round up your final break even answers to the nearest whole number.) |
6. |
Refer to the data in (5) above. |
a. |
If the new plant is built, how many balls will have to be sold next year to earn the same net operating income, $144,000, as last year? (Do not round intermediate calculations. Round up your final answer to the nearest whole number.) |
b-1. |
Assume the new plant is built and that next year the company manufactures and sells 59,000 balls (the same number as sold last year). Prepare a contribution format income statement. (Do not round your intermediate calculations.) |
b-2. |
Compute the degree of operating leverage. (Do not round intermediate calculations and round your final answer to 2 decimal places.) |
In: Accounting
Exercise 5-14 Break-Even and Target Profit Analysis [LO5-3, LO5-4, LO5-5, LO5-6]
Lindon Company is the exclusive distributor for an automotive product that sells for $38.00 per unit and has a CM ratio of 39%. The company’s fixed expenses are $355,680 per year. The company plans to sell 25,000 units this year. |
Required:
1. |
What are the variable expenses per unit? (Round your answer to 2 decimal places.) |
||
2. | Use the equation method: |
a. |
What is the break-even point in unit sales and in dollar sales? (Do not round intermediate calculations.) |
b. |
What amount of unit sales and dollar sales is required to earn an annual profit of $74,100? (Do not round intermediate calculations.) |
c. |
Assume that by using a more efficient shipper, the company is able to reduce its variable expenses by $4.30 per unit. What is the company’s new break-even point in unit sales and in dollar sales? (Do not round intermediate calculations. Round up break even point answers to the nearest whole number.) |
3. | Repeat (2) above using the formula method. |
a. |
What is the break-even point in unit sales and in dollar sales? (Do not round intermediate calculations.) |
b. |
What amount of unit sales and dollar sales is required to earn an annual profit of $74,100? (Do not round intermediate calculations.) |
c. |
Assume that by using a more efficient shipper, the company is able to reduce its variable expenses by $4.30 per unit. What is the company’s new break-even point in unit sales and in dollar sales? (Do not round intermediate calculations. Round up break even point answers to the nearest whole number.) |
In: Accounting
Debt Investment Transactions, Available-for-Sale Valuation
Rekya Mart Inc. is a general merchandise retail company that began operations on January 1, Year 1. The following transactions relate to debt investments acquired by Rekya Mart Inc., which has a fiscal year ending on December 31:
Year 1 | |
Apr. 1. | Purchased $60,000 of Smoke Bay 5%, 10-year bonds at their face amount plus accrued interest of $500. The bonds pay interest semiannually on February 1 and August 1. |
May 16. | Purchased $124,000 of Geotherma Co. 6%, 12-year bonds at their face amount plus accrued interest of $310. The bonds pay interest semiannually on May 1 and November 1. |
Aug. 1. | Received semiannual interest on the Smoke Bay bonds. |
Sept. 1. | Sold $24,000 of Smoke Bay bonds at 103 plus accrued interest of $100. |
Nov. 1. | Received semiannual interest on the Geotherma Co. bonds. |
Dec. 31 | Accrued $600 interest on Smoke Bay bonds. |
Dec. 31 | Accrued $620 interest on Geotherma Co. bonds. |
Year 2 | |
Feb. 1. | Received semiannual interest on the Smoke Bay bonds. |
May 1. | Received semiannual interest on the Geotherma Co. bonds. |
Required:
1. Journalize the entries to record these transactions. For a compound transaction, if an amount box does not require an entry, leave it blank.
Date | Description | Debit | Credit |
---|---|---|---|
Year 1 | |||
Apr. 1. | Investments-Smoke Bay Bonds | ||
Interest Receivable | |||
Cash | |||
May 16. | Investments-Geotherma Co. Bonds | ||
Interest Receivable | |||
Cash | |||
Aug. 1. | Cash | ||
Interest Receivable | |||
Interest Revenue | |||
Sept. 1. | Cash | ||
Interest Revenue | |||
Gain on Sale of Investment | |||
Investments-Smoke Bay Bonds | |||
Nov. 1. | Cash | ||
Interest Receivable | |||
Interest Revenue | |||
Dec. 31 Smoke Bay | Interest Receivable | ||
Interest Revenue | |||
Dec. 31 Geotherma Co. | Interest Receivable | ||
Interest Revenue | |||
Year 2 | |||
Feb. 1. | Cash | ||
Interest Receivable | |||
Interest Revenue | |||
May 1. | Cash | ||
Interest Receivable | |||
Interest Revenue |
2. If the bond portfolio is classified as available for sale, what impact would this have on financial statement disclosure?
If the bonds are classified as available-for-sale securities, then the portfolio of bonds would need to be adjusted to fair value . This would be accomplished by using a valuation allowance account and an unrealized gain (loss) account.
In: Accounting
love Company is a merchandiser that provided a balance sheet as of September 30 as shown below:
Wheeling Company Balance Sheet September 30 |
||
Assets | ||
Cash | $ | 70,800 |
Accounts receivable | 130,000 | |
Inventory | 59,400 | |
Buildings and equipment, net of depreciation | 276,000 | |
Total assets | $ | 536,200 |
Liabilities and Stockholders’ Equity | ||
Accounts payable | $ | 172,200 |
Common stock | 216,000 | |
Retained earnings | 148,000 | |
Total liabilities and stockholders’ equity | $ | 536,200 |
The company is in the process of preparing a budget for October and has assembled the following data:
Sales are budgeted at $440,000 for October and $450,000 for November. Of these sales, 35% will be for cash; the remainder will be credit sales. Forty percent of a month’s credit sales are collected in the month the sales are made, and the remaining 60% is collected in the following month. All of the September 30 accounts receivable will be collected in October.
The budgeted cost of goods sold is always 45% of sales and the ending merchandise inventory is always 30% of the following month’s cost of goods sold.
All merchandise purchases are on account. Thirty percent of all purchases are paid for in the month of purchase and 70% are paid for in the following month. All of the September 30 accounts payable to suppliers will be paid during October.
Selling and administrative expenses for October are budgeted at $89,400, exclusive of depreciation. These expenses will be paid in cash. Depreciation is budgeted at $2,760 for the month.
Required:
1. Using the information provided, calculate or prepare the following:
a. The budgeted cash collections for October.
b. The budgeted merchandise purchases for October.
c. The budgeted cash disbursements for merchandise purchases for October.
d. The budgeted net operating income for October.
e. A budgeted balance sheet at October 31.
2. Assume the following changes to the underlying budgeting assumptions:
(1) 50% of a month’s credit sales are collected in the month the sales are made and the remaining 50% is collected in the following month, (2) the ending merchandise inventory is always 10% of the following month’s cost of goods sold, and (3) 20% of all purchases are paid for in the month of purchase and 80% are paid for in the following month. Using these new assumptions, calculate or prepare the following:
a. The budgeted cash collections for October.
b. The budgeted merchandise purchases for October.
c. The budgeted cash disbursements for merchandise purchases for October.
d. Net operating income for the month of October.
e. A budgeted balance sheet at October 31.
In: Accounting
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales data for portable DVD players are as follows: Apr. 1 Inventory 59 units @ $62 10 Sale 44 units 15 Purchase 33 units @ $66 20 Sale 23 units 24 Sale 11 units 30 Purchase 20 units @ $69 The business maintains a perpetual inventory system, costing by the first-in, first-out method. Determine the cost of the merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 3. a. Under FIFO, if units are in inventory at two different costs, enter the units with the LOWER unit cost first in the Cost of Merchandise Sold Unit Cost column and in the Inventory Unit Cost column. Cost of the Merchandise Sold Schedule First-in, First-out Method Portable DVD Players Date Quantity Purchased Purchases Unit Cost Purchases Total Cost Quantity Cost of Merchandise Sold Cost of Merchandise Sold Unit Cost Cost of Merchandise Sold Total Cost Inventory Quantity Inventory Unit Cost Inventory Total Cost Apr. 1 $ $ Apr. 10 $ $ Apr. 15 $ $ Apr. 20 Apr. 24 Apr. 30 Apr. 30 Balances $ $ b. Based upon the preceding data, would you expect the inventory to be higher or lower using the last-in, first-out method?
In: Accounting
12.4 Explain how calculating current cash debt coverage for an entity overcomes a disadvantage of the current and quick ratios.
In: Accounting
In: Accounting
For which of the following taxes is there a ceiling on the amount of employee annual earnings subject to the tax?
A.
FICAminus−OASDI
Your answer is not correct.
B.
State unemployment taxes
C.
Federal unemployment taxes
D.
All of these answers are correct.
The correct answer is D
Explain:
In: Accounting