Purchase Solution

Excel Spreadhsheet: Item Inventory

Not what you're looking for?

Ask Custom Question

Need help on Excel program ASAP. The problem is below. Please also refer to the attached Excel file.

I am using an excel spreadsheet to do item inventory and also count items.

There are two lines per item starting with Row 5 Column D which is item One
The count starts on Column 5

Thus D5 is 1

There are TWO empty rows between items

Thus D9 is 2

Thus D13 is 3

Thus D17 is 4

What I need to do is track items that are out of stock and NOT count them into this count

If D3 is Out of Stock I would like to be able to put into C13 a "N" and have D13 go Blank and go onto make D17 be 3

Also, there may be situations where there are multiple items out of stock one after another so it must keep looking for the lack on an N in row C

Lastly I need the colomn c to add up the total at the bottom with the number of out of stocks.

Attachments
Purchase this Solution
Solution Summary

The solution assists with doing an item inventory and count items on an Excel spreadsheet.

Solution Preview

See word file for explanation and excel file for end result.

Please refer to 85516sol.xls which has all of the required changes.

The first thing I did was to change the "1" in D2 to "0" in D1. I did this to allow the first entry to be the same as the others.

Next step was to create a formula that added 1 to the count of the ...

Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • Quantitative Methods: Inventory Model

    Demand for the item is six hundred units weekly. The lead time is three weeks, and the purchase price is $0.60. The solution finds answers to following using an Inventory Model in Excel. a. What is the economic order quantity for this item? b.

  • MS Excel

    It is also advisable to place item number column to determine how many items are in the inventory. If the inventory reached item #800, then every 800 games are already stored in the inventory and he has not missed any game he needs to tabulate.

  • Safety Stock and Reorder Point Calculations

    Inventory Item Average Demand (Annual) Sigma (Std.

  • Calculate inventory cost using FIFO, LIFO, average cost

    Jan 1 Inventory 27 units at $120 Feb 17 Purchase 54 units at $138 July 21 Purchase 63 units at $156 Nov 23 Purchase 36 unit at $165 50 units of the item in the physical inventory at Dec 31.

  • Computing Lower of Cost or Market

    Cost-to complete/Disposal cost amount to 20% of selling price and the normal profit is 35% of selling price for every item sold. ** Please see the attached Excel 97-2003 spreadsheet.

  • Lower of Cost or Market

    (b) Determine the inventory by the lower-of-cost-or-market method, applying the method to the total of the inventory. Please see the attached Excel 97-2003 spreadsheet.

  • Calculating EOQ, safety stock and inventory costs

    566185 Prod & Ops Mgt develop inventory system in excel Given the following information, determine an inventory management system for an item in demand 50 weeks/year.

  • Acme Corporation: Calculate Operating & Cash Cycles

    In an Excel format, the solution explains every calculation to arrive at the the operating and cash cycles.

  • Huffman Trucking Co - Ratio Analysis

    turnover Sales/ Inventory NA NA As inventory is Nil 2) Profitability ratios a) Asset turnover Sales/ Assets 3.86 3.80 b) Profit margin Net Profit after taxes 2.18%

View More Related Solutions