cost

I've got a spreadsheet with nearly a million rows, I've included a snippet below. Each SKU should have the same cost regardless of warehouse. Also, each SKU should have the same cost multiplier regardless of warehouse. I need to find SKU's which do not abide by this. So, SKU 1343qq1 should be...

Hi all, I tried looking for an answer myself (or here), but I just can't get it to work. Hopefully the answer is understandeable for a non-IT guy (finance background)... :-) So the problem: We have about 100 employees working on our payroll and we want to allocate their individual cost to...

Hopefully this is as easy as the title makes it seem: I have the below data: <tbody> Month Month Number Total Cost Mar-19 3.00 71,250.00 Mar-19 3.00 71,250.00 Mar-19 3.00 41,250.00 Mar-19 3.00 41,250.00 Jun-19 6.00 16,988.00 Mar-19 3.00 13,904.21...

<tbody> Cost value (Local currency) Currency Cost value 500 SGD 3664 EUR </tbody> So I'm stuck in a situation whereby, I'm supposed to convert the cost value (local currency) into cost (in USD). I had made a button to run the VBA Macro to calculate the values and paste back into the...

Hey all, I have a set of data I'm trying to calculate the cost / time per completed project. A completed project is one that has gone to "Prod". (production). I want to figure out a formula that takes the below data and calculates for me the COST (or time) spent on projects that are complete...

I have been searching most of this morning looking for a solution. I have not seen anything like what I am wanting to do. I have a Bill Of Materials with a part number, Description, Cost, and QTY. Some of those rows do not list an item, so I don't want those copied. Just the cells that have a...

Hi. Twice a year i have a task that i hope can be simplified. I'll just show the input and show how it should look at the end My working budget file has about 40 tabs (each tab represents a different Cost Center). Each tab if formatted exactly the same way (fig 1) Each cost center has 117...

I am struggling with a Power Query performance problem and have exhausted all of my ideas, so I am hoping someone here may have an idea. I have two tables: - Fact table containing sales data: approximately 200,000 rows. The relevant fields for this question include Item Number and Period...

Hi, Is it possible to change a specific value in a structured reference calculation? Basically I want to change the week depending on week I select from a dropdown in another cell. My table has a column per week for the value I want to obtain, so I want the Sum Range to move depending on that...

Hi All, In sheet 1 i have everything sorted but i want to add the COST for everything COMMITTED into Sheet 2. Can anyone please help me. Many Thanks, Jim <colgroup><col><col><col><col><col span="9"></colgroup><tbody> Sheet 1 G H I J K L M N O P Commited Order Status Order Delivery...

I have cost centers in column A and amounts in column B. Cost centers are repeated so I want a formula to sum the amount for each cost center on column C. It is like doing pivot table. Thanks

I have 4 invoices across multiple sheets (new sheet added monthly) and I want to create a master sheet with all part numbers on it. So I don't have to go through the invoices manually and transpose the cost, is there a way to use either IF(OR or INDEX(MATCH to pull the data from any of the...

I’m currently working on a worksheet with over 2000 products. Try as I might I cannot work out the formula required (or if it’s even possible) to quickly complete the task in hand without going through line by line. I already have the cost of the product in the table. Is there anyway of...

So I am trying to create a formula to equally spread a given cost X starting at year Y and spread over Z amount of years. Ex <tbody> Cost X Start Year Y Spread over Z years 2019 2020 2021 2022 2023 2024 2025 1000 2020 5 0 200 200 200 200 200 0 </tbody>...

I have been offered 2 payment methods as I was buying some tools for a company I work for. I need your help to assess the best method. Here it goes, Total cost is $100 and I don't want to pay it all in advance. First offer is they increase the total cost by 30% (they call it "financing cost" ...

I successfully created a workbook that had a combined sheet (that contained 7 other workbooks) that successfully used several formulas/functions to get 5 Fiscal Years totals and then produced slicers. I wanted a way to allow the 7 managers to update their individual workbooks an then automate...

Hi I have a table on one sheet with a few columns, including COUNTRY, AREA, ROLE and COST On another sheet I have the same columns where people can select the country, area, role from a drop down The sheet with the predetermined area is called called "CTC", some example cells: C7 = USA D7 =...

Bit of a novice here so please bare with me. Trying to use an ISBLANK formula like so: =IF(ISBLANK(B26),"","Food Cost: "&B26) B26 is the cost of food. I want this formula to tie into a text line and reference both "Food Cost and cell B26 together. For the life of me and cant get this to work.

<tbody> I am trying to write a formula to calculate cost per foot (cell E13) I want the total in cell E12 to be divided by cell C8 if it has data if not move to cell C9, do this through C11. Item Quantity Cost Total Corner post assembly 8 90 720 "H" assembly 10 56 560 Wood...

Hello! Is there way to calculate the hours needed at two separate rates that add up to the total cost of a project? For instance, the estimate is 40,000, and the hourly rates are 120/hr for one position and 150/hr for another position. How many hours of each rate would I need to get to 40,000...