Tutorial #2 - Templates

xlsx

School

Western University *

*We aren’t endorsed by this school

Course

MOS 3330

Subject

Medicine

Date

Oct 30, 2023

Type

xlsx

Pages

22

Uploaded by Getbystudying

Report
Data Variable Cost $6 Fixed cost $60,000 Selling Price $13 Approach 1: Goal Seek Decision variable # of units 10,000 Variable cost $60,000 Fixed cost $60,000 Revenue $125,000 Profit $5,000 a) 5,000 units Approach 2: Algabraic 9230.7692308 Approach 3: Sensitivity Analysis $5,000 $12 12.5 $13 13.5 $14 0 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000
20000
14.5 $15 15.5 $16 16.5 $17
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
17.5 $18
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Data Options Fixed Cost Variable cost/unit 1 (Internal) $61,000 $12.5 2 (External) $25,000 $18.5 Room/night 50 Days of operations 365 Approach 1: Algebraic BEP # of rooms 6000 Total rooms rented 18250 /year Variable Cost $12.50 /room internal Yearly variable cost $228,125.00 internal Yearly fixed cost $61,000 internal Total internal cost $289,125.00 Variable Cost $18.50 /room external Yearly variable cost $337,625.00 external Yearly fixed cost $25,000 external Total external cost $362,625.00 Approach 2: Sensitivity Analysis Decision variable # of rooms 10000 Solutions Options Fixed Cost Total variable cost Total costs 1 (Internal) $61,000 $125,000 $186,000 2 (External) $25,000 $185,000 $210,000 Option 1 Option 2 $186,000 $210,000 0 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 13000
14000 15000 16000 17000 18000 19000 20000 Option 1 Option 2 $186,000 $210,000 0 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000 20000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0 1000 2000 3000 4000 $- $2.00 $4.00 $6.00 $8.00 $10.00 $12.00
00 500 0 600 0 7000 8000 9000 10000 11000 12000 130 00 140 00 15000 16000 17000 18000 19000 20000 Chart Title Option 1 $186,000 Option 2 $210,000
Data Location AFC Variable cost per pair Aspen $8,000,000 $250 Medicine Lodge $2,400,000 $130 Broken Bow $3,400,000 $90 Wounded Knee $4,500,000 $65 Decision variable: # of skis 44,000 Location Total Cost Aspen $19,000,000 Medicine Lodge $8,120,000 Broken Bow $7,360,000 Wounded Knee $7,360,000 a) Plot cost curves Total cost Aspen Medicine Lodge Broken Bow $19,000,000 $8,120,000 $7,360,000 0 $ 3,400,000.00 10,000 $ 4,300,000.00 20000 $ 5,200,000.00 30,000 $ 6,100,000.00 40000 $ 7,000,000.00 50,000 $ 7,900,000.00 60000 $ 8,800,000.00 70,000 $ 9,700,000.00 80000 $ 10,600,000.00 90,000 $ 11,500,000.00 100000 $ 12,400,000.00 110,000 $ 13,300,000.00 120000 $ 14,200,000.00 130,000 $ 15,100,000.00 140000 $ 16,000,000.00 150,000 $ 16,900,000.00 160000 $ 17,800,000.00 170,000 $ 18,700,000.00 180000 $ 19,600,000.00 190,000 $ 20,500,000.00 200000 $ 21,400,000.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
b) Breakeven between Medicine Lodge and Broken Bow ($760,000) This happens at Breakeven between Broken Bow and Wounded Knee $0 This happens at Therefore from X-X units you want to produce at Medicine Lodge, from X-X you want to produce c) Location AFC Variable cost per pair Total fircastedcost Aspen $8,000,000 $250 $23,000,000 Medicine Lodge $2,400,000 $130 $8,250,000 Broken Bow $3,400,000 $90 $7,270,000 Wounded Knee $4,500,000 $65 $7,100,000 d) Yes it is sensitive to forecasted demand, so we will conduct a sensitivity analysis to prove this Location AFC Variable cost per pair Total cost Aspen $8,000,000 $250 $33,000,000 Medicine Lodge $2,400,000 $130 $15,400,000 Broken Bow $3,400,000 $90 $12,400,000 Wounded Knee $4,500,000 $65 $11,000,000 Decision variable Forecasted Demand 100,000 Profit Aspen Medicine Lodge Broken Bow $17,000,000 $19,600,000 $22,600,000 40,000 7000000 50,000 9600000 60,000 12200000 70,000 14800000 80,000 17400000 90,000 20000000 100,000 22600000 110,000 25200000
120,000 27800000 130,000 30400000 140,000 33000000 150,000 35600000 160,000 38200000 170,000 40800000 180,000 43400000 190,000 46000000 200,000 48600000 Breakeven between Aspen and Broken Bow Decision variable 100,000 (R1-v1)QBEP - F1 $7,780,000 R2 $500 v2 $250 F2 $8,000,000 (R2-v2)QBEP - F2 $17,220,000 =
Wounded Knee $7,360,000 $ 4,500,000.00 $ 5,150,000.00 $ 5,800,000.00 $ 6,450,000.00 $ 7,100,000.00 $ 7,750,000.00 $ 8,400,000.00 $ 9,050,000.00 $ 9,700,000.00 $ 10,350,000.00 $ 11,000,000.00 $ 11,650,000.00 $ 12,300,000.00 $ 12,950,000.00 $ 13,600,000.00 $ 14,250,000.00 $ 14,900,000.00 $ 15,550,000.00 $ 16,200,000.00 $ 16,850,000.00 $ 17,500,000.00 $- $5,000,000.0 $10,000,000.0 $15,000,000.0 $20,000,000.0 $25,000,000.0 A
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
e at Broken Bow, and after X you want to produce at Wounded Knee Price per pair Forecasted Demand Total forecasted revenue Total forecasted profit $500 60000 $30,000,000 $7,000,000 $350 45000 $15,750,000 $7,500,000 $350 43000 $15,050,000 $7,780,000 $350 40000 $14,000,000 $6,900,000 Price per pair Total forecasted revenTotal forecasted profit $500 $50,000,000 $17,000,000 $350 $35,000,000 $19,600,000 $350 $35,000,000 $22,600,000 $350 $35,000,000 $24,000,000 Wounded Knee $24,000,000 6900000 9750000 12600000 15450000 18300000 21150000 24000000 26850000 30000000 40000000 50000000 60000000
29700000 32550000 35400000 38250000 41100000 43950000 46800000 49650000 52500000 1 2 3 0 10000000 20000000
0 10000 20000 300 00 40000 50000 600 00 70000 80000 900 00 100000 110000 120000 130000 140000 150000 160 000 170000 180000 190 000 200000 00 00 00 00 00 Chart Title Aspen Medicine Lodge Broken Bow Wounded Knee
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Profit Curve
4 5 6 7 8 9 10 11 12 13 14 15 1 Aspen Medicine Lodge Broken Bow Wounded Knee
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
16 17
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Oral Report - Blue Light.pdf
N440 - HIVAIDS.docx
4200 Exam 2 Study Guide.docx
opioid hw.docx
Review+Questions+Chapter+9+Radiation+Protection+in+Medical+Radiography.pdf
Surgery Midterm.pdf
Week 2.docx
The 2017 hormone therapy position statement of The North American.pdf
8.1 Assignment_ Emergency Scenarios (Part 2).pdf
Week 1 Discussion Health Care Finance.docx
IMG_0526.png
83137-Family-Narratives-docx.docx

Browse Popular Homework Q&A

Q: The lifetime of lightbulbs has a mean of 1500 hours and a standard deviation of 70 hours. A sample…
Q: Parts a-c
Q: Precise measurements give the following masses: nuclide mass 27 13 Al 26.98154 u He 30. ISP 4.00260…
Q: Which of the following carbocations is the most stable one? a. I-U-I H-C+ H b. CH3 H-C + I H C. CH3…
Q: Question 1 Complete the nuclear equation for the alpha-decay of Fm-244. FM-244 Complete the nuclear…
Q: uppose there are two states that do not trade: Iowa and Nebraska. Each state produces the same two…
Q: Name the following compound. CH3 CH3 CH3 CH₂ ECCH3 Spell out the full name of the compound.
Q: You are in a spaceship with no windows, radios, or other means to check outside. How would you…
Q: What force must be applied to the tip of the wing to store twice the energy found in part B? Express…
Q: college faculty consists of 400 men and 250 women. The college administration wants to draw a sample…
Q: Discuss several effects of aging on the male reproductive system.
Q: Suppose the government wants to reduce the total pollution emitted by three local firms. Currently,…
Q: There are 4 permutations: natural response and step response for both parallel and for series RLC…
Q: Write 2.132 (repeat line over 32) as a quotient of two natural numbers.
Q: normally distributed with a mean of 104.9 and a standard deviation of 22.7. Find the probability…
Q: what is the WACC?
Q: When 1 mole of H₂CO(g) reacts with O₂(g) to form CO₂(g) and H₂O(1) according to the following…
Q: In Exercises 33–34, find the distance from the point to the line. 33. (0, 0, 12); x = 4t, y =-2t, z…
Q: 2 just write them! Find the 20v 2523 mesh currents. m 4.2 me do not solve the equations, 55L m 65…
Q: Hat is the NPV of this investment ?
Q: A force P of magnitude 520 lb acts on the frame shown at point E. Determine the moment of P about…
Q: PRICE (Dollars per unit) 140 70 50 egion etween W and X etween X and Y etween Y and Z each of the…
Q: (3) Look at the boxplot below, which shows data for the selling price of homes in a certain…
Q: Suppose you want to deposit a certain amount of money into a savings account and then leave it alone…
Q: What half reaction occurs at the anode during the electrolysis of molten potassium bromide: OK---->…