Managerial Accounting: Creating Value in a Dynamic Business Environment
11th Edition
ISBN: 9781259569562
Author: Ronald W Hilton Proffesor Prof, David Platt
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 2, Problem 29E
Alexandria Aluminum Company, a manufacturer of recyclable soda cans, had the following inventory balances at the beginning and end of 20x1.
During 20x1, the company purchased $250,000 of raw material and spent $400,000 on direct labor.
Sales revenue was $1,105,000 for the year. Selling and administrative expenses for the year amounted to $110,000. The firm’s tax rate is 40 percent.
Required:
- 1. Prepare a schedule of cost of goods manufactured.
- 2. Prepare a schedule of cost of goods sold.
- 3. Prepare an income statement.
- 4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how both cost schedules and the income statement will change if the following data change: direct labor is $390,000 and utilities cost $35,000.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
During its first year of operations, Silverman Company paid $16,360 for direct materials and $10,300 for production workers' wages. Lease payments and utilities on the production facilities amounted to $9,300 while general, selling, and administrative expenses totaled $4,800. The company produced 6,200 units and sold 3,800 units at a price of $8.30 a unit.
What is Silverman's cost of goods sold for the year?
During its first year of operations, Silverman Company paid $10,285 for direct materials and $9,800 for production workers' wages. Lease payments and utilities on the production facilities amounted to $8,800 while general, selling, and administrative expenses totaled
$4,300. The company produced 5,450 units and sold 3,300 units at a price of $7.80 a unit.
What is the amount of finished goods Inventory on the balance sheet at year-end?
Multiple Choice
O
O
O
O
$11,395
$5,698
$2,150
$8,250
Goodrow Industries is calculating its Cost of Goods Manufactured at year-end. The company's accounting records show
the following: The Raw Materials Inventory account had a beginning balance of $19,000 and an ending balance of $14,000. During
the year, the company purchased $56,000 of direct materials. Direct labor for the year totaled $125,000, while manufacturing
overhead amounted to $152,000. The Work in Process Inventory account had a beginning balance of $22,000 and an ending
balance of $18,000. Assume that Raw Materials Inventory contains only direct materials. Compute the Cost of Goods Manufactured
for the year. (Hint: The first step is to calculate the direct materials used during the year.)
Start by calculating the direct materials used during the year.
Goodrow Industries
Calculation of Direct Materials Used
For Current Year
Plus:
Less:
Direct materials used
Chapter 2 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 2 - Distinguish between product costs and period...Ch. 2 - Why are product costs also called inventoriable...Ch. 2 - What is the most important difference between a...Ch. 2 - List several product costs incurred in the...Ch. 2 - Prob. 5RQCh. 2 - Why is the cost of idle time treated as...Ch. 2 - Explain why an overtime premium is included in...Ch. 2 - Prob. 8RQCh. 2 - Give examples to illustrate how the city of Tampa...Ch. 2 - Distinguish between fixed costs and variable...
Ch. 2 - How does the fixed cost per unit change as the...Ch. 2 - Prob. 12RQCh. 2 - Distinguish between volume-based and...Ch. 2 - Would each of the following characteristics be a...Ch. 2 - List three direct costs of the food and beverage...Ch. 2 - List three costs that are likely to be...Ch. 2 - Which of the following costs are likely to be...Ch. 2 - Distinguish between out-of-pocket costs and...Ch. 2 - Define the terms sunk cost and differential cost.Ch. 2 - Distinguish between marginal and average costs.Ch. 2 - Prob. 21RQCh. 2 - Two years ago the manager of a large department...Ch. 2 - Indicate whether each of the following costs is a...Ch. 2 - For each case below, find the missing amount.Ch. 2 - A foundry employee worked a normal 40-hour shift,...Ch. 2 - A loom operator in a textiles factory earns 16 per...Ch. 2 - Consider the following costs that were incurred...Ch. 2 - Alexandria Aluminum Company, a manufacturer of...Ch. 2 - Prob. 30ECh. 2 - A hotel pays the phone company 100 per month plus...Ch. 2 - Prob. 32ECh. 2 - Orbital Communications, Inc. manufactures...Ch. 2 - The state Department of Education owns a computer...Ch. 2 - Prob. 35ECh. 2 - List the costs that would likely be included in...Ch. 2 - Consider the following cost items: 1. Salaries of...Ch. 2 - The following selected information was extracted...Ch. 2 - Prob. 39PCh. 2 - Mason Corporation began operations at the...Ch. 2 - Determine the missing amounts in each of the...Ch. 2 - The following cost data for the year just ended...Ch. 2 - The following data refer to San Fernando Fashions...Ch. 2 - Highlander Cutlery manufactures kitchen knives....Ch. 2 - Cape Cod Shirt Shop manufactures T-shirts and...Ch. 2 - Heartland Airways operates commuter flights in...Ch. 2 - San Diego Sheet Metal, Inc. incurs a variable cost...Ch. 2 - Hightide Upholstery Company manufactures a special...Ch. 2 - For each of the following costs, indicate whether...Ch. 2 - Indicate for each of the following costs whether...Ch. 2 - Water Technology, Inc. incurred the following...Ch. 2 - The following terms are used to describe various...Ch. 2 - Several costs incurred by Bayview Hotel and...Ch. 2 - Refer to Exhibit 23, and answer the following...Ch. 2 - Roberta Coy makes custom mooring covers for boats....Ch. 2 - The Department of Natural Resources is responsible...Ch. 2 - Prob. 57PCh. 2 - Prob. 58PCh. 2 - CompTech, Inc. manufactures printers for use with...Ch. 2 - You just started a summer internship with the...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- W. W. Phillips Company produced 4,000 leather recliners during the year. These recliners sell for $400 each. Phillips had 500 recliners in finished goods inventory at the beginning of the year. At the end of the year, there were 700 recliners in finished goods inventory. Phillips’ accounting records provide the following information: Purchases of raw materials $320,000 Beginning materials inventory 46,800 Ending materials inventory 66,800 Direct labor 200,000 Indirect labor 40,000 Rent, factory building 42,000 Depreciation, factory equipment 60,000 Utilities, factory 11,900 Salary, sales supervisor 90,000 Commissions, salespersons 180,000 General administration 300,000 Beginning work-in-process inventory 13,040 Ending work-in-process inventory 14,940 Beginning finished goods inventory 80,000 Ending finished goods inventory 114,100 Required: 1. Prepare a statement of cost of goods manufactured. 2. Compute the average cost of producing…arrow_forwardABC manufacturing company begins the period with $5 in Materials Inventory, $15 in Work-in-Process Inventory, and $10 in Finished Goods Inventory. During the period, it purchases $50 of materials, uses $55 of materials and $70 of direct labour, and spends $90 for factory overhead. During the period, the inventory of work in process are increasing into $20, and inventory of finished goods are stagnant ($10). Manufacturing firm has $290 sales and $50 of selling expense for the manufacturing firm. Create Cost of Goods Manufactured Statement and Income Statement.arrow_forwardKelvin Industries is calculating its Cost of Goods Manufactured at year-end. The company's accounting records show the following: The Raw Materials Inventory account had a beginning balance of $16,000 and an ending balance of $21,000. During the year, the company purchased $51,000 of direct materials. Direct labor for the year totaled $125,000, while manufacturing overhead amounted to $152,000. The Work in Process Inventory account had a beginning balance of $24,000 and an ending balance of $23,000. Assume that Raw Materials Inventory contains only direct materials. Compute the Cost of Goods Manufactured for the year. (Hint: The first step is to calculate the direct materials used during the year.) Start by calculating the direct materials used during the year. Kelvin Industries Calculation of Direct Materials Used For Current Year Plus: Less: Direct materials used iarrow_forward
- Olson manufactures a single product and sells it for $10 per unit. At the beginning of the year there were 1,000 units in inventory. Upon further investigation, you discover that units produced last year had $3.00 of fixed manufacturing cost and $2.00 of variable manufacturing cost. During the year Olson produced 10,000 units of product. Each unit produced generated $3.00 of variable manufacturing cost. Total fixed manufacturing cost for the current year was $40,000. There were no inventories at the end of the year. This current year Absorption Costing Net Income is Select one: a. $36,000 b. $35,000 c. $37,000 d. $38,000arrow_forwardHawthorn Industries is calculating its Cost of Goods Manufactured at year-end. The company's accounting records show the following: The Raw Materials Inventory account had a beginning balance of $12,000 and an ending balance of $17,000. During the year, the company purchased $63,000 of direct materials. Direct labor for the year totaled $135,000, while manufacturing overhead amounted to $156,000. The Work in Process Inventory account had a beginning balance of $21,000 and an ending balance of $19,000. Assume that Raw Materials Inventory contains only direct materials. Compute the Cost of Goods Manufactured for the year. (Hint: The first step is to calculate the direct materials used during the year.) Start by calculating the direct materials used during the year. Hawthorn Industries Calculation of Direct Materials Used For Current Year Plus: Less: Direct materials usedarrow_forwardKenzi, a manufacturer of kayaks, began operations this year. During this year, the company produced 1,050 kayaks and sold 800 at a price of $1,050 each. At year-end, the company reported the following income statement information using absorption costing. Sales (800 × $1,050) $ 840,000 Cost of goods sold (800 × $450) 360,000 Gross profit 480,000 Selling and administrative expenses 220,000 Income $ 260,000 Additional Information a. Product cost per kayak under absorption costing totals $450, which consists of $350 in direct materials, direct labor, and variable overhead costs and $100 in fixed overhead cost. Fixed overhead of $100 per unit is based on $105,000 of fixed overhead per year divided by 1,050 kayaks produced.b. The $220,000 in selling and administrative expenses consists of $85,000 that is variable and $135,000 that is fixed.Prepare an income statement for the current year under variable costing.arrow_forward
- During its first year of operations, Silverman Company paid $10,385 for direct materials and $11,400 for production workers' wages. Lease payments and utilities on the production facilities amounted to $10,400 while general, selling, and administrative expenses totaled $3,100. The company produced 7,850 units and sold 4,900 units at a price of $6.60 a unit. What was Silverman's net income for the first year in operation? Multiple Choice $21.940 O $10.555 50350 $29.240arrow_forwardRene Inc. has capacity to produce 15,000 units of inventory. It operated at capacity during the second quarter of the current year and provided the following cost data: Cost Data Accounts Amounts Production costs (15,000 units): - Direct materials $150,000 Direct labor 180,000 Variable manufacturing overhead 120,000 Fixed manufacturing overhead 45,000 Total production costs $495,000 Operating expenses: - Variable operating expenses $60,000 Fixed operating expenses 40,000 Total operating expenses $100,000 There was no inventory on hand at the beginning of the quarter. 2,000 units remained unsold at the end of the quarter. The COGS to be reported on the income statement for the second quarter under absorption costing method is: Group of answer choices $429,000 $515,667.67 $442,000 $390,000arrow_forwardHawthorn Industries is calculating its Cost of Goods Manufactured at year-end. The company's accounting records show the following: The Raw Materials Inventory account had a beginning balance of $18,000 and an ending balance of $16,000. During the year, the company purchased $66,000 of direct materials. Direct labor for the year totaled $120,000, while manufacturing overhead amounted to $161,000. The Work in Process Inventory account had a beginning balance of $30,000 and an ending balance of $19,000. Assume that Raw Materials Inventory contains only direct materials. Compute the Cost of Goods Manufactured for the year. (Hint: The first step is to calculate the direct materials used during the year.) Start by calculating the direct materials used during the year. Hawthorn Industries Calculation of Direct Materials Used For Current Year Beginning raw materials inventory Plus: Purchases of direct materials Materials available for use Less: Ending raw materials inventory Direct materials…arrow_forward
- Product ) is one of the many products manufactured and sold by Oceanside Company. An income statement by product line for the past year indicated a net profit for Product J of $2,750. This net profit resulted from sales of $275,000, cost of goods sold of $186,500, and operating expenses of $85,750. It is estimated that 30% of the cost of goods sold represents fixed factory overhead costs and that 40% of the operating expense is fixed. If Product J is retained, the revenue, costs, and expenses are not expected to change significantly from those of the current year. Because of the large number of products manufactured, the total fixed costs and expenses are not expected to decline significantly Product J is discontinued. Prepare a differential analysis report dated February 8 of the current year. If an amount is zero, enter "0". If required, use a minus sign to indicate a loss. Differential Analysis Continue (Alternative 1) or Discontinue (Alternative 2) Product J February 8 Line Item…arrow_forwardA condensed income statement by product line for Warrick Beverage Inc. indicated the following for Mango Cola for the past year: Sales $237,400 Cost of goods sold (112,000) Gross profit $125,400 Operating expenses (146,000) Operating loss $(20,600) It is estimated that 14% of the cost of goods sold represents fixed factory overhead costs and that 19% of the operating expenses are fixed. Because Mango Cola is only one of many products, the fixed costs will not be materially affected if the product is discontinued. a. Prepare a differential analysis dated February 29 to determine whether Mango Cola should be continued (Alternative 1) or discontinued (Alternative 2). If an amount is zero, enter "0". If required, use a minus sign to indicate a loss. Differential Analysis Continue (Alt. 1) or Discontinue (Alt. 2) Mango Cola February 29 Continue Discontinue Differential Effects (Alternative 1) (Alternative 2) (Alternative 2) Mango Cola Mango Cola Revenues Costs: Variable cost of goods sold…arrow_forwardBenson Manufacturing Company produced 3,000 units of inventory in January Year 2. It expects to produce an additional 9,800 units during the remaining 11 months of the year. In other words, total production for Year 2 is estimated to be 12,800 units. Direct materials and direct labor costs are $71 and $53 per unit, respectively. Benson expects to incur the following manufacturing overhead costs during the Year 2 accounting period. Production supplies Supervisor salary Depreciation on equipment Utilities Rental fee on manufacturing facilities Required $ 5,800 182,000 135,000 33,000 332,200 a. Combine the individual overhead costs into a cost pool and calculate a predetermined overhead rate assuming the cost driver is number of units. b. Determine the cost of the 3,000 units of product made in January.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Job Costing and Spoilage | Topic 2 | Spoilage, Re-work, and Scrap; Author: Samantha Taylor;https://www.youtube.com/watch?v=VP55_W2oXic;License: CC-BY