Question: Please help! Is there a way to do this Without Excel? If so , please do it that way. Thank you so much!!Top part of

Please help! Is there a way to do this Without Excel? If so, please do it that way. Thank you so much!!Top part of question cut off since we can't upload more than one pic anymore (sorry about the format) January and May are cut off at the top its 1500 for January and 2300 for May.
Question 2, Problem 13.3
Part 1 of 6
HW Score: 20%,1 of 5 points
Points: 0 of 1
\table[[February,1,500,June,2,100],[March,1,700,July,1,900],[April,1,900,August,1,900]]
Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan A.
Plan A: Vary the workforce level to execute a strategy that produces the quantity demanded in the prior month. The December demand and rate of production are both 1,600 units per month. The cost of hiring additional workers is $50 per unit. The cost of laying off workers is $80 per unit. Evaluate this plan. (Enter all responses as whole numbers.)
Note: Both hiring and layoff costs are incurred in the month of the change. For example, going from 1,600 in January to 1,500 in February incurs a cost of layoff for 100 units in February.
\table[[Period,Month,Demand,Production,\table[[Hire],[(Units)]],\table[[Layoff],[(Units)]],\table[[Ending],[Inventory]],\table[[Stockouts],[(Units)]]],[\table[[0],[1]],\table[[December],[January]],\table[[1,600],[1,500]],\table[[1,600],[1,600]],,,200,],[2,February,1,500,1,500,,,,],[3,March,1,700,1,500,,,1,],[4,April,1,900,1,700,,,,],[5,May,2,300,1,900,13,,,],[6,June,2,100,2,300,,,,],[7,July,1,900,2,100,7,,)=(,],[8,August,1,900,1,900,,,?bar(17),]]January and 2300 for May
 Please help! Is there a way to do this Without Excel?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!