Reference no: EM131128378
Robin Tires, Inc. makes two types of tires, for SUV’s and Hatchbacks. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. The production time required per tire type is given in the following table: Production Hours Type Production Packaging Shipping Profit/Tire
SUV tires 2 1.5 1 $22
Hatchbacks tires 1.5 1 0.5 $12
Assuming that the company is interested in maximizing the total profit contribution, find the optimal solution using Excel Solver and answer the following:
a. How many hours of production time will be scheduled in each department?
b. What is the slack time in each department?
c. If one more hour is available for packaging, what is the change in profit?
d. What is the change in profit if one more hour is available for shipping?
Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. Submit your Excel Solver file.
|
What kind of online presence do you have
: What kind of online presence do you have? How often do you post? What devices or platforms do you use to post? If you don't have much of an online presence, do you read others' blogs, Facebook pages, Tumblr posts, or Twitter feeds regularly? Why or w..
|
|
How will you handle conflict and motivate people
: What three big ideas you will take away from MGT 363 ORGANIZATIONAL BEHAVIOR class that will inform your interaction in organizations. As you consider the big ideas, think about these questions: How will you help lead? How will you help create positi..
|
|
What is the firm new labor productivity
: The Dulac Box plant produces wooden packing boxes to be used in the local seafood industry. Current operations allow the company to make 500 boxes per day, in two 8-hour shifts (250 boxes per shift). These changes did not require any change in the am..
|
|
What is her percentage increase in productivity
: Susan has a part-time business producing seasonal plywood yard ornaments for resale at local craft fairs and bazaars. She currently works 8 hours per day to produce 16 ornaments. What is her productivity? What is her percentage increase in productivi..
|
|
How many hours of production time will be scheduled
: Robin Tires, Inc. makes two types of tires, for SUV’s and Hatchbacks. The firm has 500 hours of production time, 250 hours of packaging, and 150 hours available for shipping. How many hours of production time will be scheduled in each department? Wha..
|
|
Develop system for evaluating the productivity
: As the administrative manager in a law office, you have been asked to develop a system for evaluating the productivity of the 15 lawyers in the office. What difficulties are you going to have in doing this, and how are you going to overcome them?
|
|
Regarding differences between goods and services
: Which is NOT true regarding differences between goods and services?
|
|
Calculate the capacity of each resource in the process
: At the security station of Singapore Airport, all carry-on bags must first be X-rayed. Two resources are involved in X-raying. First, there is a conveyer belt that moves the bags through the X-ray machine. Draw a process-flow diagram for this process..
|
|
What ways have unions begun to collaborate internationally
: All components of globalization have increased dramatically since the 1970s. Many companies in the U.S. now do business abroad, invest abroad, and have relocated facilities abroad. Given the extent of this corporate internationalization, why haven’t ..
|