SPREADSHEET CREATION WITH FORMULAS

$30-250 AUD

Selesai

Disiarkan

9 bulan yang lalu

$30-250 AUD

Dibayar semasa penghantaran

structure a basic job cost calculator in Excel TO PRICE JOBS 1. **Setup Your Excel Sheet**: - A1: "Material Cost" - B1: Enter your material cost, e.g., "$1000" - A2: "Labour Cost" - B2: Enter your labour cost, e.g., "$500" - A3: "Desired Profit Margin (%)" - B3: Enter your desired profit margin, e.g., "35" (for 35%) - A4: "Third Party Payment (%)" - B4: Enter "8" (for 8%) - A5: "Total Cost (Material + Labour)" - A6: "Total Invoice Amount" 2. **Formulas**: - In B5, enter the formula: `=B1 + B2`. This gives you the sum of material and labour costs. - In B6, enter the formula to calculate the invoice amount: `=B5 / (1 - B3/100) * (1 + B4/100)`. This formula calculates the invoice amount needed to maintain the desired profit margin after accounting for the third-party payment. The way the formula in B6 works is by first determining the invoice amount required to achieve the desired profit margin without the third-party payment (`B5 / (1 - B3/100)`) and then adjusts this value to account for the 8% third-party fee (`* (1 + B4/100)`). With this setup, you can easily input different values for material costs, labour costs, and desired profit margins, and the Excel sheet will automatically calculate the appropriate invoice amount. Remember to protect the cells with formulas to prevent any accidental modifications and only leave the input cells (like Material Cost, Labour Cost, and Desired Profit Margin) editable.

Excel

Accounting

ID Projek: 37092189

Tentang projek

11 cadangan

Projek jarak jauh

Aktif 9 bulan yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

@daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Automation, Data Analysis, Complex Formulas, Calculations, Analysis, Financial Modeling etc. To make your hiring decision easier, I can share the limited version quickly before you hire and then you can decide if this fulfills your needs or not. Lets discuss more in detail about my previous similar experience and how I am highly suitable for this project.

$40 AUD dalam 1 hari

4.8

(358 ulasan)

7.5

11 pekerja bebas membida secara purata $80 AUD untuk pekerjaan ini

@toplinesolutions

I have read and understood the details of this project "SPREADSHEET CREATION WITH FORMULAS". I am a Highly-Qualified & Skilled WRITER with more than 10-Years of experience. In last 10 years, I have served more than 2,500 clients and achieved 98% satisfaction ratio of my clients. I strongly believe in customer satisfaction and this is the key factor of my success and I provide a service that gives quality outcome to my clients. I am professionally able to write; Customized Business Plans, Grant Proposals, eBooks, Stories, Articles, Blogs, Resumes, LinkedIn Profiles, and Cover Letters etc. In order to talk with me, please click on “CHAT” button so we can finalize the deal. Thank You :-)

$30 AUD dalam 1 hari

4.9

(54 ulasan)

5.9

@assignsolver

I have read and understood all your project details "SPREADSHEET CREATION WITH FORMULAS" and I feel my self the best candidate to complete this project with 100 percent accuracy. I have vast amount of experience in this industry since I am working from 2009 as a professional writer. I have huge number of client base in these 12 years. I can write Articles, Blogs, Website Content, CV, Business Plans, Books & eBooks and Product Descriptions. I provide Supreme Quality Work against very low prices even in short deadlines. You may contact me anytime so we can discuss your project in detail. Thank You.

$30 AUD dalam 1 hari

4.8

(65 ulasan)

5.8

@IdealExpert

Hi, I have seen your your project details and I am the "BEST CANDIDATE" for this job "SPREADSHEET CREATION WITH FORMULAS". I am an experienced Engineer & Mathematician with more than 8 years of experience who can provide you with Top Notch Solutions as per your requirements within your given deadline and budget. I am M Phil in Mathematics and Graduation in Physics and I have full command of all the areas related to both subjects. My specialties are; LENIAR ALGEBRA, CALCULUS, TRIGONOMETRY, Mathematics, GEOMETRY, MATRIX, Electronics, Digital Logic Design, Circuit Designing, Power System Protection, Communication Systems, and Many More. I have a strong grip on several tools/software such as; Pspice, Multisim, Power Word Simulator, Altium & MATLAB & Simulink. To check my samples, please visit my profile; https://www.freelancer.com/u/IdealExpert Please send me a message to "Hire" me. Thank You

$30 AUD dalam 1 hari

4.7

(15 ulasan)

4.3

@HelpingHut

I am damn sure that I can complete this project "SPREADSHEET CREATION WITH FORMULAS" beyond your expectations and within your given time and budget. I am a Ph.D. degree holder in education management with vast experience in the academic writing field. Alongside my team, I provide custom writings that not only meet your requirements but also adhere to the rules of academic writing. I can solve any kind of assignment related to every subject; Business, Public Relations, Economics, International Affairs & Relations, Education, History, Sociology, Psychology and Criminology, Engineering, Mathematics, English, Literature, and Psychology. I will help you to score over 90% grades in all your homework and assignments even with short deadlines. I promise you that I will provide high-quality and plagiarism-free solutions even with "3-Hours" deadline. Please click on "Award" button to hire me. I am waiting for you, "Thank You"

$30 AUD dalam 1 hari

4.9

(8 ulasan)

3.8

@WritingLabb

SPREADSHEET CREATION WITH FORMULAS I am Minahil Hameed with a vast amount of experience in multiple fields like; Finance & Economics, Accounting & Cost Accounting, Business & Management, and Taxation & Auditing. I have achieved a great amount of success in this industry by providing TOP NOTCH solutions to my clients. I always provide quality services & respect to my clients because I consider him/her my BOSS. I provide a friendly environment to my clients so they always feel comfortable and openly discuss their requirements which allows me to produce MAXIMUM results...! Please visit my profile to see my reviews and samples. www.freelancer.com/u/writinglabb

$30 AUD dalam 1 hari

5.0

(2 ulasan)

1.8

@dealzdekho

Dear Client, I have carefully reviewed your project requirement and I am confident that I can assist you in creating a job cost calculator in Excel. With over 6 years of experience in accounting and proficiency in Excel, I am well-equipped to handle this task with perfection. I have read through the project description and understand that you need a spreadsheet that calculates the total cost and invoice amount based on material cost, labor cost, desired profit margin, and third-party payment percentage. I can set up the Excel sheet as per the provided structure and incorporate the necessary formulas to achieve the desired functionality. To discuss your exciting project further, I would like to connect with you in the chat. This will allow us to clarify any additional requirements or specifications you may have, ensuring that the final deliverable meets your expectations. I am confident that my expertise in accounting and Excel, combined with your valuable input, will result in a job cost calculator that meets your needs. I look forward to the opportunity to work with you on this project. Best regards, Soham

$140 AUD dalam 7 hari

0.0

(0 ulasan)

0.0

@Ismtsuraj

Greetings, l am Rassel Singha, work as a virtual assistant to you and your organization. My main aim is to deliver the work in the fastest time with accuracy and efficiency. Notable among my services are - File Convert + Retype (PDF to Word, Excel) Services and good Formatting in Microsoft Word & Excel. I believe in action rather than words.

$140 AUD dalam 7 hari

0.0

(0 ulasan)

0.0

@nehadevpura2

I have a degree in accounting with experience in professional field for three years. I am confident for completion of the task and accuracy. My skills include accurate data entry, strong math skills, and effective communication. I know how to prepare and do accounting entries such as QuickBooks accounting, accounts receivable, accounts payable, sales, expenses, Bank reconciliation, financial statements including balance sheet, profit and loss account and Income statement. . Through my education and work experience, I have developed a deep understanding of accounting principles which can benefit your company greatly. If you award me the project, I would be pleased to discuss this further and get started with you as soon as possible. Thanks Neha

$100 AUD dalam 5 hari