Posted on by Judy

•Table consists of 2 LARGE and 2 SMALL LEGO’s •Chair consists of 1 LARGE and 2 SMALL LEGO’s •Have available 15 LARGE and 22 SMALL LEGO’s for production –Can use less, but no more than limit •There is also capacity restrictions (cubic units) – each Table takes up 6 units, each Chair 4 units – with no more space than 48 available. •Table per unit profit of $16, Chair per unit profit of $9 •Determine production of furniture to maximize profit? •(Assume it is okay to make fractional Tables and Chairs … for now.)

https://d2vlcm61l7u1fs.cloudfront.net/media%2F2a4%2F2a4788a4-bf0c-42f4-ac4b-f2469a5749a8%2FphpGctdXA.png
Formula: D2 =SUMPRODUCT(B2:C2,$B$7:$C$7) copy to D2:D5
Result: Number of Tables to be produced = 6
Number of Chairs to be produced = 3
Total Profit = $ 123
 
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"

Related posts:

  1. Your boss is the project manager for a large contract assembly plant. A new customer has come to you with a product they want 20 units of assembled. The customer estimates that the time to assemble a unit is about 15 hours to assemble each one and is willing to pay you at that rate. She accepts the terms and offers you the project. You want to impress the boss but you don’t want to take the project if it will lose money and make you look bad. She tells you that the first unit took 25 hours and the second one took 20 hours. a) What is the learning rate for this project? How many hours do you expect the third unit to take? How many hours do you expect the 20th unit to take? What is the percentage change in productivity from the first unit to the 20th unit? b) What is the total number of hours required for all 20 units? What is the average time to assemble all of the units? Should you accept the project? Why or why not? c) After you have finished the project, the company comes back and asks for 20 more units. How long do believe the first unit of the order would take to produce? The 20th? How many labour hours would be required for the second order? What is the labour time per unit? d) Suppose your company can supply 503 labour hours per month to this product. What is your “capacity” to produce this product (i.e. how many can you produce in the first month)?
  2. Martinez Company S Relevant Range Production 9 500 Units 14 500 Units Produces Sells 12 00 Q17792314
  3. LG owns five production plants where 90″ high definition televisions are produced. LG can sell up to 25,000 televisions per year at the price of $4000 per television. For each plant, the production capacity, the production cost per television, and the fixed cost of operating a plant for year are given below. Production Plant Cost per Plant Capacity Fixed Cost Television 1 10000 $9 million $1,600 2 8000 $5 million $2,000 3 9000 $3 million $2,300 4 7000 $4 million $2,100 5 6000 $1 million $2,400 a. Use Solver to determine how LG can maximize its yearly profit from television production. b. Use SolverTable to determine how the optimal plant locations vary as the number of televisions that can be sold varies from 20,000 to 30,000 (in 1000 unit increments).
  4. your boss asked you for the per unit price of a new product at 200 units and at 400 units given the following: Direct Material Cost is linear from $25/unit for 100 units to $20unit for 600 units Direct Labor Hours are 2.2 hours/unit for 100 to 299 units and 2.0hours/unit for 300 to 599 units Direct Labor Rate is $14/hour Overhead is $50/unit COGS Markup is 40%