Spreadsheet Design Principles: Documentation And Functionality

Background
The group associated with the task of car model rebuilding will show signs of improvement understanding of creation cost of the way towards restoring a car model. The car model reclamation spreadsheet worksheet will be made which will help in assessing the planned cost and the real cost caused which would additionally help in dissecting and modifying the cited costs thus and will help in analysing the profit and loss.
This model contains a data sheet, which is a combination of real and imaginary data.
It is basically can be used to understand how these types of calculations can be perfromed. In real llife authentic data needsto be used.
This is designed as a group project.


		Name	Student Number	Position (Role)		MRC
		Mehak Garg	1103981	Project Manager
		Supreet Sonia	1099396	Statistical Analyst
		Prabhjot Kaur	1099417	Risk Manager
16-05-2018		Shital Jayantilal Nai	1097421	Costing Manager
15-05-2018	1	days since last edited



			Go to specific page
		Part 1	Documentation
		Part 2	Data
		Part 3	Workings
		Part 4	Input_Output






How to Use
This speadsheet can be used to calculate the impact on environment in terms of co2 emissions.
Only input tab needs to be use and the input cell is marked with “yellow” color.
User can use the dropdown option available and provide necessary information to get a desirable output.
User do not have to do anything expect input tab data entry
however, in data tab information can easily be altered
In order to enter new information, the user have to delete all the previously entered input information


Assumptions
Immediate Service	15%	Extra
Standard service	0%	Extra
Extended Service	5%	Discount

Limitations
The model is a simplified version of calculating cost of restoration.
It is build to show the understanding of excel features while designing a model.
The practicality of this model required other factors, which is not considered

Responding to business need
The execution of the task will help in fitting bookkeeping practices and build up exact profit and loss all the while. Moreover, it will help in characterizing the suitable stock of the considerable number of materials which would required for rebuilding of the car model.





Principle	Excel Function or design characteristic	Cell reference(s) and link
Understanding and Responding to Need	Written under background section in identification page	Background
Accurate	All excel formulas were checked multiple times and excel functions like “IF”, “Nested IF”, Cell reference have been used to maintain the accuracy	accuracy check
Usability	Instructions, limitations and assumptions clearly specified in the documentation page. Clear labelling throughout	How to use
Flexibility	Data can be easily changed without affecting input/output or working section. Only raw data section needs to be altered under data tab.	Data
Auditable	workings are self explanatory. Cell lebels have been used to make the clarity of calculations done.	cell lebel
Efficient	separate sheet has been used and “next”, “back” and “main menu” button have been used to move freely to any other tab	button



Auto Restoration Worksheet
		Description	Cost
Cleaning
Cleaning_1	Large Parts (Blasting and Dipping)	Stripping and cleaning of chassis, hard parts, and bodywork	$60.00
Cleaning_2	Small Parts (Bead blasting/solvents)	Remove grease, paint, and rust	$45.00
Repairing and Rebuilding
Chassis	Frames	Undercarriage, cast steel
Chassis	Suspension	Front suspension kit	$280.00
Chassis	Steering	Steering	$250.00
Chassis	Brakes	Reline shoes and turn drums	$110.00
Chassis	Cylinder	Master and wheel cylinder kits	$44.00

Drive Train – Engine	Engine Rebuilding	Rebuild long block and balance	$2,300.00
Drive Train – Engine	Motor mounts	Motor mounts	$80.00
Drive Train – Engine	Cooling Systems	Boil out radiator	$90.00
Drive Train – Engine	Lubrication	Oil, filter, grease	$18.00
Drive Train – Engine	Fuel Systems	Boil out and seal tank	$220.00
Drive Train – Engine	Carburetor kit	Carburetor kit	$40.00
Drive Train – Engine	Rebuilt fuel pump	Rebuilt fuel pump	$60.00
Drive Train – Engine	New gas lines	New gas lines	$90.00
Drive Train – Engine	Fuel filter	Fuel filter	$10.00
Drive Train – Engine	Engine Bays	Rattle cans of primer and paint	$20.00

Drive Train – Transmission	Clutches	Resurface flywheel	$40.00
Drive Train – Transmission	Rebuild clutch disk	Rebuild clutch disk	$35.00
Drive Train – Transmission	Rebuild pressure plate	Rebuild pressure plate	$40.00
Drive Train – Transmission	Rebuild throwout bearing	Rebuild throwout bearing	$25.00
Drive Train – Transmission	Rebuild standard transmission	Rebuild standard transmission	$400.00
Drive Train – Transmission	Transmission rebuild kit	Transmission rebuild kit	$95.00
Drive Train – Transmission	Automatic Transmissions		$560.00


Drive Train – Drive shaft	Drive Shafts	Replacement U-Joint	$75.00

Drive Train – Rear end	Rear Ends	Axle seals	$35.00

Drive Train – Wheels	Rims	See Powder Coating below
Drive Train – Wheels	Sandblasting	Sandblasting	$60.00
Drive Train – Wheels	Replacement hubcaps	Replacement hubcaps	$200.00
Drive Train – Wheels	Rechrome	Rechrome	$400.00
Drive Train – Wheels	Tires	Wide whitewalls	$575.00

Body – Body Exterior	Rust Repair	Replace trunk pan	$1,200.00
Body – Body Exterior	Dent Removal	Remove plastic filler and assorted dents	$1,800.00
Body – Body Exterior	Glass	Windshield	$300.00
Body – Body Exterior	Glass for two door and two vents	Glass for two door and two vents	$280.00
Body – Body Exterior	Channel for all doors	Channel for all doors	$160.00
Body – Body Exterior	Felt strips for all doors	Felt strips for all doors	$120.00
Body – Body Exterior	Weather Stripping and Seals	Window,door, trunk, firewall, light seals	$1,300.00

Body – Interior	Upholstery	Seats	$675.00
Body – Interior	Headliner	Headliner	$200.00
Body – Interior	Door panels	Door panels	$400.00
Body – Interior	Windlacing	Windlacing	$100.00
Body – Interior	Labor	Labor	$3,000.00
Body – Interior	Steering Wheels	Steering wheel repair kit	$49.00
Body – Interior	Metal Trim	Buff stainless at $8.00 per foot (window and body trim)	$800.00
Body – Interior	Heating	Boil out heater	$30.00
Body – Interior	Air Conditioning
Body – Interior	Windshield Wipers	Replacement blades	$20.00
Body – Interior	Sound and heat insulation	Hush Mat and heat barrier material	$480.00

Electrical	Electrical – Engine Ancillary	Tune up kit	$95.00
Electrical	Generator rebuild kit	Generator rebuild kit	$35.00
Electrical	Starter rebuild kit	Starter rebuild kit	$35.00
Electrical	Electrical – Main Harness	Wiring harness	$650.00
Electrical	Electrical – Fuel System	Rebuild gas gauge sending unit	$100.00
Electrical	Electrical – Lighting	Replacement bulbs	$35.00
Electrical	Electrical – Interior

Finishing_1	Painting the Engine and Drivetrain	Self-etching primer and spray paint	$40.00
Finishing_2	Painting and Bodywork	Repaint exterior, firewall, door jams	$9,000.00
Finishing_3	Powder Coating	Powder coat frame, wheels, etc.	$450.00
Finishing_4	Ceramic Coatings	Ceramic coat exhaust	$250.00
Finishing_5	Anti-rust Coatings and Sealants	Gasket sealer, silicone glue, POR-15, urethane	$60.00
Finishing_6	Plating – Chrome, Nickel, etc.	Bumpers, grill, hood ornament, etc.	$2,500.00
Finishing_7	Plating – Zinc, Cadmium, etc.	Zinc plate all nuts, bolts, etc.	$200.00

Assembly_1	Purchasing Parts	Miscellaneous parts	$1,000.00
Assembly_2	Fasteners	Replace rusted nuts/bolts	$80.00
Assembly_3	Motor and Transmission Mounts	Motor and transmission mounts	$120.00
Assembly_4	Hoses and Belts	Fan belt, heater hose, and clamps	$68.00
Assembly_5	Assembly Procedures	Engine hoist, spring compressor	$50.00

Chassis	Cost	Drive Train – Engine	Cost	Drive Train – Engine	Cost	Drive Train – Drive shaft	Cost
Frames	$0.00	Engine Rebuilding	$2,300.00	Engine Rebuilding	$2,300.00	Drive Shafts	$75.00	0	0
Suspension	$280.00	Motor mounts	$80.00	Motor mounts	$80.00			0	0
Steering	$250.00	Cooling Systems	$90.00	Cooling Systems	$90.00			0	0
Brakes	$110.00	Lubrication	$18.00	Lubrication	$18.00			0	0
Cylinder	$44.00	Fuel Systems	$220.00	Fuel Systems	$220.00			0	0
		Carburetor kit	$40.00	Carburetor kit	$40.00			0	0
		Rebuilt fuel pump	$60.00	Rebuilt fuel pump	$60.00			0	0
		New gas lines	$90.00	New gas lines	$90.00			0	0
		Fuel filter	$10.00	Fuel filter	$10.00			0	0
		Engine Bays	$20.00	Engine Bays	$20.00			0	0
								0	0
Total	$684.00		$2,928.00		$2,928.00		$75.00
Sum total	$6,615.00
Normal charge	100%
Total	$6,615.00







			Cost
		Chassis	$684.00
		Drive Train – Engine	$2,928.00
		Drive Train – Engine	$2,928.00
		Drive Train – Drive shaft	$75.00







	Input

	Type of service	Repairing
	Sub Category 1	Chassis
	Sub Category 2	Drive Train – Engine
	Sub Category 3	Drive Train – Engine
	Sub Category 4	Drive Train – Drive shaft
	Sub Category 5
	Sub Category 6
	Sub Category 7
	Sub Category 8
	Sub Category 9
	Sub Category 10

	Expected Delivery time	Standard

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Spreadsheet Design Principles: Documentation And Functionality ”

Get high-quality paper

NEW! AI matching with writer

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order