Gemini Inc. is using the Sales and Operations Planning with Spreadsheets Solver in OM Explorer to develop a five month production plan. Use the provided Derived outputs and Calculated costs to specify the model's inputs.

Inputs Starting Workforce Wages per Worker per Period Overtime Pay Percentage Subcontracting Cost per Period $20,000.00 $ 5,000.00 Cost to Hire One Worker Cost to Lay Off One Worker Initial Inventory Level Initial Backorders Inventory Cast Backorder Cost 20 $ 2,500.00 150% 10 100.00 $ 250.00 February April May Total Period Inputs Forecasted demand Workforce level Undertime Overtime Vacation time Subcontracting time Backorders Derived Utilized time inventory Hires January March 165 130 130 15 10 0 Calculated Utilized time cost Undertime cost Overtime cost Vacation time cost Inventory cost Backorders cost Hiring cost Layoff cost Subcontracting cost Total cost $50,000.00 50,000.00 75,000.00 75,000.00 $ 75,000.00 $325,000.00 $56,250.00 37,500.00 S 37,500.00 131,250.00 4,000.00 $ 2,500.00 20,000.00 $1,000.00 $1,500.001,500.00 $ 2,500.00 s 20,000.00 $ $50,000.00 $51,000.00 152,750.00 $114,000.00 115,000.00 482,750.00