Cost Curves by SpreadsheetZONE

VIEWS: 133 PAGES: 5

More Info
									COST CURVES
Unit price of a Worker: 50
FC Worker Amount 1 2 3 4 5 6 7 8 9 10 Copy Amount 625 1325 2200 2600 2900 3100 3290 3500 3600 3700 Fixed Cost 200 200 200 200 200 200 200 200 200 200 VC Variable Cost 50 100 150 200 250 300 350 400 450 500

Fixed cost to keep on producti
TC Total Cost 250 300 350 400 450 500 550 600 650 700

0.4500

0.4000 0.3500 0.3000 0.2500 0.2000 0.1500 0.1000 0.0500 0.0000 0 2 4 6 8 10 12 AFC AVC ATC
Best

CURVES
200
AVC Average Variable Cost (per unit) 0.0800 0.0755 0.0682 0.0769 0.0862 0.0968 0.1064 0.1143 0.1250 0.1351 ATC Average Total Cost (per unit) 0.4000 0.2264 0.1591 0.1538 0.1552 0.1613 0.1672 0.1714 0.1806 0.1892

cost to keep on production/service:
TC AFC Average Fixed Cost (per unit) 0.3200 0.1509 0.0909 0.0769 0.0690 0.0645 0.0608 0.0571 0.0556 0.0541

Total Cost 250 300 350 400 450 500 550 600 650 700

ANALYSIS Lowest cost of the Worker is obtained at the minimum point of the ATC curve. Worker Amount: Copy Amount: FC: VC: TC: 200.00 200.00 400.00 4 2,600 AFC: AVC: ATC: 0.0769 0.0769 0.1538

AFC AVC ATC Best

#### #### #### #### #### #### #### #### #### ####

1 2 3 4 5 6 7 8 9 10

#### #### #### #### #### #### #### #### #### ####

#### #### #### #### #### #### #### #### #### ####

#### #### #### #### #### #### #### #### #### ####

#### #### #### #### #### #### #### #### #### ####

4 0 4 ####

#### #### #### #### #### #### #### #### #### #### #### #### 4

#### #### #### #### #### #### #### #### #### ####

#### #### #### #### #### #### #### #### #### ####

Follow the steps to enable your Cost Curve.
>> 1) 2) >> 1) such resources. Type the name of the resource that you want to create the cost curve: Worker Type the name of the product/service: Copy Visit the site below: http://www.spreadsheetweb.com/getting_started.htm You will only need the username and password to create your Cost Curve. 2) Visit the site below: http://trial.spreadsheetweb.com/spreadsheetweb/ Login to page with your new account information. 3) >> >> Click "Add Web Application" to upload this file. Your Cost Curve will be created automatically. You can simply use the Cost Curve from that link or place it on your website. Your Cost Curve will look like: http://www1.spreadsheetweb.com/SpreadSheetWeb/Output.aspx?ApplicationId=643dcda5-4863-4d77-95fe-ac9dea78a78b In order to see more online applications created with PSW you can check the link below: http://www.spreadsheetweb.com/demos.htm

The productivity observed by using different amounts of resources may not always be linear. This template helps to evaluate the rea

Your Cost Curve is ready to use. You can fill the table in the "Cost Curve" sheet and analyze the costs. Following steps are for online u

Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

plate helps to evaluate the real cost of

ollowing steps are for online use.

77-95fe-ac9dea78a78b


								
To top