MRP完成，需要帮助通过MS Project创建产品树 [英] MRP Finished, Need Help Creating Product Tree via MS Project

问题描述

你好，

我已经完成了关于材料资源规划的excel中我的家庭作业的第一部分。我知道需要将此数据导入MS Project并从中创建产品树。从那里我可以计算CPM（关键路径管理）。

I have finished the first part of my homework assignment in excel regarding material resource planning. I know need to import this data into MS Project and create a product tree out of it. From there I can calculate CPM (critical path management).

我会给你一些功课问题，这样你就可以知道我所指的是什么：

I'll give you the homework questions so you can have an idea of what I'm referring to:

Q1。 非常简单的产品（A）由基料（B）和铸件（C）组成。底座由板（P）和三个紧固件（F）组成。目前有30个铸件和100个基地。总决赛需要一周时间。该铸件的交付周期为3美元b $ b周。所有其他部分都有一周的交货时间。没有预定的收据。所有组件都使用lot-for-lot技术。主计划在第5周需要80个单位的产品A，在第8周需要120个单位。

绘制产品结构树（即BOM）。

为即将到来的八周制作MRP。



我无法上传excel电子表格供您查看。如果有人有任何可能的提示，请赐教。

Q1.  A very simple product (A) consists of a base (B) and a casting (C). The base consists of a plate (P) and three fasteners (F). There are currently 30 castings and 100 bases on hand. Final assembly takes one week. The casting has a lead time of three weeks. All other parts have one week lead times. There are no scheduled receipts. All components use the lot-for-lot technique. The master schedule requires 80 units of product A in week 5 and 120 in week 8.
Draw the product structure tree (i.e. BOM).
Produce the MRP for the upcoming eight weeks.

I can't upload the excel spreadsheet for you to look at. If anyone has any tips for this to be possible, please enlighten me.

谢谢，

先生。机器人

推荐答案

我可以将excel电子表格通过电子邮件发送给任何能够帮助我创建的人通过MS Project的产品树。

I can email the excel spreadsheet to anyone who would be gracious enough with helping me create a product tree out of it through MS Project.

这篇关于MRP完成，需要帮助通过MS Project创建产品树的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！