online excel project takes less than an hour to finish

profilesk1234
e06c1Manufacturing.xlsx

Forecast

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 $ 2,625
Two-Variable Data Table: Production and Manufacturing Time

Q&A

Your Answers Question
1) How many units must be sold to exhaust all raw materials and why is the not a feasible option?
2) For the one-variable data table, how many units muse be sold to Net over $5000?
3) For the two-variable data table, if the hourly wage is raised to $20.00 per hour, how many units must be sold to Net $4000?
4) For the two-variable data table, if the hourly wage is raised to $40.00 per hour, how many units must be sold to Net $4000?
5) What is the Net income based on the best case scenario?
6) What is the most profit you can generate within the constraints using Solver?
7) How many labor hours are consumed when net profit is maximized?
8) What is the total production costs when profit is maximized?