Total Cost Formula Excel Template.xlsx - Total Cost Excel Template Visit www.educba.com Email [email protected] SDF Ltd which is a company engaged in the

# Total Cost Formula Excel Template.xlsx - Total Cost Excel...

• 5

This preview shows page 1 - 3 out of 5 pages.

Total Cost Excel Template Visit: Email: [email protected]
SDF Ltd which is a company engaged in the manufacturing of auto parts components.During a recent in cost audit, the accounts department informed that the total fixed cost of production for the company is per month while the average variable cost per unit is \$5.Based on the given information,Calculate the cost of production for the company when the quantity of monthly production is Total Fixed Cost \$10,000 Average Variable Cost Per Unit \$5 For 2,000 Units Quantity of Units Produced \$2,000 Total Cost of Production is calculated using the formula given below Total Cost = Total Fixed Cost + Average Variable Cost Per Unit * Quantity of Units Produced Total Cost \$20,000 For 3,000 Units Quantity of Units Produced \$3,000 Total Cost of Production is calculated using the formula given below Total Cost = Total Fixed Cost + Average Variable Cost Per Unit * Quantity of Units Produced Total Cost \$25,000 For 5,000 Units Quantity of Units Produced \$5,000 Total Cost of Production