Future Auto company produces three types of automobiles: models x, X2, and x3. The generated profit,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Future Auto company produces three types of automobiles: models x, X2, and x3. The generated profit, required assembly time, and required material value for each of the models is represented in the following table. There is a total of 500 assembly hours and $250,000 material value available each month. According to the marketing data model x, is the most popular model and demand for that is more than the demand of two other models combined. Therefore, it must be produced more than models x2 and x3 combined. What combination of the three models maximizes total profit in each month? Model Assembly (hours) Material ($) Profit ($) X1 27 12,000 2000 X2 32 14,000 4500 X3 38 17,000 6000 I a) Formulate the problem as a linear programming model IN A WORD FILE. b) Solve the LP using Excel AND GENERATE THE ANSWER REPORT. Note: leave the optimal values fractional in the Excel file. Hint: Optimal objective function value $61,538.46 c) Bonus question: What is the best integer solution? Future Auto company produces three types of automobiles: models x, X2, and x3. The generated profit, required assembly time, and required material value for each of the models is represented in the following table. There is a total of 500 assembly hours and $250,000 material value available each month. According to the marketing data model x, is the most popular model and demand for that is more than the demand of two other models combined. Therefore, it must be produced more than models x2 and x3 combined. What combination of the three models maximizes total profit in each month? Model Assembly (hours) Material ($) Profit ($) X1 27 12,000 2000 X2 32 14,000 4500 X3 38 17,000 6000 I a) Formulate the problem as a linear programming model IN A WORD FILE. b) Solve the LP using Excel AND GENERATE THE ANSWER REPORT. Note: leave the optimal values fractional in the Excel file. Hint: Optimal objective function value $61,538.46 c) Bonus question: What is the best integer solution?
Expert Answer:
Answer rating: 100% (QA)
LP programming Model Maximizing the profit Z 2000X14500X26000X3 Constraints 27X132X238X3 500 12000X1... View the full answer
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
A leading hardware company produces three types of computers: Pear computers, Apricot computers, and Orange computers. The relevant data are given in the file S14_91.xlsx. The equipment cost is a...
-
The Growall Fertilizer Company produces three types of fertilizerSupergro, Dynaplant, and Soilsaver. The company has the capacity to produce a maximum of 2,000 tons of fertilizer in a week. It costs...
-
The Liverpool Company produces three types of circuit boards: Alpha, Beta, and Gamma. The cost accounting system used by Liverpool until 2012 applied all costs except direct materials to the products...
-
Smart Sets manufactures headphone cases. During September 2016, the company produced 108,000 cases and recorded the following cost data: Requirements 1. Compute the cost and efficiency variances for...
-
Refer to Exercise 11.67 and the height and speed of the four tallest roller coasters. Given the data Height 456 420 415 377 Speed 128 20 00 107 Evaluate rsp
-
Use the information from the Luxury Cruiseline Data Set. If Luxury Cruiseline sells an additional 300 tickets, by what amount will its operating income increase (or operating loss decrease)? Luxury...
-
Could an include use case have a primary actor? Explain.
-
Ganesh Incorporated had the following transactions occur involving current assets and current liabilities during February 2012. Feb. 3 Accounts receivable of $15,000 are collected. 7 Equipment is...
-
This house is new and how to set up the network in this house? CLOSET BATH 3 CLOS MASTER BATH SITTING 8'6"X7'0" BALCONY 10'4"x5'8" MASTER WARDROBE MASTER SUITE 18'0"x14'0" UTILITY LIFT DEN...
-
Overview The milestone for Project One involves applying accounting principles and methods to long-term liabilities and equity. You will also evaluate these financial statement components for...
-
Greatbrands, Inc was organized as a C corporation on January 1, 2020. During its first year in business, the company earned enough profits to pay dividends to its shareholders. Choose the response...
-
Carly Jacobsen has been hired as the new CEO of Argosy Bank. Argosy Bank is based in Detroit, MI and is heavily oriented towards consumer lending (as opposed to commercial lending to businesses,...
-
Which incoterms would be applicable to them? please provide reasoning answer. Thank you! 1. You are a Brotherhood of Steel scribe in the Mohave Wasteland. You are trying to buy a piece of valuable...
-
In the state of Florida, the intestate succession statute elects an estate executor through probate court, if there isn't a will in place. The next of kin is selected. The next of kin starts with a...
-
Lord Kit Meowington has come to the terrible realization that one day he may die. Traumatized as he is by this eventuality, he has decided to listen to his lawyer, Mr. Pongo's, advice and prepare a...
-
In what ways do intersectional frameworks enrich our understanding of identity formation by acknowledging the complex interplay of race, class, gender, sexuality, and other axes of social...
-
reword Due to the novelty of this service, we encountered some difficulties in uploading all employee information. As a result, Curai will have to manually set up an account for you. I have emailed...
-
On 1 July 2021, Croydon Ltd leased ten excavators for five years from Machines4U Ltd. The excavators are expected to have an economic life of 6 years, after which time they will have an expected...
-
The emergency room at the new Community Hospital selected every other week during the past 5 months to observe the number of patients during two parts of each weekthe weekend (Friday through Sunday)...
-
A robbery has just been committed at the Corner Market in the downtown area of the city. The market owner was able to activate the alarm, and the robber fled on foot. Police officers arrived a few...
-
Given the following graph of a linear programming model with a single constraint and the objective function maximize Z = 30x1 + 50x2 , determine the optimal solution point: Determine the values by...
-
In what way are glaciers like dirty snowballs?
-
Distinguish between mechanical and chemical weathering.
-
Name an environment where wind shapes the landscape to a significant degree.
Study smarter with the SolutionInn App