Introducing the new, smallerTablet to market work onth.new product development team for your comgany'snew tabletcomputerofferng, of determining three wildly popular Tablet line decisions for this new preduct, First, you have been asked to determine the price for this product il a tricky decision. You don't want to pricthe new tablet too high because few customers will new product over your fullsized tablet offerings and you risk losing sales to your eivelypriced Total Fixed Costs products You don't want to price the preduct soo low, because you want to earn as much as possible from the product Second, you muit determine where to set the marketing budget for whe will buy just about anything you produce. Beyond that you also know that every dolar you you will want to spend on advertising because eventualy mere meney spent on advertising wilhave new produt You inow that there will be a base demand ler your preduct that comes from your loyal effect on demand and will reduce the profitability of the new product Finally, you have been anked to deoide how much money to prepay to the suppliers of the raw materials e the new product to reduce overal costs of these n on prepaying your supplers wi Contract ICA 550,000,000 s75,000,000 5100,000,000 sao a spreadsheet model so aid in your analysis. Use the What If Analysis options in Excel to help Changing Cel Supplier Contract adPofitability Advertising Budget Price, Advertising, and Profitability 25,000,000 $S0,000,000 210 230 270 370 00 5210 1320 5230 50 N 5080 5390 500 5310 5320 5330 5340 510 5HO 53TO 5380 $0 5400 Introducing the new, smallerTablet to market work onth.new product development team for your comgany'snew tabletcomputerofferng, of determining three wildly popular Tablet line decisions for this new preduct, First, you have been asked to determine the price for this product il a tricky decision. You don't want to pricthe new tablet too high because few customers will new product over your fullsized tablet offerings and you risk losing sales to your eivelypriced Total Fixed Costs products You don't want to price the preduct soo low, because you want to earn as much as possible from the product Second, you muit determine where to set the marketing budget for whe will buy just about anything you produce. Beyond that you also know that every dolar you you will want to spend on advertising because eventualy mere meney spent on advertising wilhave new produt You inow that there will be a base demand ler your preduct that comes from your loyal effect on demand and will reduce the profitability of the new product Finally, you have been anked to deoide how much money to prepay to the suppliers of the raw materials e the new product to reduce overal costs of these n on prepaying your supplers wi Contract ICA 550,000,000 s75,000,000 5100,000,000 sao a spreadsheet model so aid in your analysis. Use the What If Analysis options in Excel to help Changing Cel Supplier Contract adPofitability Advertising Budget Price, Advertising, and Profitability 25,000,000 $S0,000,000 210 230 270 370 00 5210 1320 5230 50 N 5080 5390 500 5310 5320 5330 5340 510 5HO 53TO 5380 $0 5400