The Fiat Lux lamp company manufactures metal lamps using a variety of different metals and their...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Fiat Lux lamp company manufactures metal lamps using a variety of different metals and their production is constrained by how much of each metal they have on hand. For the next month, the company has available a total of 450 lbs. of brass, 400 lbs. of copper, 400 lbs. of steel, and 50 pounds of iron. Each lamp style requires different amounts of each metal based on a proprietary design. For the next month they will make three styles of lamps: Eiffel, Arch and Taj. Based on the selling price to retailers, each Eiffel lamp made creates a profit of $40, each Arch lamp made creates a profit of $50 and each Taj lamp made creates a profit of $30. Each Eiffel lamp requires 0.5 lbs. of brass, one lb. of copper, 0.5 lbs. of steel and two lbs. of iron. Each Arch lamp requires no brass, one lb. of copper, four lbs. of steel and 0.2 lbs. of iron. Each Taj lamp requires five lbs. of brass, one lb. of copper, 0.5 lbs. of steel and 0.1 lbs. of iron. Contracts require that at least 15 of each type of lamp must be made next month. FiatLux wants to know how many of each style of lamp to produce next month, given the limited amount of materials. Formulate this as a linear programming problem to maximize FiatLux's profit. Assume that fractional lamps are allowed to be made in the month (to be completed the following month). Use Solver in Excel to find the optimal solution. (1) In the optimal solution, how many lamps of each style should be made? (ii) What is the optimal profit? (iii) Paste your complete Excel spreadsheet below showing the optimal solution. Maximum profit=_ Number of Eiffel lamps produced =_ Number of Arch lamps produced = Number of Taj lamps produced = The Fiat Lux lamp company manufactures metal lamps using a variety of different metals and their production is constrained by how much of each metal they have on hand. For the next month, the company has available a total of 450 lbs. of brass, 400 lbs. of copper, 400 lbs. of steel, and 50 pounds of iron. Each lamp style requires different amounts of each metal based on a proprietary design. For the next month they will make three styles of lamps: Eiffel, Arch and Taj. Based on the selling price to retailers, each Eiffel lamp made creates a profit of $40, each Arch lamp made creates a profit of $50 and each Taj lamp made creates a profit of $30. Each Eiffel lamp requires 0.5 lbs. of brass, one lb. of copper, 0.5 lbs. of steel and two lbs. of iron. Each Arch lamp requires no brass, one lb. of copper, four lbs. of steel and 0.2 lbs. of iron. Each Taj lamp requires five lbs. of brass, one lb. of copper, 0.5 lbs. of steel and 0.1 lbs. of iron. Contracts require that at least 15 of each type of lamp must be made next month. FiatLux wants to know how many of each style of lamp to produce next month, given the limited amount of materials. Formulate this as a linear programming problem to maximize FiatLux's profit. Assume that fractional lamps are allowed to be made in the month (to be completed the following month). Use Solver in Excel to find the optimal solution. (1) In the optimal solution, how many lamps of each style should be made? (ii) What is the optimal profit? (iii) Paste your complete Excel spreadsheet below showing the optimal solution. Maximum profit=_ Number of Eiffel lamps produced =_ Number of Arch lamps produced = Number of Taj lamps produced =
Expert Answer:
Related Book For
Modern Advanced Accounting In Canada
ISBN: 9781259066481
7th Edition
Authors: Hilton Murray, Herauf Darrell
Posted Date:
Students also viewed these general management questions
-
A garden hose with an internal diameter of 1.3 cm is connected to a (stationary) lawn sprinkler that consists merely of a container with 27 holes, each 0.12 cm in diameter. If the water in the hose...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
The electric fields at point P due to the positive charges q 1 and q 2 are shown in Fig. Q21.22. Does the fact that they cross each other violate the statement in Section 21.6 that electric field...
-
With reference to Problem 2.2, suppose the water pressure p increases linearly with depth (according to p = wz where z = depth below water table and w = specific weight of water) from the water table...
-
Suppose that we have a knapsack with total capacity of W kg. We also have n items where item j has mass wj. The knapsack problem asks for a subset of these n items with the largest possible total...
-
According to an article in the Economist magazine, in 2023, the legal minimum wage in Venezuela was 130 bolivars per month, and the inflation rate during 2023 was expected to be 500 percent. How many...
-
The stockholders?? equity section of Traylor Corporation??s balance sheet at December 31 is presented here. InstructionsFrom a review of the stockholders?? equity section, answer the following...
-
The price of a car you want is $39,000 today. Its price is expected to increase by $1000 each year. You now have $23,500 in an investment account, which is earning 11% per year. How many years will...
-
Your company is considering investing in its own transport fleet. The present position is that carriage is contracted to an outside organization. The life of the transport fleet would be five years,...
-
Write a Report on individual creative thinking skills. Demonstrate adequate knowledge and understanding of challenges and opportunities in promoting organisational creativity and innovation or...
-
Honey plc is a UK company which has two forthcoming US dollar transactions, a $3,500,000 receipt from a US customer and a payment of $5,019,400 to a US supplier. These transactions are expected to...
-
A phone company divides a city into n cells C, C2,..., C. In each cell it has a tower. When a call comes to a mobile user the company has a set of probabilities P, P2, ..., Pn such that the user is...
-
What is the output of the given code block? number1= 60 number2 = 40 if number1 + number2 = 100: print("sum is 100") else: print("sum is not 100") Your answer: sum is not 100 sum is 100 sum is not...
-
Let A ERmxn with m
-
Big Co acquired 70% of the common Stock of Little Co. on 1/1/22 for $301,000. The fair value of the non-controlling interest was $129,000. Little's book value on that date was $300,000. Little had...
-
1. The equation for the Reynolds number for a pipe flow is Re-PvD where p = mass density 32 v = velocity of the flow D-diameter of the pipe [L] - viscosity of the fluid [FIT] [] (a) Show that the...
-
A test car is driven a fixed distance of n miles along a straight highway. (Here n Z+.) The car travels at one mile per hour for the first mile, two miles per hour for the second mile, four miles...
-
The balance sheets of X Ltd. and Y Ltd. on December 30, Year 7, are as follows: On December 31, Year 7, X issued 150 common shares for all 60 outstanding common shares of Y. The fair value of each of...
-
It is now mid-September Year 3. Growth Investments Limited (GIL) has been owned by Sam and Ida Growth since its incorporation under the Canada Business Corporations Act many years ago. The owners,...
-
Required: Determine how this transaction should have been accounted for assuming that (a) Enron controlled LIM2 and used consolidated financial statements to report its investment in LIM2; (b) Enron...
-
Two radio stations have the same power output from their antennas. One broadcasts AM at a frequency of \(1000 \mathrm{kHz}\) and one broadcasts FM at a frequency of \(100 \mathrm{MHz}\). Which...
-
A paramecium is covered with motile hairs called cilia that propel it at a speed of \(1 \mathrm{~mm} / \mathrm{s}\). If the paramecium has a volume of \(2 \times 10^{-13} \mathrm{~m}^{3}\) and a...
-
How many photons does a \(5.0 \mathrm{~mW}\) helium-neon laser \((\lambda=633 \mathrm{~nm})\) emit in 1 second? A. \(1.2 \times 10^{19}\) B. \(4.0 \times 10^{18}\) C. \(8.0 \times 10^{16}\) D. \(1.6...
Study smarter with the SolutionInn App