Introduction To Managerial Accounting
8th Edition
ISBN: 9781259917066
Author: BREWER, Peter C., Garrison, Ray H., Noreen, Eric W.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 6, Problem 1AE
The Excel worksheet form that appears be1o is to be used to recreate portions of the Review Problem relating to Voltar Company. 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 fixed expenses to $270,000. If your worksheet is operating properly, the degree of operating leverage should be 10. If von & not get this answer, find the errors in your worksheet and correct them. How much is the margin ofsafety percentage? Did it change? Why or why not?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
GenX is a career training company that offers both online and on-campus weekend training courses on web development, data science, coding, and digital marketing. The accompanying data file shows the courses that will be offered next month by GenX. The data set contains course name (Course), whether the course is offered online or on-campus (Mode), current enrollment (Enrollment), tuition per student (Tuition), cost of instructors (Instructor costs), facility costs (Facility costs), technical service costs (Technical services), and historical cancellation rate for the course (Cancellation rate). Only on-campus courses incur facility costs. Online courses carry much higher costs for technical services than on-campus courses. The historical cancellation rate is used to project the actual enrollments of the courses. GenX would like to develop a spreadsheet model that calculates the projected revenue and profit for the month.
Course
Mode
Enrollment
Tuition
Instructor costs
Facility…
Please help me do a general journal for this scenario:
Master Flow hired Ring Social Media Company to build Master Flow’s Web Site for$3,000 and paid a $1,000 initial payment up front and opened a $2,000 trade accountwith Ring. Final payment will be due upon completion of the Web Site.
Can I please ge thelp with this question?
Required information
Skip to question
[The following information applies to the questions displayed below.]
Franklin Training Services (FTS) provides instruction on the use of computer software for the employees of its corporate clients. It offers courses in the clients’ offices on the clients’ equipment. The only major expense FTS incurs is instructor salaries; it pays instructors $6,000 per course taught. FTS recently agreed to offer a course of instruction to the employees of Novak Incorporated at a price of $700 per student. Novak estimated that 20 students would attend the course.
Base your answers on the preceding information.
The instructor has offered to teach the course for a percentage of tuition fees. Specifically, the instructor wants $300 per person attending the class. Assume that the tuition fee remains at $700 per student.
Is the cost of instruction a fixed or a variable cost?
Determine the profit, assuming that 20…
Chapter 6 Solutions
Introduction To Managerial Accounting
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
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
- Calculate the net income for the year and post it on the Discussion Board, as well as all supporting documentation to arrive at the net income.- Each group will also advise Tyler Stasney whether to continue operating Swift Classified Ads and post their advice on the Discussion Board, writing a minimum of two to three sentences on the Discussion Board.arrow_forwardThe 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?arrow_forwardSocial Media, Inc. (SMI) has two services for users. To ot!, which connects tuters with students who are looking for tutoring services, and TiX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results. Toot! TiX Total Users 13,100 20,100 33,200 Revenues $ 1,800,000 $ 1,760,000 $ 3,560,000 Engineering hours 9,300 7,300 16,600 Engineering cost $ 687,750 $ 806,250 $ 1,494,000 Administrative costs $ 1,195,200 Required: a. Compute the predetermined overhead rate used to apply administrative costs to the two services assuming SMI uses the number of users to allocate administrative costs. b. Based on the rates computed in requirement (a), what is the profit for each service?arrow_forward
- Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…arrow_forwardStart with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…arrow_forwardStart with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021: Sales Labor and Raw Materials May, 2020 $75,000 $80,000 June, 2020 $115,000 $75,000 July, 2020 $145,000 $105,000 August, 2020 $125,000 $85,000 September, 2020 $120,000 $65,000 October, 2020 $95,000 $70,000 November, 2020 $75,000 $30,000 December, 2020 $55,000 $35,000 January, 2021 $45,000 N/A Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the…arrow_forward
- 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_forwardThe general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, 17,731. To test your model, use the following balances at August 31: Print the worksheet when done. Check figure: Total debits, 18,810. CHART (optional) Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.arrow_forwardMay I ask for help with this question? I got an answer of 800,000 (Rounded Up) Please check. P Co. incurred the following costs in developing software :arrow_forward
- Jade Ltd is now considering how to obtain a computer software. The director of Jade Ltd has noticed that over the last 20 years, many companies have spent a great deal of money internally developing new intangible assets, such as software. You have been asked by the director to provide your advice on the accounting treatments of the two possibilities below: (i) Employ its own programmers to write software that the company will use (ii) Purchase computer software externally, including packages for payroll and general ledger. Required: In accordance with IAS 38 / AASB 138 Intangible Assets, discuss whether internally developed intangible assets should be recognised, and explain the differ in the accounting treatments for the two possible options.arrow_forwardHaving gone through the principles II class, imagine you are an intern at Floro agro florists and its end year. The Warehouse Manager is overwhelmed with work and realizes that you can just be the perfect person to help him with inventory-related issues after he realizes a glitch in some year's records. The information for the years in question has been provided as follows; 2018 2019 2020 Current Assets = 1,000 1,250 1,750 Non-Current Assets = 5,000 6,250 8,750 Total Assets = 6,000 7,500 10,500 Long term Liabilities = 2,000 2,500 3,500 Revenue = 1,000 1,250 1,750 Cost of Sales 40% on cost for all the Years Assume that ending Inventory was overstated by K1, 500 in 2018 and Understated by K10, 000 ends of 2019. Required a. Calculate the Cost of goods sold for the years 2018, 2019, and 2020 b. Calculate the Owners Equity value for the…arrow_forwardSocial Media, Inc. (SMI) has two services for users. Toot!, which connects tutors with students who are looking for tutoring services, and TiX, which can be used to buy, sell, or exchange event tickets. For the following year, SMI expects the following results. Toot! TiX Total Users 9,500 17,100 26,600 Revenues $ 1,500,000 $ 1,280,000 $ 2,780,000 Engineering hours 7,650 5,650 13,300 Engineering cost $ 439,125 $ 558,375 $ 997,500 Administrative costs $ 798,000 The company is considering using a two-stage cost allocation system and wants to assess the effects on reported product profits. The company is considering using Engineering Hours and Users as the allocation base. Additional information follows. Toot! TiX Total Engineering hours 7,650 5,650 13,300 Users 9,500 17,100 26,600 Engineering-hour related administrative cost $ 114,380 User-related…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 LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license