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
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
Show entire document

### 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