Design an application to facilitate the estimating process

Assignment Help Applied Statistics
Reference no: EM132382387

Assignment - VBA and Spreadsheet

Learning Objectives: • Design and implement the cost estimating application via VBA and Spreadsheet, involving:

  • Built-in tools and functions in Excel
  • Basic programming in VBA
  • Interaction among VBA code, Spreadsheet, and users.

Instructions:

Background: IndCon LLC is a construction specialist company in concrete construction. Over the years, the company has developed its own cost database aligned with its unique construction method. Table below illustrates the cost database with a few examples.

Section

Sub section

Item ID

Description

Productivity

Cost

Total

Material

Equipment

Labor

01

01

001

Insurance


$600/wk




01

01

002

Performance bond


5% of contract value




01

02

001

Main office


$1000/wk




02

01

001

Forms in place


8.65/SFCA

2.8

5.85


02

02

001

Splicing reinforcing bars

190 units/day

10.45/unit

4.55

5.90


...

...

...

...

...

...

...

...

...

Tasks -

Your objective is to design an application to facilitate the estimating process for IndCon. Specifically, you need to design the data structure to accommodate the cost database and the cost estimate for future projects, design a program to use the database and interact with the user to estimate cost for future projects. Following is a list of functions the estimators would like to have:

1) Picking, rather than typing, an estimate item;

2) Type in the quantity and the relevant cost and time information (how long does it take) is computed automatically and filled in;

3) Provide a mechanism, e.g., a command button, for the estimator to compute the total project cost by adding indirect costs and mark-up. Note the application shall have a mechanism, e.g., a user form of input box, to seek information on indirect costs and mark-up from the user in real time;

4) Display the total cost in an Excel cell.

Make data input error-proof.

Deliverables: An Excel file with your application. Note you need to expand the sample database to include at least three sections, 2-4 sub sections under each section with variation of how many sub sections under each section, and 2-4 varying number of items under each sub section.

Reference no: EM132382387

Questions Cloud

How can you prove that organizational culture is strong : 1. In what ways cultural values are transmitted to employees? 2. How can you prove that organizational culture is strong?
Individuals to be successful leaders in sport organizations : What traits are necessary for individuals to be successful leaders in sport organizations? Give an example of someone you believe
Provide the code before and after the fix : Use one or more python validation techniques provided and fix your code to gracefully and securely handle user input errors.
One thousandth of a second per step : Why do you think that Nike specify the time for each step in making their products down to one thousandth of a second per step?
Design an application to facilitate the estimating process : Assignment - VBA and Spreadsheet - Your objective is to design an application to facilitate the estimating process for IndCon
Write a program that prompts user to enter positive integer : Write a program that prompts the user to enter a positive integer and prints the largest just number that is less than or equal to the user's input.
Future application of artificial intelligent systems : Prepare a presentation showing Recent/Future application of (Artificial) Intelligent Systems - discuss about the pro and cons of that with references
Display the union of square and cube sets : Determine the union, intersection and difference of the square and cube of integers ranging from 1 to 100. Sets are clearly the way to go here.
BUGEN1502 Business Statistics Assignment Problem : BUGEN1502 Business Statistics Assignment- Confidence Interval and Hypothesis testing, Assessment Help and Solution - Semester 2, Federation University Australia

Reviews

Write a Review

Applied Statistics Questions & Answers

  Hypothesis testing

What assumptions about the number of pedestrians passing the location in an hour are necessary for your hypothesis test to be valid?

  Calculate the maximum reduction in the standard deviation

Calculate the maximum reduction in the standard deviation

  Calculate the expected value, variance, and standard deviati

Calculate the expected value, variance, and standard deviation of the total income

  Determine the impact of social media use on student learning

Research paper examines determine the impact of social media use on student learning.

  Unemployment survey

Find a statistics study on Unemployment and explain the five-step process of the study.

  Statistical studies

Locate the original poll, summarize the poling procedure (background on how information was gathered), the sample surveyed.

  Evaluate the expected value of the total number of sales

Evaluate the expected value of the total number of sales

  Statistic project

Identify sample, population, sampling frame (if applicable), and response rate (if applicable). Describe sampling technique (if applicable) or experimental design

  Simple data analysis and comparison

Write a report on simple data analysis and comparison.

  Analyze the processed data in statistical survey

Analyze the processed data in Statistical survey.

  What is the probability

Find the probability of given case.

  Frequency distribution

Accepting Manipulation or Manipulating

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd