Develop a model that can be used to schedule production

Assignment Help Business Management
Reference no: EM13859761

The Scottsville Textile Mill produces five different fabrics. Each fabric can be woven on one or more of the mill's 38 looms. The sales department has forecast demand for the next month. The demand data are shown in Table 1.0, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month.
The Mill has two types of looms: dobbie and regular. The dobbie looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The Mill has a total of 38 looms: 8 are dobbie and 30 are regular. The rate of production for
each fabric on each type of loom is given in Table 1.1. The time to change over from producing one fabric to another is negligible and
does not have to be considered.

The Mill satisfies all demand with either its own fabric or fabric purchased from another mill. That is, fabrics that cannot be woven at The Mill because of limited loom capacity will be purchased from another mill. The purchase price of each fabric is also shown in Table 1.0.

Table 1.0

Monthly Demand, Selling Price, Variable Cost, and Purchase Price Data for The Mill

Demand:

Fabric

Demand (yards)

Selling Price ($/yard)

Variable Cost ($/yard)

Purchase Price ($/yard)

1

16,500

0.99

0.66

0.80

2

22,000

0.86

0.55

0.70

3

62,000

1.10

0.49

0.60

4

7,500

1.24

0.51

0.70

5

62,000

0.70

0.50

0.70

Table 1.1

Loom Production Rates for The Mill Loom rate (yard/hour)

Fabric

Dibbie

Regular

1

4.63

--

2

4.63

---

3

5.23

5.23

4

5.23

5.23

5

4.17

4.17

* Fabrics 1 and 2 can be manufactured only on the dobbie loom.

Question

Develop a model that can be used to schedule production for The Mill, and at the same time, determine how many yards of each fabric must be purchased from another mill. Include a discussion and analysis of the following items in your answer:

1. The final production schedule and loom assignments for each fabric

2. The projected total contribution to profit

3. A discussion of the value of additional loom time (The Mill is considering purchasing a ninth dobbie loom. What is your estimate of the monthly profit contribution of this additional loom?)

4. A discussion of the objectives coefficients' ranges

5. A discussion of how the objective of minimizing total costs would provide a different model than the objective of maximizing total profit contribution. (How would the interpretation of the objective coefficients' rages differ for these two models?)

Reference no: EM13859761

Questions Cloud

Identify a specific application of statistics : Identify a specific application of statistics in identifying an information security related threat. Identify how number theory plays a role in contributing to information security data analytics and encryption algorithms
What do you think are the main reasons for the trend : What do you think are the main reasons for the trend toward "managing by the numbers," as discussed in the case? Do you believe that this is happening in many organizations, or is it an isolated phenomenon?
Find the bid price and derive the production schedule : The contractor can deliver only completed units and is paid the following month. Profit is set at 10 percent of the bid price. Find the bid price, derive the production schedule, and calculate the cash flow schedule.
What is the role of the manager in an organization? : What is the role of the manager in an organization?
Develop a model that can be used to schedule production : Develop a model that can be used to schedule production for The Mill, and at the same time, determine how many yards of each fabric must be purchased from another mill.
Develop a simple canvas animation of your own design : Develop a simple canvas animation of your own design. For example, you could rotate the four smaller solid circles around the red hollow circle using trigonometry (sin and cos)to locate the x,y coordinates of the circles at different angles.
Assumed rate of inflation : Using the assumed rate of inflation,what is the annual amount drawn the first year, (solution b) worth today? Comment on your client's ability to live on this amount in retirement
How has technology changed the way : How has technology changed the way in which the manager defines how tasks are performed and completed within the organizational structure? What happens to structure when the walls are missing? How do the tasks get complete and by whom?
How would you incorporate these into your working life : In a brief 1-2 paragraph reflection, explain why a professional organization had a policy such as this. How would you incorporate these into your working life

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd