Will someone please help me with this excel assignment? The first picture attached are facts and the second picture is how the excel sheet should look.
Spreadsheet Assignment Eacts for Assignment Sandy's Shampoo Shacks sell 2 types of shampoo; a high-end product called "Sophisticate," and a low-end product called "Shampoo." Fixed costs other than advertising total $200,000. Selling prices and variable costs per bottle are "Sophisticate Shampoo Regular selling price $11.00 $1.00 Variable costs 7.00 Sandy's is trying to decide on the right advertising mix. It has narrowed down its options to some combination of the following: Ads in fancy magazines, promoting "Sophisticate" only Coupons for "Shampoo" only Sandy's advertising budget totals $100,000 per year. The advertising agency has informed Sandy's that ads can be purchased only in $25,000 increments, and that if Sandy's decides to issue coupons, the minimum cost will also be $25,000, with additional amounts of coupons available at $25,000 increments. Therefore, Sandy's has five possible combinations of ads and coupons. Assume the $100,000 will be fully spent. For coupons, the S25,000 figure refers to the cost of printing and distributing coupons. If no ads are run, Sandy's estimates that it will sell 50,000 bottles of "Sophisticate," and if no coupons are issued, it estimates it will sell 500,000 bottles of"Shampoo." These would be the results if the $100,000 were not spent. The following table details how bottle sales of "Sophisticate" are expected to increase for a given level of ads purchased: $25,000 12,000 20,000 50,000 75,000 25,000 27,000 100,000 For each $25,000 increment of coupons, the company expects a 160,000 bottle increase in sales of "Shampoo" as a result of new customers using the coupons. The coupons entitle customers to 20% off the regular selling price of shampoo." Assume coupons will not "cannibalize" existing wywo us Navy use coupons sales at all. If Sandy's issues coupons for "Shampoo," one additional complication not included in the figures above is that doing so will cause a decline in the sale of"Sophisticate," because some of the snooty buyers of "Sophisticate" will feel that thc "Sophisticate" image has been tarnished by association with a sister product that uses the low-brow tactic of couponing. Sandy's estimates that each S25,000 increment of coupons will cause a 1000 bottle decline in the sale of "Sophisticate
