View the step-by-step solution to:

Homework #1 Q1 - A Fix Cost 65000 Variable Cost 7.5 sales volume 15000 sale Price 25 Variable Cost 7.5 sales price 25 Break-even quantities Q1 - B...

I need to show my work for these excel questions with an excel formula. Can anyone help me?

Homework #1 Fix Cost Variable Cost sales volume sale Price Revenue Total Cost Proft Revenue Q1 - A 65000 7.5 15000 25 Total Cost Proft Fix Cost Variable Cost sales price Break-even quan±±es Q1 - B 65000 7.5 25 Break-even: Revenue = Total Cost Fix Cost Variable Cost sales price Break-even quan±±es Q2 25000 0.2 0.45 Fix Cost Variable Cost sales price Break-even quan±±es E²ects Q3 25000 0.2 0.55 0 Fix Cost & Adver±sing Variable Cost sales price Break-even quan±±es E²ects Q4 25833.33333 0.2 0.45 0 Q13 Monthly fx Cost & adv. Variable Cost sales price Break-even quan±±es Q5 - A 6500 0.4 9000 Q5 - B Fix Cost Variable Cost sales price Break-even quan±±es Q6 - A 400000 10000 20000 Fix Cost Variable Cost sales volume sale Price Proft Q6 - B 400000 10000 80 20000 Fix Cost Variable Cost sales volume sale Price Proft Note Q6 - C 400000 10000 50 25000 Fix Cost (vender's ³ee & equipment) Please give your answers in YELLOW boxes
Background image of page 1
Q7 Grade Scale Probability Expected Value Variance A 4 0.1 B 3 0.2 C 2 0.4 D 1 0.2 F 0 0.1 1 Expected Grade Course Variance Q8 Economic CondiTons Investment Good Poor Probability 0.45 0.55 A: A $380,000 ($100,000) B: B 130,000 85,000 Choose investment A or B? Q9 DistribuTon Mean Standard deviaTon Lower weight limit Upper weight Limit Probability Upper limit Normal 45 5 38 50 Lower Limit Probability (in betwee Note: probability from the upper limit to -inFnity is 0.7734 Q10 DistribuTon Mean Standard deviaTon Occupied Probability NO± occupied Normal 15 5 18 Occupuied Not occupied Q11 DistribuTon Mean Standard deviaTon Probability Number of recorders ordered Normal 175 55 0.85
Background image of page 2
Show entire document
Sign up to view the entire interaction

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question