In Progress

Excel Macro/VBA calculations setup

Budget $80 - $100

Product Monthly Service Billing: costs/price/profit calculator

Need an Excel spreadsheet build for multiple products, multiple cost entries per product, percentage price markup on costs, additional family price discount based on units ordered. Allow for 12 costs. Setup a forum for data entry. Label all cell input values and calculated values.

Consumer price:

Calculations will for cost total with cost breakdown.

Provision for simultaneous multiple (5) mark-up what if factors per cost item, display marked up amount, display cost plus mark-up amount, display cost plus mark-up amount rounded to nearest dollar plus add in a fixed dollar amount e.g. $1.99 or $ .95

One special cost called MC = 20 % (enter as a variable) of total of marked-up costs

Display profit margin. If none of the 5 mark-up values result in a profit margin = 60% , make this an entry variable, display increases in total cost mark-up in a separate cell to achieve a profit margin of 60% (enter as a variable)

Optional Voice pricing:

Same as other costs but optional. Other costs are not optional.

Family pack:

If family pack is selected, family pack cell = y, enter the total cost, enter the regular price, number of units entered => the minimum number of family packs units, enter and apply a family pack discount percent variable and display the price per unit and the total price, display the profit margin.

Distributor Monthly Price:

Calculate percentage and display the percentage that will establish a distributor price where the total of costs marked-up – the distributor price (x in this case) = $5.00. Display the distributor price.

Distributor Volume discount on monthly fees:

Enter total cost, enter distributor price, enter percentage discount, display discount price, display profit margin percentage

Product cost/price calculator

This section will deal with product costs, discounts and prices. Same as monthly fees except skip Family Pack and skip Distributor Monthly Price. Allow for twelve product costs.

One time setup Fee = 20 % (enter as a variable) of gross sales price.

Use one worksheet per product. Setup sheets for 12 products. Include detail explanation of all parameters and calculations in the worksheet.

I will be available for clarification and will provide some sample data. Please convince me that you get the general idea of what we what the spreadsheets to calculate to win the project. Need it as soon as possible.

Skills: Algorithm, Electronic Forms, Excel, Mathematics, Visual Basic

See more: macro vba calculate percentage, calculate price discount vba excel, vba macro gross margin calculator, vba product cost entry, vba excel profit margin calculator, what is voice data entry, visual basic cost, vba with, sheets add, product pricing spreadsheet, pricing calculator excel, price for vba for excel, minimum unit cost, excel special, data entry macro, cost of sales breakdown, calculate factors of a number, 5 dollar deal, vba macro calculate percentage, calculate profit margin vba, what is vba in excel, what is vba, what is macro in excel, vba time, vba for

About the Employer:
( 21 reviews ) Lacombe, Canada

Project ID: #1272419

Awarded to:

ethicalboy

hello, please see what I've said.

$80 CAD in 2 days
(39 Reviews)
4.9

6 freelancers are bidding on average $73 for this job

FIBIN

Hi, The project looks interesting. I can do this in less than 3 days. I am an expert in Excel VBA Programming. I have lot of experience in creating Excel Applications. Please see my PM for more details abot me and m More

$100 CAD in 3 days
(44 Reviews)
5.3
best4best

Please see PMB.

$100 CAD in 5 days
(57 Reviews)
5.0
habayabah

Please read my PM for details of my bid.

$30 CAD in 1 day
(4 Reviews)
3.2
roopamumbai

Hi, I have got expertise with VB/VBA/VB.Net with 5+ years of experience. You have explained quite in detail, I can do this in a days time. Please feel free to write to me if you have any clarification or need More

$30 CAD in 1 day
(4 Reviews)
2.6
mailmeakhila

Hi I have done similar work and can finish within 3 days and 100% accuracy

$100 CAD in 3 days
(0 Reviews)
0.0