Please use excel to solve this

Use solver to minimize the total costs. Round your answer to the nearest dollar.

You run Merciete, a company selling manufactured homes. Your current catalogue covers 3 sub models of homes that are later assembled with other components into a working house: V412, V512 and V612.

You recently acquired a contract to provide at minimum 2000 V412 parts, 3750 V512 parts and 1700 V612 parts. Each of these parts costs $17, $19 and $23 to produce, respectively. Optionally, you have a contract to outsource these parts at $20.40, $21.85 and $25.76 respectively. At least 60% of the minimum amount listed in the contract for each product must be produced in-house to meet the quality standards of your contract.

Each part made in-house must first be fabricated and then inspected. You currently have 16500 man-hours for fabrication and 1600 man-hours for inspection. Below is a table of the times for each part:

		Hours Required
Product	V412	V512	V612
Fabrication Time	2.50	3.40	3.80
Inspection Time	0.25	0.30	0.45

Parts that are outsourced incur 0 fabrication time from your factory and are allowed to skip the internal inspection.

Use solver to minimize the total costs. Round your answer to the nearest dollar.