You manage a production line that operates using a monthly production cycle. Five different products could...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You manage a production line that operates using a monthly production cycle. Five different products could be made this month. However, you only have 500 hours of line capacity, so you must be careful which products you select to make in the production cycle. Making a product incurs two types of setup costs: (1) a material "tear down" cost (measured in dollars) and (2) downtime for line preparation (measured in hours). Any quantity up to the forecasted monthly demand can be sold. Additional production details are given in the table below: Monthly Demand Revenue (per unit) Production Cost (per unit) Set Up Cost Set Up Time Production Time (per unit) Product 1 1000 units $150 $60 $10000 25 hrs 1 hrs Product 2 1100 units $175 $70 $15000 15 hrs 12 hrs Product 3 1700 units $155 $60 $25000 0 hrs 13 hrs Product 4 1600 units $200 $100 $10000 10 hrs 15 hrs Product 5 1500 units $225 $110 $5000 30 hrs 16 hrs 1. Based on this information, design a monthly production schedule to maximize monthly profit. Your solution should identify which products to make and the quantities of each. (Assume the line is not currently set up to make any of these products; Set Optimality Gap to .1%) You manage a production line that operates using a monthly production cycle. Five different products could be made this month. However, you only have 500 hours of line capacity, so you must be careful which products you select to make in the production cycle. Making a product incurs two types of setup costs: (1) a material "tear down" cost (measured in dollars) and (2) downtime for line preparation (measured in hours). Any quantity up to the forecasted monthly demand can be sold. Additional production details are given in the table below: Monthly Demand Revenue (per unit) Production Cost (per unit) Set Up Cost Set Up Time Production Time (per unit) Product 1 1000 units $150 $60 $10000 25 hrs 1 hrs Product 2 1100 units $175 $70 $15000 15 hrs 12 hrs Product 3 1700 units $155 $60 $25000 0 hrs 13 hrs Product 4 1600 units $200 $100 $10000 10 hrs 15 hrs Product 5 1500 units $225 $110 $5000 30 hrs 16 hrs 1. Based on this information, design a monthly production schedule to maximize monthly profit. Your solution should identify which products to make and the quantities of each. (Assume the line is not currently set up to make any of these products; Set Optimality Gap to .1%)
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To design a monthly production schedule to maximize monthly profit we can use Excel Solver Heres how you can set up the problem Step 1 Set up ... View the full answer
Related Book For
Management Accounting
ISBN: 9780730369387
4th Edition
Authors: Leslie G. Eldenburg, Albie Brooks, Judy Oliver, Gillian Vesty, Rodney Dormer, Vijaya Murthy, Nick Pawsey
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A small company has $4,500,000 in (annual) revenue, spends 57% of its revenues on purchases, and has a net profit margin of 11.75%. They would like to increase their profits and they are looking at...
-
Repeat the analysis for the variance of the quantization error, carried out in section 6.4.2, for the decimation-in-frequency radix-2 FFTalgorithm. 2-25 A? (6.4.2) 12 12
-
MacAskill Mills Limited, which follows IFRS, and has a calendar year end, and adopted the policy of classifying interest paid as financing activities engaged in the following transactions in 2017. 1....
-
Each year, the paper and pulp industry produces millions of tonnes of sludge in the production of paper. This sludge is typically disposed of in landfill sites or incinerated. Both disposal methods...
-
McDonalds Corporation, the worlds largest fast-food restaurant chain, with 2010 revenues of $28 billion, has recently been on a roll. Its shareholder value rose over 50% from May 2010 to May 2013....
-
What is MATLAB? Pros and cons.
-
2. EMORY ALUMINUM The Emory Aluminum company rolls and sells aluminum foil in several widths. (Length is the same for all orders). Customers can order rolls of foil 24 inches, 20 inches, 12 inches,...
-
The following information is available from Gabe's LOL Co. for the month ending September 30, 20XX. Gabe's LOL Co. Information Direct materials used in production 215,500 Direct Labor 199,200 84,400...
-
(b) You are given four numbers a, b, c, d. You want to sort them in increasing order. It is known that they are all different, and furthermore a
-
The following are lot dimensions for a rectangular lot taken with Google Maps. What is the area of this rectangular lot? Enter the number and the unit with a one space between the number and the...
-
Jack lives in Ontario and is moving to BC. He is selling all of his furnishings including his car. Jill sees the car up for sale on Kijiji, and offers Jack the money he asked for, but also saying she...
-
In own words and using this week's materials for support, answer the following question/prompt: Firms use different strategies to extend the life cycles of their products throughout the maturity...
-
The demand for vegetables is given by Qd = 500-? P and supply is given by Qs=? P-100? Where Q represents quantity of vegetables in kilos and P represents the price of vegetable. In an attempt to...
-
l'ex Refere Compatibility Mode - Word Mailings MENING Review View Help Grammarly MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question. 1) For a...
-
State whether each statement is true or false. If false, give a reason. {purple, green, yellow} = {green, pink, yellow}
-
Bridges and Roads is an entity engaged in road construction. Some selected items from its chart of accounts are listed below. Required For each account, indicate whether the account represents a...
-
Hector Gonzales runs the Floral Art Company, which supplies floral arrangements to three large supermarket chains throughout Australia. Management has become concerned about the rising costs...
-
Why do proponents of the Beyond Budgeting movement recommend abandoning traditional budgets?
-
Honeybees accumulate charge as they fly, and they transfer charge to the flowers they visit. Honeybees are able to sense electric fields; tests show that they can detect a change in field as small as...
-
A platypus foraging for prey can detect an electric field as small as 0.002 N/C. To give an idea of the sensitivity of the platypuss electric sense, how far from a +10 nC point charge does the field...
-
Raindrops acquire an electric charge as they fall. Suppose a 2.0-mm-diameter drop has a charge of +12 pC; these are both very common values. In a thunderstorm, the electric field under a cloud can...
Study smarter with the SolutionInn App