面试时的一道数学题

lily2004

朋友面试时,遇到一道数学题,恳请大家帮忙:
今天去面试了，感觉还不错，谁知下午竟接到对方的邮件，要求我做如下一道题：
In a production plant there are 3 pieces of equipment required to produce a product. The first piece of equipment the products go through is labeled A, and it has the capacity to produce 100 units per hour. The next piece in the production line is equipment B, it has the capacity to produce 90 units per hour. The last piece of equipment in the production line is C, and it has the capacity to produce 75 units per hour. The production equipment requires 3 operators. The operators work 8 hour shifts. There are 3, 8 hour shifts every 24 hours. The operators receive $ 12.00 per hour plus 25 % for benefits. The 24 hour production results for one mouth are as follows: Monday, May 1, 1200 units, 72 man hours. Tuesday May 2, 1300 units, 72 man-hours. Wednesday May 3, 1600 units, 72 man-hours. Thursday May 4, 1500 units, 72 man-hours. Friday May 5, 900 units, 48 man-hours. Monday May 8, 1200 units, 72 man-hours. Tuesday May 9, 1300 units, 72 man-hours. Wednesday May 10, 1200 units, 72 man-hours. Thursday May 11, 1400 units, 72 man-hours. Friday May 12, 800 units, 24 man-hours. Monday May 15, 1000 units, 72 man-hours, Tuesday May 16, 1500 units, 72 man-hours. Wednesday May 17, 1300 units, 72 man-hours. Thursday May 18, 1600 units, 72 man-hours. Friday may 19, 800 units, 24 man-hours. Monday May 22, 1300 units, 72 man-hours. Tuesday May 23, 1200 units, 72 man-hours. Wednesday May 24, 1100 units, 72 man-hours. Thursday May 25, 1200 units, 72 man-hours. Friday May 26, 700 units, 24 man-hours. Monday May 29, 1200 units, 72 man-hours. Tuesday May 30, 1300 units, 72 man-hours.

Organize the information into a meaningful way to illustrate production trends and calculate the labor cost per unit.

Use Excel to complete the exercise
我考虑可以用ＥＸＣＥＬ作出表格和趋势图，可是怎么也用不上Ａ，Ｂ，Ｃ三个设备的生产能力１００，９０，和７５，并且也用不上 The first piece of equipment the products go through is labeled A, and it has the capacity to produce 100 units per hour. The next piece in the production line is equipment B, it has the capacity to produce 90 units per hour. The last piece of equipment in the production line is C, and it has the capacity to produce 75 units per hour. The production equipment requires 3 operators. The operators work 8 hour shifts. There are 3, 8 hour shifts every 24 hours这些条件．请高人指点！！明天就要交卷呀！着急！

lily2004

朋友贴在加拿大家园里了,http://www.**********.com/forum/ ... read&tid=122477

小旺爱蓝天

人工及设备能力是可以完成当月总任务的,但问题是设备C的每班产能只有8*75=600件,在5月12,19,26这三天只有一班的时候,B和C是不能当天完成任务的,所以要拖延到第二天,或者任务安排时要合理调整一下,否则只有B和C加班了.呵呵

lily2004

谢谢小旺.朋友7月底到的萨思卡通,今天已经被录用了,是一家粮食的进出口公司,和她原来的工作有点类似.

snowyak

Post by lily2004;712597
谢谢小旺.朋友7月底到的萨思卡通,今天已经被录用了,是一家粮食的进出口公司,和她原来的工作有点类似.

今天才看到题，没帮上忙，既然你的朋友已录用了，俺 真为他高兴。