Business Studies 12D Half Term Work

Business Studies 12D: Half Term Work

Assignment: You are to make a handout on Breakeven which explains the following situations:

1. Increase in Price
2. Decrease in Price
3. Increase in VC per Unit
4. Decrease in VC per Unit
5. Increase in Fixed Costs
6. Decrease in Fixed Costs

Make Column Names:
Output    Price    Variable    Cost Per Unit      Fixed Cost     Variable Cost      Total Cost       Revenue

Formulas:

Variable Cost: “=C2*A2”

Total Cost: “=D2+E2”

Revenue: “=A2*B2”

 

You can then use these values to make a table.

Using this table, you can make breakeven graphs for your handout.

Due Date: Monday 31 October 2011

 

If you have any questions, email me.  I will be able to provide help, but not for people trying to get it done last minute.

 

Mr. Hughes