Sales Price Variance Calculator

✖Actual Selling Price refers to the price at which a product or service is sold to customers, as opposed to the standard or budgeted selling price.ⓘ Actual Selling Price [ASP]			+10% -10%
✖Budgeted Selling Price is the anticipated or planned price at which a product or service is expected to be sold, based on budgeting and forecasting calculations.ⓘ Budgeted Selling Price [BSP]			+10% -10%
✖Number of Units Sold refers to the quantity of products or services that a business has sold within a specific period, reflecting its sales performance.ⓘ Number of Units Sold [n]			+10% -10%

✖Sales Price Variance is the difference between the actual selling price and the budgeted or standard selling price, multiplied by the actual quantity sold.ⓘ Sales Price Variance [SPV]

⎘ Copy

👎

Formula

✖

Sales Price Variance

Formula

`"SPV" = ("ASP"-"BSP")*"n"`

Example

`"4000"=("102"-"98")*"1000"`

Calculator

LaTeX

Reset

👍

Download Financial Formula PDF PDF Image

Sales Price Variance Solution

STEP 0: Pre-Calculation Summary

Formula Used

Sales Price Variance = (Actual Selling Price-Budgeted Selling Price)*Number of Units Sold
SPV = (ASP-BSP)*n
This formula uses 4 Variables

Variables Used

Sales Price Variance - Sales Price Variance is the difference between the actual selling price and the budgeted or standard selling price, multiplied by the actual quantity sold.
Actual Selling Price - Actual Selling Price refers to the price at which a product or service is sold to customers, as opposed to the standard or budgeted selling price.
Budgeted Selling Price - Budgeted Selling Price is the anticipated or planned price at which a product or service is expected to be sold, based on budgeting and forecasting calculations.
Number of Units Sold - Number of Units Sold refers to the quantity of products or services that a business has sold within a specific period, reflecting its sales performance.

STEP 1: Convert Input(s) to Base Unit

Actual Selling Price: 102 --> No Conversion Required
Budgeted Selling Price: 98 --> No Conversion Required
Number of Units Sold: 1000 --> No Conversion Required

STEP 2: Evaluate Formula

Substituting Input Values in Formula

SPV = (ASP-BSP)*n --> (102-98)*1000

Evaluating ... ...

SPV = 4000

STEP 3: Convert Result to Output's Unit

4000 --> No Conversion Required

FINAL ANSWER

4000 <-- Sales Price Variance

(Calculation completed in 00.004 seconds)

You are here -

Home » Financial » Cost Accounting » Sales Price Variance

Credits

Created by Keerthika Bathula

Indian Institute of Technology, Indian School of mines, Dhanbad (IIT ISM Dhanbad), Dhanbad

Keerthika Bathula has created this Calculator and 50+ more calculators!

Verified by Aashna

IGNOU (IGNOU), India

Aashna has verified this Calculator and 25+ more calculators!

< 25 Cost Accounting Calculators

Material Cost Variance

Go Material Cost Variance = (Standard Quality for Actual Output*Standard Price)-(Actual Quantity*Actual Price)

Labour Cost Variance

Go Labour Cost Variance = (Standard Hours for Actual Output*Standard Rate)-(Actual Hours*Actual Rate)

Revised Standard Quantity

Go Revised Standard Quantity = (Standard Quantity of each Material/Total Standard Quantity)*Total Actual Quantity

Learning Curve

Go Learning Curve = (Time Taken to Produce Initial Quantity*Cumulative Number of Batches)^(-Learning Coefficient)

Labour Efficiency Variance

Go Labour Efficiency Variance = Standard Rate*(Standard Time-Actual Time)*Variance

Time to Receive

Go Time to Receive = Time for Stock Validation+Time to Add Stock to Records+Time to Prep Stock for Storage

Labour Rate Variance

Go Labour Rate Variance = Actual Time*(Standard Rate-Actual Rate)*Variance

Cycle Time

Go Cycle Time = Process Time+Inspection Time+Move Time+Queue Time

Revised Standard Hours of Labours

Go Revised Standard Hours of Labours = (Actual Mix/Standard Mix)*(Standard Hours of Labour)

Material Yield Variance

Go Material Yield Variance = (Actual Unit Usage-Standard Unit Usage)*Standard Cost per Unit

Overall Equipment Effectiveness

Go Overall Equipment Effectiveness = Good Count*Ideal Cycle Time/Planned Production Time

Avoided Cost

Go Avoided Costs = Assumed Repair Cost+Production Losses-Preventative Maintenance Cost

Material Usage Variance

Go Material Usage Variance = Standard Price*(Actual Quantity Units-Standard Quantity)

Labour Mix Variance

Go Labour Mix Variance = Standard Rate*(Reversed Standard Rate-Actual Time)

Material Price Variance

Go Material Price Variance = Actual Quantity*(Standard Price-Actual Price)

Material Quantity

Go Material Quantity = Standard Price*(Standard Quantity-Actual Quantity)

Customer Acquisition Cost

Go Customer Acquisition Cost = Cost of Sales and Marketing/Number of New Customers Acquired

Total Addressable Market

Go Total Addressable Market = Annual Contract Value per Client*Number of Potential Clients

First Pass Yield

Go First Pass Yield = Number of Good Products Finished/Number of Production Orders Started

Average Days Delinquent

Go Average Days Delinquent = Days Sales Outstanding-Best Possible Days Sales Outstanding

Backorder Rate

Go Backorder Rate = (Number of Undeliverable Orders/Total Number of Orders)

Monthly Recurring Revenue

Go Monthly Recurring Revenue = Number of Customers*Average Billed Amount

Sell -Through Rate

Go Sell Through Rate = Number of Units Sold/Number of Units Received

Takt Time

Go Takt Time = Production Available Time/Customer Demand

On-Time Delivery

Go On-Time Delivery = On Time Units/Total Units

Sales Price Variance Formula

Sales Price Variance = (Actual Selling Price-Budgeted Selling Price)*Number of Units Sold
SPV = (ASP-BSP)*n

What is Sales Price Variance ?

Sales Price Variance is a financial metric that measures the difference between the actual selling price of goods or services and the budgeted or standard selling price. It is calculated by multiplying the variance between actual and standard prices by the actual quantity sold. A positive variance indicates that products were sold at a higher price than anticipated, potentially boosting revenue, while a negative variance suggests that products were sold below the expected price, possibly impacting profitability. This variance analysis helps businesses assess pricing strategies, understand revenue fluctuations, and make data-driven decisions to optimize pricing and maximize financial performance.

How to Calculate Sales Price Variance?

Sales Price Variance calculator uses Sales Price Variance = (Actual Selling Price-Budgeted Selling Price)*Number of Units Sold to calculate the Sales Price Variance, The Sales Price Variance is the difference between the actual selling price and the budgeted or standard selling price, multiplied by the actual quantity sold. Sales Price Variance is denoted by SPV symbol.

How to calculate Sales Price Variance using this online calculator? To use this online calculator for Sales Price Variance, enter Actual Selling Price (ASP), Budgeted Selling Price (BSP) & Number of Units Sold (n) and hit the calculate button. Here is how the Sales Price Variance calculation can be explained with given input values -> 4000 = (102-98)*1000.

FAQ

What is Sales Price Variance?

The Sales Price Variance is the difference between the actual selling price and the budgeted or standard selling price, multiplied by the actual quantity sold and is represented as SPV = (ASP-BSP)*n or Sales Price Variance = (Actual Selling Price-Budgeted Selling Price)*Number of Units Sold. Actual Selling Price refers to the price at which a product or service is sold to customers, as opposed to the standard or budgeted selling price, Budgeted Selling Price is the anticipated or planned price at which a product or service is expected to be sold, based on budgeting and forecasting calculations & Number of Units Sold refers to the quantity of products or services that a business has sold within a specific period, reflecting its sales performance.

How to calculate Sales Price Variance?

The Sales Price Variance is the difference between the actual selling price and the budgeted or standard selling price, multiplied by the actual quantity sold is calculated using Sales Price Variance = (Actual Selling Price-Budgeted Selling Price)*Number of Units Sold. To calculate Sales Price Variance, you need Actual Selling Price (ASP), Budgeted Selling Price (BSP) & Number of Units Sold (n). With our tool, you need to enter the respective value for Actual Selling Price, Budgeted Selling Price & Number of Units Sold and hit the calculate button. You can also select the units (if any) for Input(s) and the Output as well.

Home

FREE PDFs

🔍 Search