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 3, Problem 4AE
The Excel worksheet form that appears below is to be used example relating to Crafters that appear earlier in thechapter .download the workbook containing this fun from Connect, where you will also record? Instruction about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Required:
4. Change the estimate total amount of the allocation base bank to 50,000 machine hour so that the data look exactly like they did in part (2). Now change the actual
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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!
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?
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.
Chapter 3 Solutions
Introduction To Managerial Accounting
Ch. 3.A - Carmen Company is a manufacturer that completed...Ch. 3.A - Transaction Analysis L03-5 Adams Company is a...Ch. 3.A - Transaction Analysis L03-5 Dixon Company is a...Ch. 3.A - A Transaction Analysis L03-5 Morrison Company uses...Ch. 3.A - Prob. 5PCh. 3.A - Transaction Analysis Brooks Corporation uses a...Ch. 3 - What is the link that connect the schedule of cost...Ch. 3 - What account is credited when overhead cost is...Ch. 3 - What is under applied overhead? Over applied...Ch. 3 - Provide two reason why overhead might be under...
Ch. 3 - What adjustment is made for under applied overhead...Ch. 3 - How do you compute the raw materials used in...Ch. 3 - How do you compute the total manufacturing cost...Ch. 3 - How do you compute the cost of goods manufactured?Ch. 3 - How do you compute the unadjusted cost of goods...Ch. 3 - How do direct labor costs flows through a...Ch. 3 - The Excel work sheet form that appears below is to...Ch. 3 - The Excel worksheet form that appears below is to...Ch. 3 - The Excel worksheet form that appears below is to...Ch. 3 - The Excel worksheet form that appears below is to...Ch. 3 - Bunnell Corporation is a manufacturer tint uses...Ch. 3 - Bunnell Corporation is a manufacturer tint uses...Ch. 3 - Bunnell Corporation is a manufacturer tint uses...Ch. 3 - Prob. 4F15Ch. 3 - Prob. 5F15Ch. 3 - Prob. 6F15Ch. 3 - Prob. 7F15Ch. 3 - Prob. 8F15Ch. 3 - Prob. 9F15Ch. 3 - Bunnell Corporation is a manufacturer tint uses...Ch. 3 - Prob. 11F15Ch. 3 - Prob. 12F15Ch. 3 - Prob. 13F15Ch. 3 - Prob. 14F15Ch. 3 - Prob. 15F15Ch. 3 - Prepare Journal Entries L03-1 Larned Corporation...Ch. 3 - Prepare Accounts L03-2, L03-4 Jurvin Enterprises...Ch. 3 - Schedules of Cost of Goods Manufactured and Cost...Ch. 3 - Under applied and Overapplied Overhead Osborn...Ch. 3 - Journal Entries and T-Accounts 103-1,103-2 The...Ch. 3 - EXERCISE 3-6 Schedules of Cost of Goods...Ch. 3 - Applying Overhead; Cost of Goods Manufactured...Ch. 3 - Applying Overhead; Journal Entries; Disposing of...Ch. 3 - Applying Overhead; T-Accounts; Journal Entries...Ch. 3 - Applying Overhead; Journal Entries; T-accounts...Ch. 3 - PROBLEM 3-11 T-Account Analysis of cost Flows...Ch. 3 - PROBLEM 3-12 Predetermined Overhead Rate;...Ch. 3 - Schedules of Cost of Goods Manufactured and Cost...Ch. 3 - Schedule of Cost of Goods Manufactured; Overhead...Ch. 3 - Journal Entries; T-Accounts; Financial Statements...Ch. 3 - Comprehensive problem L03-1, L03-2, L03-4 Gold...Ch. 3 - Cost Flows; T-Accounts; Income Statement L03-z...
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
- Answer the following questions using the Answer Report and the Sensitivity Report on thefollowing page. Support your answers with explanations and the work showed.Your run a company that produces three electrical products – clocks, radios, and toasters. You are asked to figure out how many of each of these things should be produced, and the computer solution (answer report and sensitivity report generated in Microsoft Excel) is given on the next page. 1.) How many of each of the electronic appliances should you make? (Make sure your answer makes sense.)2.) How much will you end up profiting?3.) Which of the constraints are binding? What does the slack for each non-binding constraint represent?arrow_forwardGenX 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…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
- In the New Company File Assistant, before pressing the Next button in the 'Create your company file' window, Isabella wants to confirm some of the company settings you selected when creating the company file in MYOB. Isabella asks you to select the correct options that appear throughout the New Company File Assistant that correspond to the company settings required for Hi-Fi Way in MYOB: 12 accounting periods and 'Other' as the industry classification of the business June as the conversion month and a financial year starting in January 12 accounting periods and 'Retail Business, Other' as the industry classification of the business January as the conversion month and a financial year ending in Julyarrow_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_forwardKruger Designs hired a consulting firm 3 months ago to redesign the information system that the architects use.The architects will be able to use state-of-the-art computer-aided design (CAD) programs to help in designing the products. Further, they will be able to store these designs on a network server where they and other architects may be able to call them back up for future designs with similar components. The consulting firm has been instructed to develop the system without disrupting the architects. In fact, top management believes that the best route is to develop the system and then to introduce it to the architects during a training session.Management does not want the architects to spend precious billable hours guessing about the new system or putting work off until the new system is working. Thus, the consultants are operating in a back room under a shroud of secrecy.Requireda. Do you think that management is taking the best course of action for the announcement of the new…arrow_forward
- A catalog company has hired you to computerize its sales order entry forms. Approximately 60 percent of all orders are received over the telephone, with the remainder received by either mail or fax. The company wants the phone orders to be input as they are received. The mail and fax orders can be batched together in groups of 50 and submitted for keypunching as they become ready.The following information is collected for each order: Customer number (if customer does not have one,one needs to be assigned) Customer name Address Payment method (credit card or money order) Credit card number and expiration date (if necessary) Items ordered and quantity Unit price RequiredDetermine control techniques to make sure that all orders are entered accurately into the system. Also, discuss any differences in control measures between the batch and the real-time processing.arrow_forwardWork the problem out by hand on a piece of paper so that you know what the answers should be. All dollar amounts (except EPS) should end in ",000" The schedule and statment in your output should compute mathematically from TOP to Bottom, so check and make sure that's the case Math Example: If A - B = C, then A - C = B and A = B + C Prepare an output section that produces the following items: 1) "COGS Schedule", 2) "Income Statement", and 3) "Retained Earning Statement". The reporting period is for the calendar year of 2023. The output items should be placed on a separate 'sheet' (the heading "... OUTPUT SECTION ..." should be centered over all columns to which it relates: [A1..G1]). Naming of the output 'sheet' should be "OUTPUT". No number (dollar amount, shares, or percentage) or company name should be typed (hard coded) directly into any cell in the output section, as this would prevent your output from being correct when the input is changed. Instead, the output section must…arrow_forwardUse the template attached below to complete this activity: (Videos are available in the C4 module on using the ebook + copying worksheets). Chapter_7_Applying_Excel_template-1.xlsx Use the data found in the template + use the additional data found in the ebook section, "Applying Excel" (p. 330 print text). All calculations should be performed within the cell using cell referencing/formulas so that I can see how you arrived at your answers! Do not use your calculator and just type in numbers! You will submit four worksheets within your assignment file: sheet 1 = original sheet 2 = requirement 1 quantitative + question responses sheet 3 = requirement 2 quantitative + question responses sheet 4 = requirement 3 quantitative + question responses In scenario 1, 2, and 3.... copy the original worksheet after inputting your cell formulas and change the values as indicated for each requirement. Name each tab by the question #. Chapter 7: Applying Excel Data…arrow_forward
- How can you move your Quickbooks Desktop company file, with all of your data, to a new computer? A. Create a portable file and restore it to the new system. B. Export your company file to Excel from the old computer, then copy this file over to your new computer. C. Install Quickbooks on the new computer, back up your company file on the old computer, and restore the file to the new system. D. Condense the data file on the old computer to the drive space. Back up the file and then restore the condense data file to the new computer.arrow_forwardFor this problem, there are 10 future value and present value exercises to be solved. Review the printout of the worksheet file COMPOUND that follows these requirements. This file also contains a second sheet called the Answer Sheet. Note that the worksheet is divided into four sections. You have to decide which section is appropriate for each exercise. Open the file COMPOUND from the website for this book at cengagebrain.com. To enter the four formulas in the appropriate cells, use the FV and PV functions for the annuities (see Appendix A in Excel Quick for a discussion of them). Unfortunately Excel does not provide functions for the future value of an amount nor the present value of an amount. Enter the following formulas for FORMULA1 and FORMULA2: FORMULA1: =B6*((1+B8)^B7) FORMULA2: =E6/((1+E8)^AE7) For the annuity calculations (FV and PV), it is important that you enter a value (or cell reference) for type to indicate the timing of the first payment. If the first payment is made…arrow_forwardCD Express, Inc., provides CD duplicating services for its customers. An order from a customer can be for a single copy or for thousands of copies. Most jobs are broken down into batches to allow smaller jobs, with higher priorities, to have access to the machines.A number of activities carried out at CD Express are listed below.a. Sales representatives’ periodic visits to customers to keep them informed about the services provided by CD Express.b. Ordering labels from the printer for a particular CD.c. Setting up the CD duplicating machine to make copies from a particular master CD.d. Loading the automatic labeling machine with labels for a particular CD.e. Visually inspecting CDs and placing them by hand into protective plastic cases prior to shipping.f. Preparation of the shipping documents for the order.g. Periodic maintenance of equipment.h. Lighting and heating the company’s production facility.i. Preparation of quarterly financial reports.Required:Classify each of the activities…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 Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License