Reconsider the example on JC company we discussed in class,

now you need to make budget plan for the next half year.

Please use the updated data $($for the data not mentioned in

this problem, they are the same as the original example in the

textbook$)$ and compare the $4$ plans based on the total cost of

each, show which one is the best option? $($Please follow the

spreadsheet model we discussed in class and show all the

details in one excel file$)$

$[$For constant workforce, we assume $40$ workers; For constant

low workforce, we assume $25$ workers; For constant workforce

but overtime, we assume $35$ workers.

The number of the working days of each month should be

based on calendar but exclude the weekend and national

holidays as follows.$]$