Question 4 Gemini Inc. is using the sales and Operation Planning with Spreadsheets to develop a five month production plan. Use the provided Derived outputs and Calculated costs to specify the model's inputs (Hint: Don't forget that the forecasted demand and reactive alternatives are expressed as employee period equivalents) $ 20,000.00 $5.000.00 0 10 5 10000 $ 250.00 Total 16 130 35 0 10 Input Starting Workforce 20 Cort to Hire One Worker Waget per Worker per Period $2500.00 Cost to Lay Off One Worker Overtime Pay Percentage 150% nitial ventory Level Subasttracting Cost per Period 0 htul Backorders Inventory Cost Badkorder Cost Period January February March April May Inputs Forecasted demand Worldorce level Undertime Overtime Vacation time Subcontracting time Badarders Derived Ulced time 22 20 30 30 30 Inventory 10 15 15 0 Hires 0 10 0 0 0 0 0 0 0 Calculated Ulped time cost $50.000.00 $50.000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 Undertime cost $ $ $ $ $ Overtime cost $ $ $ 56,250.00 $ 37.500.00 $ 37.500.00 Vacation time.co $ $ $ $ $ Inventory cout $ $ 1,000.00 $ 1.500.00 $ 1500.00 $ Badiordes con $ $ $ $ $ 2500.00 $ $ 20,000.00 $ Layoll cost $ $ $ $ Subcontracting.com $ $ $ $ Total cost $50,000.00 $51.000.00 $152.750.00 $ 114,000.00 $ 115,000.00 under the force 130 Rolo 50 10 0 Layolls $325.000.00 $ $131.250.00 $ $ 4,000.00 $ 2,500.00 $ 20.000.00 5 $ 32,750.00 Gemini Inc. is using the sales and Operations Planning with Spreadsheets to develop a five month production plan. Use the provided Derived outputs and Calculated costs to specify the model's inputs. (Hint: Don't forget that the forecasted demand and reactive alternatives are expressed as employee period equivalents.) $ 20,000.00 $ 5,000.00 0 10 $ 100.00 $ 250.00 Total 165 130 0 35 0 0 10 Inputs Starting Workforce 20 Cost to Hire One Worker Wages per Worker per Period $2,500.00 Cost to Lay OH One Worker Overtime Pay Percentage 150% hitial inventory Level Subcontracting Cost per Period 0 Intel Badiorders hentary Cost Bastiander Cost Period January February March April May Inputs Forecasted demand Workforce level Undertime Overtime Vacation time Subcontracting time Backorders Derived Utilized time 20 20 30 30 30 Inventory 0 10 15 15 0 Hires 0 90 0 0 Layoffs 0 0 0 0 0 Calculated Usized time cost $50,000.00 $50,000.00 $ 75,000.00 $ 75,000.00 $ 75,000.00 Undertime cost $ $ $ $ $ Overtime cost $ $ $ 56250.00 $ 37.500.00 $ 37,500.00 Vacation time cost $ $ $ $ $ Inventory cost $ $ 1,000.00 $ 1.500.00 $ 1.500.00 $ Backorders cost $ $ $ $ $ 2500.00 Hiring cost $ $ $ 20,000.00 $ $ Layolf cost $ $ $ $ $ Subcontracting cost $ $ $ $ $ Total cost $50,000.00 $51,000.00 $152,750.00 $114,000.00 $ 115,000.00 Reminder Espree frecated and und die stempler 130 40 Relo 10 0 $325,000.00 $ $131,250.00 $ $ 4,000.00 $ 2,500.00 $ 20,000.00 $ $ $ 492,750.00