【20點!】生產作業管理:產能的計算題

學校的原文課本在第5章「Strategic Capacity Planning for Products and Services」有一題與產能有關的計算題:

A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of %9,200 per month and variable costs of 70 cents per unit produced. Each item is sold to retailers at a price that averages 90 cent.

a. What volume per month is required in order to break even?

b. What profit would be realized on a monthly volume of 61,000 units? 87,000units?

c. What volume is needed to obtain a profit of $16,000 per month?

d. What volume is needed to provide a revenue of $23,000 per month?

e. Plot the total cost and total revenue lines.

============================

e小題是excel的相關答法,不用回答ok,

但想麻煩您指導我a~d小題的計算算式,讓我了解它的算式過程,

以利我解惑,感謝您!

1 Answer

Rating
  • Huevos
    Lv 6
    7 years ago
    Favorite Answer

    A - 46,000

    B - $3000, $8200

    C - 1,260,000

    D - 25,555,56

    Total Cost 公式為: (FC+(VC*Price Sold))

    Total Revenue公式為: (Quantity*Price Sold)

    Profit 公式為: TR-TC = (Quantity*Price Sold)-(FC+(VC*Price Sold))

    檔案為: https://docs.google.com/spreadsheet/ccc?key=0AlckZ...

    運用的程式

    圖片參考:http://i15.photobucket.com/albums/a386/magengeschw...

    方式:

    圖片參考:http://i15.photobucket.com/albums/a386/magengeschw...

    2012-12-29 14:56:16 補充:

    更正:

    Total Cost 公式為: (FC+(VC*Quantity))

    Profit 公式為: TR-TC = (Quantity*Price Sold)-(FC+(VC*Quantity))

    2012-12-29 14:58:35 補充:

    簡單講,第一題的公式是:

    Profit = 0

    0 = (Q*0.9)-(9200+(0.7*Q))

    解Q,答案就出來了

    2012-12-29 15:02:09 補充:

    第二題,公式是: (變數都跟你講了,直接解)

    (61,000*0.9)-(9200+(0.7*61,000)) = ?

    (87,000*0.9)-(9200+(0.7*87,000)) = ?

    第三題,公式是:

    (Q*0.9)-(9200+(0.7*Q)) = 16,000

    解Q答案就出來了。

    第四題,公式是:

    (Q*0.9) = $23,000

    解Q答案就出來了。

    2012-12-29 15:05:02 補充:

    我運用的"Q"是Quantity,也就是volume。

    • Login to reply the answers
Still have questions? Get your answers by asking now.