Exercise 5-11 (Algo) Missing Data; Basic CVP Concepts [LO5-1, LO5-9] Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that only one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Units sold Sales Variable expenses Fixed expenses Net operating income (loss) Contribution margin per unit Case 1 Case 2 Case 3 Case 4 9,000 19,700 $ 315,000 $ 144,000 351,000 $ 5,800 185,600 197,000 91,000 173,000 87,000 $ $ 61,000 $ 18 $ 157,400 $ (17,400) 12 < Required A Required B >

Exercise 5-11 (Algo) Missing Data; Basic CVP Concepts [LO5-1, LO5-9] Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. Required: a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: Complete this question by entering your answers in the tabs below. Required A Required B Assume that only one product is being sold in each of the four following case situations: (Loss amounts should be indicated by a minus sign.) Units sold Sales Variable expenses Fixed expenses Net operating income (loss) Contribution margin per unit Case 1 Case 2 Case 3 Case 4 9,000 19,700 $ 315,000 $ 144,000 351,000 $ 5,800 185,600 197,000 91,000 173,000 87,000 $ $ 61,000 $ 18 $ 157,400 $ (17,400) 12 < Required A Required B >

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter19: Variable Costing (varcost)

Section: Chapter Questions

Problem 5R: Click the Chart sheet tab. This chart is based on the problem data and the two income statements....

See similar textbooks

Similar questions

Answer complete question please please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image) The Foundational 15 (Algo) [LO11-2, LO11-3, LO11-4, LO11-5, LO11-6] Skip to question [The following information applies to the questions displayed below.] Cane Company manufactures two products called Alpha and Beta that sell for $175 and $135, respectively. Each product uses only one type of raw material that costs $5 per pound. The company has the capacity to annually produce 117,000 units of each product. Its average cost per unit for each product at this level of activity are given below: Alpha Beta Direct materials $ 40 $ 15 Direct labor 30 30 Variable manufacturing overhead 18 16 Traceable fixed manufacturing overhead 26 29 Variable selling expenses 23 19 Common fixed expenses 26 21 Total cost per unit $ 163 $…
Ma1. Question 11. Which of the following is not a catetory found in the Content Pane of Dynamics GP? Options: A.Cards B.Inquiry C.Print D.Reports Question 12. The typical size of a business that is most likely to use MS Dynamics GP is options: A.Fewer than 50 employees B.250-500 employees C.2500 - 5000 employees D.More than 5000 employees Question 13. Which of the following features allows you to view information about a customer and then begin entering an invoice for that customer? options: A.Lists B.Reports C.Inquiry D.SmartLists Question 14. Which of the following statements is not true regarding the Navigation Pane? options: A.You can choose not to show specific series/functions on the Navigation Pane B.You can change the order in which series/function areas appear on the Navigation Pane C.If you hide a series/function so it doesn’t appear on the Navigation Pane, it is removed from your Dynamics GP system D.It can be hidden in order to make the Content area larger…
Click the Chart sheet tab. This chart is based on the problem data and the two income statements. Answer the following questions about the chart: a. What is the title for the X-axis? b. What is the title for the Y-axis? c. What does data range A represent? d. What does data range B represent? e. Why do the two data ranges cross? f. What would be a good title for this chart? When the assignment is complete, close the file without saving it again. Worksheet. The VARCOST2 worksheet is capable of calculating variable and absorption income when unit sales are equal to or less than production. An equally common situation (that this worksheet cannot handle) is when beginning inventory is present and sales volume exceeds production volume. Revise the worksheet Data Section to include: Also, change actual production to 70,000. Revise the Answer Section to accommodate this new data. Assume that Anderjak uses the weighted-average costing method for inventory. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as VARCOSTT. Check figure: Absorption income, 670,000. Chart. Using the VARCOST2 file, fix up the chart used in requirement 5 by adding appropriate titles and legends and formatting the X- and Y-axes. Enter your name somewhere on the chart. Save the file again as VARCOST2. Print the chart.
A 12 Compute the ROI 13 Margin 14 Turnover 15 ROI 16 1 Chapter 10: Applying Excel 2 3 Data 4 Sales 5 6 Average operating assets 7 Minimum required rate of return 8 9 Enter a formula into each of the cells marked with a ? below 10 Review Problem: Return on Investment (ROI) and Residual Income 11 Net operating income 17 Compute the residual income 18 Average operating assets 22 23 24 25 26 27 28 29 30 31 32 33 34 19 Net operating income 20 Minimum required return 21 Residual income Chapter 10 Form B + $25,000,000 $3,000,000 $10,000,000 25% ? ? ? C ? ? ? ? D E F G H | J K L
ag2 of 16)- Google Chronme edu.om/mod/quiz/attempt.php?attempt=D18933338&cmid%3D891193&page=D1 NING SYSTEM (ACADEMIC) gerial Accounting - Spring21 Time left 1:53:58 When performing sales mix analysis, which one of the following is true: The sales mix is usually assumed to change. O b. Normally the calculation of the breakeven point for multiproduct is much simpler than that for a single product. O c. Making changes to the sales mix will likely cause no change in the breakeven point O d. Shifting the sales mix to the product with a lower contribution maigin will likely increase the overall contribution margin O e. Producing and selling more units of the product with a higher contribution margin would likely decrease the breakeven point Which of the following statements related to CVP chart is not true? O a. None of the given answers. O b. The slope of the total cost line determines the variable cost per unit. Oc. The high-low method is a way to estimate the cost behavior by graphically…
Problem 3. Calculate the PW and IRR of this transaction. At the given MARR is this a good purchase? Please workout in excel spreadsheet.
Previous parts have been answered already with this note ''NOTE = AS YOUR QUESTION HAVE MULTIPLE PARTS SO I AM ABLE TO SOLVE FIRST THREE PARTS OF THE QUESTION IF YOU WANT REMAINING PARTS THAN PLEASE RE-POST THE QUESTION AGAIN WITH THAT PART . THANK YOU.'' Solve the below problem with the help of required ratio formulas and comment on the company’s position.
Match the pattern of development in column A to the transitional device in column B. Write only the letter of your choice on the space provided 1. Cause and effect 2. Spatial 3. Chronology 4. Classification 5. Comparison 6. Contrast 7. Definition B. Persuasion 9. Problem-solution 10. Exemplification a. arguably b.as defined c. away from d. by e. consequently f. even though g. in a similar fashion h. meanwhile i.the next category J. to illustrate
Compute the dollar value of each missing item as indicated by A thru E below. Each horizontal line of numbers is a separate problem. Therefore, only use the first horizontal line of numbers when calculating the answers for A,B,and C, and only use the second line of horizontal numbers when calculating your answers for D and E. Each horizontal line of information is separate and distinct from the other horizontal line of numbers. First horizontal line of numbers ( Use the first row of numbers below to solve for A,B,and C ) Sales Beginning Net cost of Ending COGS Gross Operating Net Income Inventory purchases Inventory Margin expenses or net loss $250,000 A $70,000 $20,000 B $80,000 C $24,000 --------------------------------- ---------------------------------------------------------------------------------------- Second…
* CengageNOWv2 |x C Power Serve Comp. X ilm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentScssionLocator &inprogress=false eBook Calculator Print Item The conderised pruduct-line income statement for Rhinebeck Company for the month of October is as follows: Rhinebeck Company Product-Line Income Statement For the Month Ended October 31 Hats Gloves Mufflers Sales $65,800 $88,500 $27,600 Cost of goods sold (25,800) (32,100) (13,800) Gross profit $40,000 $56,400 $13,800 Selling and administrative expenses (29,000) (34,500) (14,500) $11,000 $21,900 $(700) Operating incorne (loss) Fixed costs are 12% of the cost of goods sold and 36% of the selling and administrative expenses. Rhinebeck Company assunes that fixed costs would not be materially affecter discontinued. a. Prepare a differential analysis dated October 31 to determine if Mufflers should be continued (Alternative 1) or discontiriued (Alternative 2). If an amount is zero, enter "0 indicate a loss. Differential Analysis…
mpt=17649928cmid=8751838page=D9 wio a https//alternativet A SQUCOFFEE - Goog A BCOM2911-Busines O Sultan Caboos Univ. G Trading Platform C. Accounting Club DEMIC) E-LEARNING SERVICES- SQU LIBRARIES - SQU PORTAL ATTENDANCE Time left 1:46:33 An allocation base: O a can be units of output if the company has a single product O b. All the given answers are NOT correct. Oc is determined at the end of the period. O d. isameasure used to assign conversion costs to products and services O e isameasure used to assign prime costs to products and services ר A Company uses job order costing and has chosen direct labor hours to allocate its manufacturing overhead. The company estimates that total direct labor hours to be operated next year are 250,000 hours. The estimated variable overhead is $15 per hour and the estimated fixed overhead costs are $750,000. The predetermined overhead rate is: O a $6 O b. None of the answers given Oc $45 Od. $3 Oe $18 NEXT PAGE OUS PAGE ACCT2121 general-chat Origin…
How would you interpret this formula: 'Income Statement' ! C5 Ocell C5 from the Income Statement named cell in the current work sheet O cell C5 from the Income Statement tab in the work book O cell C5 from the named range of Income Statement in the file name cell from the file named Income Statement that is copied to C5