A company manufactures 3 products in 2 different factories. The cost of production and time required for
Question:
The time and cost required for production of each product in each factory is provided in the tables in this worksheet.
Demand for products 1, 2 and 3 are 200, 240 and 100 units, respectively.
There are a total of 3000 hours available in each factory.
Additionally, at least 60% of the total units of Product 1 must be produced in Factory A, and at least 40% of the total units of Product 2 must be produced in Factory B.
Create a linear programming model and use the Solver add-in to determine the optimal production plan that will minimize total cost.
Transcribed Image Text:
Cost per unit Product 1 Product 2 Product 3 $ 15.00 4.00 S 10.00 Factory A $ 22.00 $ 40.00 S 11.00 Factory B Time per unit Product 1 Product 2 Product 3 Factory A 7.5 Factory B 8 7.5 %24
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 77% (9 reviews)
Objective Function Minimize total cost Z 15AP1 4AP2 10AP3 22BP1 40BP2 11BP3 Where AP1 Product 1 pro...View the full answer
Answered By
Ashington Waweru
I am a lecturer, research writer and also a qualified financial analyst and accountant. I am qualified and articulate in many disciplines including English, Accounting, Finance, Quantitative spreadsheet analysis, Economics, and Statistics. I am an expert with sixteen years of experience in online industry-related work. I have a master's in business administration and a bachelor’s degree in education, accounting, and economics options.
I am a writer and proofreading expert with sixteen years of experience in online writing, proofreading, and text editing. I have vast knowledge and experience in writing techniques and styles such as APA, ASA, MLA, Chicago, Turabian, IEEE, and many others.
I am also an online blogger and research writer with sixteen years of writing and proofreading articles and reports. I have written many scripts and articles for blogs, and I also specialize in search engine
I have sixteen years of experience in Excel data entry, Excel data analysis, R-studio quantitative analysis, SPSS quantitative analysis, research writing, and proofreading articles and reports. I will deliver the highest quality online and offline Excel, R, SPSS, and other spreadsheet solutions within your operational deadlines. I have also compiled many original Excel quantitative and text spreadsheets which solve client’s problems in my research writing career.
I have extensive enterprise resource planning accounting, financial modeling, financial reporting, and company analysis: customer relationship management, enterprise resource planning, financial accounting projects, and corporate finance.
I am articulate in psychology, engineering, nursing, counseling, project management, accounting, finance, quantitative spreadsheet analysis, statistical and economic analysis, among many other industry fields and academic disciplines. I work to solve problems and provide accurate and credible solutions and research reports in all industries in the global economy.
I have taught and conducted masters and Ph.D. thesis research for specialists in Quantitative finance, Financial Accounting, Actuarial science, Macroeconomics, Microeconomics, Risk Management, Managerial Economics, Engineering Economics, Financial economics, Taxation and many other disciplines including water engineering, psychology, e-commerce, mechanical engineering, leadership and many others.
I have developed many courses on online websites like Teachable and Thinkific. I also developed an accounting reporting automation software project for Utafiti sacco located at ILRI Uthiru Kenya when I was working there in year 2001.
I am a mature, self-motivated worker who delivers high-quality, on-time reports which solve client’s problems accurately.
I have written many academic and professional industry research papers and tutored many clients from college to university undergraduate, master's and Ph.D. students, and corporate professionals. I anticipate your hiring me.
I know I will deliver the highest quality work you will find anywhere to award me your project work. Please note that I am looking for a long-term work relationship with you. I look forward to you delivering the best service to you.
3.00+
2+ Reviews
10+ Question Solved
Related Book For
Operations management processes and supply chain
ISBN: 978-0136065760
9th edition
Authors: Lee J Krajewski, Larry P Ritzman, Manoj K Malhotra
Question Posted:
Students also viewed these Managerial Accounting questions
-
Organet Stamping Company manufactures a variety of products made of plastic and aluminum components. During the winter months, substantially all production capacity is devoted to lawn sprinklers for...
-
The Dynaco Company manufactures a product in five stages. Each stage of the manufacturing process is conducted at a different plant. The following network shows the five different stages and the...
-
Solar Power Inc, (SPI) is a public company manufacturing and distributing solar panels. SPI has been in existence for 10 year the last three have been as a public company. To date, the company has...
-
Draw a plausible mechanism for each of the following transformations: (a) (b) [TSOH] MENH2 -H20
-
The Roller Ball skate is an in-line tandem skate that uses two large spherical wheels on each skate, rather than traditional wafer-shape wheels. During skating the two forces acting on the wheel of...
-
Protrade Corporation acquired 8 0 percent of the outstanding voting stock of Seacraft Company on January 1 , 2 0 2 0 , for $ 6 0 4 , 0 0 0 in cash and other consideration. At the acquisition date,...
-
Why are UC scenarios important to defining systems, product, and services?
-
Lisa Vozniak started her own business, We Do Windows. She offers interior and exterior window cleaning for local area residents. Lisa rents a garage to store her tools and cleaning supplies and has a...
-
Reading the information provided, please provide a detailed response to the material. Include at least one key point in-text citation and two references to support your response no older tfivean five...
-
An investment firm can invest in four financial instruments: Trade Credits, Bonds, Gold Stocks, and Construction loans. The income from each investment will be 7%, 11%, 19%, and 15% respectively. The...
-
2% of the checks received by an oil company is returned due to insufficient funds. Yesterday 400 checks were received in the mail. Let x equals the number of these checks which will be returned due...
-
What organizational controls do you think were lacking in the old GM? What organizational controls are needed in the new GM?
-
Part of the evidence for restricted rotation about the carbon-nitrogen bond in a peptide linkage comes from 1H NMR studies done with simple amides. For example, at room temperature the 1H NMR...
-
Consider the space truss represented schematically in Figure 1. It has 21 struts and a fixed support at "C". At joint "E", it is applied a force vector with a component of 30 N, along the x-axis, and...
-
don't use streams for each of these methods (Applies for all assignment questions) [2] Create a method that takes in a list of Integers and returns largest number in the list [1] Create a unit test...
-
Find the following (in m) for the path in the figure below. 0 (a) the total distance traveled m 2 (b) the displacement from start to finish m 6 8 10 12 x (m)
-
The acceleration of a particle is given by a = 5 At where A = 1.8 m/s2 . At t = 0, v = 6.3 m/s and x = 0. What is the speed at t = 5.6 s? Express your answer using two significant figures. V = Submit...
-
3. Three point-like charges are placed at the corners of a square as shown in the figure, 32.0 cm on each side. Find the magnitude of the net electrostatic force exerted on the point charge q2. Let...
-
Repeat the previous problem for the Boyer-Moore algorithm, not counting the comparisons made to compute the last(c) function.
-
Which of the following is NOT a magnetic dipole when viewed from far away? a) A permanent bar magnet. b) Several circular loops of wire closely stacked together with the same current running in each...
-
A large company has an inspection system for the batches of small compressors purchased from vendors. A batch typically contains 15 compressors. In the inspection system a random sample of 5 is...
-
A government task force suspects that some manufacturing companies are in violation of federal pollution regulations with regard to dumping a certain type of product. Twenty firms are under suspicion...
-
Every hour, 10,000 cans of soda are filled by a machine, among which 300 under filled cans are produced. Each hour a sample of 30 cans is randomly selected and the number of ounces of soda per can is...
-
3. Show that : -3t = y 3 sin(t) cos(t) + e is a solution to the differential equation y' + 3 y 10 sin(t)
-
The United States, Austrailia, Canada, and the United Kingdom cluster high on individualism but low on power distance on Hofstede\'s cutlutral graph. What does this mean to someone looking to market...
-
Mini-garden project Week one of the mini-garden project involved Sacha and her fellow pre-schoolers planting sunflower seeds into the outdoor garden bed. Each child in the activity has been assigned...
Study smarter with the SolutionInn App