Piccininni – Week 3 T3.4 #2
In this spreadsheet I created a very basic outlook for a company selling CD’s new, used and MP3 downloads. Listed below is a description of columns and how they relate. I was trying to capture some of the cost that could be in a value chain manufacturing company including raw material, inbound/outbound logistics, overhead cost and the final monthly profit for the company. As stated it is a very basic look monies coming in and going out.
· Column A - Artists – This is the artists of the CD
· Column B - Title – Title of the CD
· Column C - New – Listed price charged for a new CD (if available)
· Column D – Amount ordered for new cd’s
· Column E - Total Amount of that individual cd’s. This is simple formula of specified row, Column C multiplied by column d.
· Column F – Used CD’s – Listed price charged for used CD (if available)
· Column G – Amount of used CD’s ordered
· Column H – total amount of this individual used cd’s. Again simple formula specified row, column f multiplied by column g
· Column I -Shipping Cost – Basic listing of shipping amount of ONLY new and used cd’s
· Column J – MP3 Download charge
· Column K – amount of cd’s downloaded to MP3
· Column M – Overhead cost. This is only charged to New and Used CD’s at a price of $2 per cd. This would be sum of (D2 plus G2) multiplied by $2.
· Column N – Is the profit listed for the month of each individual CD and Total for the month below double lines. Sum (E2plusH2plusL2)-M2.
No comments:
Post a Comment