Question: Please formulate the problem as an LP model and use What'sBest to solve it setting up the problem in excel as shown in the images.

Please formulate the problem as an LP model and use What'sBest to solve it setting up the problem in excel as shown in the images. Please interpret and explain the optimal production plan found.

Project Question Bob's Custom Trucks has demand over the next six months shown in the table below. Currently, Bob employees 264 full-time workers. Cost to hire a new worker is $400 and to fire a worker is $1000. Inventory holding cost is $300 per car per month. Over the last six months, it takes an average of 10 worker-days to make one car. Currently, there are 180 cars in stock. Bob wants to make sure that at least a 20 -car buffer at the end of each month. Bob says he will not using outsourcing or overtime. What is an optimal production plan over next 6 months that minimizes the total cost for production and workforce change? Project Requirements (1) Formulate the problem as an LP or ILP model, and then use What'sBest to solve it. (2) Write a project repott that explains how you formulate the problem, presents your L.P or IL.P model, and reports and interpret the optimal production plan found using What'sBest

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

3. LP formulation - Product mix: Coffee makers A manufacturing company produces two types of coffee makers. The Espresso maker requires $30 in materials and 2 labor hours to produce and it yields a...

You are running for an election in a district that has 3 different sections; urban, suburban and rural. The populations of these three areas are: - Urban: 100,000 - Suburban: 200,000 - Rural: 50,000...

3. LP formulation - Product mix: Burgers A fast-food restaurant sells two types of burgers; BigBurgers and Quarter Pounders. A BigBurgers uses 0.1lb of meat, and Quarter Pounders uses a 0.25lb of...

A fast-food restaurant sells two types of burgers; BigBurgers and Quarter Pounders. A BigBurgers uses 0.1 lb of meat, and Quarter Pounders uses a 0.25 lb of meat. The restaurant starts with 200 lb of...

2. LP modeling - Media selection for advertisements Assume that you want to advertise a new product. Your company assigned $1,000,000 for advertising budget. The table shows TV stations, time and...

2. LP modeling - Fast Food Restaurant A fast-food restaurant sells two types of sandwiches; cheeseburger and meat-lover. Both sandwiches need meat and cheese slice. A meat-lover uses a 0.5 lb of meat...

Problem 2. [30'] A factory produces two small appliances, Appliance I and Appliance II. Each of the appliances must pass through the following processes: machine A, machine B, and manual inspection....

2. LP modeling: Political Campaign Problem You are running for an election in a district that has 3 different sections, urban, suburban and rural The populations of these three areas are: Urban: 100K...

An electronics manufacturer has an option to produce six styles of cell phones. Each of these devices requires time, in minutes, on three types of electronic testing equipment, as shown in the table...

1. Given the language of the time frame notice, do you agree with the courts statements that it was clear and objectively reasonable consumers would not be confused by it? Why or why not? 2. This is...

Develop a synchronous 3-bit gray code up/down counter with a gray code sequence using T flip flops. The counter should count up when control input M is 0 and count down when the control input is 1....

10 The height of a horse is measured in hands (H) and inches (I). This formula is used to work out the height of a horse in centimetres (C ). C = 2.5(4H + I) where: C is the number of centimetres H...

What is an example of constructive feedback? provide reference