Explore BrainMass
Share

Filling in a Cost spreadsheet

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

During the last few days the Company ABC has been running into problems with its computer system. The last run of the production cost schedule resulted in the incomplete listing shown below. From your knowledge of cost theory, fill in the blanks.

Q TC TFC TVC ATC AFC AVC MC
0 40 _____ _____ x x x x
1 _____ _____ _____ 52 _____ _____ _____
2 _____ _____ 20 _____ _____ _____ _____
3 _____ _____ _____ 21.33 _____ _____ _____
4 _____ _____ _____ _____ _____ _____ 4
5 _____ _____ 40 _____ _____ _____ _____
6 _____ _____ _____ 15.67 _____ _____ _____
7 _____ _____ _____ _____ _____ 10 _____
8 _____ _____ 96 _____ _____ _____ _____
9 _____ _____ _____ _____ _____ 15 _____
10 _____ _____ _____ _____ _____ _____ 45

Q = Production; TC = Total Cost; FC = Fixed Cost; TVC = Total Variable Cost; ATC = Average Total Cost; AFC = Average Fixed Cost; and MC = Marginal Cost

© BrainMass Inc. brainmass.com October 17, 2018, 4:35 am ad1c9bdddf
https://brainmass.com/economics/cost-benefit-analysis/filling-in-a-cost-spreadsheet-469476

Solution Preview

See the attached file. The formulas in the cells show how each ...

Solution Summary

Given a partially filled-in spreadsheet of a firm's costs, this solution gives the formulas for each type of cost and shows how to calculate the missing values.

$2.19
Similar Posting

Analysis of Selling Price and Unit Cost for Profitability

Cost-volume-profit analysis as a tool used for decision making.

The Hershey Corporation:
http://library.corporate-ir.net/library/11/115/115590/items/283950/10K_Hershey[1].pdf

Review the Consolidated Statements of Income In Hershey's 2007 annual report (ignore all figures below net income, such as, per share information). Using the spreadsheet below fill in requirements 1 through 4 in the spreadsheet using the following data:

1. Units Sold

a. 2005 - 100,000,000 units

b. 2006 - 100,400,000 units

c. 2007 - 200,000,000 units

2. Variable Manufacturing Costs Percentage- 45% of Cost of Sales

3. Variable Marketing Costs Percentage- 15% of Cost of Sales

4. Fixed Costs Percentage- 40% of Cost of Sales

View Full Posting Details