EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the company produced 13,500...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the company produced 13,500 windows and ended the month with 8,500 windows in inventory. EZ-Windows' management team would like to develop a production schedule for the next three months. A smooth production schedule is obviously desirable because it maintains the current workforce and provides a similar month-to-month operation. However, given the sales forecasts, the production capacities, and the storage capabilities as shown, the management team does not think a smooth production schedule with the same production quantity each month is possible. February March April Sales forecast 13,500 15,000 19,000 13,000 16,500 Production capacity 12,500 Storage capacity 6,000 6,000 6,000 The company's cost accounting department estimates that increasing production by one window from one month to the next will increase total costs by $1.00 for each unit increase in the production level. In addition, decreasing production by one unit from one month to the next will increase total costs by $0.65 for each unit decrease in the production level. Ignoring production and inventory carrying costs, formulate and solve a linear programming model that will minimize the cost of changing production levels while still satisfying the monthly sales forecasts. If required, round your answers to two decimal places. If an amount is zero, enter "0". Let: F= number of windows manufactured in February M = number of windows manufactured in March A number of windows manufactured in April Im increase in production level necessary during month m Dm decrease in production level necessary during month m Sm ending inventory in month m Min [₁ + 12+ 13+ s.t. (1) F- (2) S1 + $2= (3) 52 + 53 (4) F- D₁ = (5) M- 12+ (6) A- 13+ (7) FS (8) Ms (9) As (10) 51 5 (11) $25 (12) 53 S If required, round your answers to the nearest dollar. Cost: 5 51 = M- A- I; + F- M- D₁ + D₂ = D3= D₂ + D3 February Demand March Demand April Demand Change in February Production Change in March Production Change in April Production February Production Capacity March Production Capacity April Production Capacity February Storage Capacity March Storage Capacity April Storage Capacity If required, round your answers to the nearest dollar. Cost: $ If required, round your answers to the nearest whole number. If an amount is zero, enter "0" February March April Production Level Increase in Production Decrease in Production Ending Inventory EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the company produced 13,500 windows and ended the month with 8,500 windows in inventory. EZ-Windows' management team would like to develop a production schedule for the next three months. A smooth production schedule is obviously desirable because it maintains the current workforce and provides a similar month-to-month operation. However, given the sales forecasts, the production capacities, and the storage capabilities as shown, the management team does not think a smooth production schedule with the same production quantity each month is possible. February March April Sales forecast 13,500 15,000 19,000 13,000 16,500 Production capacity 12,500 Storage capacity 6,000 6,000 6,000 The company's cost accounting department estimates that increasing production by one window from one month to the next will increase total costs by $1.00 for each unit increase in the production level. In addition, decreasing production by one unit from one month to the next will increase total costs by $0.65 for each unit decrease in the production level. Ignoring production and inventory carrying costs, formulate and solve a linear programming model that will minimize the cost of changing production levels while still satisfying the monthly sales forecasts. If required, round your answers to two decimal places. If an amount is zero, enter "0". Let: F= number of windows manufactured in February M = number of windows manufactured in March A number of windows manufactured in April Im increase in production level necessary during month m Dm decrease in production level necessary during month m Sm ending inventory in month m Min [₁ + 12+ 13+ s.t. (1) F- (2) S1 + $2= (3) 52 + 53 (4) F- D₁ = (5) M- 12+ (6) A- 13+ (7) FS (8) Ms (9) As (10) 51 5 (11) $25 (12) 53 S If required, round your answers to the nearest dollar. Cost: 5 51 = M- A- I; + F- M- D₁ + D₂ = D3= D₂ + D3 February Demand March Demand April Demand Change in February Production Change in March Production Change in April Production February Production Capacity March Production Capacity April Production Capacity February Storage Capacity March Storage Capacity April Storage Capacity If required, round your answers to the nearest dollar. Cost: $ If required, round your answers to the nearest whole number. If an amount is zero, enter "0" February March April Production Level Increase in Production Decrease in Production Ending Inventory
Expert Answer:
Answer rating: 100% (QA)
E D Let us assume the notations for each of the values in the months EqNo 1 LL F G H ... View the full answer
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these mathematics questions
-
For 7a-c, use u1= 4. Round your answers to the nearest thousandth. a. For a geometric series with r = 0.7, find S10 and S40. b. For r = 1.3, find S10 and S40. c. For r = 1, find S10 and S40. d. Graph...
-
EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the company produced 15,000 windows and ended the month with 9000 windows in inventory. EZ-Windows...
-
Solve for x. Round your answers to the nearest thousandth. a. = 2x + 1 b. 4x2.7 = 456 c. 734 =11.2(1.56)x d. f(f -1(x)) = 20.2 e. 147 = 12.1(1 + x)2.3 f. 2(x-3 + 4.5 = 16?
-
Describe what happens if you put the double quotes in the print statement of HelloWorld.java on different lines, as in this code fragment: System.out.println("Hello, World");
-
A feedback system has a loop transfer function (a) Determine the corner frequencies (break frequencies) for the Bode plot. (b) Determine the slope of the asymptotic plot at very low frequencies and...
-
How might values and attitudes form a barrier to trade, and how can they be overcome?
-
Many large cities have recently enacted living wage ordinances that require paying a minimum wage that is higher than the state or federal minimum wage. Moreover, sometimes living wage ordinances...
-
1. Assume that a taxpayer purchases a computer in 2014 that has an estimated useful life of 10 years. If the computer is used 100 percent for business and no election to expense was made, what is the...
-
Discuss the role of boundary layers in fluid dynamics, examining the formation of laminar and turbulent boundary layers, the effect of boundary layer separation on flow characteristics, and the...
-
Nautilus Resources is investing in a new heavy oil upgrader in northern Alberta. Nautilus has hired Rite Build Contractors to construct the facilities. The contract price is $3,600 million to be...
-
1.State the amount of the largest expense on the income statement for the year ended January 31, 2009. and describe the transaction represented by the expense. 2.Assuming that all net sales are on...
-
You are building an instrument to measure the orientation of Earth's magnetic field. Your device consists of a single conducting coil that encloses an area \(A=400 \mathrm{~mm}^{2}\) and rotates at a...
-
What instances of athlete activism have you witnessed since this chapter was published? How do they differ from Kaepernicks protest? To what degree have the maintenance of athletes reputations and/or...
-
Frances paid income tax and Class 4 NICs of 47,000 for tax year 2019-20, of which 19,000 was paid via the PAYE system. Her total liability for 2020-21 is 69,000, of which 21,000 is paid via PAYE. Her...
-
The current through an inductor of inductance \(L\) is given by \(I(t)=I_{\max } \sin (\omega t)\). (a) Derive an expression for the induced emf in the inductor as a function of time. (b) At \(t=0\),...
-
An article in the New York Post placed some of the blame on Maria Taylor for not working with Rachel Nichols after her recorded comments to come to a satisfactory resolution. What do you think?...
-
1. Ronnie Gilley Properties, LLC (Gilley), wrote a check to Cile way Properties, LLC (Cile), for $100,000. when Cile deposited the check in its bank, it was misencoded in the amount of $1,000. As a...
-
What are the main distinctions between the different schools of legal interpretation?
-
Jobs arrive randomly at a particular assembly plant; assume that the arrival rate is five jobs per hour. Service times (in minutes per job) do not follow the exponential probability distribution. Two...
-
The Federal Election Commission maintains data showing the voting age population, the number of registered voters, and the turnout for federal elections. The following table shows the national voter...
-
Recall the production model from Section 1.3: Max 10x s.t. 5x 40 x 0 Suppose the firm in this example considers a second product that has a unit profit of $5 and requires 2 hours for each unit...
-
Polyethylene bottles are used to contain fluids as various as milk and engine oil. A typical polyethylene bottle weighs about 30 grams and has a wall thickness of about \(0.8 \mathrm{~mm}\). The...
-
This exercise and the next require the use of the CES Edu-Pack Materials Selection software. a. Use CES to select a joining process to meet the following requirements. b. Use CES to select a joining...
-
This exercise, like the last, requires the use of the CES Edu-Pack Materials Selection software. a. Use CES to select a surface-treatment process to meet the following requirements. b. Use CES to...
Study smarter with the SolutionInn App