ACC M118 Lecture Notes - Lecture 4: Income Statement, Office Supplies
Document Summary
Get access
Related Documents
Related Questions
Bushman Case
The Bushman Company is a publicly traded corporation that produces different types of digital control systems. My name is Alan Smith and I have worked for this company for the last ten years in the controllerâs office. I was both an accounting and finance major in university. The company currently produces 300 products and does not anticipate any new products coming out over the next three years. I have previously mentioned to my superiors that it is not appropriate for our firm to use a traditional accounting system (where overhead costs are allocated across products at a rate of 400% of direct labor costs) when different products require different amounts of indirect overhead resources. For example, under the traditional system all costs associated with testing of products for quality assurance purposes are part of overhead costs and therefore allocated across products based on direct labor costs. Yet, some of our products require as much as 5 hours of testing whereas some products require less than 1 minute of testing with no connection to direct labor costs. Given that traditional costing systems result in significant cost distortions when determining products costs and given that the firm now has revenues of over $700,000,000 a year, Bushman has decided to adopt activity based costing over the next year or two.
Bushmanâs management has hired Deloitte Consulting to help us implement activity based costing. I will be acting as the liaison between our firm and Deloitte. As part of the initial implementation phase, I have asked Deloitte to derive the costs and product margins associated with two of our products, delta and vega, so that these costs and product margins could be compared with the costs and product margins under our current traditional accounting system. I picked these products since Bushman management believe they have very different demands on indirect overhead resources. Further, delta is sold in large quantities whereas vega is sold in small quantities and traditional accounting systems can cause large cost distortions in different directions for products sold in large and small quantities.
Current information from our existing system on a per unit basis is shown in Exhibit 1.
Exhibit 1
delta | vega | |
Direct material | $10 | $10 |
Direct labor hours | 1 | 1 |
Direct labor wage rate per hour | $20 | $20 |
Sales price per unit | $160 | $170 |
My staff has identified for Deloitte five activity cost pools. Information on those cost pools and the related activity measures are provided in Exhibit 2.
Exhibit 2
Activity cost pool | Total costs | Activity measure | Activity level |
Equipment setups | $20,000,000 | number of setups | 50,000 |
Purchase orders | $15,000,000 | number of purchase orders | 300,000 |
Machining | $90,000,000 | number of machine hours | 2,000,000 |
Testing | $13,300,000 | number of testing hours | 700,000 |
Packaging | $24,000,000 | number of containers | 2,000,000 |
Although fixed costs are lumped in with variable costs across the five different cost pools, I am aware that machining related costs consists almost exclusively of depreciation costs. Hence, with respect to all questions asked in this case, machining costs will be treated as entirely fixed with respect to machine hours. Each machine is used in the production of multiple product lines. The resale value of machines is only affected by the passage of time and not by how much they are used in a given year.
In all questions asked in this case, the firm will assume that costs associated with equipment setups, purchase orders, testing, and packaging are variable with respect to their respective activity measures. Currently, we believe our assumptions on cost behavior patterns are quite reasonable.
All products are produced in batches, where the size of a batch differs across products. For example, if we produce 80 units of a product in batch sizes of 40, then the product will be produced in two batches. An equipment setup must be performed before producing each batch of a product. Hence, in the example above, two equipment setups would be performed. Units of product are packaged in containers and sent to distributors.
Production volumes are set equal to sales volumes since the company only produces products that they have orders for. Consequently, the firm never has a beginning or ending work in process inventory, and it does not have a beginning or ending finished goods inventory.
Further information on our two products is provided in Exhibit 3
Exhibit 3
delta | vega | |
annual sales and production in units | 800,000 | 12,000 |
number of units per batch | 200 | 150 |
number of purchase orders | 400 | 100 |
number of machine hours per unit | 0.2 | 3 |
total number of testing hours | 7,000 | 21,000 |
total number of containers | 5,000 | 2,000 |
REQUIRED:
1. (20 Points) Prepare an income statement for delta and an income statement for vega using the traditional accounting system where overhead is applied at a rate of 400% of direct labor costs. (For simplicity, there are no SG&A expenses for the firm.) The income statements should be prepared on a total basis and then show the average net operating income per unit using the following template for guidance:
delta vega
Sales $$$ $$$
Direct materials $$$ $$$
Direct labor $$$ $$$
Manufacturing overhead $$$ $$$
Total Costs $$$ $$$
Net operating income $$$ $$$
Average net operating income
per unit $$$ $$$
2. (20 Points) Calculate the five activity rates under activity based costing.
3. (35 Points) Prepare an income statement for delta and an income statement for vega using activity based costing. (For simplicity, there are no SG&A expenses for the firm.) The income statements should be prepared on a total basis and then show the average net operating income per unit using the following template for guidance:
delta vega
Sales $$$ $$$
Direct materials $$$ $$$
Direct labor $$$ $$$
Equipment Setups $$$ $$$
Purchase orders $$$ $$$
Machining $$$ $$$
Testing $$$ $$$
Packaging $$$ $$$
Total Costs $$$ $$$
Net operating income $$$ $$$
Average net operating income
per unit $$$ $$$
4. (10 Points) Assume next year that the activity rates remain the same as you calculated in question (2). Assume that the demand for delta is expected to increase significantly. Consequently, the firm expects to produce more batches of delta next year than this year and the firm plans to produce in batch sizes of 500 rather than 200. Calculate what the equipment setup cost per unit of delta will be next year if it can be calculated. If it cannot be calculated, then explain in words why the equipment setup cost per unit of delta cannot be determined in the absence of more information. Excluding your quantitative analysis if any, your explanation should not be more than 1/3 page double spaced with a 12 font size. Your grade will be lowered for poor writing (e.g., grammar).
5. (15 Points) Question 5 is independent of question 4. Next year, because of an expected increase in product demand, machine hours are expected to increase from 2,000,000 to 2,500,000. The company will not need any new machinery since the current machinery is highly underutilized. Also, the number of purchase orders will increase from 300,000 to 360,000. Assume that these new levels of operations are within the firmâs relevant range. Calculate what the activity rate for the cost pool of machining would be next year if it can be calculated. Also, calculate what the activity rate for the cost pool of purchase order would be next year if it can be calculated. If one or both rates cannot be calculated, then explain in words why the calculations cannot be determined in the absence of more information. Excluding any quantitative analysis, your explanation should not be more than 1/3 page double spaced with 12 font. Your grade will be lowered for poor writing (e.g., grammar).
I'll rate posting for sec times just do last parts likecost and balance sheet ( account balance and cost incurred ) that'sit ready question carefully then answer all last partthanks
Charles Maxwell is starting a cheesecake bakery, Able BakerCharlie Company, to produce and sell different flavored cheesecakesto restaurants and the general public. He has just begun his studyof accounting, and is a bit confused about the many types ofreports he has read about and how they will help him run hisbusiness. He asks you to help him clarify what the differencesbetween managerial accounting and financial accounting are. Heâsalso wondering how to set up his inventory, how to classify thecosts of his business, and how to fill in some missinginformation.
Required: | |
1. | Choose whether thecharacteristics on the Managerial vs. Financial panel are mostoften associated with managerial accounting or financialaccounting. |
2. | Charles has provided some ofthe costs he expects to incur on the Cost Classification panel.Decide on the classifications that could be applied to each ofthese costs using the table provided. The cost object in each caseis the cheesecake. |
3. | Charles found some sampleincome statements and balance sheets on the Internet, and askedwhich of them might be most appropriate for a manufacturingbusiness like his. Review income statements A and B on the IncomeStatements panel, and balance sheets C and D on the Balance Sheetspanel. Determine which income statement and balance sheet would bemost appropriate for a manufacturing business like Able BakerCharlie. Then, on the Financial Statements panel, denote whichincome statement and balance sheet would be most appropriate for amanufacturing business. |
4. | At the end of February, afterthe second month of operations of Able Baker Charlie Company,Charles shows you the data heâs collected, but he was unable tofigure out some of the amounts. On the Costs and Balances panel,determine the missing amounts. Note: It may behelpful to use T accounts to map the flow of the amounts throughthe manufacturing accounts and solve for the missing dollarvalues. |
Managerial vs. Financial
Choose whether the following characteristics are most oftenassociated with managerial accounting or financial accounting.
Managerial Accounting | Financial Accounting | ||
---|---|---|---|
Primarily used for internal decision making | |||
Generally Accepted Accounting Principles (GAAP) must beused | |||
Prepared statements usually pertain to the company as a wholerather than individual departments or products | |||
Information provided will often be subjective, such asestimated future results | |||
Often prepared on an as-needed basis rather than at fixedintervals | |||
Use principles of the Sustainability Accounting Standards Board(SASB) to provide sustainability information to external financialstatement users | |||
Consideration of sustainability practices to contribute to thecompanyâs long-term success | |||
Using eco-efficiency measures to reduce expenses |
Cost Classification
Charles has provided some of the costs he expects to incur asfollows. Decide on the classifications that could be applied toeach of these costs using the table provided. The cost object ineach case is the cheesecake.
Cost | Product | Period | Direct | Direct | Factory | Selling | Administrative | Direct | Indirect | Prime | Conversion | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
Cost | Cost | Materials | Labor | Overhead | Expense | Expense | Cost | Cost | Cost | Cost | ||
Eggs used to make cheesecakes | ||||||||||||
Bakerâs wages | ||||||||||||
Delivery driver wages | ||||||||||||
Depreciation of office computers | ||||||||||||
Power to run the cheesecake ovens | ||||||||||||
Presidentâs salary | ||||||||||||
Sales commissions | ||||||||||||
Factory supervisor salary |
Financial Statements
Charles found some sample income statements and balance sheetson the Internet, and asked which of them might be most appropriatefor a manufacturing business like his. Review income statements Aand B on the Income Statements panel, and balance sheets C and D onthe Balance Sheets panel. Determine which income statement andbalance sheet would be most appropriate for a manufacturingbusiness like Able Baker Charlie Company.
Which income statement is most appropriate for a manufacturingbusiness?
Income statement A
Income statement B
Which balance sheet is most appropriate for a manufacturingbusiness?
Balance sheet C
Balance sheet D
Income Statements
Income Statement A (scroll down for Income StatementB):
Sample Company A |
Income Statement |
For the Year Ended December 31, 20Y8 |
1 | Sales | $42,000.00 | |
2 | Beginning finished goods inventory | $5,250.00 | |
3 | Plus cost of goods manufactured | 6,400.00 | |
4 | Cost of finished goods available for sale | $11,650.00 | |
5 | Less ending finished goods inventory | 400.00 | |
6 | Cost of goods sold | 11,250.00 | |
7 | Gross profit | $30,750.00 | |
8 | Operating expenses: | ||
9 | Selling expenses | $6,400.00 | |
10 | Administrative expenses | 5,250.00 | |
11 | Total operating expenses | 11,650.00 | |
12 | Net income | $19,100.00 |
Income Statement B:
Sample Company B |
Income Statement |
For the Year Ended December 31, 20Y8 |
1 | Sales | $42,000.00 | |
2 | Beginning merchandise inventory | $5,250.00 | |
3 | Plus net purchases | 6,400.00 | |
4 | Merchandise available for sale | $11,650.00 | |
5 | Less ending merchandise inventory | 400.00 | |
6 | Cost of merchandise sold | 11,250.00 | |
7 | Gross profit | $30,750.00 | |
8 | Operating expenses: | ||
9 | Selling expenses | $6,400.00 | |
10 | Administrative expenses | 5,250.00 | |
11 | Total operating expenses | 11,650.00 | |
12 | Net income | $19,100.00 |
Balance Sheets
Balance Sheet C (scroll down for Balance SheetD):
Sample Company C |
Balance Sheet |
December 31, 20Y8 |
1 | Assets | ||
2 | Cash | $20,800.00 | |
3 | Accounts receivable (net) | 10,000.00 | |
4 | Merchandise inventory | 6,000.00 | |
5 | Supplies | 2,100.00 | |
6 | Land | 17,000.00 | |
7 | Total assets | $55,900.00 | |
8 | Liabilities | ||
9 | Accounts payable | $17,800.00 | |
10 | Stockholdersâ Equity | ||
11 | Common stock | $19,000.00 | |
12 | Retained earnings | 19,100.00 | |
13 | Total stockholdersâ equity | 38,100.00 | |
14 | Total liabilities and stockholdersâ equity | $55,900.00 |
Balance Sheet D:
Sample Company D |
Balance Sheet |
December 31, 20Y8 |
1 | Assets | ||
2 | Cash | $20,800.00 | |
3 | Accounts receivable (net) | 10,000.00 | |
4 | Inventories: | ||
5 | Finished goods | $2,000.00 | |
6 | Work in process | 1,500.00 | |
7 | Materials | 2,500.00 | 6,000.00 |
8 | Supplies | 2,100.00 | |
9 | Land | 17,000.00 | |
10 | Total assets | $55,900.00 | |
11 | Liabilities | ||
12 | Accounts payable | $17,800.00 | |
13 | Stockholdersâ Equity | ||
14 | Common stock | $19,000.00 | |
15 | Retained earnings | 19,100.00 | |
16 | Total stockholdersâ equity | 38,100.00 | |
17 | Total liabilities and stockholdersâ equity | $55,900.00 |
Costs and Balances
At the end of February, after the second month of operationsof Able Baker Charlie Company, Charles shows you the data heâscollected, but he was unable to figure out some of the amounts.Review the following data and fill in the missing amounts on thechart for Able Baker Charlie Company. Note: It maybe helpful to use T accounts to map the flow of the amounts throughthe manufacturing accounts and solve for the missing dollar values.It may also be helpful to review the steps for determining the costof materials used, total manufacturing cost incurred, and cost ofgoods manufactured.
Data forFebruary | |
---|---|
Decrease in materialsinventory | $3,300 |
Materials inventory on Feb. 28 | 50% of materials inventory on Jan.31 |
Direct materials purchased | $12,600 |
Direct materials used | 3 times the direct laborincurred |
Total manufacturing costs incurredin period | $29,400 |
Total manufacturing costs incurredin period | 70% of Cost of GoodsManufactured |
Total manufacturing costs incurredin period | $7,000 less than Cost of GoodsSold |
Account | Account Balances | Costs Incurred | ||
---|---|---|---|---|
Jan.31 | Feb.28 | |||
Materials Inventory | DirectMaterials Used | |||
Work inProcess Inventory | $27,000 | DirectLabor Incurred | ||
FinishedGoods Inventory | $16,000 | FactoryOverhead Incurred | ||
Cost ofGoods Sold |