Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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. image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Internal Audit Of Treasury And Cash Management

Authors: Badr Bentalha

1st Edition

B0BM3R6WG7, 979-8363213779

More Books

Students also viewed these Accounting questions

Question

How do you determine the load-bearing capacity of a soil?

Answered: 1 week ago

Question

what is Edward Lemieux effect / Anomeric effect ?

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago

Question

Explain the importance of staffing in business organisations

Answered: 1 week ago