Product Mix Model IV

Introduction: A small retail store is trying to decide on the best use of its advertising budget of $1,000 per month. The store can advertise on local radio for $5 per minute or on local TV for $100 per minute. Each minute of TV advertisement generates 25 times as many sales as each minute of radio advertisement. The store wants to use radio at least twice as much as TV. Instruction: - Review the attached document. Problem: - Create a spreadsheet in Excel to represent this situation and then use the Excel add-in Solver to determine the optimal number of minutes of radio and TV advertising the store should use to maximize its sales. - Return the spreadsheet showing the opti... click for more

Goal Seeking

Instruction: - Review the attached document. - Recreate the last spreadsheet shown in the attached document. - The formulas for the cells E10, E11, and E13 are shown in the last spreadsheet in the attached document. Note: - The PMT() function displays the Monthly Loan Payment amount as a negative value, not as a positive value as shown in the attached document, so you will need to use a negative $1000 (-1000) as your target value for the following problem. Problem: -Once you have recreated the spreadsheet, use Excel's Goal Seek tool to answer the following three questions. -What interest rate will reduce the monthly loan payment to $1,000? (Make a note of the new value for ... click for more

Decision Making Problem

Problem: - Identify a real-world decision-making problem that is appropriate for a decision support system or expert system. - Give a brief description of the overall project. - Describe the specific problem to be solved. - Describe the business setting in which it occurs.

OSI Reference Model

OSI Reference Model The OSI reference model divides network operation and management into seven layers. Layers 1 through 4 are responsible for moving data form one place to another, whereas 5 through 7 handle the exchange of data between application programs. What are the seven layers?

LANS, WANS VANS

What are the main differences between LANs, WANs, and VANs?