Please show work....

You have been hired as a planner for a company that makes bicycles and bicycle accessories. You need to develop an aggregate plan for bicycle helmets for the next six months. Data is below. Period Jan Feb Mar Apr May Jun Forecast 200 200 300 400 500 200 Costs: Production labor (regular time) = $2 per helmet Production labor (overtime) = $3 per helmet Production labor (Subcontract) = $6 per helmet (inclusive of materials) Materials = $2 per helmet Inventory = $1 per helmet per period = $5 per helmet per period Back orders Evaluate a plan that calls for a steady rate of regular time output, using inventory to absorb uneven demand and allowing for backorders to occur. Assume there is no beginning inventory in January. 1. Assuming a level output rate per period, how many units do you need to produce per period? 2. If a single worker can produce 20 units per period, then based on your production rate in part a, how many workers do you need? 3. Develop a table showing your production plan and relevant costs, showing the total cost of this plan. 4. What assumptions did you make. If any 5. Identify one challenge associated with this particular strategy. You may hand-write your responses to all parts except part c. Part c should be produced in either a - word table or excel table