operations management excel problems
wmashles88
ch3hmwk.xlsx3-P2
| Chapter 3-Problem 2 | |||
| Parameters | Results | ||
| Fixed costs (FC) | Breakeven (Q) | 6,000 | patients/year |
| Variable costs (VC) | $ 35 | per patient | |
| Selling price (SP) | $ 55 | per patient | |
Chapter 3 Solutions-&A
&P of &N
3-P8
| Chapter 3-Problem 8 | |||||
| Parameters | Inputs | Results | |||
| Fixed costs (FC) | $ 70,000 | Selling price (SP) | $ 20 | Breakeven (Q) | 5,834 |
| Variable costs (VC) | $ 8 | per unit | Quantity | Contribution to Profit | $ 80,000 |
| a. | Costs | Revenue | |||
| Quantities | FC+(VCXQ) | SPXQ | |||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| $ 70,000 | $ - 0 | ||||
| b. | |||||
| Contribution Margin | $ 80,000 | ||||
| c. | |||||
| Contribution Margin | $ 74,000 |
Chapter 3 Solutions-&A
&P of &N
FC+(VCXQ) 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 SPXQ 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 FC+(VCXQ) 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 70000.0 SPXQ 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.03-P10
| Chapter 3-Problem 10 | |||||
| Parameters | Inputs | Results | |||
| Fixed costs (FC) | Selling price (SP) | Breakeven (Q) | |||
| Variable costs (VC) | per unit | Quantity | Contribution to Profit | ||
| Current Situation | |||||
| Parameters | Inputs | Results | |||
| Fixed costs (FC) | Selling price (SP) | Breakeven (Q) | |||
| Variable costs (VC) | per unit | Quantity | Contribution to Profit | ||
| New Equipment | |||||
| Parameters | Inputs | Results | |||
| Fixed costs (FC) | $ 200,000 | Selling price (SP) | $ 35 | Breakeven (Q) | |
| Variable costs (VC) | $ 13 | per unit | Quantity | Contribution to Profit | $ 1,340,000 |
| Increase Sales Price | |||||
| Parameters | Inputs | Results | |||
| Fixed costs (FC) | $ 50,000 | Selling price (SP) | Breakeven (Q) | ||
| Variable costs (VC) | $ 3 | per unit | Quantity | Contribution to Profit | $ 880,000 |
| Contribution Margin |
Chapter 3 Solutions-&A
&P of &N
3-P12
| Chapter 3-Problem 12 | |||
| Parameters | Inputs | Results | |
| Fixed costs (FC) | Selling price (SP) | Breakeven (Q) | |
| Variable costs (VC) | per unit | Quantity | Contribution to Profit |
| a. | Costs | Revenue | |
| Quantities | FC+(VCXQ) | SPXQ | |
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| $ - 0 | $ - 0 | ||
| b. | |||
| Contribution Margin | |||
| c. | |||
| Contribution Margin |
Chapter 3 Solutions-&A
&P of &N
FC+(VCXQ) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 SPXQ 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 FC+(VCXQ) 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 SPXQ 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.03-P14
| Chapter 3-Problem 14 | |
| Try using DrawAnywhere.com to create your flowchart. | |
| Parameters | Results |
| Step 1 | Unload carrots |
| Step 2 | Inspect carrots |
| Step 3 | Weigh carrots |
| Step 4 | Move to storage |
| Step 5 | Wait until needed |
| Step 6 | Move to washer |
| Step 7 | Boil in water |
| Step 8 | Mash carrots |
| Step 9 | Inspect |
Chapter 3 Solutions-&A
&P of &N
unload truck
inspect carrots
weigh carrots
move to storage
wait until needed
move to washer
boil in water
mash carrots
inspect
3-P16
| Chapter 3-Problem 16 | |||
| Parameters | Results | ||
| Total time | minutes | Process velocity | 5.25 |
| Staff contact | minutes | Process efficiency | 105% |
| Aver Qty | pat/day | ||
| Stan Qty | pat/day | ||
Chapter 3 Solutions-&A
&P of &N
3-P18
| Chapter 3-Problem 18 | ||
| Parameters | Results | |
| Production time | hrs | Process velocity |
| Time on product | hrs | |
Chapter 3 Solutions-&A
&P of &N
