HomeworkLib
Question

4. Samantha and Sabrina are opening a soda stand. They believe the fixed cost per week of running the stand is $50.00. Their best guess is that they can sell 300 sodas per week at $0.75 per soda. The variable cost of obtaining a can of soda is $0.20 Given her other assumptions, and using Excel, find the level of sales volume a. that will enable them to break even. Given her other assumptions, draw a break-even graph and discuss how a change in sales volume affects profit. b. From the graph in (b) discuss how changes in sales volume and variable cost jointly affect profit. c.

additional instructions to follow:

For part b: Create a data table with sales volume beginning at 250 units up to 400 units at increments of 25 units which displays the units and profits. Graph this data table like is done in the Teez instructor video. For part c: Create a two dimensional data table with the variable cost of a soda moving from.10 to.30 at.05 intervals and sales volume moving from 250 to 400 units at increments of 25. Graph you findings.

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Sou Consider the folouwin given data Samantha and Sabsina a a Soda seand he Pixed Cose per weekoe uring the Stand is 350, o0o. The, best uess enae set 30 0 Sodes Pe ase openin53.500 53.000 52.500 52.000 1.500 $1.000 $500 s0 5500 TFC Sales Profit 400 800 1.2001 2400 2,800 3 200 3600 4Break Even Point units)-91 Break Even Point (Ss)-568 Formula BEP funitsTFCHSPU BEP (59) BEP (unts) SPU VCU Sales Pice per Unt 50.7SP Pea Soda s o.-15 Less vas Cost So 20 Cont pes Soda So 55 Le ss Fixed cose S50 oo i S a. Foom 33apn, we sales douaaS b- From gyaph, a,İth incvease in sales volume, the Por|t c. mc in Sares Varume orth ma Change im vax Co wi inCrease Profits st

0 0
Add a comment
Know the answer?
Add Answer to:
additional instructions to follow: 4. Samantha and Sabrina are opening a soda stand. They believe the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Sabrina and Samantha are opening a soda stand. They believe that the fixed cost per week...

    Sabrina and Samantha are opening a soda stand. They believe that the fixed cost per week of running the stand is $50.00.Their best guess is that they can sell 300 sodas per week at $0.75 per soda. The variable cost of obtaining a can of soda is $0.20. A. Given her other assumptions, using Excel, find the level of sales volume that will enable them to break even. B. Given her other assumptions, draw a break even graph and discuss...

  • Sabrina and Samantha are opening a soda stand. They believe that the fixed cost per week...

    Sabrina and Samantha are opening a soda stand. They believe that the fixed cost per week of running the stand is $50.00.Their best guess is that they can sell 300 sodas per week at $0.75 per soda. The variable cost of obtaining a can of soda is $0.20. A. Given her other assumptions, using Excel, find the level of sales volume that will enable them to break even. B. Given her other assumptions, draw a break even graph and discuss...

  • additional instructions for part B and C Samantha and Sabrina are opening a soda stand. They...

    additional instructions for part B and C Samantha and Sabrina are opening a soda stand. They believe the fixed cost per week of running the stand is $50.00. Their best guess is that they can sell 300 sodas per w sar eek at S0.75 per soda. The variable cost of obtaining a can of soda 4. Given her other assumptions, and using Excel, find the level of sales volume that will enable them to break even. a. b. Given her...

  • Samantha and Sabrine are opening a soda stand. They believe the fixed cost per week of...

    Samantha and Sabrine are opening a soda stand. They believe the fixed cost per week of running the stand is 50.00. Their best guess is that they can sell 300 sodas per week at 0.75 per soda. The variable cost of obtaining a can of soda is 0.20. a. given her other assumptions and using Excel, find the level of sales volume that will enable them to break even. For part b: Create a data table with sales volume beginning...

  • The manufacturing costs of Ackerman Industries for the first three months of the year follow: Total...

    The manufacturing costs of Ackerman Industries for the first three months of the year follow: Total Costs Units Produced January $60,280 1,440 units February 56,160 845 March 87,360 2,145 Using the high-low method, determine (a) the variable cost per unit and (b) the total fixed cost. Round all answers to the nearest whole dollar. a. Variable cost per unit $ b. Total fixed cost $ part 2 Willie Company sells 35,000 units at $29 per unit. Variable costs are $18.56...

  • Answers (Need work shown using: Contribution Margin Approach to CVP analysis): a) 150 units/week b) (i)...

    Answers (Need work shown using: Contribution Margin Approach to CVP analysis): a) 150 units/week b) (i) Loss of $240 a week (ii) Profit of $800 a week c) 200 units/week A small manufacturing operation can produce up to 250 units per week of a product that it sells for $20 per unit. The variable cost per unit is $12, and the fixed cost per week is $1200. Answer a. How many units must the business sell per week to break...

  • riable Calculate the expected production costs if 9,000 units a E20-2 The controller of Norton Industries...

    riable Calculate the expected production costs if 9,000 units a E20-2 The controller of Norton Industries has the cost behaviour of maintenance costs. LIUIl cost listed as variable, fixed, or mixed. n costs if 9,000 units are produced. per of Norton Industries has collected the following monthly expense data for use in a for use in analyting ph. Total Total Month Maintenance Costs Machine Hours January $2,700 300 February 3,000 350 March 3,600 500 April 4,500 690 May 3,200 400...

  • A company sells a product with a contribution margin ratio of 20%. The company's monthly fixed...

    A company sells a product with a contribution margin ratio of 20%. The company's monthly fixed expense is $400,000 and the company's monthly target profit is $100,000. The dollar sales required to attain the target profit are: A. $2,500,000 B. $1,500,000 C. $625,000 D. $2,000,000 Sales above the break-even point will result in net profit equal to _______. A. number of units above break-even times fixed cost per unit B. number of units above break-even times contribution margin per unit...

  • Lab 3: Consider This: Your turn Apply your creative thinking and problem-solving skills to design and...

    Lab 3: Consider This: Your turn Apply your creative thinking and problem-solving skills to design and implement a solution. Determine the Break – Even Point Part 1: You have been hired by Alison Chang, owner of a small start- up company, to create a data table that analyzes the break-even point for a new product she is developing. She would like you to analyze the break-even point for prices ranging from $12.99 to $17.99 per unit, in $0.50 increments. You...

  • Child's Play Company makes a plastic rattle for toddlers. The rattle is generally marketed through exclusive...

    Child's Play Company makes a plastic rattle for toddlers. The rattle is generally marketed through exclusive retailers located in upscale shopping malls. The company used 23 retailers. In late 2016, Diana Suares, the president of the company, was considering alternative marketing plans presented to her by Bill Dings, the marketing manager. Based on sales from January through October 2016, Diana expected that 2016sales would amount to 300,000 units at $8.00 per unit. Diana Suares also had with her some cost...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT