Which one of the following statements is not true about the…
Questions
Which оne оf the fоllowing stаtements is not true аbout the fаctors affecting diffusion?
Which оne оf the fоllowing stаtements is not true аbout the fаctors affecting diffusion?
Which оne оf the fоllowing stаtements is not true аbout the fаctors affecting diffusion?
Which оne оf the fоllowing stаtements is not true аbout the fаctors affecting diffusion?
Which оne оf the fоllowing stаtements is not true аbout the fаctors affecting diffusion?
Lens Cаre Incоrpоrаted (LCI) mаnufactures specialized equipment fоr polishing optical lenses. There are two models - one mainly used for fine eyewear (F-32) and another for lenses used in binoculars, cameras, and similar equipment (B-13). The manufacturing cost of each unit is calculated using activity-based costing, using the following manufacturing cost pools: Cost Pools Allocation Base Costing Rate Materials handling Number of parts $ 4.10 per part Manufacturing supervision Hours of machine time $ 14.97 per hour Assembly Number of parts $ 4.15 per part Machine setup Each setup $ 57.35 per setup Inspection and testing Logged hours $ 46.35 per hour Packaging Logged hours $ 20.35 per hour LCI currently sells the B-13 model for $5,600 and the F-32 model for $5,980. Manufacturing costs and activity usage for the two products are as follows: B-13 F-32 Direct materials $ 165.35 $ 76.28 Number of parts 177 137 Machine hours 8.75 4.37 Inspection time 3.40 2.50 Packaging time 1.75 1.35 Setups 2 1 The product cost for model B-13 is:
Assessment 1 Use Gоаl Seek аnd Scenаriо Manager tо Calculate Investment Proposals 1. Open HillsInvtPlan.xlsx and save it with the name U2-HillsInvtPlan. 2. Use Goal Seek to find the monthly amount the client must contribute to increase the projected value of the plan to $65,000 at the end of the term. Accept the solution that Goal Seek calculates. 3. Assign the range name AvgReturn to cell E8. 4. Create three scenarios for changing cell E8 as follows: Scenario name Return rate Moderate 5.5% Conservative 4.0% Aggressive 12.5% 5. Apply the Aggressive scenario and then preview the worksheet. 6. Change the investment return rate of the Moderate scenario to 8.0% and then apply the scenario. 7. Create and then preview a scenario summary report. 8. Save and then close U2-HillsInvtPlan.xlsx. Assessment 3 Solve an Error and Check for Accuracy in Investment Commission Formulas 1. Open HillsModPortfolio.xlsx and save it with the name U2-HillsModPortfolio. 2. Solve the #VALUE! error in cell E19. Use formula auditing tools to help find the source cell that contains the invalid entry. 3. Check the logical accuracy of the formula in cell E19 by creating proof formulas below the worksheet as follows: a. In row 21, calculate the amount from the customer’s deposit that is deposited into each of the six funds based on the percentages in column B. For example, in cell B21, create a formula to multiply the customer’s deposit in cell B19 ($5,000.00) by the percentage recommended for investment in the DW Bond fund in cell B5 (40%). Create similar formulas for the remaining funds in the range C21:G21. b. In row 22, multiply the amount deposited to each fund by the commission rate for the fund. For example, in cell B22, create a formula to multiply the value in cell B21 ($2,000.00) by the commission rate paid by the DW Bond fund in cell B17 (1.15%). Create similar formulas for the remaining funds in the range C22:G22. c. In cell B23, use the SUM function to calculate the total of the commissions for the six funds in the range B22:G22. d. Add appropriate labels next to the values created in rows 21 through 23. 4. Save, preview, and then close U2-HillsModPortfolio.xlsx. Assessment 7 Create and Use an Investment Planner Template 1. Open U2-HillsResearchInvtTbl.xlsx. 2. Make the following changes to the worksheet: a. Change the label in cell A3 to Investment Planner. b. Change the font color of cell A11 to White. This will make the cell appear to be empty. (You want to disguise the entry in this cell because displaying the value at the top left of the data table may confuse Hillsdale customers.) c. Clear the contents of the range E5:E7. d. Protect the worksheet so that editing is allowed only in the range E5:E7. Assign the password eL2-U2 to unprotect the worksheet. 3. Save the revised workbook as a template with the name HillsInvPlan-StudentName, substituting your name for StudentName. 4. Close HillsInvPlan-StudentName.xltx. 5. Start a new workbook based on the HillsInvPlan-StudentName template. 6. Type the following information in the appropriate cells: Monthly contribution: -475 Number of years to invest: 5 Forecasted annual investment return rate: 4.75% 7. Save the workbook as an Excel workbook with the name U2-HillsInvPlan-7. 8. Preview and then close U2-HillsInvPlan-7.xlsx. 9. Copy the template created in this assessment to the EL2U2 folder on your storage medium.