26) Apple makes three models of the iPOD (Shuffle, Nano, and Touch). The selling prices per unit are $49, $149 and $229, respectively for each model. Apple manufacture these three versions at labor cost per unit of $5, $10 and $12, respectively for each model. Each model has increasing amount of memory (GB). The Shuffle has 2GB, Nano has 16GB and the Touch has 64GB. A GB of memory has an electronic material cost of $2. If Apple only has 30,000 GB of electronic memory material available per month how many of each iPOD model should be produce to maximize the total profit? Complete the excel spreadsheet and run solver to calculate the solution and answer the following questions.
Bu iş için 31 freelancer ortalamada $24 teklif veriyor
Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 hour
Hello, I am engineer in statistics and applied economics with a long experience in this field, and I realized several projects, I have just finished a project like yours on [login to view URL] (see review).
I am a statistician with advanced knowledge of Ms Excel, Google sheets and other statistical tools. I am very thorough with my work while speed and precision is my watchword. You can take a look at my track record on m Daha Fazla
Hi there, Having thoroughly read about your project details am available to deliver on objectives. I have previously completed more than 50 linear programing tasks, all successfully. I possess skills such as excel, e Daha Fazla
It is a single objective (maximize profit) optimization which can be easily solved in Excel solver. But I think the data shows only labor costs and data costs. Cost of material to assemble an iphone is not mentioned to Daha Fazla
Hello. I'm bidding for this project because I'm an Accountant with a lot of experience in Excel programming and academic writing. I'm well versed in optimization problems and Solver padd-in. I guarantee you an accurat Daha Fazla
Hi sir, good morning, I am expert in Excel solver for minimize, maximum, and targeted value calculation using linear model in Excel solver. I can do perfect for you. waiting in inbox thanks
Hello! I use solver very often for my projects in operations and optimization as part of my MBA degree from one of India's top engineering colleges. I can do this immediately for you and also provide a proper explanati Daha Fazla
Hello, I can solve this problem using excel. I have solved similar problems and submitted the same before too. . I can solve it as soon as you award me the project. Awaiting to hearing from you. Regards Kapil
Hello! I am happy to put my bid on your project. I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call Daha Fazla
Hi, I am very much interested in your project " Excel solver expert", I have read the project description and fully understand your requirement. I want to help you in this task with 100% accuracy. I can start workin Daha Fazla
Hi, I have gone through your project placement & it matches my expertise, I understand that you are looking for solution through excel solver. MY PROFILE: https://www.freelancer.com/u/muhammadumar84 EXPERIENCE: 13 Daha Fazla
This actually is a very easy problem statement... I can give the result of this within 1 hour... If needed any help let me know..........