PLEASE HELP!!!

Production Data Workdays per month Hours per workday Labor standard - labor hours per table On-hand inventory (tables) Current workforce (workers) Overtime hours per worker per month La Mesa Abundante (LMA) located just outside of Barcelona, Spain produces kitchen tables that it sells throughout Western Europe. Sales have been increasing steadily over the past several years, due in large part to the free trade among Western European countries that has resulted from the formation of the European Union (EU). 20 7.5 2.5 300 25 20 Jordi Garolera, the operations management at LMA, is currently developing an aggregate plan for the next six months. In order for him to be able to evaluate alternative plans, Jordi has collected the information on the left. Jordi has just returned from a meeting with the marketing manager, who provided him with a sales forecast for the next six months of 13,260 tables, which is broken down by month at the left. Cost Data Labor cost ($ per table) Hiring costs ($ per table increase) Firing costs ($ per per table decrease) Overtime costs are 1.5 times hours wage Inventory carrying costs ($ per table per month) Stockout costs ($ per table) 1) Develop a pure level aggregate plan for the next 6 months and determine the total cost of the plan. Save on a sheet labeled "LEVEL" 27.5 4.67 15.83 41.25 3 3 14 2) Develop a pure chase aggregate plan for the next 6 months and determine the total cost of the plan. Save on a sheet labeled "CHASE 3) Which plan (pure level or pure chase) has the lowest cost? Which plan has the lowest SHORTAGE cost? Demand Jan Feb Mar Apr May Jun 6-month total Tables 1740 1740 2460 3240 2220 1860 13260 20 7.5 Production Data Workdays per month Hours per workday Regular time hours per month per employee Labor standard - labor hours per table On-hand inventory (tables) Current workforce (workers) Overtime hours per worker per month How many hours per month does each employee work? 2.5 300 25 | How many tables can 25 employees make in a month? 20 Cost Data Labor cost ($ per table) Hiring costs ($ per table increase) Firing costs ($ per per table decrease) Overtime costs are 1.5 times hours wage Inventory carrying costs ($ per table per month) Stockout costs ($ per table) 27.5 4.67 15.83 41.25 3 14 Demand Jan Feb Mar Apr May Jun 6-month total Tables 1740 1740 2460 3240 2220 1860 13260 QUESTION 1 The hourly wage for La Mesa Abundante is $11/hour. What is the hourly wage in S/table (provide 2 decimal places)? QUESTION 2 The hiring costs for La Mesa Abundante is $280/employee. The cost to increase production in $/table is (provide 2 decimal places). QUESTION 3 How many tables can be produced by 25 employees in a month? (No decimal places.)