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.

Transcribed Image Text:

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