Operations Management assignment

profileMaldiyvormbn
ForecastingExtraCredit1AnswerSpreadsheet.xlsx
Home>Business & Finance homework help>Operations Management homework help>Operations Management assignment

Blank Form no Formulas

Answers
1
2
Mean Y5
Mean Y4
Mean Y3
Mean Y2
Mean Y1
3 check January February March April May June July August September October November December Total
600 Y5
760 Y4
590 Y3
750 Y2
610 Y1
4
December January February March April May June July August September October November December Total Y5
Demand / Forecasted Sales
Inventory
Raw Material Sets Ordered
Number of Total Parts Manufactured
Number of Parts Scrapped in Manufacturing
Number of Parts lost to Rework Manufacturing
Number Remanufactured parts returned to manfacturing
Total Number of Parts for sale from manufacturing
Number of parts returns that are scrapped
Number of parts returns that are to be resold
Number of Part Returned to resell
Total Number of Parts available to sell
5
December January February March April May June July August September October November December Total Y5
$28 Demand / Forecasted Sales
Inventory
25% annual Inventory Carrying cost
$10 Raw Material Sets Ordered
$3.85 Number of Total Parts Manufactured
$15 Number of Parts Scrapped in Manufacturing
$2 Number of Parts lost to Rework Manufacturing
Number Remanufactured parts returned to manfacturing
Total Number of Parts for sale from manufacturing
$15 Number of parts returns that are scrapped
$10 Number of parts returns that are to be resold
Number of Part Returned to resell
Total Number of Parts avaialble to sell
$5 Profit on Each Unit Sale (taken by Owner)
$28 Returned Part Refunds
Total Months Cashflow
6
7
Retrun On Investment Gross Return is Total Sales
Net Retrun on Sales
Investment is Money In
Gross ROI
Net ROI