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
Section	Sub section	Item ID	Description	Productivity	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

User Account

All Pages