Concept explainers
The Excel work sheet form that appears below is to be used example relating to Turbo Crafters that appears earlier in the chapter D0M110ad the workbook containing this fun from Connect, where you will also receive instruction about how to use this worksheet form.
You should proceed to the requirements below only after completing your worksheet.
Required:
1. Checkyour by changing the estimated total amount of the allocation base in the Data area to 60,000 machine-hours, keeping all of the Other data the same as in the original example. If youris operating properly. The predetermined rate should now be $5.00.If do not get this in worksheet and correct them. How much IS the under applied (over applied) manufacturing did it change? Why or why not?
Want to see the full answer?
Check out a sample textbook solutionChapter 3 Solutions
LSC BARUCH COLL COMBO LL INTRO MANAGERI
- The comparative financial statements of Global Technology are as follows: Open the file RATIOA from the website for this book at cengagebrain.com. Enter the formulas in the appropriate cells. Enter your name in cell A1. Save the completed model as RATIOA2. Print the worksheet when done. Also print your formulas. Check figure: Acid test (quick) ratio (cell C58), .82.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_forwardempt.php?attempt%3D1530301&cmid%3D800386&page%=D2 E-learning services SQU Libraries - SQU Portal Attendance English (en) Clear my choice COVID Co. produces two different products (A and X) using two different activities: Machining, which uses machine hours as an ed activity driver, and Inspection, which uses number of batches as an activity driver. The cost of Machining is $500,000, while the cost of Inspection is $30,000. Product A uses 30% of total machine hours out of question and 70% of total batches. What is the total ac cost assigned to product X? Select one: O a. None of the given ANSWER O b. $171,000 O c. $359,000 O d. $22,500 O e. $125,000 ous page Next pagearrow_forward
- Draw graph in excel that show the comparison between Machine A vs. Machine B Net Present Value using the attached data. Please note there are two pages with data,arrow_forwardPlease show your computations through excel format. Using FIFO, compute for the cost of WIP, end.arrow_forwardPlease do it on an excel sheet so i can see how to do itarrow_forward
- 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…arrow_forwardRequired information. Excel Analytics 12-01 (Static) Quality Cost Report [LO12-2] To complete this activity, you will need to have Excel installed on your computer. This exercise requires you to work in Excel and answer questions in Connect. You will read a brief scenario and then download an Excel file that you will need to complete the requirements in Parts 1 through 3 of this exercise. Some of the requirements include brief video tutorials on using Excel functions. After viewing the tutorials, you will then use what you learned to work directly in Excel to answer the required questions in Connect. [The following information applies to the questions displayed below.] Harvey Company designs and produces surgical lasers. Its product is brilliantly designed, but the manufacturing process has been plagued by chronic quality control problems. To help address the situation, Harvey formed a cross-functional team of managers that quantified its costs of quality over the last two quarters as…arrow_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_forward
- I 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_forwardWhich of the following would not be a batch-related activity? O a. Performing 100% inspection. O b. Setting up a machine for a new production run. O c. Processing a customer order. O d. Purchasing materials. e to search ort sc delete 24 backspace ア E pause S alt ctriarrow_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_forward
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning