Calculate unit costs for items in a price schedule. Get accurate prices per unit for items like brick, sand, and cement.

Schedule of Prices

Purpose

The "Schedule of Prices" function in this web app is designed to calculate the unit cost of different items based on the input prices and units provided by the user. It helps in generating a schedule that lists the unit cost of each item.

Use Cases

• When you want to calculate the unit cost of items such as bricks, sand, and cement.
• When you need a detailed schedule showing the unit cost of each item in the specified currency and unit of measurement.

How to Use

1. Enter the prices and units for each item in the input form.
2. Click on the "Calculate" button to generate the schedule of prices.

Input Values

1. Item: Name of the item (e.g., Brick, Sand, Cement)
2. Price: Price of the item per unit
3. Currency: Currency in which the price is specified (default currency is BDT)
4. Price Per: Number of units the price is based on (e.g., 1 for each item, 100 for per 100 units)
5. Price Unit: Unit of measurement for the price (e.g., ea for each, cft for cubic feet, bag for bag)

Output Values

1. Unit Cost: Calculated unit cost of each item in the specified currency and unit of measurement.

Any other Instruction

• Make sure to enter accurate prices and units for each item to get the correct unit cost in the schedule.
• Review the generated schedule to verify the unit cost of each item.

Steps of Calculation

1. The function calculates the unit price by dividing the provided price by the price per unit.
2. It then formats the unit price with the currency and price unit to display the final unit cost.
3. The function generates a schedule of prices listing the unit cost for each item.

Technical Parameters

• request, rate_schedule

Return Values

• cost_schedule

Example Expressions

You can use the following expressions to directly evaluate in a non-interactive manner using eva():

1. Example Expression 1:

rates(request, pd.DataFrame({
    'Item': ['Brick', 'Sand', 'Cement'],
    'Price': [10.0, 2000.0, 500.0],
    'Currency': ['BDT', 'BDT', 'BDT'],
    'Price Per': [1, 100, 1],
    'Price Unit': ['ea', 'cft', 'bag']
}))

1. Example Expression 2:

rates(request, pd.DataFrame({
    'Item': ['Tile', 'Steel', 'Paint'],
    'Price': [15.0, 3000.0, 100.0],
    'Currency': ['USD', 'USD', 'USD'],
    'Price Per': [1, 10, 1],
    'Price Unit': ['sq ft', 'kg', 'gal']
}))

Click on Help icon to open the help page on a separate window.