Consider the production capacity for the new Nissan plant in Smyrna, Tennessee. Assume that we can i

Our academic writers are ready and waiting to assist with any assignment you may have. From simple essays to full dissertations, you're guaranteed we've got a writing expert to perfectly match your needs.


Order a Similar Paper Order a Different Paper

Consider the production capacity for the new Nissan plant in Smyrna, Tennessee. Assume that we can increase the capacity and suppose that Nissan currently has enough regular production capacity to produce 3200 electric Nissan Leafs per week. Further assume that with overtime, an additional 1000 cars per week can be produced. The cost of assembly and inspecting a car during regular time is $1,900. Overtime production of a car costs $2,600. It also costs $100 per week to hold a car in inventory for future delivery. Nissan’s order schedule for the next six weeks is: 2100, 3400, 4600, 3600, 3000 and 5000 cars. Their goal is to provide quality service and as such, they want to be able to meet all of their customer orders with no shortages. Nissan wants to create a production schedule that will determine how much regular and overtime production it needs for the next six weeks while also minimizing its cost. Assume that there is no inventory on hand at the beginning of week 1. Develop a linear programming (LP) model for the Nissan production problem. Solve this LP using the Excel Solver (You need to add the corresponding Excel Add-in that comes with Excel: Excel-Options ? Add-Ins ? Manage Excel Add-ins ? Go ? Solver Add-in). If you have any questions about using the Excel Solver, please do not hesitate to ask. You can also use any other solver available if you prefer. For example, see Google Drive (Spreadsheet ? Tools ? Solver)

Writerbay.net

Do you need help with this or a different assignment? In a world where academic success does not come without efforts, we do our best to provide the most proficient and capable essay writing service. After all, impressing professors shouldn’t be hard, we make that possible. If you decide to make your order on our website, you will get 15 % off your first order. You only need to indicate the discount code GET15.


Order a Similar Paper Order a Different Paper