EXCEL ASSIGNMENT #3
GJbratt
Exp19_Excel_Ch06_Cap_DeltaPaint.xlsxForecast
| Delta Paint | One-Variable Data Table: Production | |||
| Input | ||||
| Units Sold | 100 | |||
| Unit Selling Price | $ 30.00 | |||
| Employee Hourly Wage | $ 15.00 | |||
| Maximum Capabilty per week | 200 | |||
| Limitations | ||||
| Raw Materials in Units | 15000 | |||
| Required raw materials per unit | 3 | |||
| Required Labor Hours Per Gallon | 0.25 | |||
| Labor Hours available | 2,000 | |||
| Expenses | ||||
| Raw Materials Consumed | 300 | |||
| Labor Hours Consumed | 25 | |||
| Total Production Cost | $ 375.00 | |||
| Income | ||||
| Gross Profit | $ 3,000 | |||
| Net Profit | ||||
| Two-Variable Data Table: Production and Manufacturing Time | ||||
