Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

ASSIGNMENT

PROJECT OVERVIEW

You are in the accounting department for Independence Home Improvement, a large hardware and home improvement store. Now that you've converted the company's accounting records to Excel, the manager would like you to work on an analysis of the inventory. Although many more items will be added, the worksheet has enough information for you to begin your work.

Instructions

1. Create a formula in cell G4 that calculates the value of the on-hand inventory, based on the price paid for the item, in cell C4. Copy the formula into the range G5:G14. Format the range G4:G14 in the Comma Style.

2. In cell H4, use an absolute reference to the markup percentage in cell K1 to calculate the selling price of one wrench set. (Hint: Multiply the price paid by the markup percentage.) Copy the formula into the range H5:H14.

3. Add the bold attribute to the column headings, and italicize the items in A4:A14.

4. Increase the width of column A to be at least 19.00 characters (or 138 Pixels).

5. Format the Selling Price column so it displays the Accounting Number Format with two decimal places.

6. Change the Price Paid column so it displays the Comma style with two decimal places.

7. Add a row directly under wrench set for Box of Nails, price paid 1.31, sold individually (each), with 56 on hand and 756 sold YTD. Then enter appropriate formulas in cells G5 and H5.

8. Use the spelling checker to correct and replace any spelling errors in the worksheet.

9. Use conditional formatting on the range E4:E15 to call attention to items with a quantity of less than 20 on hand. Use yellow fill with dark yellow text.

10. Create an icon set for the range E4:E15 using the symbols of your choosing.

11. Delete the row containing the Nail Gun item.

12. Add "all borders" in cells A3 to H15. This allows you to see the cells when you print.

13. Insert a table with headers to the area A3 to H14. Select the color of your choice.

14. Create a formula in cell B4 to show the Year to Date (YTD) Profit by subtracting the price paid from the selling price and multiplying by Total Sold YTD. (Hint: You'll need to put parentheses () around the subtraction to tell Excel to compute that part first). Format B4:B14 in the comma style.

15. Use the auto sum button to get the Total YTD Profit in cell B15.

16. Add a pie chart to summarize the YTD Profit of each item. Move the pie chart under the table.

17. Change the font size of "Independence Home Improvement" in cell A1 to Times New Roman, 36 point.

18. Save the file using the naming convention APP101_your last name_week4_assignment. Compare your work to the sample shown below.

Attachment:- Attachments.rar

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92395661
  • Price:- $40

Priced at Now at $40, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Question - effective financial reporting depends on sound

Question - Effective financial reporting depends on sound ethical behavior. Financial scandals in accounting and the businesses world have resulted in legislation to ensure adequate disclosures and honesty and integrity ...

Question - state your accounting method of choice and

Question - State your accounting method of choice and describe several types of business transactions you expect to incur. Explain how the transactions will impact your financial statements. How will the transactions inf ...

Questions 1did the employees know of the lost inventory2why

Questions: 1 Did the employees know of the lost inventory? 2 Why the auditor did not take any action against the insurance company? 3 Was there any conspiracy involved in between the insurance company and the auditor? 4 ...

Question - journalize the transaction1 collected 25000 for

Question - Journalize the transaction 1. Collected $25,000 for services to be provided over the coming year on June 30. 2. Paid $72,000 for a three-year insurance policy on July 10 with coverage beginning on August 1. 3. ...

Question this project paper is an individual assignmentthe

Question: This Project Paper is an individual assignment. The company you select for this Project Paper is up to you; however, it must be a publicly traded company whose financials are available on the internet. You will ...

Question - a bond has a 7 coupon and pays interest

Question - A bond has a 7% coupon and pays interest semi-annually. What is the amount of each interest payment if the face value of a bond is $1,000?

Question - splish company purchased equipment on january 2

Question - Splish Company purchased equipment on January 2, 2013, for $ 111,400. The equipment had an estimated useful life of 5 years with an estimated salvage value of $ 12,400. Splish uses straight-line depreciation o ...

Question - what is the purpose of an operational plan what

Question - What is the purpose of an operational plan? What information or resource is required to develop an operational plan business? In your response include the main requirement to effectively develop and implement ...

Assignment economics of risk and uncertainty applied

Assignment: Economics of Risk and Uncertainty Applied Problems Please complete the following two applied problems. Show all your calculations and explain your results. Problem 1: A generous university benefactor has agre ...

Question - the following list of accounts appear in

Question - The following list of accounts appear in alphabetical order and were taken from ABC Corporation's ledger as of December 31, 2018. The Accounts Payable records were missing. Accounts Payable $? Inventory $7,000 ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As