Product Costs and Product Profitability Reports, using a Single Plantwide Factory Overhead Rate
Isaac Engines Inc. produces three products—pistons, valves, and
cams—for the heavy equipment industry. Isaac Engines has a very
simple production process and product line and uses a single
plantwide factory overhead rate to allocate overhead to the three
products. The factory overhead rate is based on direct labor hours.
Information about the three products for 20Y2 is as
follows:
| Budgeted Volume (Units) |
Direct Labor Hours Per Unit |
Price Per Unit |
Direct Materials Per Unit |
|||||
| Pistons | 6,000 | 0.30 | $40 | $ 9 | ||||
| Valves | 13,000 | 0.50 | 21 | 5 | ||||
| Cams | 1,000 | 0.10 | 55 | 20 | ||||
The estimated direct labor rate is $20 per direct labor hour. Beginning and ending inventories are negligible and are, thus, assumed to be zero. The budgeted factory overhead for Isaac Engines is $235,200.
If required, round all per unit answers to the nearest cent.
a. Determine the plantwide factory overhead
rate.
$ per dlh
b. Determine the factory overhead and direct labor cost per unit for each product.
| Direct Labor Hours Per Unit |
Factory Overhead Cost Per Unit |
Direct Labor Cost Per Unit |
|
| Pistons | dlh | $ | $ |
| Valves | dlh | $ | $ |
| Cams | dlh | $ | $ |
c. Use the information provided to construct a budgeted gross profit report by product line for the year ended December 31, 20Y2. Include the gross profit as a percent of sales in the last line of your report, rounded to one decimal place.
| Isaac Engines Inc. | |||
| Product Line Budgeted Gross Profit Reports | |||
| For the Year Ended December 31, 20Y2 | |||
| Pistons | Valves | Cams | |
| $ | $ | $ | |
| Product Costs | |||
| $ | $ | $ | |
| Total Product Costs | $ | $ | $ |
| Gross profit (loss) | $ | $ | $ |
| Gross profit percentage of sales | % | % | % |
d. What does the report in (c) indicate to you?
Valves have the gross profit as a percent of sales. Valves may require a price or cost to manufacture in order to achieve a higher profitability similar to the other two products.
In: Accounting
Problem 08-3A Flexible budget preparation; computation of materials, labor, and overhead variances; and overhead variance report LO P1, P2, P3, P4
[The following information applies to the questions
displayed below.]
Antuan Company set the following standard costs for one unit of its
product.
| Direct materials (4.0 Ibs. @ $6.00 per Ib.) | $ | 24.00 |
| Direct labor (1.9 hrs. @ $12.00 per hr.) | 22.80 | |
| Overhead (1.9 hrs. @ $18.50 per hr.) | 35.15 | |
| Total standard cost | $ | 81.95 |
The predetermined overhead rate ($18.50 per direct labor hour) is
based on an expected volume of 75% of the factory’s capacity of
20,000 units per month. Following are the company’s budgeted
overhead costs per month at the 75% capacity level.
| Overhead Budget (75% Capacity) | |||||
| Variable overhead costs | |||||
| Indirect materials | $ | 15,000 | |||
| Indirect labor | 75,000 | ||||
| Power |
15,000 |
||||
| Repairs and maintenance | 30,000 | ||||
| Total variable overhead costs | $ | 135,000 | |||
| Fixed overhead costs | |||||
| Depreciation—Building | 24,000 | ||||
| Depreciation—Machinery | 72,000 | ||||
| Taxes and insurance | 17,000 | ||||
| Supervision | 279,250 | ||||
| Total fixed overhead costs | 392,250 | ||||
| Total overhead costs | $ | 527,250 | |||
The company incurred the following actual costs when it operated at
75% of capacity in October.
| Direct materials (61,500 Ibs. @ $6.10 per lb.) | $ | 375,150 | |||
| Direct labor (19,000 hrs. @ $12.10 per hr.) | 229,900 | ||||
| Overhead costs | |||||
| Indirect materials | $ | 41,300 | |||
| Indirect labor | 176,050 | ||||
| Power | 17,250 | ||||
| Repairs and maintenance | 34,500 | ||||
| Depreciation—Building | 24,000 | ||||
| Depreciation—Machinery | 97,200 | ||||
| Taxes and insurance | 15,300 | ||||
| Supervision | 279,250 | 684,850 | |||
| Total costs | $ | 1,289,900 | |||
|
Required: 3. Compute the direct materials cost variance,
including its price and quantity variances. (Indicate the
effect of each variance by selecting for favorable, unfavorable,
and No variance.) Compute the direct labor cost variance, including its rate and efficiency variances. (Indicate the effect of each variance by selecting for favorable, unfavorable, and No variance. Round "Rate per hour" answers to two decimal places.) Prepare a detailed overhead variance report that shows the variances for individual items of overhead. (Indicate the effect of each variance by selecting for favorable, unfavorable, and No variance.) |
|||||
In: Accounting
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and other areas to gather the information assembled below.
The company sells many styles of earrings, but all are sold for the same price—$13 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings):
| January (actual) | 21,400 | June (budget) | 51,400 |
| February (actual) | 27,400 | July (budget) | 31,400 |
| March (actual) | 41,400 | August (budget) | 29,400 |
| April (budget) | 66,400 | September (budget) | 26,400 |
| May (budget) | 101,400 | ||
The concentration of sales before and during May is due to Mother’s Day. Sufficient inventory should be on hand at the end of each month to supply 40% of the earrings sold in the following month.
Suppliers are paid $4.70 for a pair of earrings. One-half of a month’s purchases is paid for in the month of purchase; the other half is paid for in the following month. All sales are on credit. Only 20% of a month’s sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale. Bad debts have been negligible.
Monthly operating expenses for the company are given below:
| Variable: | |||
| Sales commissions | 4 | % of sales | |
| Fixed: | |||
| Advertising | $ | 270,000 | |
| Rent | $ | 25,000 | |
| Salaries | $ | 120,000 | |
| Utilities | $ | 10,500 | |
| Insurance | $ | 3,700 | |
| Depreciation | $ | 21,000 | |
Insurance is paid on an annual basis, in November of each year.
The company plans to purchase $19,500 in new equipment during May and $47,000 in new equipment during June; both purchases will be for cash. The company declares dividends of $20,250 each quarter, payable in the first month of the following quarter.
The company’s balance sheet as of March 31 is given below:
| Assets | ||
| Cash | $ | 81,000 |
| Accounts receivable ($35,620 February sales; $430,560 March sales) | 466,180 | |
| Inventory | 124,832 | |
| Prepaid insurance | 24,500 | |
| Property and equipment (net) | 1,020,000 | |
| Total assets | $ | 1,716,512 |
| Liabilities and Stockholders’ Equity | ||
| Accounts payable | $ | 107,000 |
| Dividends payable | 20,250 | |
| Common stock | 940,000 | |
| Retained earnings | 649,262 | |
| Total liabilities and stockholders’ equity | $ | 1,716,512 |
The company maintains a minimum cash balance of $57,000. All borrowing is done at the beginning of a month; any repayments are made at the end of a month.
The company has an agreement with a bank that allows the company to borrow in increments of $1,000 at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company would pay the bank all of the accumulated interest on the loan and as much of the loan as possible (in increments of $1,000), while still retaining at least $57,000 in cash.
Required:
Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules:
1. a. A sales budget, by month and in total.
b. A schedule of expected cash collections, by month and in total.
c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total.
d. A schedule of expected cash disbursements for merchandise purchases, by month and in total.
2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $57,000.
3. A budgeted income statement for the three-month period ending June 30. Use the contribution approach.
4. A budgeted balance sheet as of June 30.
In: Accounting
Kitchen Supply, Inc. (KSI), manufactures three types of flatware: institutional, standard, and silver. It applies all indirect costs according to a predetermined rate based on direct labor-hours. A consultant recently suggested that the company switch to an activity-based costing system and prepared the following cost estimates for year 2 for the recommended cost drivers.
| Activity | Recommended Cost Driver |
Estimated Cost |
Estimated Cost Driver Activity |
||||
| Processing orders | Number of orders | $ | 40,250 | 175 | orders | ||
| Setting up production | Number of production runs | 160,000 | 80 | runs | |||
| Handling materials | Pounds of materials used | 242,000 | 110,000 | pounds | |||
| Machine depreciation and maintenance | Machine-hours | 220,000 | 11,000 | hours | |||
| Performing quality control | Number of inspections | 44,450 | 35 | inspections | |||
| Packing | Number of units | 98,000 | 490,000 | units | |||
| Total estimated cost | $ | 804,700 | |||||
In addition, management estimated 7,100 direct labor-hours for year 2.
Assume that the following cost driver volumes occurred in January, year 2.
| Institutional | Standard | Silver | |||||||
| Number of units produced | 64,000 | 25,000 | 7,000 | ||||||
| Direct materials costs | $ | 42,000 | $ | 22,000 | $ | 17,000 | |||
| Direct labor-hours | 410 | 430 | 620 | ||||||
| Number of orders | 11 | 9 | 6 | ||||||
| Number of production runs | 3 | 3 | 6 | ||||||
| Pounds of material | 14,000 | 6,000 | 2,900 | ||||||
| Machine-hours | 560 | 150 | 60 | ||||||
| Number of inspections | 4 | 2 | 3 | ||||||
| Units shipped | 64,000 | 25,000 | 7,000 | ||||||
Actual labor costs were $16 per hour.
Required:
a.
(1) Compute a predetermined overhead rate for
year 2 for each cost driver using the estimated costs and estimated
cost driver units prepared by the consultant.
(2) Compute a predetermined rate for year 2 using
direct labor-hours as the allocation base.
Processing orders: Rate per order?
Setting up Production: Rate per run?
Handling Materials: Rate per pound?
Using Machines: Rate per machine hour?
Performing Quality Control: Rate per Inspection?
Packing: Rate per unit?
a2. Predetermined Rate per direct labor-hour?
b. Compute the production costs for each product
for January using direct labor-hours as the allocation base and the
predetermined rate computed in requirement
a(2).
Direct Labor for: Institutional? Standard? Silver?
Indirect Costs for: Instituional? Standard? Silver?
c. Compute the production costs for each product
for January using the cost drivers recommended by the consultant
and the predetermined rates computed in requirement
a. (Note: Do not assume that total
overhead applied to products in January will be the same for
activity-based costing as it was for the labor-hour-based
allocation.)
Institutional Standard Silver
Direct Labor?
Processing Orders?
Setting up Production?
Handling Materials?
Using Machines?
Performing Quality Control?
Packing?
In: Accounting
What decisions on the basis of this information, including the same data for the previous period and possibly two years prior, can investors or shareholders take (focus on future growth, evolution of risk level, or volatility of future earnings and evolution of the 'time horizon of visibility' into the firm's future)?
In: Accounting
Cain Components manufactures and distributes various plumbing products used in homes and other buildings. Over time, the production staff has noticed that products they considered easy to make were difficult to sell at margins considered reasonable, while products that seemed to take a lot of staff time were selling well despite recent price increases. A summer intern has suggested that the cost system might be providing misleading information.
The controller decided that a good summer project for the intern would be to develop, in one self-contained area of the plant, an alternative cost system with which to compare the current system. The intern identified the following cost pools and, after discussion with some plant personnel, appropriate cost drivers for each pool. There were:
| Cost Pools | Costs | Activity Drivers | |
| Receiving | $ | 600,000 | Direct material cost |
| Manufacturing | 5,500,000 | Machine-hours | |
| Machine setup | 900,000 | Production runs | |
| Shipping | 1,000,000 | Units shipped | |
In this particular area, Cain produces two of its many products: Standard and Deluxe. The following are data for production for the latest full year of operations.
| Products | ||||||
| Standard | Deluxe | |||||
| Total direct material costs | $ | 205,000 | $ | 195,000 | ||
| Total direct labor costs | $ | 650,000 | $ | 330,000 | ||
| Total machine-hours | 134,000 | 116,000 | ||||
| Total number of setups | 115 | 85 | ||||
| Total pounds of material | 14,000 | 13,000 | ||||
| Total direct labor-hours | 6,400 | 4,150 | ||||
| Number of units produced and shipped | 12,000 | 13,000 | ||||
Required:
a. The current cost accounting system charges overhead to products based on machine-hours. What unit product costs will be reported for the two products if the current cost system continues to be used?
Direct Costs: Standard? Deluxe?
Overhead: Standard? Deluxe?
Number of Units: Standard? Deluxe?
b. The intern suggests an ABC system using the cost drivers identified above. What unit product costs will be reported for the two products if the ABC system is used?
Direct Costs: Standard? Deluxe?
Receiving: Standard? Deluxe?
Manufacturing: Standard? Deluxe?
Machine Set Up: Standard? Deluxe?
Shipping: Standard? Deluxe?
Number of Units: Standard? Deluxe?
In: Accounting
Christopher’s Custom Cabinet Company uses a job order cost
system with overhead applied as a percentage of direct labor costs.
Inventory balances at the beginning of 2016 follow:
| Raw Materials Inventory | $ | 15,700 |
| Work in Process Inventory | 6,700 | |
| Finished Goods Inventory | 21,300 | |
The following transactions occurred during January:
(a) Purchased materials on account for $26,800.
(b) Issued materials to production totaling $21,000, 90
percent of which was traced to specific jobs and the remainder of
which was treated as indirect materials.
(c) Payroll costs totaling $18,400 were recorded as
follows:
$10,100 for assembly workers
2,500 for factory supervision
2,700 for administrative personnel
3,100 for sales commissions
(d) Recorded depreciation: $5,000 for machines, $1,100 for
the copier used in the administrative office.
(e) Recorded $1,800 of expired insurance. Forty percent
was insurance on the manufacturing facility, with the remainder
classified as an administrative expense.
(f) Paid $5,600 in other factory costs in cash.
(g) Applied manufacturing overhead at a rate of 200
percent of direct labor cost.
(h) Completed all jobs but one; the job cost sheet for
this job shows $2,200 for direct materials, $2,100 for direct
labor, and $4,200 for applied overhead.
(i) Sold jobs costing $50,200. The revenue earned on these
jobs was $65,260.
Required:
1. Set up T-accounts, record the beginning
balances, post the January transactions, and compute the final
balance for the following accounts: (Post all amounts
separately. Do not combine/add any dollar amounts when posting to
the t-accounts.)
2. Determine how much gross profit the company
would report during the month of January before
any adjustment is made for the overhead balance.
3. Determine the amount of over- or underapplied
overhead.
4. Compute adjusted gross profit assuming that any
over- or underapplied overhead balance is adjusted directly to Cost
of Goods Sold.
In: Accounting
Please Answer in Detail
Question 01: Qualitative characteristics of accounting information relates to the second level of conceptual framework. Discuss in detail, the primary qualitative characteristics relating to the content and presentation of information with particular emphasis to their importance.
.
Question 02: Financial statements prepared under historical cost convention do not have regard for changes in price levels and therefore do not reflect financial realities. Discuss six limitations that statements prepared by historical cost accounting possess that reduce their utility to the users.
In: Accounting
Bob Stone, Inc., budgets the following amounts for its Buildings & Grounds and Computer Services Departments in servicing each other and the two manufacturing divisions of Signs and Mailers:
|
Used By |
||||
|
Supplied By |
Building & Grounds |
Computer Services |
Signs |
Mailers |
|
Buildings & Grounds |
— |
0.20 |
0.60 |
0.20 |
|
Computer Services |
0.15 |
— |
0.30 |
0.55 |
If you are using the step down method to allocate support department costs which of the support departments would you allocate the costs from second:
| a. |
Computer Services |
|
| b. |
Building and Grounds |
|
| c. |
Mailers |
|
| d. |
Signs |
In: Accounting
Kingbird Corporation was organized on January 1, 2017. It is
authorized to issue 9,600 shares of 8%, $100 par value preferred
stock, and 501,500 shares of no-par common stock with a stated
value of $1 per share. The following stock transactions were
completed during the first year.
| Jan. 10 | Issued 80,050 shares of common stock for cash at $6 per share. | |
| Mar. 1 | Issued 5,930 shares of preferred stock for cash at $113 per share. | |
| Apr. 1 | Issued 24,680 shares of common stock for land. The asking price of the land was $90,820; the fair value of the land was $80,050. | |
| May 1 | Issued 80,050 shares of common stock for cash at $8 per share. | |
| Aug. 1 | Issued 9,600 shares of common stock to attorneys in payment of their bill of $50,400 for services rendered in helping the company organize. | |
| Sept. 1 | Issued 9,600 shares of common stock for cash at $10 per share. | |
| Nov. 1 | Issued 1,100 shares of preferred stock for cash at $115 per share. |
Prepare the journal entries to record the above transactions.
(Credit account titles are automatically indented when
amount is entered. Do not indent manually. If no entry is required,
select "No Entry" for the account titles and enter 0 for the
amounts.)
In: Accounting
Stamboul Company lists the following condensed balance sheet as of the beginning of 2016:
|
Stamboul Company |
|
Balance Sheet |
|
Beginning of 2016 |
|
1 |
Current Assets |
$60,000.00 |
|
2 |
Investment in Ostend bonds |
9,000.00 |
|
3 |
Fixed Assets (Net) |
200,000.00 |
|
4 |
$269,000.00 |
|
|
5 |
Current Liabilities |
$30,000.00 |
|
6 |
Common Stock, no par |
150,000.00 |
|
7 |
Retained Earnings |
89,000.00 |
|
8 |
$269,000.00 |
Stamboul is considering the impact of various types of dividends on this balance sheet. Each dividend would be declared and paid in 2016. These include:
| 1. | Cash dividend of $1.00 per share on the 15,000 shares outstanding. |
| 2. | Stock dividend of 5% on the 15,000 shares outstanding when the market price is $17 per share. |
| 3. | Property dividend consisting of the $9,000 (book value) investment in Ostend bonds being held to maturity. This investment has a current market value of $13,000. (For Requirement 2, assume any gain or loss is to be reflected in retained earnings. Disregard income taxes.) |
| 4. | Scrip dividend of $0.80 per share on the 15,000 shares outstanding. The scrip earns interest at a 12% annual rate and is to be declared on January 30 and paid on December 30, 2016. (For Requirement 2, assume any interest expense is to be reflected in retained earnings. Disregard income taxes.) |
| 5. | Cash dividend consisting of a $0.70 per share normal dividend and a $0.30 per share liquidating dividend. |
Required:
| For each preceding independent dividend: | |
| 1. Prepare the appropriate journal entries for the declaration and payment or distribution of the dividend. | |
| 2. Prepare a condensed balance sheet after each dividend has been paid or distributed. |
In: Accounting
Olivia’s Outdoor Essentials produces gear for climbing, hiking, and camping. Last month, Olivia reported the following: Beginning Work in Process Inventory: $20,000 Ending Work in Process Inventory: $25,000 Beginning Finished Goods Inventory: $15,000 Ending Finished Goods Inventory: $13,000 Direct Labor: $60,000 Beginning Raw Materials Inventory: $20,000 New Raw Materials Purchased: $48,000 Ending Raw Materials Inventory: $10,000 Indirect Materials Used: $8,000 Indirect Labor: $10,000 Other Applied Manufacturing Overhead: $30,000
Required:
a. What was the Manufacturing Costs for the period?
b. What was the Cost of Goods Manufactured for the period?
c. What was the Cost of Goods Sold for the period?
In: Accounting
Fairness of the Federal Estate Tax"
In: Accounting
Discuss "Overhead Costs" and the difficulty it causes when dealing with manufacturing costs.
In: Accounting
Sandra’s Purse Boutique has the following transactions related to its top-selling Gucci purse for the month of October. Sandra's Purse Boutique uses a periodic inventory system.
| Date | Transactions | Units | Cost per Unit | Total Cost |
| October 1 | Beginning inventory | 6 | $870 | $ 5,220 |
| October 4 | Sale | 4 | ||
| October 10 | Purchase | 5 | 880 | 4,400 |
| October 13 | Sale | 3 | ||
| October 20 | Purchase | 4 | 890 | 3,560 |
| October 28 | Sale | 7 | ||
| October 30 | Purchase | 7 | 900 | 6,300 |
| $19,480 | ||||
1. Calculate ending inventory and cost of goods sold at October 31, using the specific identification method. The October 4 sale consists of purses from beginning inventory, the October 13 sale consists of one purse from beginning inventory and two purses from the October 10 purchase, and the October 28 sale consists of three purses from the October 10 purchase and four purses from the October 20 purchase.
Ending Inventory=
Cost of Goods Sold=
2. Using FIFO, calculate ending inventory and cost of goods sold at October 31.
Ending Inventory=
Cost of Goods Sold=
3. Using LIFO, calculate ending inventory and cost of goods sold at October 31.
Ending Inventory=
Cost of Goods Sold=
4. Using weighted-average cost, calculate ending inventory and cost of goods sold at October 31. (Do not round intermediate calculations. Round your final answers to 2 decimal places.)
Ending Inventory=
Cost of Goods Sold=
In: Accounting