component & training database

Project Description:

software skills: spreadsheet formulas, two-variable data table
business skills: manufacturing bill of materials sensitivity analysis

a bill of materials is used in manufacturing and production to show all of the parts and materials required to manufacture a specific item or for the subassembly of a finished product, such as a motorcycle. the information in the bill of materials is useful for determining product costs, coordinating orders, and managing inventory. it can also show how product costs will be affected by price changes in components or raw materials. this project provides you with an opportunity to use spreadsheet software to perform a sensitivity analysis showing the impact of various prices for component parts on the total costs of a dirt bike. the bill of materials for this project has been simplified for instructional purposes.

dirt bikes’s management has asked you to explore the impact of changes in some of its parts components on production costs. review the spreadsheet file containing bill of materials information for the brake system for dirt bikes’s moto 300 model, which can be found here mis11ch12 bill of materials.xls. the completed bill of materials contains the description of the component, the identification number of each component, the supplier (source) of the component, the unit cost of each component, the quantity of each component needed to make each finished brake system, the extended cost of each component, and the total materials cost. the extended cost is calculated by multiplying the quantity of each component needed to produce the finished brake system by the unit cost. the prices of components are constantly changing, and you will need to develop a spreadsheet application that can show management the impact of such price changes on the cost to produce each brake system and on total production costs for the moto 300 model.

• complete the bill of materials by calculating the extended cost of each component and the total materials cost for each brake system.

• develop a sensitivity analysis to show the impact on total brake system materials costs if the front brake calipers unit cost ranges from $103 to $107 and if the brake pipe unit cost ranges from $27 to $30.

• the brake system represents 30 percent of the total materials cost for one moto 300 motorcycle. use sensitivity analysis again to show the impact of the changes in front brake caliper unit costs and brake pipe unit costs described previously on total materials costs for this motorcycle model.

software skills: database design, querying, and reporting
business skills: employee training and skills tracking

this project requires you to perform a systems analysis and then design a system solution using database software.

dirt bikes promotes itself as a “learning company.” it pays for employees to take training courses or college courses to help them advance in their careers. as employees move on, their job positions become vacant and dirt bikes must quickly fill them to maintain its pace of production. dirt bikes’s human resources staff would like to find a way to quickly identify qualified employees who have the training to fill vacant positions. once the company knows who these employees are, it has a better chance of filling open positions internally rather than paying to recruit outsiders. dirt bikes would like to track each employee’s years of education and the title and date completed of training classes that each employee has attended.

• dirt bikes currently cannot identify such employees. its existing employee database is limited to basic human resources data, such as employee name, identification number, birth date, address, telephone number, marital status, job position, and salary. a portion of this database is illustrated here. you can find some sample records from this database on the moodle web site for this hands-on project (or click on this link to download: dirt bikes’s human resources staff keeps skills and training data in paper folders.

• prepare a systems analysis report describing dirt bikes’s problem and a system solution that can be implemented using pc database software.

then use the database software to develop a simple system solution. your report should include the following:
1) description of the problem and its organizational and business impact.
2) proposed solution and solution objectives.
3) information requirements to be addressed by the solution.
4) management, organization, and technology issues to be addressed by the solution, including changes in business processes.

• on the basis of the requirements you have identified, design the solution using database software and populate it with at least 10 records per table. consider whether you can use or modify the existing employee database in your design. print out the design for each table in your new application. use the system you have created to create queries and reports that would be of most interest to management, such as which employees have college education or which employees have training in project management or advanced computer-aided design [cad] tools.
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 8
1 Current viewersl
460 Total views
Project posted by:


Proposals Reputation Price offered