Incline Electronics produces three different products in a plant that is open 40 hours per week. Each
Question:
Incline Electronics produces three different products in a plant that is open 40 hours per week. Each product requires the following processing times (in hours) on each of three machines.
Each machine must be run by one of 19 cross-trained workers who are each available 35 hours per week. The plant has 10 type 1 machines available, 6 type 2 machines available, and 8 type 3 machines available. Products 1, 2, and 3 contribute $90, $120, and $150, respectively, in marginal profit per unit produced.
a. Formulate an LP model for this problem.
b. Implement your model in a spreadsheet and solve it.
c. What is the optimal solution?
d. How many workers should be assigned to each type of machine?
Product 1 Product 2 Product 3 Machine 1 Machine 2 3 Machine 3
Step by Step Answer:
a P1 Units of product 1 to make P2 Units of product 2 to make P3 Un...View the full answer
Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analytics
ISBN: 978-1285418681
7th edition
Authors: Cliff Ragsdale
Students also viewed these Management Leadership questions
-
Aire-Co produces home dehumidifiers at two different plants in Atlanta and Phoenix. The per unit cost of production in Atlanta and Phoenix is $400 and $360, respectively. Each plant can produce a...
-
The CitruSun Corporation ships frozen orange juice concentrate from processing plants in Eustis and Clermont to distributors in Miami, Orlando, and Tallahassee. Each plant can produce 20 tons of...
-
The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each...
-
The Chicago Omni Hotel is a 750-room luxury hotel offering guests the finest facilities in downtown Chicago. The hotel is organized into four departments: lodging, dining, catering, and retail...
-
What general guidelines should a firm follow in properly estimating the net cash flow from an investment?
-
Oakridge Leasing Corporation signs an agreement on January 1, 2017 to lease equipment to LeBlanc Limited. Oakridge and LeBlanc follow ASPE. The following information relates to the agreement. 1. The...
-
It is estimated that nearly half of all users of the social networking platform TikTok in the United States were between the ages of 10 and 29 in 2020 (Statista.com website). Suppose that the results...
-
Kay Wing, Inc., prepared the following balance sheet at December 31, 2016. Kay Wing, Inc. Balance Sheet as of December 31, 2016 Cash................................................................$...
-
Korda International Inc. recently issued new securities (common shares and bonds) to finance a new project with a cost $16 million. The equity issued had a flotation cost of 8%, while the debt issued...
-
Build a data table in G21:AB42 that shows what 2021 EPS would be based on the revenue growth rate and cost of goods sold / revenue assumptions listed in Table 1. Input the revenue growth rate...
-
Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mixture of pine and oak chips. The following table...
-
Tuckered Outfitters plans to market a custom brand of packaged trail mix. The ingredients for the trail mix will include Raisins, Grain, Chocolate Chips, Peanuts, and Almonds costing, respectively,...
-
Ultraviolet light with photons of energy 2.5 10 18 J is shone onto a zinc plate. The work function of zinc is 4.3 eV. Calculate the maximum energy with which an electron can be emitted from the zinc...
-
Happy Sdn Bhd purchased a debt instrument on 1 January 2 0 2 3 at its fair value of RM 5 million. The face value of the instrument was RM 1 2 million with an interest rate of 2 . 3 5 % . The...
-
On October 21, Portland Skydiving received $6,200 cash in advance from customers for a group skydiving experience it will provide in November, and correctly recorded this transaction. On November 8,...
-
Using the following information, prepare the following financial statements in good form: Cost of Goods Sold Statement Multi - Step Income Statement Retained Earnings Statement Classified Balance...
-
3. Explain how a franchise business model works, and discuss its advantages and disadvantages for a company like Domino's who is trying to pursue a new international market. a) How does Franchising...
-
Thermo dynamics reported earnings of $ 8 0 0 , 0 0 0 last year with 2 0 0 , 0 0 0 shares outstanding. On January 1 of the current year, the company issued 3 0 , 0 0 0 new shares. Earnings after tax...
-
Match the correct term with its definition: A structure in which data is stored in a database Field Query A unique identifier for a record A collection of data about one single item in a database...
-
(a) How far away can a human eye distinguish two ear headlights 2.0 m apart? Consider only diffraction effects and assume an eye pupil diameter of 5.0 mm and a wavelength of 550 nm. (b) What is the...
-
a. Calculate the centroids for each group in the analysis sample. What do these values indicate? b. Use the regression approach to two-group DA to develop a rule for predicting whether or not a bank...
-
In this chapter, we stated that the longest path through an activity network is the critical path. Why isnt the completion time for a project defined by the shortest path through the network? Explain...
-
Throughout this chapter, we assumed that a project manager identifies and organizes the activities in a project, estimates the time required for each activity, then determines how quickly the project...
-
A 7 5 kg cliff - diver is falls from a height through the air head, diving towards the water. The drag coefficient for the diver is 0 . 8 3 and the area of the descending diver is 0 . 2 1 m ^ 2 ....
-
In the automobile industry, the dimensionless drag coefficient and the area of the vehicle are often combined into one variable - the drag area whereby the drag area is the product of the...
-
When you drop 10 pebbles into the well, you record the times for hearing the splash as 2.94 s, 3.11 s, 3.12 s, 2.97 s, 3.12 s, 2.97 s, 3.06 s, 3.21 s, 3.37 s, and 3.53 s. (a) Find the average time...
Study smarter with the SolutionInn App