A company is outsourcing the manufacturing of a venturi injector device, Please, complete the following tasks:

A manufacturing cost model in the Excel format that shows the following.

NOTE: For data, Use the average market rate or base your cost on assumption.

Cost of Raw materials (include wastage as well)

Cost of manufacturing operations

Cost of Software (Cost of module = Time taken for development x ($40/hour for coding)

Cost of Assembly (system and subsystems)

Overhead

Miscellaneous Costs

Total Cost of the system

Man-hours spent in manufacturing Operations

Man-hours spend in assembly