Question: Please help me solve this problem by using excel! Please showing the code step by step and detail! Thank you Problem 1. The HONDA company
Problem 1. The HONDA company produces different chassis for different car models. Each CR-V chassis requires 4 units of aluminum, 1 units of steel, and 2 units of polymer. Each PILOT chassis requires three, three, and one units of the three materials, respectively. Putting this inventory information into table for different models, we get: Supplies of these materials vary from week to week, so the company needs to determine a different production run each week. For example, one week the total amounts of materials available are 960 units of aluminum, 510 units of steel, and 610 units of polymer. Set up the system of equations modeling the production run, and use Gauss-Elimination method to solve for the number of CR-V, Pilot and Accord to be manufactured this week. You may use Excel for the calculations
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
