Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 19, Problem 4R
To determine the effect of different levels of production on the company’s income, move to cell B7 (Actual production). Change the number in B7 to the different production levels given in the table below. The first level, 100,000, is the current level. What happens to the operating income on both statements as production levels change? Enter the operating incomes in the following table.
Does the level of production affect income under either costing method? Explain your findings.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The following information relates to CEE Company: (Refer to image). Assume that the company uses the average cost approach. What is the cost ratio? Express your answer in percentage and round up to two decimal points.
The following diagram is a cost-volume-profit graph for a manufacturing company:
^
O
Volume
с
Select the answer that best describes the labeled item on the diagram.
A. Area CDE represents the area of net loss.
B. Line AC graphs total fixed costs.
C. Point D represents a point at which the profit is greater than zero.
D. Line AC graphs total costs.
Based on the image below for a manufacturing company, the correct statement is
A. line b graphs total fixed costs
B. point c represents the point at which the marginal contribution per unit increases
C. line d graphs total costs
D. area e (between lines b and d) represents the contribution margin
Chapter 19 Solutions
Excel Applications for Accounting Principles
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
- How is operating income affected if the number of units sold exceeds the number of units produced? Select one: a. Operating income would be higher under a variable costing income statement. b. Operating income would be lower under a variable costing income statement. c. Operating income would be higher under an absorption costing income statement. d. Operating income would be the same under both a variable costing and absorption costing income PreviousSave AnswersNextarrow_forwardUsing the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2. Determine the cost to be charged to the product for the year. 3. Determine the cost to be charged to factory overhead for the year. 4. Determine the plotted data points using Chart Wizard. 5. Determine R2. 6. How do these solutions compare to the solutions in P4-2 and P4-3? 7. What does R2 tell you about this cost model?arrow_forwardThe cost behavior patterns below are lettered A through H. The vertical axes of the graphs represent total dollars of expense, and the horizontal axes represent production in units, machine hours, or direct labor hours. In each case, the zero point is at the intersection of the two axes. Each graph may be used no more than once. Required: Select the graph that matches the lettered cost described here. a. Depreciation of equipmentthe amount of depreciation charged is computed based on the number of machine hours that the equipment was operated. b. Electricity billflat fixed charge, plus a variable cost after a certain number of kilowatt hours are used. c. City water billcomputed as follows: d. Depreciation of equipmentthe amount is computed by the straight-line method. e. Rent on a factory building donated by the citythe agreement calls for a fixed fee payment, unless 200,000 labor hours are worked, in which case no rent need be paid. f. Salaries of repair workersone repair worker is needed for every 1,000 machine hours or less (i.e., 0 to 1,000 hours requires one repair worker, 1,001 to 2,000 hours requires two repair workers, etc.).arrow_forward
- In the variable costing income statement, how are the fixed manufacturing costs reported, and how are the fixed selling and administrative expenses reported?arrow_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. ( Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.)a. Assume that only one product is being sold in each of the four following case situations:Contribution Net OperatingUnits Variable Margin Fixed IncomeCase Sold Sales Expenses per Unit Expenses (Loss)1 .......... 15,000 $180,000 $120,000 ? $50,000 ?2 .......... ? $100,000 ? $10 $32,000 $8,0003 .......... 10,000 ? $70,000 $13 ? $12,0004 .......... 6,000 $300,000 ? ? $100,000 $(10,000)arrow_forwardDescribe how total variable costs and unit variable costs behave with changes in the level of activity. Describe the behavior of (a) total fixed costs and (b) unit fixed costs as the level of activity increases. In applying the high-low method of cost estimation, how is the total fixed cost estimated? An examination of the accounting records of Larredo Company disclosed a high contribution margin ratio and production at a level below maximum capacity. Based on this information, suggest a likely means of improving operating income. If the unit cost of direct materials is decreased, what effect will this change have on the break-even point? What does operating leverage measure, and how is it computed?arrow_forward
- Kindly answer all questions: 1.) Cost behavior is considered linear whenever a straight line is a reasonable approximation for the relation between cost and activity. A. True B. False 2.) Which of the following is an example of a cost that is variable with respect to the number of units produced? A. rent on administrative office building B. rent on factory building C. Salaries of top marketing executives D. direct labor cost, where the direct labor force is adjusted to actual production of the period 3.) Fixed costs are constant in total amount over the relevant range of operations. A. True B. False 4.) The cost function derived by the simple least squares method: A. must be tested for minimum and maximum points. B. is parabolic. C. is linear. D. is curvilinear.arrow_forwardFill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Fixed expenses Operating income (loss) Contribution margin per unit Sales Variable expenses Fixed expenses $ Operating income (loss) Average contribution margin (percentage) Case #1 20,100 241,200 $ 160,800 67,000 $ Case #2 S $ $ Case #1 134,000 42,880 10,720 S 10 S 8,700 20% b. Assume that more than one product is being sold in each of the following four case situations. (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) 534,000 $ Case #3 Case #2 13,400 434,000 282,100 108,500 93,800 Case #4 8,040 S 402,000…arrow_forwardFill in the missing amounts in each of the eight case situations below. Each case Is Independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format Income statement for each case, enter the known data, and then compute the missing items.) Required: a. Assume that only one product is being sold in each of the following four case situations: Unit sold Sales Variable expenses Fixed expenses Operating income (loss) Contribution margin per unit Sales Variable expenses Fixed expenses $ Operating income (loss) Average contribution margin (percentage) Case #1 20,400 244,800 163,200 68,000 $ $ 136,000 $ 10 Case #2 $ Case #1 536,000 43,520 10.880 $ 8,800 20% 10 $ 69 Case #3 Case #2 13,600 b. Assume that more than one product is being sold in each of the following four case situations: (Enter "Contribution margin ratio" in percent. Round your final answers to the nearest whole dollar amount.) 436.000 283.400 109.000 95,200 16,320 13 $ S CA Case #4…arrow_forward
- Baxter Corporation has been using FIFO during a period ofrising costs. Explain whether you would expect each of the following measurements to be higher or lower if the com-pany had been using LIFO. a. Net income.b. Inventory turnover rate.c. Income taxes expense.arrow_forwardAn analyst is constructing a simple model to determine the gross and net profit of a product, given its profit per unit, quantity sold, and the total costs assigned to the product. The calculation for gross profit is Profit per Unit times Quantity. The calculation for Net Profit is Gross Profit minus Total Costs. A B 1. 2 Profit per Unit 8 3 Quantity |10,100 4 Gross Profit 5 6 Total Costs 6,100 7 8 Net Profit With the values for Profit per Unit, Quantity, and Total Costs shown above, what should the model return for the following calculated cells? Cell Value Gross Profit Net Profitarrow_forwardWhat are the Costs per unit of Alfa and Beta under traditional and ABC costing systems? What would be the prices of Alpha and Beta traditional and ABC costing systems? Compare the costs and prices calculated in the two systems. Please write down the calculation process!thanks!!!arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license