Report of the Week - What-If Analysis (Influence of Discount over Sales)

Report of the Week - What-If Analysis (Influence of Discount over Sales)

When an archer is aiming to hit the bullseye (or a sniper, her target), she has to consider external factors like gravity, wind direction and wind speed. Similarly, when running your business, you will have to ask various questions. Have you aligned yourself against all external factors, when it comes to meeting your target? Should you raise the price, or increase the production to make more money in the current market trend? By how much percentage? Is it the right time to run a marketing campaign?


Would it not be easier if you knew what the outcome can be when you undertake such a change? What-if Analysis helps you evaluate such options. It shows you how external changes might affect the outcome of a decision you are about to take.


What can be done?

What-if Analysis shows what might happen if one or more factors change. It lets you know the impact of various factors on your business and gives you an idea of what needs to be done.


Here are a few scenarios where What-if Analysis can help you.


  • You are planning for a sales day. Based on your previous sales, you can measure the impact of discount percent on your revenue and learn what percent of discount makes people buy more. And you can set your discount percentage to an optimal value so that it leads to maximum profit for you.

  • You have spent various amount on marketing over the months, which affects the leads gained in each month. With What-If analysis, you can learn what will happen if you increase or decrease the expenses.

  • You have multiple teams working on different projects. There will be different billing prices and hours per week, each team member might be working for.  You can check the time and money needed for each member - project combination and choose the best combination out of it to assign projects.

  • You have projected sales for the next six months. There is a possibility of your revenue increasing or decreasing and you can know with What-if analysis how much your revenue would be, based on percentage increase/decrease.

  • And much more...


Now, let's see how to implement the first example of measuring the impact of discount percentages on your revenue.



How to do What-if Analysis

You can easily set up a What-if report by following the steps here.


Step 1: Creating Variables


As we said earlier, What-if Analysis is to show the outcome when one or more parameter value changes. To parameterize dynamic inputs, you need to store all the possible values in a placeholder named Variable.

Here, we have created two variables to apply the change in discount percentage and sales volume. 


Discount Percentage

Create a variable with a range of discount percentages you are planning to provide. We have set the Range between 5 to 50 with an Increment Size of 5. And the Default Value is set as 10




If you plan to have different discounts for each product category, you need to create different variable for each category.



Sales Volume
Create a variable with a range of possible sales volume change. We have set the Range between -50 to +50 with an Increment Size of 5. And the Default Value is set as 0.



Step 2: Creating Aggregate Formulas


Construct an Aggregate Formula to compute your metrics. Insert the variables appropriately in the formula to visualize the impact as the dynamic value changes. You can specify different calculations for each value or a range of values.  

The following is the formula to calculate the sales after discount.

 

sum( "Sales"."Sales" )-(sum( "Sales"."Sales" )/ 100 )* ${Discount %} *(1+${Sales Volume}/100


If you have different product categories, then use the following formula to calculate the Sales after discount for all products with different discounts. 


Sum( "Sales"."Sales" )

-(sumif( "Sales"."Product Category" = 'Furniture' , "Sales"."Sales",   0 )/ 100 * ${Furniture Discount %} )

-(sumif( "Sales"."Product Category " = 'Stationery',   "Sales"."Sales",   0 )/ 100 * ${Stationery discount %} )

-(sumif( "Sales"."Product Category" = ' Grocery', "Sales"."Sales",   0 )/ 100 * ${Grocery Discount %}))*(1+${Sales Volume}/100 )


Step 3: Creating Report


Create the What-if report using the Aggregate Formula in Step 2.
  • X-Axis - Date with Month & Year
  • Y-Axis - Sales with Sum and Sales After Discount (Aggregate Formula with variable) with Actual



Report will be created as shown below. Sales after Discount will be calculated with a 10% discount based on the Variable's default value.



Apply Forecast for next one month to see the prediction for the upcoming month. 



Now, how do you dynamically change the input for the reports? We will see how it's to be done in the following step.

Step 4: Adding Variable as User Filter


Add the discount variables we had defined in Step 1 as User Filters in the report. Each User Filter will be in the form of a slider and will list the discount values in steps of 5. As you change the input (discount percentage) by moving each slider, the report will get re-generated dynamically based on the appropriate calculations defined in Step 2.



The final report will be as shown here. As you drag the What-If Variable sliders (the User Filters at the top), the total sales after discount will be calculated based on the values.


Now you have the privilege to know what might be the outcome of your sale month. And you are one step closer to a discount campaign run successfully!





        • Recent Topics

        • ticketsCountByFieldValues

          Hi Zoho Team, Just to check how can I include customfields to the url string. currently I'm using this. url :"https://desk.zoho.com/api/v1/ticketsCountByFieldValues?accountId=xxxxxxxxxxx&departmentId=xxxxxxxxxxxxxx&field=statusType,status" If I add customFields
        • Mrs

          I have paid for a year subscription. I cannot set up my account I need help
        • Rich-text fields in Zoho CRM

          Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatile
        • Clone a Module??

          I am giong to repurpose the Vendors module but would like to have a separate but very similar module for another group of contacts called Buyers. I have already repurposed Contacts to Sellers. Is it possible to clone (make a duplicate) module of Vendors
        • Webhook from Zobot to Zoho Flow fails

          I'm trying to connect from zobot to zoho flow. When testing in zflow, I am receiving all entered data from the connector correctly. The SalesIQ connector's "outputreaction" is {} (is this normal or is there a problem?). But as soon as I try my chat bot
        • New Asap Widget How to update my code

          I know you're still working on updating the documentation for calling the Asap Widget, the existing documentation is no longer valid. In the old 1.0 version I was able to do many things programmatically in javascript. I could open an article directly
        • Unified WhatsApp Number Management in Zoho Desk and SalesIQ

          Dear Zoho Desk Support Team, We are currently utilizing both Zoho Desk and Zoho SalesIQ for our customer support operations. While both platforms offer WhatsApp integration, we are facing challenges due to the requirement of separate WhatsApp numbers
        • Ability to re-order Workflow Rules

          We really need the ability to re-order workflow rules within departments.  Either the ability to drag/drop them into a different order or something.
        • Is it possible to lock editing subform rows?

          Ideally editing would only be locked after the form has been updated but I still want them to be able to add new subform records at any time and they should be able to delete rows from the subform. It is a named subform if that's relevant however the
        • Customer Parent Account or Sub-Customer Account

          Some of clients as they have 50 to 300 branches, they required separate account statement with outlet name and number; which means we have to open new account for each branch individually. However, the main issue is that, when they make a payment, they
        • Zoho CRM <> Zoho Desk Account Sync

          I have had custom fields in Zoho CRM for a time and would like that data to sync to Zoho Desk. However, since the accounts are all synced to Zoho Desk already, the newly mapped fields are not updating in Zoho Desk. Is there a way to force the sync to
        • Repeating Sections in Writer

          I am wondering if it's possible to create repeating sections or text boxes of a document based on a merged subform fields coming from Zoho Forms. We are currently using excel to dynamically create a legal PDF document based on input fields in another
        • Adding fields to campaign members

          Is it possible to add fields to campaign members? I want to be able to insert a date that certain actions happened as we progress a client, but can't see where or how I might be able to do that
        • Email Body as Ticket Description

          Many of my customers use the support email instead of the portal to enter tickets. When this happens, the "Description" field is left blank. The email subject is automatically entered as the ticket subject when tickets are created this way - I would like
        • Can I export to PDF in Zoho Learn

          I have seen help pages where export to pdf options are available but I do not see that option available from the application. I see that exprt is available in my free trial version but that is only to html pages. I need to be able to export my manuals
        • Ticket/email attachment automation

          Is it possible for a ticket to grab any attachments included in the email chain(s) and add them as ticket attachments?  Or at least is there a better work-around than saving attachments to a workstation and then uploading them to the ticket? What is the best workflow others have found to include files sent to and from clients in tickets?
        • Add rows in subform with Excel / Sheet datas

          Hi! I'm trying to build an application where I can choose an Excel / Sheet file from a Workdrive folder, and for each data in the file, I create a row of a subform. But I can't do it, here is the code I have: inputString = input.choose_xls_file; separatorIndex
        • How do you print a refund check to customer?

          Maybe this is a dumb question, but how does anyone print a refund check to a customer? We cant find anywhere to either just print a check and pick a customer, or where to do so from a credit note.
        • This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details

          Hello, Just signed up to ZOHO on a friend's recommendation. Got the TXT part (verified my domain), but whenever I try to add ANY user, I get the error: This user is not allowed to add in Zoho. Please contact support-as@zohocorp.com for further details I have emailed as well and writing here as well because when I searched, I saw many people faced the same issue and instead of email, they got a faster response here. My domain is: raisingreaderspk . com Hope this can be resolved.  Thank you
        • custom candidate status

          how can I customize the candidate statuses (referenced to job opening). The default list can not be edited.
        • How to... Automatically update a field in "Contacts" that i change or add in "Accounts"

          Hi There HELP ;_) I have a field in ACCOUNTS called REPS that has drop down options (Global Drop down List) I want to Update a field in CONTACT called REPS (Global Drop down List) automatically for all contacts associated to the Company in Accounts I
        • Is there a way to select all notes in a notebook at once?

          I am trying to move notes into other notebooks but I can only select individually at the moment ( holding control allows adding to selection but it's tedious when there are a lot of notes and if I mis-click I have to start again.
        • Notebook freezes mobile

          Hi I'm very happy to have found an alternative to Evernote! But when using Notebook on my Android mobile, it freezes. Typing gets very slow. I need to exit the app, and when I do so, my screen becomes black and need some time to give access to the phone
        • Setting Duration for Tasks

          Can any one have any idea how can we set start date and end date for tasks by excluding saturday and sunday.
        • Zoho Learn Add members to a course API issues

          Hello, Been having an issue with the add members to a course API for quite some time now. uids = list(); uids.add(ZUID); paramMap = {"userIds":{"" + uids + ""}}; addmember = invokeurl [ url :"https://learn.zoho.eu/learn/api/v1/portal/" + portal + "/course/"
        • Recurring Events Not Appearing in "My Events" and therefore not syncing with Google Apps

          We use the Google Sync functionality for our events, and it appears to have been working fine except: I've created a set of recurring events that I noticed were missing from my Google Apps calendar. Upon further research, it appears this is occurring
        • Version Update in Writer Desktop Apps?

          Are there plans to add the ability to check for updates within the Writer desktop apps? There seems to be no simple way of knowing if newer version are available for download.
        • Using Direct Assignment Automation for Keywords in Tickets

          Hello, I'm trying to use the Direct Assignment automation to move a ticket from one department to a different one based on a keyword found in the tickets subject OR description. SAMPLE:  Ticket Create (Checked) Ticket coming to - Dept A Criteria - Subject contains keyword OR Description contains keyword Move Ticket to - Dept B Assign Ticket To - Unassigned I saved and tested this by sending emails to Dept A using the keywords, but it keeps sending it straight to Dept A. Am I doing something wrong
        • Created delayed alerts

          We have a custom alert & rule that notifies our service alerts email address when new tickets are created but these alerts are sent out immediately when a ticket is created, is there a way to set the alerts to be sent out 15 minutes after the ticket is
        • Get Workflow Metadata via API

          Is there a way to get metadata on workflows and/or custom functions via API? I would like to automatically pull this information. I couldn't find it in the documentations, but I'm curious if there is an undocumented endpoint that could do this.
        • Cannot read properties of null (reading 'className')

          Hello, I'm attempting to integrate the Zoho desk chat widget. It loads visually on most pages, but at some point, it throws this error and it never appears: Cannot read properties of null (reading 'className') Here is the full trace: floatbutton1_hXdnKUp…f6FPihRNT_T47_.js:1
        • Associate subforms and save templates as draft in Email and Inventory templates

          Hello everyone, We are here with one of the most awaited updates in the Templates! Associate subform data to templates Fields from a Subform can be added to email and inventory templates in a tabular manner. Each subform will be displayed as an individual
        • API issue: list invoices endpoint no longer returns custom fields

          Hi, could anyone please advise. It looks as though the Zoho Books API has been changed, and now does not reflect the documentation. We use the list invoices endpoint (https://www.zoho.com/invoice/api/v3/invoices/#list-invoices) to return a list of invoices,
        • Dashboard customization

          HI, I have been working on a project feedback managment system. In that the manager dashboard should only list his projects, where as in admin dashboard it should list all the projects can we display the dashboard contents based on the logedin user ?
        • Add the new Home Widgets and Social channels to the signature landig page chat?

          the landig page chat window does not show the new features of home widgets and social channels How can we add them to it?
        • Custom Page title

          Hi how can we set a custom page title? like<title> in html Now it displays my username as the page title for dashboards and all other forms. It should be good if the user visits the dashboard page then the title is Dashboard.
        • Schedule Flow on Last Day of Month

          Is there a way to schedule a flow to run on relative terms like last day of month, first Monday of month, 5th day of month, second Tuesday of month, etc?
        • how to send recurring estimates instead of recurring invoices

          Hello, Is it possible to use the recurring invoice functionality to send recurring estimate to our customers ? We first need to send them an invoice in order to receive their purchase order and then send them the invoice with their purchase order number
        • Cross module filtering is now supported in CRM

          Editions: All DCs: All Release plan: This enhancement is being released in phases. It is now available in AU, JP, and CN DCs. Help resource: Advanced filters The Cross-module filtering enhancement is now available to all CRM accounts in the following
        • Make collecting payments from your customers in Bigin easier with payment links

          Greetings, Efficient payment collection is crucial for business success. Bigin already helps your businesses manage and sell products effectively, but we can further enhance this by making payment collection easier. This integrated payment feature lets
        • Next Page