QuestionQuestion

Transcribed TextTranscribed Text

Facts for Assignment Cost and Managerial Accounting Spreadsheet 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: Regular selling price Variable costs "Sophisticate" $11.00 7.00 $1.00 .60 "Shampoo" 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 $25,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 ifno 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" ~e expected to increase for a given level of ads purchased: Ads purchased $25,000 50,000 75,000 100,000 Additional bottles sold 12,000 20,000 25,000 27,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 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 the "Sophisticate" image has been tarnished by association with a sister product that uses the low-brow tactic of couponing. Sandy's estimates that each $25,000 increment of coupons will cause a 1000 bottle decline in the sale of "Sophisticate." Requirements: Prepare a spreadsheet that performs the computations specified below. You should proceed in the following manner: I. Copy the schedule presented below into a spreadsheet. For the time being, leave blank the cells marked "input." 2. Next, input data into the cells marked "input." 3. Put formulas in the cells marked "computed" that compute the requested results. 4. Hand in a printout of your schedule, with numbers in it. 5. Separately, hand in a listing (printout) of each formula organized in the order listed in the schedule (total dollar sales, total fixed costs, etc.). The cell references should correspond to your printout of the separate schedule (from #4 above). Name Ads Purchased Input Input Input Input Input Coupons Purchased " " " " " Other Fixed Costs " " " " Regular Price, Sophisticate " Regula1 Price, Shampoo ., " " Variable cost, Sophisticate " " Variable cost, Shampoo " " " Units Sophisticate, no ads " " " " " Units Shampoo, no coupons " " " Increased units, Sophisticate, ads " " " " " Increased units Sho/.oo, coupons " " " " " Coupon discount O 0 " " " " . Decreased units Sophisticate, coupons " " " " " Total Dollar Sales Computed Computed Computed Computed Computed Total Fixed Costs " " " " Total Variable Costs ,. " " " Operating Income " " " " "

Solution PreviewSolution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Cost And Managerial Accounting Assignment
    $23.00 for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Accounting Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats