answer 8,9,10 please

This assigned project aims to enable a student to analyze the given quantitative information use mathematical models/formulas taught in a class to solve a set of connected questions of some topics such as forecasting, capacity requirements planning, inventory, bill of materials in MRP scheduling, etc.), and then draw general conclusions. By doing so, a student can apply course concepts to enhance quantitative reasoning abilities or skills for effective decision making Jewelry manufacturing industries are mostly labor-intensive industries that need high operator involvement. Jewelry items such as brooches, rings, bracelets, earrings, etc. are meant for adornment and can be worn by persons. A jewelry company reveals the following production information as shown in Table 1 including the different types of each product name, processing times and due dates. The production department does not consider product setup times on machines for its production. Product name Bracelets Rings Brooches Earrings G J 76 H 1 K L E Product type D B A 0.4 0.6 0.9 0.7 02 0.3 0.1 0.3 0.3 0.2 0.7 0.5 Processing time/hour 54 33 44 21 20 33 12 14 15 12 18 55 Minutes until due The receiving department at the company orders materials for producing each finished product type. For example, one unit of product type A of bracelets requires one unit of material type A1, three units of material type A2 and two units of material A3. Further, each unit of material A2 needs one unit of material A21, one unit of material A3 needs three units of A31, and finally one unit of material A31 needs five units of material A311. Moreover, the purchase costs and quality (quality scale is out of 100) of materials required from suppliers to build the finished product are shown in Table 2. N A1 A2 Product type A3 A21 AJI A311 Mous COS quality COST quality co quality COS COS COS alt S40 Supplies 1 60 539 40 $29 40 $20 20 ma Supplier 545 30 535 55 587 40 $23 10 ws ' S15 25 54.7 50 Supplier 2 530 40 10 515 15 The production manager sets each machine to be available for 2000 hours per year (1.0, a department works one 8-hour shift per day, 250 days per year). Each machine costs S15000. Additionally, the marketing department brings the following customer homand information about product type A of bracelets as shown in Table 3. Month Jan. Feb. Mar. Apr May Jul. Aug Sept. Oct. Nov. Dec. Demand 500 550 610 620 42 54 42- 614 65 717 42:12 +465 4208 +465 -801 7+4 65 4299 +465 =843 421 0:46 S 885 421 1 +46 S- 927 969 65 675 759 Finally, the management of inventory at the company, that plays a great role in the function of meeting the customer demand and smoothing production requirements, estimates the following: Setup costs per order include $150 and $200 for both fixed cost transportation (trucking) and other order expenses, respectively. Annual holding cost is 6% of the cost per unit of product type A of bracelets. Shortage cost is 25% of the cost per unit of product type A of bracelets. I Lead time is one month Demand rate is assumed to be 470 unit per month Starting (beginning) inventory for January is 1500 units. No safety stock is specified. - Based on the given information, a student needs to play as a decision maker on behalf of the company by addressing the following prompts: 5 1. Assuming April as the current month of the year, it seems that there is missing data about the customer demand of product type A of bracelets for the rest of the year. This causes a problem to plan the production capacity. Do you agree? Why? How would you handle this situation and show you answer quantitatively (Due February 20, 2022, by midnight) Yes we do agree with this statement because without accurate representation of the amount of demand it makes it hard to forecast for the rest of the year or even the following month. As a team we decided to make a graph of the current trend of demand. In dging this we were also able to find out the equation and the R^2 for the trendline using Microsoft Excel. After we found out the equation we just plugged in the numbers. X is going to be dependent on the month that we are trying to forecast. For instance for the month of May we used 5 because it is the 5th month. So our equation looked like this 42*5+465-675 to forecast for the month of May. Similarly we used the same formula for each month corresponding that month with the number of months out of twelve. So for June our equation looked like this, 42*6+465-717 and so forth for each consecutive month following. After this we were able to forecast for the entire year using this method. 2. Based on how you have handled prompt 1, what the total annual capacity requirements (.e., total processing time needed) in hours should be. (Due March 6, 2022, by midnight) We will find the number of hours needed annually after we add all the demand and then multiply it by the hours needed per unit I Hours needed per unit of A = 0.5 hours Total demand = 500+550+610+620+675+7174759+801+843+885+927+969 = 8856 Total capacity needed in terms of hours = 8856*0.5 = 4428 hours. 3. If you need to allocate resources such as workers, machines, etc., bow many machines you need to handle the required volume. (Due March 6, 2022, by midnight) Machine hours available = 2000 Number of hours needed = 4428 Therefore, the number of machinos needed = 4428/2000 - 2.214 we need the answer in decimals, Round up to 3 4. Do you have any idea about how much the total machines required would cost you? (Due March 6, 2022, by midnight) Cost per machine - $ 15000 Number of machines needed = 2.214 but rounded up to 3. Cost of machine (if we consider the decimal value assuming that the remaining time the 3rd machine is allocated to another product) = 15000'3 = $ 45000 5. Draw the structure of product type A of bracelets (Due March 20, 2022, by midnight) A(1) I A1 (1) A2 (3) A3 (2) A21 (1) A31 (3) A311 (5) Pictured above is the breakdown of the product structure tree to create I type A bracelet. 6. According to the suppliers' information in terms of the cost and quality of materials, show how you address the following concerns: (Due March 20, 2022, by midnight) How would you select your suppliers? The vendors will be chosen based on their ability to provide the best value and quality Unless there is a concept of bulk discounts, we shall pick the supplier for each product component independently. We will choose the best quality supplier with the lowest pr moderate cost and then finalize them for each part because there is no bulk discount. The chart below summarizes what suppliers are chosen and the cost and quality of each material. A1 Material A2 A3 A31 A21 A311 Supplier 2 Supplier 1 Supplier 2 Supplier Chosen Supplier 1 Supplier 2 Supplier 3 Cost S4.0 $3.5 $3.0 $2.5 $2.0 SIS 40 40 20 25 Quality 55 60 What is the cost of each material needed? The cost of each individual material needed for a single product A is listed in the chart above. What is the cost of product type A of bracelets? In regards to the material cost of a single product A, the cost is $84.50 which is the sum of the cost for the materials shown in the chart below. Material AI A2 A3 A21 A31 A311 3 2 3 6 30 Quantity Needed 1 per Product A Cost for Materials $4.0 $10.0 $6,0 $7.5 $12.0 $45.0 7. Based on the product structure you have drawn, what the number of units of each material needed should be before you contact the purchasing department (Due March 20, 2022, by midnight) Reference the above churt in question for the number of units of each material needed for a single unit of Product A, If we assume the full demand rate of 470 units per month goes towards Product A, the total cost would be $39,715 8. As a manager, you know that inventory ordering policies address two basic issues, and they are: how much to order and when to order. Therefore, you need to determine both the optimal order quantity and the reorder point for product type A of bracelets. (Due March 27, 2022, by midnight) 9. Given that the management of the company sets 1500 units of product type A of bracelets as the starting inventory of January, determine the ending inventory of each month during the entire year. (Due March 27, 2022, by midnight) 10. According to the ending inventory information you have attained, calculate the total inventory costs including shortage, holding, and ordering costs. (Due March 27, 2022, by midnight)