please explain your answer 12Stanley Manufacturing Company, which sold 16,000 units of product at $20 per unit, collected thefollowing information regarding three different levels of production.16,000 $34Required5a. Complete the spreadsheet below.678910Spreadsheet TipExplore the power of formulas by copying cells A10:D29 and cell H2 into the scratchpad area below.There you will be able to modify the given information (currently in cells B11:D12, B14:D14 and H2)and see the resulting changes. You will need to modify any formulas in which you used a "$" to reflectthe new cell reference and the formulas for "Sales" to reference the new location of cell H2.11 Fixed Overhead12 Number of Units Produced13 Fixed Overhead Per UnitInventory Costs$ 100,000 $ 100,000 $ 100,00016,00020,00025,00014 Variable Manufacturing Costs12.0012.0012.0015 Full Absorption Production Cost Per Unit1617Absorption Income Statements18Level of Production19 Sales20Cost of Goods Sold21Gross Margin2223Variable Costing Income Statements24 Level of Production25 SalesVariable Cost of Goods SoldContribution Margin262728 Fixed Costs29Net Income302020

Answered: Image /qna-images/answer/1213331b-95e1-4314-9253-a4d57da24a3c.jpg

Answered: 1 2 Stanley Manufacturing Company,…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter25: Segment Income Statement (dept)

Section: Chapter Questions

Problem 2R

See similar textbooks

Similar questions

Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, "=84" was entered, the formula would output the result from cell B4. or 17.000 in this example. • Basle Math funetlons: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: (plus sign to add). - (minus sign to subtract). * (asterisk sign to multiply), and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=B19+B20" was entered, the formula would add the values from those cells and output the result, or 183,.800 in this example. If using the other math symbols the result would output an appropriate…
The Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining to the Magnetic Imaging Division of Medical Diagnostics, Inc. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form. You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the average operating assets in cell B6 to $8,000,000. The ROI should now be 38% arid the residual income should now be $1,000,000. If you do not get these answers, find the errors in your worksheet and correct them. Explain why the ROI and the residual income both increase when the average operating assets decrease. 2. Revise the data in your worksheet as follows: a. What is the ROI? b. What is the residual income? c. Explain the relationship between the ROI and the residual income?
Alanco, Inc. manufactures a variety of products and is currently manufacturing all of its own component parts. An outside supplier has offered to sell one of those components to Alanco. The Controller has asked you to help evaluate this offer to determine if the company should make or buy the component. Here are some tips for using Excel: • Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. Basic Math Functions: Allow you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add), - (minus sign to subtract), * (asterisk sign to multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. ●
The comparative financial statements of Global Technology are as follows: Open the file RATIOA from the website for this book at cengagebrain.com. Enter the formulas in the appropriate cells. Enter your name in cell A1. Save the completed model as RATIOA2. Print the worksheet when done. Also print your formulas. Check figure: Acid test (quick) ratio (cell C58), .82.
1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. A. XCountry Train Inc. specializes in trans-American moves for businesses and individuals through the delivery of containers. For every container the company loads on its trans-American rail, the business must pay the rail owners $8,000. In addition, containers are weighed and for each pound of weight, the company must pay $0.10. Harry plans to charge $0.50 per pound to his customers. How many pounds would a container have to hold in order for the company to Break Even?
Application Time! 1) You will type the TVM inputs in the table provided from the "Info Sheet". 2) Mirror the inputs from the "Info Sheet" to the TVM cells provided. 3) Within the TVM cells, if needed, compound. 4) In the "ANSWER" cell show us your TVM calculation. Goal 1: Opened an account with $1500, with the hope to have a total of $2500 saved in an LG2-Q8 emergency fund within one year (no additional payments). What would the quarterly interest rate be needed to reach this goal? Goal 2: A credit card balance of $2000 with an 15% rate. The goal is to pay off the credit card LG2-Q9 by the end of the year. (future is a $0 balance) What would be the monthly payment to reach this goal? Goal 3: Student loan balance of $18,000 at 6.5% and making $425 monthly payments. (future LG2-Q10 is a $0 balance) How many months will it take to complete this goal? in fuo (no Compounding Number (select from dropdown) 4 Compounding Number (select from dropdown) 12 Compounding Number (select from…
Your department receives an invoice dated October 10 and received on October 27 in the amount of $6,750. How much must be paid on November 10 it the terms are: 10/10 net 30 -5/10 EOM -3/10 ROG For the toolbar, press ALT+F10 (PC) or ALT-FN+F10 (Mac). BIYS Paragraph Arial AV I. Font Sizes 1 I x x, 8 T 11 田由田国田田回

When a company has post-acquisition expenditures related to Property, Plant, and Equipment it must determine whether the amount should be expensed as an ordinary repair or capitalized as a major repair, addition, or betterment. This requires considering the nature of the expenditure and the use of judgment. Many companies use a threshold amount. Any expenditure below the threshold is expensed. Items over the threshold are examined and a decision is made about whether to expense or capitalize the item. This approach is justified by both materiality and considering costs and benefits. For example, a company with $94 million in net property, plant, and equipment and $250 million of operating expenses would not consider a $100 repair as material. Plus, if the company had to spend thousands of dollars examining every repair expenditure, the costs of doing the analysis could easily outweigh the benefits. SouthEast Equipment has a large number of machines and equipment that are available for…
Swippy Software offers three software products: a word processing software, a spreadsheet software, and an accounting software. Information for the stand-alone selling prices and costs of its individual products is as follows: Stand-Alone Selling Price, Cost Word Processing (WP) $75 $18 Spreadsheet (SS) $90 $20 Accounting Software (AS) $65 $25 Recently, Swippy Software has begun offering software bundles, which includes all three programs at a discounted price. The bundle price for the software is $185.00 Using the unit cost as the weights, allocate the bundled price to the three programs using the stand-alone revenue-allocation method. Allocate the bundled price to the three types products using the incremental revenue-allocation method. Assume Spreadsheets is the primary product, followed by Word Processing, and then Accounting Software.
Instructions for Excel Spreadsheet Assignment #2Preliminary Setup InformationYour company manufactures and sells computer memory chips. You are part of the department whose job it is to figure out how many chips you should produce and sell. Let x represent the number (in millions) of chips that you plan to produce and sell. Your marketing department has figured out that if you produce x million chips then the selling price (in dollars) you must charge for each chip is given by the functionp(x) = 150-2x. Your production department has figured out that if you produce x million chips then the cost of production (in millions of dollars) will be given by the function C(x) = 50 + 40xYour tax department has figured out that you should expect to pay 10% tax on any profits. The tax (in millions of dollars) on a profit of y millions of dollars will be given by the functionT( y) = 0.1yExplanation of what you are to do on the Excel spreadsheetNOTE: You will not get credit for your work if you just…
ework i 370253A%252+%252Flms.mheducation.com%252Fmghmiddleware%252Fmheproducts%252 Saved Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not Required information [The following information applies to the questions displayed below.] Wardell Company purchased a minicomputer on January 1, 2022, at a cost of $56,000 The computer was depreciated using the straight-line method over an estimated five-year life with an estimated residual value of $8,000. On January 1, 2024, the estimate of useful life was changed to a total of 10 years, and the estimate of residual value was changed to $2,000. 2. Prepare the year-end journal entry for depreciation on December 31, 2024. Assume that the company uses the double-declining- balance method instead of the straight-line method. Note: If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Do not round intermediate calculations. Round…
p.mheducation.com/ext/map/index.html?_con=con&external_browser%3D0&launchUrl=https%253A%252F%252Flms.mhe D and P Indeed 6 Monster Jobs w Degree Programs O L02 A Hearn: Student Da.. 6 Consumer Center ework: Assignment 1 i Saved Perez Company reported the following operating results for two consecutive years: Required Compute each income statement component for each of the two years as a percentage of sales due to rounding. Round your percentage answers to 1 decimal place. (i.e., 0.234 should be e PEREZ COMPANY Vertical Analysis of Income Statements Percentage of Sales Percentage of Sales Year 4 Year 3 Sales 1,077,500 00S'000'L Cost of goods sold 550,275 000 Z09 Gross margin on sales 450,225 475,500 Operating expenses 130,500 149,800 319.725 325,700 Income before taxes 79.700 81,800 Income taxes 240.025 243.900 % Net income

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

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

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

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

SEE MORE TEXTBOOKS