Question: Please solve using excel solve showing all formula for Decision variables, Constrants and objective function Intel recently released a new GPU* (Arc A770). To assess

Please solve using excel solve showing all formula for Decision variables, Constrants and objective function

Please solve using excel solve showing all

Intel recently released a new GPU* (Arc A770). To assess the production cost properly, the GPU division must internally purchase "fab"-time every period over the three subsequent periods. Purchasing "fab" time allows GPU units to produce up to a certain amount based on a given period (i.e., periods capacity). For each period GPU division must decide whether to buy "fab" time or not. In addition to "fab-time" costs, the GPU division pays for material costs for each unit produced. All relevant cost information and demand that they need to fulfill in each period are in the Intel worksheet. The GPU market is competitive, and Intel wants to ensure that they meet the demand every period and has 20,000 units at the end of each period as a safety stock. Since this is a new product, the beginning inventory of period 1 is zero. *GPU (Graphics Processing Unit): A programmable processor specialized for rendering all images on the computer's screen.

Create an optimization model that adheres to spreadsheet modeling principles and achieves Intels goal. Explain your solution.

Input Parameters \begin{tabular}{|r|c|c|c|} \hline & Period1 & Period2 & Period3 \\ \hline "Fab-time" Cost & $80,000,000 & $65,000,000 & $50,000,000 \\ \hline Capacity & 290,000 & 250,000 & 250,000 \\ \hline Material Cost & $130 & $125 & $120 \\ \hline Demand & 150,000 & 120,000 & 170,000 \\ \hline \end{tabular} Safety Stock 20,000 Input Parameters \begin{tabular}{|r|c|c|c|} \hline & Period1 & Period2 & Period3 \\ \hline "Fab-time" Cost & $80,000,000 & $65,000,000 & $50,000,000 \\ \hline Capacity & 290,000 & 250,000 & 250,000 \\ \hline Material Cost & $130 & $125 & $120 \\ \hline Demand & 150,000 & 120,000 & 170,000 \\ \hline \end{tabular} Safety Stock 20,000

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!