Question: please solve on excel H B D 1. Question 01: Naramata Risers 3-Points 2. A local Okanagan company makes three different types of standing desks
please solve on excel
H B D 1. Question 01: Naramata Risers 3-Points 2. A local Okanagan company makes three different types of standing desks Gamer, 3 Manager, and Executive models. The marketing group has asked for your help in 4 determining how many of each it should produce this year in order to maumize their total 5 profit. Given the current supply chain issues, their production capacity is limited by the current levels of raw material inputs. Furthermore, the company expects to produce less 7 than what is demanded this year, in order to ensure that they can meet their orders without over-promising to customers. 6 8 10 Standing Desks Gamer Desk 31 12 13 14 Executive Desk $1,150 600 Manager Desk 5850 1500 Profit per Unit Max Demand $625 1350 Materials Required per Un Glue Casters Tubes Motor Wood Executive Desk 500 80 120 20 52.0 Manager Gamer Desk Desk 720 45.0 40 40 80 100 10 00 320 200 Mates Avale 42 500 6,600 8.000 1,220 35 000 15 16 17 18 19 20 21 22 23 24 25 26 227
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
