Copy of Q3 (Chris) - Assignmen This is a team-assignment One submission per team would suffice Work on this sprea Use range names coloring scheme

Copy of Q3 (Chris) - Assignmen This is a team-assignment...

This preview shows page 1 - 6 out of 24 pages.

Assignm This is a team-assignment. One submission per team would suffice. Work on Use range names, coloring scheme, comments to improv the assignment. Clumpsy work that is hard to figure out even if the procedure and answers see to be correct. All members of the team should contribute. This would include team membe on the three problems and sharing the results to validate and choosing one re Peer evaluation is attached as a separate file. Each team member should eva a scale of excellent contibution at one end to no participation on the other en from 10 points to 1 point for participation and contribution. Feel free to expr will be given as feedback to the team members.
Image of page 1
ment 1 n this spreadsheet. ve the readability of t will loose points ers working independently eport for submission. aluate the contribution on nd. The score also varies ress your comments which Team 1 and name
Image of page 2
Inputs for Lemonade Stand Expected Sales Fixed Cost for Lemonade Stand 50 Sales in Cups 167 Variable Cost (per lemonade) 0.2 Output Models for Revenue, Cost and Sales Price per Cup 0.5 Total Revenue 83 Fixed Cost of Lemonade Stand 50 Total variable cost 33.3 Total cost 83.3 Profit 0 Q. 1-A: Break Even Point Q. 1-B: Sales Volume's impact on Profitability Sales in Cups required to break-even 167 Sales Volume in Cups 0 100 200 300 400 500 600 700 800 900 Queston 1Julie James is opening a lemonade stand. She believes the fixed corunning the stand is $50.00. Her best guess is that she can sell 300$0.50 per cup. The variable cost of producing a cup of lemonade ia.Given her other assumptons, what level of sales volume will eneven?b.Given her other assumptons, discuss how a change in sales voc.Given her other assumptons, discuss how a change in sales volcost jointly afect profit. Soluton 1 : Julie James's Lemonade Stand Model
Image of page 3
Q. 1-C: Sales Volume's and Varaiable Co 0 0.1 100 200 300 400 500 600 700 800 900
Image of page 4
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 24 pages?

  • Spring '08
  • Moeeni,F
  • sales volume

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture