MANAGERIAL ACCT.F/MANAGERS>CUSTOM<
4th Edition
ISBN: 9781307090147
Author: Noreen
Publisher: MCG/CREATE
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 2, Problem 1AE
To determine
Concept Introduction:
Gross Margin- Gross Margin is the profit determined by subtracting the cost of goods sold from the sales generated in a given period.
To compute: The amount of gross margin and whether it changed and reason for the same.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Please don't forget to check your worksheet by changing the units sold in the Data to 6,000 for Year 2 before submitting the response to my question. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn’t, check cell C41. The formula in this cell should be =IF(C26<C27,C26*C36+(C27-C26)*B36,C27*C36).] If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $(34,000) for Year 2. That is, the loss in Year 2 is $34,000 under both methods. If you do not get these answers, find the errors in your worksheet and correct them. Assume that the units produced in year 2 were sold first.
ALSO PLEASE INCLUDE THE EXCEL FORMULAS!! Thanks!!
If someone can help I will give a thumbs up. Thanks for the help! :)
Please don't forget to check your worksheet by changing the units sold in the Data to 6,000 for Year 2 before submitting the response to my question. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn’t, check cell C41. The formula in this cell should be =IF(C26<C27,C26*C36+(C27-C26)*B36,C27*C36).] If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $(34,000) for Year 2. That is, the loss in Year 2 is $34,000 under both methods. If you do not get these answers, find the errors in your worksheet and correct them. Assume that the units produced in year 2 were sold first.
If someone can help I will give a thumbs up. Thanks for the help! :)
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?
Chapter 2 Solutions
MANAGERIAL ACCT.F/MANAGERS>CUSTOM<
Ch. 2 - Prob. 2.1QCh. 2 - Prob. 2.2QCh. 2 - Prob. 2.3QCh. 2 - Prob. 2.4QCh. 2 - Prob. 2.5QCh. 2 - Prob. 2.6QCh. 2 - Prob. 2.7QCh. 2 - Prob. 2.8QCh. 2 - Prob. 2.9QCh. 2 - Prob. 2.10Q
Ch. 2 - Prob. 2.11QCh. 2 - Give the general formula for a mixed cost. Which...Ch. 2 - What is meant by the term least-squares...Ch. 2 - Prob. 2.14QCh. 2 - Prob. 2.15QCh. 2 - Prob. 2.16QCh. 2 - Prob. 2.17QCh. 2 - Prob. 1AECh. 2 - Prob. 1TF15Ch. 2 - Prob. 2.1ECh. 2 - Prob. 2.2ECh. 2 - Prob. 2.3ECh. 2 - Prob. 2.4ECh. 2 - High-Low Method (LO 2-5) The Cheyenne Hotel in Big...Ch. 2 - Prob. 2.6ECh. 2 - Prob. 2.7ECh. 2 - Cost Behavior; High-Low Method [LO 2-4, LO 2-5]...Ch. 2 - Cost Terminology for Manufacturers [LO 2-2, LO...Ch. 2 - Prob. 2.10ECh. 2 - Prob. 2.12ECh. 2 - Prob. 2.13ECh. 2 - Prob. 2.15ECh. 2 - Cost Behavior; High-Low Method; Contribution...Ch. 2 - High-Low Method; Predicting Cost [LO 2-4, LO 2-5]...Ch. 2 - Prob. 2.18PCh. 2 - Prob. 2.19PCh. 2 - High-Low Method; Predicting Cost [LO 2-4, LO 2-5]...Ch. 2 - Prob. 2.21PCh. 2 - High-Low Method; Contribution Format Income...Ch. 2 - Scattergraph Analysis; Selection of an Activity...
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
- PLEASE INCLUDE THE EXCEL FORMULAS!! Thanks!! Please don't forget to check your worksheet by changing the units sold in the Data to 6,000 for Year 2 before submitting the response to my question. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn’t, check cell C41. The formula in this cell should be =IF(C26<C27,C26*C36+(C27-C26)*B36,C27*C36).] If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $(34,000) for Year 2. That is, the loss in Year 2 is $34,000 under both methods. If you do not get these answers, find the errors in your worksheet and correct them. Assume that the units produced in year 2 were sold first. If someone can help I will give a thumbs up. Thanks for the help! :)arrow_forwardYou are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file. In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price. Customer ID: 68YJW Prices: Regular $26.95 Customer Name Reggie Greene Preferred $21.95 Preferred? Y/N: Yes Customer Pricearrow_forwardZiegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 97,500 $27,165,000 112,500 29,715,000 124,500 31,755,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Determine the variable cost per unit and the total fixed cost. Round your answer for variable cost to the nearest cent. Round your answer for total fixed costs to the nearest dollar. Variable cost: $fill in the blank 2 per unit Total fixed cost: $fill in the blank 3 Based on part (a), estimate the total cost for 80,000 units of production. Round your answer to the nearest dollar. Total cost for 80,000 units: $fill in the blank 4arrow_forward
- My formular function was wrong in cell C5 in contribution sheet. Please give me the right solution. Instruction: Enter a SUMIFS function into cell C5 on the Contribution worksheet that sums the Sales Revenue on the Sales and Cost Data worksheet based on the year that is entered into cell B1 on the Contribution worksheet. The data to be summed is in Column E on the Sales and Cost Data worksheet. The function should find a match in the Year column on the Sales and Cost Data worksheet to the year entered in cell B. The function should also find a match to the item in cell A5 (Sales Revenue) in Column C on the Sales and Cost Data worksheet. Add cell capacity to include Row 100 on the Sales and Cost Data worksheet.arrow_forwardYou are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file. In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price.= Answer ( Answer = "Yes" , Answer , Answer ) As an alternative, you could also use this logic to get the same results:When preferred status is No, the price is the regular price. Otherwise the price is the preferred price.= Answer ( Answer = "No" , Answer , Answer ) Note that these problems use short answer text boxes, and therefore can include any characters (not just numbers). Customer ID: 68YJW Prices: Regular $26.95 Customer Name Reggie Greene Preferred $21.95 Preferred? Y/N: Yes Customer Pricearrow_forwardYou want to add a new Product and Services entry to your client's QuickBooks Online company. The service is installation of a server that doesn't include the cost of the hardware. Here are some steps for getting the job done. 1. Select the Gear icon, select Products and Services, then select New2. _____________________________________________3. In the Name field, type Server installation4. In the Sales information field, type Server installation5. Sale price/rate is $12506. In the Income Account drop-down, select Service/Fee Income7. Select Save and close Which option correctly completes Step 2? A. Select Product B. Select Inventory C. Select Service D. Select Non-inventory E. Select Bundlearrow_forward
- Carolina Yachts builds custom yachts in its production factory in South Carolina. Once complete, these yachts must be shipped to the dealership. They have collected this shipping cost data: Prepare a scatter graph of the shipping data. Plot cost on the vertical axis and yachts shipped on the horizontal axis. Is the relationship between shipping costs and unit shipped approximately linear? Draw a straight line through the scatter graph. Using the high-low method, create the cost formula for Carolina Yachts shipping costs. The least-squares regression method was used and the analysis resulted in this cost equation: Y= 4,000+ 1,275x. Comment on the accuracy of your high-low method estimation. What would you estimate shipping costs to be if Carolina Yachts shipped 10 yachts in a single month? Use the cost formula you obtained in part B. Comment on how accurately this is reflected by the scatter graph you constructed. What factors other than number of yachts shipped do you think could affect Carolina Yachts shipping expense? Explain.arrow_forwardDirections Below is information for Blue Company. Using this information, answer the following questions on the "Calculation" tab in the file. Show your work (how you got your answer) and format appropriately. Blue company has prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 to 1,500 units): Sales $ 20,000 Variable expenses 12,000 Contribution margin 8,000 NOTE: Use the amounts in the original fact pattern to the left as your basis for the questions below. Fixed expenses 6,000 Net operating income $ 2,000 Questions:…arrow_forwardSuppose you are the purchasing manager for a company that manufactures scanners and other computer peripherals. Your vendor for scanner motors is now offering "quantity discounts" in the form of instant rebates and lower shipping charges as follows. Quantity Net Price Rebate Shipping 1–500 motors $16 none $1.50 501–1,000 motors 16 $1.30 1.10 1,001–2,000 motors 16 1.90 0.80 (a) Calculate the cost of the motors, including shipping charges, for each category (in $). 1–500 motors$ 501–1,000 motors$ 1,001–2,000 motors$ (b) If you usually purchase 400 motors per month, what percent would be saved per motor by ordering 800 every two months? Round to the nearest tenth of a percent. % (c) What percent would be saved per motor by ordering 1,200 every three months? Round to the nearest tenth of a percent. % (d) How much money (in $) can be saved in a year by purchasing the motors every three months instead of every month? $ (e) What other factors besides price…arrow_forward
- How difficult is it to expand the original RedBrandmodel? Answer this by adding a new plant, two newwarehouses, and three new customers, and modify thespreadsheet model appropriately. You can make up therequired input data.arrow_forwardThe production department is proposing the purchase of an automatic insertion machine. It has identified three machines and has asked the accountant to analyze them to determine which one has the best average rate of return. Line Item Description Machine A Machine B Machine C Estimated average income $47,060.44 $72,961.50 $73,785.60 Average investment 336,146.00 243,205.00 491,904.00 a. Machine C b. Machine A c. Machines B and C have the same preferred average rate of return. d. Machine Barrow_forwardell Computer incurs the following costs: LOADING... (Click the icon to view the costs.) Requirement Classify each of the cost items (a-h) into one of the business functions of the value chain. Cost Item Value Chain Business Function a. Utility costs for the plant assembling the Latitude computer line of products b. Distribution costs for shipping the Latitude line of products to a retail chain c. Payment to David Newbury Designs for design of the XPS 2-in-1 laptop d. Salary of computer scientist working on the next generation of servers e. Cost of Dell employees' visit to a major customer to demonstrate Dell'sarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
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