Question: answer in that excel format please! Please put the correct formulas within the table. An electronics manufacturer has an option to produce six styles of

answer in that excel format please!
answer in that excel format please! Please put
answer in that excel format please! Please put
answer in that excel format please! Please put
Please put the correct formulas within the table. An electronics manufacturer has an option to produce six styles of cell phones. Each of these devices requires time, in minutes, on three types of electronic testing equipment as shown in the table at the bottom of this page. The first two test devices are each available for 120 hours per week. Test device 3 requires more preventive maintenance and may be used only for 100 hours each week The market for all six cell phones is vast, so the manufacturer believes that it can sell as many cell phones as it can manufacture The table also Summarizes the revenues and material costs for each type of phone In addition variable labor costs de $15 per hour toe test device $12 per hour fortest devke 7 and 518 per hour for test device 3 Determine product rx that would maxhere profits Fomulate the problem as an LP model and solve it by single Bold Phone Luke46 Problem 3-6 Smartphone Blueber Moplane Solution value Revenue What cost Labo cost PIC Constraints La Tendevide 2 Teena Cost LNS sogn RHS Table for Problem 6 SMARTPHONE BLUEBERRY MOPHONE BOLDPHONE LUXPHONE4G TAP3G 7 3 12 6 18 17 17 2 S 3 2 IS 5 Test device 1 Test device 2 Test device 3 Revenue per unit Material cost per unit 1 3 2 9 2 S120 S200 S2601 $200 $35 SINO S.10 S430 S170 S25 Sas 560

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!