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
Use 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…
Required 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…
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…
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
- Work 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_forwardBelow you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update within excel. Please choose one of the data sets below and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided. Data set #1 Data Section: Actual and Budgeted Unit Sales: April 1,500 May 1,000 June 1,600 July 1,400 August 1,500 September 1,200 Balance Sheet, May 31, 19X5 Cash $8,000 Accounts Receivable 107,800 Merchandise Inventory 52,800 Fixed Assets (net) 130,000 Total assets $298,600 Accounts Payable (merchandise) $74,800 Owner's equity 223,800 Total liabilities & equity $298,600 Average selling price $98 Average purchase cost per unit $55 Desired ending inventory (% of next…arrow_forwardPlease do the required and bonus either way and please all the tables to be copy and pasted to a word document so I can editarrow_forward
- This is for accounting information system class please help me figure how to do this step in excel.add the 2021 data to the Dashboard Open the file Support_EX19_EOM5-1_2021.xlsx. Copy the values in the range C6:C19. In cell C6 of the Dashboard worksheet in the original workbook, use the Paste Link command to create external references to the values in the Support_EX19_EOM5-1_2021.xlsx workbook. Delete the unnecessary values in cells C8, C12, and C16, and close the Support_EX19_EOM5-1_2021.xlsx workbookarrow_forwardPlease note: You can draw your trees either by hand on paper or in Excel. If you do it on a paper, please take a picture of the tree and insert it in your solution file. You can submit your solution as an Excel file or Word document. In either case, your solution should contain your decision trees and all necessary calculations (not just the results of calculations). Problem 1. The WHN Company Problem. The WHN Company is going to introduce one of the three new products: a widget, a hummer, or a nimnot. The market condition could be favorable, stable, or unfavorable with the probabilities 0.2, 0.5, and 0.3 respectively. The monetary outcomes for each product under each condition are described in the following table: Unfavorable $120,000 $70,000 -875,000 $40,000 $20,000 $30,000 $30,000 Favorable Stable Widget Hummer $60,000 Nimnot $35,000 Create a decision tree to identify which new product should be introduced in order to maximize the company's profit?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_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_forwardPlease complete the required and bonus either way and please allow the charts to be copy and pasted to a word document for editingarrow_forwardI need help to do questions 8, 9, and 11 for the Excel Worksheet. Also, please make sure that you provide the steps carefully and get to understand the work as possible. Those questions that I will provide you would be from Microsoft Word.arrow_forward
- Please solve this problem directly on Excel spreadsheet. Make sure to include the calculations performed using Excel formulas.arrow_forwardAttached are two pictures. The first picture has the instructions (3 pages) and the second picture is a screenshot of an excel spreadsheet that need the "formulas".arrow_forwardCan someone set up an excel sheet using the following data and show me the formula side, so I know how to replicate this type of problem later on? I don't understand where we get the values from the solution excel sheet I attached in the images. Thanks in advance!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