prodution planning

Using the information below: Costs table: Inventory carrying cost $2 per unit per month Subcontracting cost per unit $ 30 per unit $ 16 per hour Average pay rate 8 hours Working hours per day 4 units per day Daily productivity per worker Monthly forecasts: Expected Month Demand Jan 750 Feb 700 850 Mar Apr May Jun Production Days 23 20 21 24 22 20 950 1.100 850 Evaluate each plan and find out which one is better in terms of total costs: - Plan 1: for the manufacturer is to maintain a constant workforce throughout the 6-month period. we assume that the production per day is average requirements ( average production per day) and that we have a constant workforce, no overtime or idle time, no safety stock, and no subcontractors. The firm accumulates inventory during the slack period of demand, January through March, and depletes it during the higher-demand warm season, April through June. We assume beginning inventory and planned ending inventory = 0. a. Please fill the below tables for Plan 1 (4 points) Required daily production rate show calculations Required Number of workers to produce the Required daily production rate (show calculation) Inventory calculations Month Production days Total production Monthly units Inventory change Jan Feb Mar Apr May June Plan I cost calculations ( calculate what is applicable to this plan): Total Unit of inventory carries over from one month to the next Il Inventory Carrying Costshow cakubations) Total cost of workers during the plan period (show calculations) Total cost of Subcontractor (shew calculations) Total Cost of Plan 1 Page 7 of 11 - Plan 2: is to maintain a constant workforce at a level necessary to meet the daily demand of January month and to meet all demand above this level by subcontracting. b. Please fill the below tables for Plan 2 (3 points) Required daily production rate (som calculations) Total of units produced by the company In house) (show calculation) Required Number of workers to produce the Repuired daily production rate show cakalations) Total of units produced by the subcontractor (show calculations) Plan 2 cost calculations (calculate what is applicable to this plan): Total Unit of inventory carries over from one month to the next Inventory Carrying Cost (show cakculations) Total cost of workers during the plan period (show calculations) = It Total cost of Subcontractorshow calculations) Total Cost of Plan 2 c. Which plan should we select ? (1 points) Page 8 of 1 d. If the company decided to change the current subcontractor with a different one higher in quality and the new subcontractor charges 10 S more than the previous one for each unit produced, based on this situation: how does the company's decision influence applying Plan 2 in term of cost? (1 Point) How does this affect your answer in Part (c)? (1 Point)