Economists at General Industries have been examining operating costs at one of its parts manufacturing plants in an effort to determine whether the plant is being operated efficiently. From weekly cost records, the economists developed the following cost-output information concerning the operation of the plant:

a. AVC (average variable cost) at an output of 2,000 units per week is $7.50.
b. At an output level of 5,000 units per week, AFC (average fixed cost) is $3.
c. TC (total cost) increases by $5,000 when output is increased from 2,000 to 3,000 units per week.
d. TVC (total variable cost) at an output level of 4,000 units per week is $23,000.
e. AVC (average variable cost) decreases by $0.75 per unit when output is increased from 4,000 to 5,000 units per week.
f. AFC plus AVC for 8,000 units per week is $7.50 per unit.
g. ATC (average total cost) decreases by $0.50 per unit when output is decreased from 8,000 to 7,000 units per week.
h. TVC increases by $3,000 when output is increased from 5,000 to 6,000 units per week.
i. TC decreases by $7,000 when output is decreased from 2,000 to 1,000 units per week.
j. MC (marginal cost) is $16 per unit when output is increased from 8,000 to 9,000 units per week.

Given the preceding information, complete the following cost schedule for the plant. (Hint: Proceed sequentially through the list, filing in all the related entries before proceeding to the next item of information in the list.)

... Rate=i= 9% Number of periods=n=nper=5 Use PV function in MS Excel to get ... FOR EACH OF THE CASES SHOWN IN THE TABLE BELOW, CALCULATE THE FUTURE VALUE OF THE ...

... periods=NPER=119.8619454 =NPER(C3,C4,,C6) (We have used the NPER function in MS Excel to get this value) Time required=29.96548636 Years. Calculate the current ...

... steps to calculate the current price and return of the given investment. Calculations are carried out with the help of suitable built-in functions in MS Excel. ...

...MS Excel is used for calculating net income, contribution margin, contribution ... Units Produced and Sold 2,000 Please use MS EXCEL to: 1) Calculate Net Income. ...

... to first problem depicts the steps to calculate value of a ... Solution to second problem calculates the realized rate of ... estimated by using PV function in MS Excel ...

... different versions of the formula to calculate a correlation ... is: One of the things that is missing from your ... if all you're doing is calculating the correlation ...

Calculating markup on price and cost. ... B.Calculate the optimal markup on cost and optimal markup on ... It calculates markup on price and cost in the second part. ...

... Here we reject the null hypothesis since calculated value of t ... 4.2563) is grater than the critical value of t ... was directed to study the problem of missing goods ...

... is H1: There is significant difference in the mean values. ...MS treatment / MS error = 166.25 ... rule: Reject the null hypothesis, if the calculated value of F ...

...Calculate the missing total-revenue and marginal-revenue amounts, and determine the profit-maximizing price and profit-earning output for his monopolist. ...