Question

In: Operations Management

he manager of the O’Brian Glass Company is planning the production of automobile windshields for the...

he manager of the O’Brian Glass Company is planning the production of automobile windshields for the next four months. The demand for the next four months is projected to be as shown in the following table.MonthDemand for Windshields1130214032604120 292 Chapter 5: Transportation, Assignment, and Network ModelsO’Brian can normally produce 100 windshields in a month. This is done during regular production hours at a cost of $100 per windshield. If demand in any one month cannot be satisfied by regular production, the production manager has three other choices: (1) He can produce up to 50 more windshields per month in overtime but at a cost of $130 per windshield; (2) he can purchase a limited number of windshields from a friendly competitor for resale at a cost of $150 each (the maximum number of outside purchases over the four-month period is 450 windshields); or (3) he can fill the demand from his on-hand inventory. The inventory carrying cost is $10 per windshield per month. Back orders are not permitted. Inventory on hand at the beginning of month 1 is 40 windshields. Set up and solve this “production smoothing” problem as a transportation model to minimize cost. Hint: Set the various production options (e.g., regular production, outside purchase, etc.) as supply nodes and the monthly demands as the demand nodes. MLA (Modern Language Assoc.) Balakrishnan, Nagraj, et al. Managerial Decision Modeling 

Solutions

Expert Solution

Let the regular production per Month be

Month 1 = x1

Month 2 = x2

Month 3 = x3

Month 4 = x4

Let the overtime production per month be

Month 1 =x5

Month 2 = x6

Month 3 = x7

Month 4 = x8

Let the purchase from competitor per month be

Month 1 = x9

Month 2 = x10

Month 3 = x11

Month 4 = x12

Constraints:

Regular: x1, x2, x3, x4 ≤ 100

Overtime: x5,x6,x7,x8 ≤ 50

Purchase: x9 + x10 + x11 + x12 ≤ 450

Other constraints are Demand constraints, which are shown in excel

Ending inventory for each month cannot be less than zero.

The LP solution is presented in Excel.

Formulae:


Related Solutions

You are a senior manager in a U.S. automobile company who is considering investing in production...
You are a senior manager in a U.S. automobile company who is considering investing in production facilities in China, Russia, or Germany. These facilities will serve the local market demand. Develop a summary that determines the benefits, costs, and risks associated with doing business in each nation. Which country seems to be the most attractive target for foreign direct investment? Why? The course is International Business and Global Strategy.
You are a senior manager in a U.S. automobile company who is considering investing in production...
You are a senior manager in a U.S. automobile company who is considering investing in production facilities in China, Russia, or Germany. These facilities will serve the local market demand. Develop a summary that determines the benefits, costs, and risks associated with doing business in each nation. Which country seems to be the most attractive target for foreign direct investment? Why? The course is DBA 8710 International Business and Global Strategy
You are a senior manager in a U.S. automobile company who is considering investing in production...
You are a senior manager in a U.S. automobile company who is considering investing in production facilities in China, Russia, or Germany. These facilities will serve the local market demand. Develop a summary that determines the benefits, costs, and risks associated with doing business in each nation. Which country seems to be the most attractive target for foreign direct investment? Why? The course is International Business and Global Strategy.
Tom Hawk is the production manager at English Garden Company. One of the products he is...
Tom Hawk is the production manager at English Garden Company. One of the products he is responsible for producing is its top-selling wheelbarrow. In the past Mr. Hawk has purchased wheels from the Jerk Werx Company for $6.00 each. Jerk Werx recently informed Mr. Hawk that, when the current contract expires, it will be raising the price of wheels to $7.00 each. In a typical year, English Garden makes 50,000 wheelbarrows. If it decides to make the wheels for its...
In an effort to increase production of an automobile part, the factory manager decides to play...
In an effort to increase production of an automobile part, the factory manager decides to play music in the manufacturing area. Eight workers are selected, and the number of items each produced for a specific day is recorded. After one week of music, the same workers are monitored again. The data are given in the table below. Can the manager conclude that the music has changed the production level? Worker Before After 1 6 8 2 8 11 3 10...
You are a newly licensed CPA working for Hurricane Glass, a glass manufacturing company. Your manager...
You are a newly licensed CPA working for Hurricane Glass, a glass manufacturing company. Your manager is considering implementing flexible budgeting. Prepare a memo to your manager describing flexible budgeting and its advantages and disadvantages.
Frederick is the manager of a company that produces toasters. He has instructed his production department...
Frederick is the manager of a company that produces toasters. He has instructed his production department to replace a steel handle shaft with a plastic shaft. This will save the company $1 per toaster. Since making this change, the toasters are being returned in great quantities because of handle breakage. Frederick tries to hide his poor decision. He instructs the accountant to ignore the returned items and put them back into inventory so they can be resold. Manufacturing was told...
How does a business manager use probabilities for production planning?
How does a business manager use probabilities for production planning?
Cameron Bly is a sales manager for an automobile dealership. He earns a bonus each year...
Cameron Bly is a sales manager for an automobile dealership. He earns a bonus each year based on revenue from the number of autos sold in the year less related warranty expenses. Actual warranty expenses have varied over the prior 10 years from a low of 3% of an automobile’s selling price to a high of 10%. In the past, Bly has tended to estimate warranty expenses on the high end to be conservative. He must work with the dealership’s...
Chapter 11 Cameron Bly is a sales manager for an automobile dealership. He earns a bonus...
Chapter 11 Cameron Bly is a sales manager for an automobile dealership. He earns a bonus each year based on revenue from the number of autos sold in the year less related warranty expenses. Actual warranty expenses have varied over the prior 10 years from a low of 3% of an automobile's selling price to a high of 10%. In the past, Bly has tended to estimate warranty expenses on the high end to be conservative. He must work with...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT