Introduction to Managerial Accounting - Connect Access
8th Edition
ISBN: 9781260519020
Author: BREWER
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 3AE
To determine
Concept Introduction:
Contribution and Fixed and Variable Costs in Manufacturing
- Variable costs refer to the costs of manufacture that have a direct co-relation with the volume of the goods manufactured, i.e. the costs increase with an increase in the goods produced.
- Examples are costs of direct material and direct labor.
- Fixed costs refer to the costs of manufacture that have an inverse co-relation with the volume of the goods manufactured, i.e. the costs decrease with an increase in the goods produced.
- Examples are costs of factory rent,
depreciation on plant and equipment
Manufacturing costs are costs that are directly incurred in connection with manufacture of goods.
- Examples are Direct materials and Manufacturing Overhead
- Contribution is the difference between the Sales revenue and the Variable cost per unit. This is an indicator of the contribution of the goods manufactured to the profit and bottom line of the organization.
- Margin of Safety represents that portion of the sales over the breakeven point, that acts as a buffer to protect the company’s revenue, in the event that there is a drop in the sales.
- Operating Leverage is the degree to which the contribution and net operating income are related and represents the relation between the Sales and Variable costs.
To Compute:
Percentage change in net operating income if the unit sales increase by 15%.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Solar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales.
The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020.
SOLAR SOLUTIONS
Adjusted Trial Balance
12/31/2020
2020
2019
Account Title
Adjusted Trial Balance
Post-Closing Trial Balance
Debit
Credit
Debit
Credit
Cash
$
122,200
55,000
125,600
Accounts Receivable
35,000
Prepaid Insurance
5,000
6,000
|Inventory
Office Equipment
Machinery & Tools
Accumulated Depreciation
Accounts Payable
Salaries Payable
Sales Tax Payable
Note Payable-Long Term
Common Stock, $10 par
46,000
15,600
63,000
47,000
59,000
21,000
21,000
16,000
11,200
16,800
2,600
2,700
2,000
4,000
31,000
22,100
240,000
160,000
Retained Earnings
28,600
28,600
Dividends
10,000
Sales Revenue
Cost of Goods Sold
Rent Expense
Salaries Expense
235,000
127,600
20,000
36,000
Insurance…
your line manager wants to assess your understanding and ability to prepare and produce the appropriate final accounts such as profit and loss account, owners’ equity statement, and balance sheet as well as how these accounts are differed under different forms and types of business.
Produce the final accounts for a sole trader business (Software Programming Company) from task 1 including profit and loss account, owners’ equity statement, and balance sheet for the Period ended July 31st. using the trial balance that you have produced in problem 2/ task1
2) Make the adjustments entries for the following transactions before preparing the final accounts for LLC company:
On the 20th of October 2019, the business purchased supplies for 8000 cash. On 31st of December, 2019 the business found out that the supplies still on hand were 4000 only.
The business has a Equipment with book value of 17000, with annual depreciation rate of 10%.
On the 1st of July the business purchased a…
Further info is in the attached images
For the Excel part of the question give the solutions in the form of the Excel equations. Please and thank you! :)
Download the Applying Excel form and enter formulas in all cells that contain question marks.
For example, in cell B34 enter the formula "= B9".
After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text.
Check your worksheet by changing the beginning work in process inventory to 100 units, the units started into production during the period to 2,500 units, and the units in ending work in process inventory to 200 units, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the cost per equivalent unit for materials should now be $152.50 and the cost per equivalent unit for conversion should be $145.50.
Thank you!
Chapter 6 Solutions
Introduction to Managerial Accounting - Connect Access
Ch. 6.A - The Cheyenne Hotel in Big Sky, Montana, has...Ch. 6.A - Least-Squares Regression LOS11 Bargain Rental Car...Ch. 6.A - Prob. 3ECh. 6.A - Archer Company is a wholesaler of custom-built...Ch. 6.A - George Caloz&Freres, located in Grenchen,...Ch. 6.A - Least-Square. Regression; Scattergraph; Comparison...Ch. 6.A - Cost Behaviour; High4æw Method; Contribution...Ch. 6.A - Nova Company’s total overhead cost at various...Ch. 6.A - High-Low Method; Contribution Format Income...Ch. 6.A - Least-Squares Regression Method; Scattergraph;...
Ch. 6.A - Mixed Cost Analysis and the Relevant Range LOS-10...Ch. 6.A - Prob. 12PCh. 6 - What is the meaning of contribution margin ratio?...Ch. 6 - Prob. 2QCh. 6 - In all respects, Company A and Company B are...Ch. 6 - What is the meaning of operating leverage?Ch. 6 - What is the meaning of break-even point?Ch. 6 - In response to a request from your immediate...Ch. 6 - What is the meaning of margin of safety?Ch. 6 - Prob. 8QCh. 6 - Explain how a shift in the sales mix could result...Ch. 6 - The Excel worksheet form that appears be1o is to...Ch. 6 - The Excel work sheet from that appears below is to...Ch. 6 - Prob. 3AECh. 6 - The Excel worksheet form that appears be1o is to...Ch. 6 - Prob. 5AECh. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Prob. 11F15Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - Oslo Company prepared the following contribution...Ch. 6 - The Effect of Cha noes ¡n Activity on Net...Ch. 6 - Prob. 2ECh. 6 - Prepare a Profit Graph L062 Jaffre Enterprises...Ch. 6 - Computing and Using the CM Ratio L063 Last month...Ch. 6 - Changes in Venable Costs, Fixed Costs, Selling...Ch. 6 - Prob. 6ECh. 6 - Lin Corporation has a single product 1ose selling...Ch. 6 - Compute the Margin of Safety LO6-7 Molander...Ch. 6 - Compute and Use the Degree 01 Operating Leverage...Ch. 6 - Prob. 10ECh. 6 - Missing Data; Basic CVP Concepts L061, L069 Fill...Ch. 6 - Prob. 12ECh. 6 - Change in selling price, Sales Volume, Variable...Ch. 6 - Prob. 14ECh. 6 - Operating Leverage 1061. 1068 Magic Realm, Inc.,...Ch. 6 - Prob. 16ECh. 6 - Break-Even and Target Profit Analysis 1064, 1066,...Ch. 6 - Break-Even and Target Profit Analysis; Margin of...Ch. 6 - Prob. 19PCh. 6 - Prob. 20PCh. 6 - Prob. 21PCh. 6 - Prob. 22PCh. 6 - CVP Applications; Contribution Margin Ratio:...Ch. 6 - Break-Even and Target Profit Analysis LO6-6, L066...Ch. 6 - Prob. 25PCh. 6 - Prob. 26PCh. 6 - Prob. 27PCh. 6 - Sales Mix; Commission Structure; Multiproduct...Ch. 6 - Changes in Cost Structure; Break-Even Analysis;...Ch. 6 - Graphing; Incremental Analysis; Operating Leverage...Ch. 6 - Interpretive Questions on the CVP Graph L062, L065...
Knowledge Booster
Similar questions
- The following information is from Bluff Run Golf Courses. The company runs three courses and the July income statement for each course is shown. A. Find the missing value for outings revenue, wages, and operating income. B. Comment on the financial performance of each course. C. Identify a limitation of analyzing the information provided. You may want to consider using Microsoft Excel or another spreadsheet application for the numerical data. This information will be used in a subsequent question.arrow_forwardUse the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the courses. Comment on how your analysis has changed for each course. B. Perform a vertical analysis for each course. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explainarrow_forwardClick 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.arrow_forward
- Problem 3. Calculate the PW and IRR of this transaction. At the given MARR is this a good purchase? Please workout in excel spreadsheet.arrow_forwardRequired information To complete this exercise, you will need to download and Install Tableau on your computer. Tableau provides free Instructor and student licenses as well as free videos and support for utilizing and learning the software. Once you are up and running with Tableau, watch the three "Getting Started" Tableau videos. All of Tableau's short training videos can be found here. [The following information applies to the questions displayed below.] Abernathy Company's accounting department has finished preparing the master budget for this year. The chief financial officer (CFO) would like your assistance in creating data visualizations that she can use to better explain the master budget to the company's senior management team. S More specifically, the CFO would like you to prepare some data visualizations that depict trends in sales, net income, cash collections, current assets, and operating cash flows. Download the Excel file, which you will use to create your Tableau…arrow_forwardRequired information (The Excel worksheet form that appears below is to be used to recreate part of the example relating to Turbo Crafters that appears earlier in the chapter.) Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B13 enter the formula "= B5". After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the example in the text. Check your worksheet by changing the estimated total amount of the allocation base in the Data area to 50,000 machine-hours, keeping all of the other data the same as in the original example. If your worksheet is operating properly, the predetermined overhead rate should now be $6.00 per machine-hour. If you do not get this answer, find the errors in your worksheet and correct them. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save." You will use this…arrow_forward
- 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…arrow_forwardWrite a paragraph on each of the following topics: liquidity, asset management, debt management and profitability. Be sure to label these separately. Analyze each topic using the answers from your ratios to support your analysis by deciphering what they are telling you. Create a text box (Insert Menu, click on the “Text” button on the right side of the menu bar, and choose, “Text box”. Then click and drag a box to write in.arrow_forwardWhat is the easiest way to set up multiple companies, with the same owner, in Quickbooks? A. Use the Advanced/detailed Setup to go through the EasyStep Interview for each company, creating a separate company file for each. B. Use the Advanced/ Detailed Setup to go through the EasyStep Interview for the oldest company, then click File >Add Additional Business at the end of the interview l. C. Purchase a separate Quickbooks license for each company. You will create different icons for each company on your desktop. D. Set up classes for each company within the parent company file. This will allow you to print financial statements for each company.arrow_forward
- After completing your first degree in accounting you have been employed by XYZ Company as an account officer. The Management of the company has tasked you to implement a computerized accounting system.RequiredIn a paragraph each, address the following questions:a) Discuss five benefits associated with the implementation of the computerizedaccounting system within the company.b) Giventhattherearesomanyaccountingpackagesonthemarket,whatshouldyoube looking for when selecting a computerized accounting package for the company?Explain any five factors to considerc) Assuming you procure a Sales Ledger package, what kind of reports should weexpect? List five types of reports expected to be generated.d) Explainthedifferencebetweenastand-alonepackageandanintegratedpackage?Explain two advantaged and two disadvantages of an integrated packagee) Before a new accounting package can be deployed, it needs to be configured. What does it mean to configure an accounting package? Explain the processes…arrow_forwardRecreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Please show all dollar amount to thousands of dollars.arrow_forwardThe following information is from Dessert Dynasty. The company runs three stores and the December Income Statement for all stores is shown. A. Find the missing values for retail revenue, ingredients, and operating income. B. Comment on the financial performance of each store. C. Identify a limitation of analyzing the information provided. You may want to consider using Microsoft Excel or another spreadsheet application for the numerical data. This information will be used in a subsequent question.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 Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage LearningCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,