Chapter 6 Excel Assignment - Managerial Accouting NEED FORMULAS

The Chapter 6 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text.

Download the Applying Excel form and enter formulas in all cells that contain question marks.

For example, in cell B26 enter the formula "= B17".

After entering formulas in all of the cells that contained question marks, verify that the dollar amounts match the numbers in Review Problem 1.

The LIFO inventory flow assumption is used throughout the problem.

Check your worksheet by changing the units sold in the Data to 6,000 for Year 2. The cost of goods sold under absorption costing for Year 2 should now be $240,000. If it isn’t, check cell C41. The formula in this cell should be =IF(C26<C27,C26*C36+(C27-C26)*B36,C27*C36).] If your worksheet is operating properly, the net operating income under both absorption costing and variable costing should be $(34,000) for Year 2. That is, the loss in Year 2 is $34,000 under both methods. If you do not get these answers, find the errors in your worksheet and correct them. Assume that the units produced in year 2 were sold first.

Expert Solution

ekkarill92 answered 2 years ago

Please show how to write the formulas for these in Excel. That is what the assignment...

Please show how to write the formulas for these in Excel. That is what the assignment requires and I don't know how to do it. Thank you! All are in column D. Cell numbers that matter are noted on the left. Suppose the risk-free interest rate is 4%. a. Having $200 today is equivalent to having what amount in one year? b. Having $200 in one year is equivalent to having what amount today? c. Which would you prefer, $200...

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...

I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...

Required information Chapter 6: Applying Excel The Chapter 6 Form worksheet is to be used to...

Required information Chapter 6: Applying Excel The Chapter 6 Form worksheet is to be used to create your own worksheet version of the main example in the text. Chapter 6: Applying Excel: Exercise (Part 2 of 2) 2. In industries that process joint products, the costs of the raw materials inputs and the sales values of intermediate and final products are often volatile. Change the data area of your worksheet to match the following: Chapter 6: Applying Excel Data Exhibit...

An Excel spreadsheet using formulas and cell referencing is required for this assignment. Careen owns a...

An Excel spreadsheet using formulas and cell referencing is required for this assignment. Careen owns a condominium near Hershey, PA that she rents out part of the year. This year, she incurs the following expenses in connection with her rental condo: Mortgage Interest $9,490 Property Taxes 6,570 Insurance 3,220 Repairs and maintenance 1,610 Utilities 3,703 Depreciation 11,270 During the year, Careen rented the condo for 112 days, receiving $17,600 of gross income. She personally used the condo for 49...

MANAGERIAL ACCOUTING 1. Overhead costs actually incurred in production are recorded in such a way to:...

MANAGERIAL ACCOUTING 1. Overhead costs actually incurred in production are recorded in such a way to: A. Increase Work-in-process B. Decrease Work-in-process c. Increase Manufacturing Overhead d. Decrease Manufacturing Overhead 2. A product, which cost $100 in manufacturing, has been sold for $120 for cash. For this transaction, which of the following is a correct accounting treatment? A. Increase Cost of goods sold by $120 B. Decrease Sales revenue by $120 C. Decrease Finished goods by $100 d....

Need to do this using excel formulas Note: there are 4 worksheets - one for each...

Need to do this using excel formulas Note: there are 4 worksheets - one for each problem ST-2 NET INCOME AND CASH FLOW Last year Rattner Robotics had the following financials (in $ millions): Operating income (EBIT) $5 Depreciation 1 Interest 1 Tax rate 40% Current assets (year end) 14 Accounts payable 3 Accruals 1 Net plant and equipment 15 Depreciation is only non cash item $ millions a. What was the company's net income? EBIT Interest EBT Taxes Net...

I need the formulas in excel: Thank you You're talking to a friend of yours who...

I need the formulas in excel: Thank you You're talking to a friend of yours who has student loans of $30,000. She has just graduated and now needs to pay them back with monthy payments at a 4.19% interest rate over the next 10 years. a. Create a loan amortization table for this loan. b. If she increases her monthly payment by $100, how much sooner will she have paid off the loan? loan balance number of payments interest rate...

I need formulas in excel: Thank you You're the owner of Arcata Scoop - the best...

I need formulas in excel: Thank you You're the owner of Arcata Scoop - the best ice cream shop on the planet. You're considering purchasing a new machine that will allow you to make chocolate dipped ice cream cones. The machine costs $42,000. Details: Depreciation: The machine will be depreciated using straight line depreciation over 7 years, but you think that you'll only use the machine for 5 years. At the end of the 5th year, you'll retire the machine...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for...

USING EXCEL FORMULAS SOLVE THE PROBLEM. MUST USE EXCEL CALCULATIONS AND FORMULAS.!!! Find the data for the problem in the first worksheet named LightbulbLife of the data table down below It gives the data on the lifetime in hours of a sample of 50 lightbulbs. The company manufacturing these bulbs wants to know whether it can claim that its lightbulbs typically last more than 1000 burning hours. So it did a study. Identify the null and the alternate hypotheses for...

CHAPTER 6 ASSIGNMENT Ch6Amnt Let's use the example in your Chapter 6 Valuing Bonds Guide spreadsheet...

CHAPTER 6 ASSIGNMENT Ch6Amnt Let's use the example in your Chapter 6 Valuing Bonds Guide spreadsheet from the Resource section for this chapter, to do a few Questions and Problems. You will see that problems and questions #3, #6, #4 and #5 from the textbook are solved for you in the Valuing Bonds Guide as follows: #3 addresses PV where we solve for the way to Price a bond #6 - same - we solve for PV to get the...

Question