I have data for average turnover per hour of a business and have fitted it to a polynomial (order 6) trendline. So I have for example, running along the x-axis i have 8am-9am, 9am-10am, 10am-11am etc and on the y-axis the average turnover for the relevant hour.
What I would like to be able to do is use the trendline's formula to be able to predict sales for any given day. So if I were to enter the first few hours of turnover on any given day, I would like excel to predict the rest of the day's turnover based on the trendline.
I need to predict sales data in future using multiple independent varaibles.I used FORECAST function to predict sales value for single independent varaiables.But i dont know how to predict sales using multiple varaiables.
I cannot solve with Excel 2010 and I have searched all over for the answer.
I have sales data that is approximately daily and would like to count the monthly data and summarize it as an average for the month in a separate column.
I will try to keep this as short as possible. I have a huge amount of stringed data from dry kiln runs all well organized. I want to make something that will look at all this data (or at lease the ones that I specify) and give me a prediction of what would happen if I was to make a change somewhere in the schedule. I have alot more info if needed.
I have an excel sheet which has 70 sheets in it...All of them are numbered but not in a sequential manner (eg : 210,211,201,202,215 etc..).The numbering is nothing but the sales order number....
All the sheets have same data (i.e Column A contains Product Sold, Column B contains Sale Value)...The thing is i want to consolidate all the data in sales order number wise. i.e.
Say there are 3 cols ( A,B & C ) whereby C sums B and A. I have a situation here where C does not show (=SUM(A10:B10)) on the formula bar. I can type anything in C and the formula remains. I've even tried deleting the contents of C. It's like the formula is only activated when values are entered into A and B. Could excel be auto-predicting the formulas as a trend? I would like to repeat this for my other workbooks but I could not find a way to repeat this fluke.
I am trying to determine the top contributors to 50% of sales based on cumulative percent of sales (see attached file). I can determine if percent of sales is less than 50%, but I need to include the person that pushes the group of top performers over the 50% mark.
I have a sales level that I need to track...My rolling 12 months' sales must be $85,000 and my currently monthly sales must be $7,000. I have a sheet that tracks the $85,000 and tells me what I need to achieve that, but I haven't figured out how to include the $7,000 monthly minimum....
The chart below is what I have. So for example, this month it's telling me I only need to sell another 3016.46 to hit the $85,000 rolling 12, but I actually need to hit $4821.79 to meet the $7k minimum.
Actual Rolling 12 Goal Sep 2012 5,367.24 73,663.30 Oct 2012 5,649.93 69,496.28 Nov 2012 14,163.38 73,451.30 [code]....
I have daily basis monthly sales. Now I want to summarize into monthly gross. Pls look attached file. I am looking for a formula to summarize January daily sales from date 1st to 31 st as of just January and and sum of each day gross.
I have created a chart on excel for us to track daily sales but also to figure sales tax so we know what to send the IRS each month. We have been figuring the sales tax ourselves and filling in the chart on excel but I would like to create a formula that automatically does it for me based on total sales.
In cells A4 to A54, their names are displayed. In cells I4 to I54, their total sales are displayed.
Starting in cell B59 and C59 I'd like to display their name and sales respectively.
Also in column I I'd have a second value which would be a total of each department. Would it be possible to leave this data out of the formula? No big deal if I have to put that value in the next column.
I need to copy the values of a range on the weekly sales worksheet to the monthly sales worksheet. The last column is the total on the weekly sales. Part of the heading of the total column is the week ending date (e.g. 10/17/2009. On the Monthly Sales I have the months in columns by week ending (e.g. 10/17/2009).
Range I4:I28 to the monthly sales worksheet by date.
I'm stumped on what I know is a pretty basic problem. Maybe i'm just trying to over think it.
I have a table of sales data...One field is the date it was sold, one field is the amount it sold for. The date field isn't in order and it contains dates over the past 12 months. I need a way to total the amount of sales in each month and not through a pivot table. I am able to count how many entries there are, but I can't find a easy way to do a count of how much was sold in each month.
I am trying to create weekly sales charts from my worksheet. The variables I have are the items in inventory, their respective price points, and units sold week by week (for about 5 weeks so far). I am having trouble formatting all of this information in the correct way to get accurate charts conveying the movement of our inventory.
At the end of every month I receive a sales report from our ERP system setting out sales quantities by Customer ID e.g. ABC001 and Product ID e.g. FB3000. I need to collect the data for each month and gradually build a report for a 12 month period.
My problem is that each monthly report does not include every Customer ID and every Product ID, it only includes cases where sales quantity was > 0. So as each month's data arrives I need to make sure that my report has all necessary Customer ID and Product ID pairs so I am not missing any sales.
Basically, I'm doing a recorded macro for work where I take an export and manipulate the data to show differences between sales from last year and this year. Also comparing this months projected sales to avg of last 6 months and also against last years this month.
The problem I'm running into is in automating the this month sales for mid-month exports. I can do it individually but I can't find a formula that will do it. Data is in one cell per month, so ex. 130 sales this month so far. I need to have it convert that to projected sales for total month based on what day it currently is.
I want to restrict the value entered on a sales sheet to force the value to be over 15% margin. In column M you enter a value in column N it report the margin. I want to force the value in M to give a minimum 15% in column N or report an error.
I want to track daily sales of a shop with the tenders (Cash, Master, Visa)seperated.
Everyday there will be a file ctp.dbf from a folder YYYYMMDD (previous day date) which contains sales details.
I tried to use sumif commands and everything is working fine. everytime i have to open book.xls and from it I do a files>Open to open the ctp.dbf for the calculation to be done. is there a way where by i can open 1 file and everthing i calculated properly?
Also this book.xls can only do for 1 day how can i go about having the daily sales detail of the month (look something like sales summary.xls) or even year in 1 excel file?
attached is book.xls and sales summary.xls for reference.
I have one sheet that shows a list of all vehicle sales for a month: with a customer column and a salesperson column and a gross profit column. I would like to give a printout to each salesperson from a different sheet that only shows that salespersons transactions on it. Can excel parse that information out and list it in order row by row showing each sale for just one salesperson per sheet?
My partner and I are selling products. He gets 5% of the sales price, then I get the rest. But I want to make at least $2 on every sale. So, let's say the item cost us $50. If he wants 5% off the top, and I want at least $2, how do we calculate what to sell it for?
I tried the following, but it didn't work: $50 (cost) + $2 (my profit) + 5% (partner's profit) ------ $54.60 (sales price)
It doesn't work because I end up with $1.87. $54.60 (sales price) - 5% (partner's profit) - 50 (cost) ------ $1.87 (my profit)
I've tried other things, but I always end up under $2. Is it possible to calculate this? or do I need to have a percentage for myself? If Excel can't do it, do you know of any calculators out there than can?
I want is for the the cover sheet to provide a simplified version of the price list for people to use that will auto complete price to customer once product has been selected.
- how do I create a sublist? so if a user selects a product group from a drop down list in cell b1 then cell b2 will automatically display only the items from that groups subset.
- how do I link prices? If a user selects data from a drop down menu in b2, is it possible to display the price for that item in cell b3?
I am looking for the formula for calculating Sales realization in installments i.e. if i am selling $100 in 1st year i am receiving 50% in 1st year and balance in next 3 years same thing happens in 2 year.
I'm trying to calculate a sales run-rate which will change on a day-to-day basis, to predict the end-of-month sales total.
The invoice values are in the data range H17:H74 (I don't want the final formula to add up the refunds in this field i.e. negative values)
The date field is in data range C17:C74.
So basically the formula will need to add all invoice totals (excluding refunds) and divide by the current number of days worked in the month (not duplicating days in the date field) and then multiply this by the average number of working days in a month (21). This should should give a predicted end of month sales total.
Am I just making things up that are impossible to do on excel?
I've had a bet with the other guy in the sales office because I said excel can do a lot more than he thinks. He's under the impression that excel begins and ends with what they teach you at school.
I have a query regarding making a Excel Sheet for Daily sales.
here I go, Well i want to make an Excel Sheet where in I just need to enter the Date, Invoice Number , Product , No of Product and rest it should calculate the VAT (Rounding Off) amount N den the Grand Total..
