作业帮 > 综合 > 作业

有没有人会excel 又懂英语的啊?我的commerce 我真的不会写,可不可以帮帮我,

来源:学生作业帮 编辑:拍题作业网作业帮 分类:综合作业 时间:2024/06/03 16:59:04
有没有人会excel 又懂英语的啊?我的commerce 我真的不会写,可不可以帮帮我,
A bus company believes that it will need the following numbers of bus drivers during each of the next 5 years
A bus company believes that it will need the following numbers of bus drivers during each of the next 5 years:60 drivers in year 1; 70 drivers in year 2; 50 drivers in year 3; 65 drivers in year 4; 75 drivers in year 5.At the beginning of each year,the bus company must decide how many drivers to hire or fire.It costs $4000 to hire a driver and $2000 to fire a driver.A driver's salary is $10,000 per year.
At the beginning of year 1 the company has 50 drivers.A driver hired at the beginning of a year can be used to meet the current year's requirements and is paid full salary for the current year.
a.Determine how to minimize the bus company's salary,hiring,and firing costs over the next 5 years.
I cannot figure out how to input the data into solver in excel.An example would be greatly appreciated :)
请按以下图片设置B2值为50,B3-B7,F2-F7为公式(图中有),单元格C2至D6的初始值设为0就OK,另外个规划求解小窗口的规则要依图设置,另分别对C2至D6设为整数和大于0,B3>=E2等(如图),再点入选项把精度和收敛度定得足够细,如0.00000001.确定后点求解就OK了.不行的话给我个邮箱,发给你.