# Sales

216

Solutions

399

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.

Here is some sample data from a table named Sales  (sql server 2008r2)

salesassociateid    salesdatetime                                     Salesamount

1234         2007-01-01 08:00:00.000                 55
1234         2007-01-01 09:00:00.000                200
1234         2007-01-01 14:00:00.000                500
4545         2007-01-01 10:00:00.000                450
4545         2007-01-01 13:00:00.000                210
4545         2007-01-01 15:00:00.000                800

This table contains summary entries for each hours that sales were made.  No entry is written for hours that do not have sales

Sales hours are between 8am and 6pm

trying to write a query that will fill return a record for each potential sales hour with a zero amount for hours not in sales table
per sales associate per day  (for space reasons I just included one day)

Here is what I would like the query results to be

salesassociateid         hourofday    salesamount  salesdate
1234                             8                        55                  2007-01-01
1234                             9                        200                2007-01-01
1234                             10                       0                   2007-01-01
1234                             11                       0                   2007-01-01
1234                 …
0
Hi Everyone

I was wodnering if anyone could kindly help please. I may go on a little bit but please bare with me. I am stuck on how to calculate this particular scenario.

A company charges its clients various different prices depending on the amount of sales per month as follows:

£0-300 sales / £30.00 fees per month
£301-600 sales / £60.00 fees per month
£601-1000 sales / £90.00 fees per month
£1001-2000 sales / £180.00 fees per month
£2001-3000 sales / £250.00 fees per month
£3001-5000 sales / £300.00 fees per month
£5001-7000 sales / £400.00 fees per month
£7001-10,000 sales / £500.00 fees per month
The company has a one off cost £300 per client to set up its clients.

the company has 15 clients and they all get charged different fees per month as they do not have the same sales figures per month.

My question is what would be the best way to have a formula where I can see the breakeven point for the company. As the company would only ever have a one off cost of £300 per client but have various sales revenue figures, I am finding it hard to think of how to do this.

I would very much appreciate it if someone could guide me to a formula. Thank you in advance 🙂
0
Hi
I need help to make financial reports.

I have a website that can show reports about sales and I need it to be printed when the user want it.

The condition is that:
1. Every page must have page number.
2. Printer can tell wheter to change to another paper or not, like a customer reports if the customers is change, so it will be printed to another page even to the current page for the current customer is just half the page.
3. There have to be header for every page and date too under the header, and the footer is just a straight line, like a border bottom.
4. It just can be printed if the user have the permission to do so.
5. It just can be exported if the user have the permission to do so, the export can be csv, excel, and pdf.
6. The tools control can be made by me and can be control by the permission the user have.

I already tried mpdf but I can't handle the download button and other tools because my reports is a dynamic one not the fixed that can be just called like a normal document.

What tools I can use to make the reports I need and with the condition I want?

Thank you...

This is the code:

``````<!DOCTYPE html>
<html lang="en">
<style>
.table td {
border-top:none;
}
.titlerpt {
font-size: larger;
color: #800000;
}
.tbltitle {
border-bottom: 1px black solid;
font-size: medium;
color: #000080;
}
.tblisi {
font-size: small;
}

@media print and (orientation:portrait) {
.table td {
border-top:none;

``````
0
Hello

Imagine this scenario -

A user walks into one of our support centres. The user has one of our mobile apps installed on their device. A beacon within the support centre is set to transmit an alert to a support tech when it detects the presence of our mobile app close to it. The beacon sends information on the user to the support tech who is able to identify them.

Possible?
0
I am a C# developer and Mac user and like the idea of using Microsoft's Visual Studio 2017 for Mac to write a cross platform app for iPhone and Android.

I have played with Xamarin and understand it's actually a website I would be offering, which is in stark contrast to an Objective C native app.

My question involves the need to the App Store from Apple.

If I wrote a cross-plarform app, could I distribute it outside the Apple channel? An iPhone user can purchase anything they want from a website.

Wondering...

Thanks
0
Hi
I have 2 different methods which are used to forecast future product returns, the problem is that the answers from each method are drastically different - ie; one method is nearly double the forecast qty of the other (4966 vs 2689), and I'm looking for some advice on which is the most appropriate or "statistically correct" (if there is such a thing).

See attached file to better understand the methods used, and their results.

The data that is involved is Sales and Returns of a product across the product timeline.
The product timeline refers to the date from when the product was first sold, to the date when the warranty runs out on that first sale.
The warranty period for the product is eg; 36 months - so 36 months after the first sale is made, the warranty expires and the product is no longer in the Warranty Install Base (WIB).

The WIB is cumulative sales from the first sale of the product until the warranty runs out.

The first method uses the returns per month against the WIB (for that month) to provide the monthly return rate.

The second method uses the cumulative returns per month against the WIB (for that month) to provide the cumulative return rate.

The first method:
Assuming we are running the report in May, n order to project/predict the return rate for June, the report looks at the average return rate for the previous 12 months, and uses this average as the return rate for June.
Then, to predict the return rate for July, we use the  average of…
0
Setting up a new store. There will be about 1300 different inventory items.  I have a merchant Visa/MC processing account. Is there a way to process all the sales on an iPad? When I was at a farmer's market once, the shop owner did the whole thing on his iPad. Typed in the product code on the pad, swiped my card and I signed right on the screen. The receipt got emailed to me in lieu of printing. I really liked the simple solution. This is also the way the Apple salespeople do it at Apple stores. No need for a big cash register set up. Not even a computer or printer.

So..... what app is that? What was that guy using at the farmer's market?

FYI: My merchant services provider is PayPal (NOT to be confused with PayPal "request money" via email). It's a service that PayPal has that directly processes the Visa/MC WITHOUT the PayPal stuff that most people do (i.e. sign up for an account, yada yada).

Anyway, if the above could be done, great. and the following would be an extra bonus, if possible:

1) Scan barcodes with the iPad camera
2) keep track of inventory

-  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -  -

Anyway, I want to keep this simple. The farmer's market owner's solution is exactly what I'd like. If the scanner/inventory makes it all much more complicated, I can eliminate that.

Greg
0
hi,

i'm using sharepoint 2007, wss 3.0 and on our main page i have a rectangle box going from right to left with some sales figures inside

how do i go about removing this rectangle box

regards
si
0
A client of mine is interested in obtaining a list of all of the online payment systems besides PayPal.

Please provide me with a list of online payment systems besides PayPal.
0
I've tried to create a Form to Calculate Sales and Taxes, but I'm not able to get the form to work.  Super new to vba, off and on for a few years and its now become imperative for me to get this done.  This is the code i have so far.

Private Sub txtSalesTax_Change()

Me.txtSubtotal.Text = Val(Replace(txtSalesPrice.Text, "\$", "")) * Val(Replace(txtSalesTax.Text, "%", "")) / 100

End Sub

Private Sub txtSubtotal_AfterUpdate()

Me.txtSubtotal.Value = Format(txtSubtotal.Text, "\$0,00")

End Sub

Private Sub txtSalesTax_AfterUpdate()

Me.txtSalesTax.Text = Val(txtSalesTax.Value) / 100
Me.txtSalesTax.Text = Format(txtSalesTax, "Percent")

End Sub

Private Sub txtTotalSale_Values()
Dim dbltxtTotalSale As Double

On Error Resume Next

dbltxtTotalSale = CDbl(txtSubtotal.Value)
dbltxtTotalSale = dbltxtSubtotal + CDbl(PriceIncrease.Value) - CDbl(txtSubtotal.Value)
dbltxtTotalSale = dbltxtTotalSale + CDbl(PriceIncrease.Value)

txtTotalSale.Value = dbltxtTotalSale

txtTotalSale = Format(txtTotalSale, "\$0.00")

End Sub
0
Dear Experts

We are evaluating to provide crome note books to sales force team who are using SugarCRM enterprise , at present they are using SugarCRM mobile app but there is a requirement from them for the laptop/note book, also we have integrated SugarCRM with google.
please suggest me does crome notebook does it have a portability or supports dongle/data card for the internet,  this is in additional to the wifi connectivity also is it possible to control the app level like to restrict users only use business applications like CRM and ERP.

0
Dear Experts

please suggest me on how to convince the sales users regarding the benefits of sales force automation.  not too technically but make them understand on how it helps to them and organization, please help me here listing few points.

Thanks
0
fatal error : Exception code= C0000005 @
error log
file: Z:\\VFP9Rerr.log
Called from - pos.loadline.line 0 ( )
Called from - pis. grid1. colpart_part_no.keypress line 0 ( )
Called from - rman line 0 (z:\rman.exe)

please how can we fix this
currently running a retail store pos software and that error occurs when trying to scan an item  for sales
0
On my site, I want to advertise books which are similar to my own. I heard I can be an affiliate w/ Amazon and earn a small cut.

What kinds are commissions are we talking about for a book that retails for \$19.99?

I do have WooCommerce installed.

Thanks
0
1)      Using one-dimensional array. A company pays its 20 salespeople on a commission basis. The sales people receive PHP 2,000.00 per week plus 9 percent of their gross sales for that week. For example, a salesperson who grosses PHP 5,000.00 in sales a week receives PHP 2,000.00 plus 9 percent of PHP 5,000.00, or a total of PHP 2,450.00. Write a program(using an array of counters) that determines how many of the salespeople earned salaries in each of the following ranges (assume that each salesperson’s salary is truncated to an integer amount):
a.      2000-2999
b.      3000-3999
c.      4000-4999
d.      5000-5999
e.      6000-6999
f.      7000-7999
g.      8000-8999
h.      9000-9999
i.      10000 and above
0
I want to protect a cell from editing but allow the cell to be populated with a radio command button that populates the cell with the user id and timestamp.  a pop up message appears when the cell has been populated (in my case approving the form).  I can certainly lock the cell but then the radio button doesn't work,  what do I need to add on the front end of marco below?

Sub Product()

Range("\$i\$5").Select
Range("\$j\$5").Select
ActiveCell.FormulaR1C1 = " " & Now

x = UCase(Range("\$i\$5").Value)
y = UCase(Range("\$i\$3").Value)

If x = y Then

MsgBox "ERROR - APROVER ID ERROR" & vbNewLine & vbNewLine & "Product Approver ID must be different then Sales Approver ID"

Range("\$j5").Select
ActiveCell = vbNullString
Range("\$i\$5").Select
ActiveCell = vbNullString

Exit Sub

End If

MsgBox "Approved"
End Sub
0
We are trying to build and excel spreadsheet for our sales people on their commission they earn and are have difficulties putting in the correct formulas.  Here is what we are trying to accomplish.  If a Sales Person make a sale to ABC company on 1/1/17 for a 36 month period for \$1000.00 they are paid in percentages in the given form.  Month 1 -12 they are paid 10%, 13 - 24 @ 4%, 25 - 36 @ 1% and commission is ended at the the end of the 36th month.  Any advise would be helpful to get on the right track.

0
I have a client who says that only 18% of their online sales (of a book) come from what PayPal terms, "mobile devices", which appears to be significantly lower than what his web stats indicate are mobile visitors.  All things being equal, his sales should be well over 50% mobile, since well over 50% of his visitors are mobile.

Does PayPal consider tablets such as iPad and Android to be mobile devices?  Or are just phones mobile devices?  I cannot find anywhere where PayPal defines this.
0
We have a situation where a user-defined field has been added to the main Invoices table on a customer's Pastel Accounting system to store a VAT number. In certain situations the user has to enter that VAT number and if they do not then a trigger will come into operation to warn them by displaying a message. The problem arises when, after having shown the message, the user goes back to enter the value in the field but the system does not perform the update. I am showing below various versions of the trigger that we have tried to no avail.

USE [Foodspec Co (Pty) Ltd]
GO
/****** Object:  Trigger [dbo].[tnt_VatNoPrommpt]    Script Date: 3/20/2017 2:26:00 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[tnt_VatNoPrommpt]
ON [dbo].[InvNum]
AS
BEGIN
/*
ucIDSOrdInvCashSaleVATno UDF IS REQUIRED FOR THIS TO WORK!
FIELD NAME: InvCashSaleVATno
TYPE: STRING
SIZE: 100
CREATE ON:INVENTORY DOCUMENT - SALES ORDER
*/
DECLARE @custID INTEGER
DECLARE @vatNo VARCHAR(100)
DECLARE @DocType INTEGER
SELECT @custID = AccountId,
@DocType = DocType,
@vatNo = ISNULL(ucIDSOrdInvCashSaleVATno, '')
FROM inserted
IF @custID IN(36,37,1) AND @DocType = 4 AND @vatNo = ''
BEGIN;
--RAISERROR ('Please Supply A Cash Sale VAT Number!

--                  This Transaction Will Be Rolled Back. '
--                  , 16, 1) WITH NOWAIT
--ROLLBACK TRANSACTION
THROW 50000, …
0
Is there a chart or article or rule of thumb for consulting rate differentials?
If a consultant gets paid \$X dollars per hour on a W-2 basis, what does that translate to on a 1099 basis?
Is it 50% more? 2% more?  I'm interested in the higher-tax states like NY, NJ, CT, CA
I realize that state and city taxes factor into this so perhaps there might be a chart with various states/locales listed.
1
I want to join two tbls (or more, not sure I need tblReps?) in a qry.  What kind of joins do I need here?  Need to include rep that might have 0 sales and/or quotes for given week as well.
The design:
On the left is what I get currently w/o joins; on the right is a mock up of what it should be. (also do I somehow need to tell db that Week Ending Dates are the same (Fridays) regardless -- QDate used in any Quote qrys or SDate used in any Sales qrys -- if joining quote & sale tbls? if yes, then how?)

0
I have attempted asking this before, but can't seem to put the pieces together.  I hope I'm, at least, learning to to better ask my question(s)!  So I am starting over.

I have tblSales & tblQuotes that I want to pull up activity data by Rep by entering 3 parameters:  WeekEndingDate (weeks end on Fridays), month and qtr.  I also would like to include reps with 0 sales and/or quotes for any given interval.

Thank you for your help and patience to date, and going forward!
0
Say my company is "X" number days into the year, and my sales are "Y".

I would like a formula to calculate my estimated annual sales based on the current date, calculating the number of days from the first day of the year (January 1) until today, and calculating the estimated end of year total sales based on year to date sales.

I would like to do this without entering an actual date anywhere in the spreadsheet, but instead based on my computer's internal time and date.

For example, if the date was today, February 23, there would have been 54 days since (and including) January 1, so if my sales today were \$150,000, the formula return I am looking for would be \$1,013,888.99.  (((\$150,000/(todays date - January 1))*365)

Thanks!
0
(sorry originally posted as addl comment to my solved qtn of 4 days ago, but not sure that was the right spot to get viewed so I am posting it again, new?!). not sure how to reference previous thread other than it was titled "aggregate query?"  (PatHartman - assisted and Ryan Chong -solved)

Hmm ... had what I thought was a similar issue and the solution above didn't work.  Rep #10 had \$0 sales for week.  Tried left/right outer joins, is this somehow a different scenario bc it's not working?
0
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Chapter5PA2
{
class Program
{
static void Main(string[] args)
{
decimal Sales;
double Ratio;
decimal Net;

Sales = GetSales();
Ratio = GetProfit(Sales);
Net = GetNet(Sales, Ratio);
Convert.ToDouble(Sales);
DisplayResults(Sales, Ratio, Net);
}

public static int GetSales()
{
int Sales;

Console.WriteLine("    Sales Profit App");
Console.WriteLine("Please enter the Sales amount: ");

return Sales;
}

public static double GetProfit(decimal Sales)
{
double ProfitRatio;
if (Sales < 0)
ProfitRatio = 0;
else
if (Sales < 1000)
ProfitRatio = 0.03;
else
if (Sales > 1000.01m || Sales < 5000m)
ProfitRatio = 0.035;
else
if (Sales > 5000.01m || Sales < 10000m)
ProfitRatio = 0.040;
else
ProfitRatio = 0.045;

return ProfitRatio;

}

private static decimal GetNet(decimal Sales, double Ratio)
{
…
0

# Sales

216

Solutions

399

Contributors

Sales is the act of selling something; the exchange of goods, services, or property for money. Use this topic to talk about sales cycles & funnels and sales strategy. Please do not use this topic for Marketing.