i need the solution for quastion 5 only but i will upload the whole quastions for u to have the full informations ( quastion 5 requiers an excel sheet)

stc ksa 7:05 AM 1 0 50% The questions containing two variables are supposed to be solved by hand as well as on Excel The questions containing more than two variables are recommended to be solved on Excel and paste the Answers report and model. No need to solve by hand Total Absolute Points 10 All questions carry equal point Qno. 1 Painters world provides the decoration services for home decorators They must decide how many information packets to prepare for the coming Eid sales season. They produce two kinds of decorating packets: popular painting packet and Glazing packet. The store managers know they will require at least 400 copies of their popular painting packet. They believe their new information packet on specialty glazing techniques could be a big seller, so they want to prepare at least 300 copies. Their printer has given the following information: The painting packet will require 2.5 minutes of printing time and 1.8 minutes of collating time. The glazing packet will require 2 minutes for each operation. The store has decided to sell the painting packet for $5.50 a copy and to price the glazing pocket at $4.50. At this time, the printer can devote 36 hours to printing and 30 hours to collation. He will charge the store SI for each packet prepared. How many of each packet should the store order to maximize the revenue associated with information packets? How many of each packet should the store order to maximize profit Qno.2 Incos chemical company produces a specific chemical which emits sulfur dioxide and particulate matter in the atmosphere. They introduced a new expensive process to supplement an older process because of new federal regulations on pollution. The older process emitted 20grams of sulfur dioxide and 40 grams of particulate matter into the atmosphere for cach gallon of chemical produced. The new process emits 5grams of sulfur dioxide and 20 grams of particulate matter for cach gallon produced. The company makes a profit of 60 cents per gallon and 20 cents per gallon on the old and new processes, respectively. a) If the government allows the plant to emit no more than 16,000 grams of sulfur dioxide and 30.000 grams of particulate matter daily, how many gallons of the chemical should be produced by each process to maximize daily profit? What is maximum daily profit? b) Discuss the effect on the production schedule and the maximum profit if the government decides to restrict emissions of sulfur dioxide to 11.500 grams daily and all other data remain unchanged c) Discuss the effect on the production schedule and the maximum profit if the government decides to restrict emissions of sulfur dioxide to 7.200 grams daily and all other data remain unchanged Qno. 3 A farmer can buy two types of plant food. mix A and mix B. Each cubic yard of mix A contains 20 pounds of phosphoric acid, 30 pounds of nitrogen, and 5 pounds of potash. Each cubic yard of mix B contains 10 pounds of phosphoric acid, 30 pounds of nitrogen, and 10 pounds of potash. The minimum monthly requireme 460 pounds of phosphoric acid, 960 pounds of nitrogen, and 220 pounds of potash. If mix A costs $30 per cubic yard and mix B costs $35 per cubic yard, how many cubic yards of each mix should the farmer blend to meet the minimum monthly requirements at a minimal cost? What is this cost? Ono. 4 Anna Creck is the world largest farm. They send cattle to a feedlot to be rain-fed before stc ksa 7:05 AM 1 50% Ono. 4 Anna Creek is the world largest farm. They send cattle to a feedlot to be grain-fed before being processed into beef. Anna Creek seeks to determine the amounts of cattle feed to buy so that minimum nutritional standards are satisfied to ensure proper weight gain, while total feed costs are minimized. The feed mix tused is made up of three grains that contain the following nutrients per pound of feed NUTRIENT (Ounces per Pound of feed Feed A B D Feed MixX 6 Feed Mix Y Feed Mix 0 8 4 Feed mixes X. Yand cost S3, S4, and $2.25 per pound, respectively. The minimum requirement per cattle per day is 4 pounds of nutrient A. 5 pounds of nutrient B, 1 pound of nutrient and 8 pounds of nutrient D. The ranch faces one additional restriction: it can only obtain 500 pounds of feed mix Z per day from the feed supplier regardless of its need. Because there are usually 100 cattle at the feed lot at any given time, this means that no more than 5 pounds of stock Z can be counted on for use in the feed of each cattle per day. Formulate this problem as a linear program and solve it by using Excel Qno. 5 China Synergy Group, manufacturers of aluminum Device Panels, wants to schedule its production for March 2021. Each Device Panels must go through three separate machines during the fabrication process. After fabrication, each Device Panels is inspected by a human being, who spends 15 minutes per Device Panel. There are 525 inspection hours available for the month. The time required in hours) by each machine to work on cach Device Panels is shown in the following table. Also shown are the minimum number of Device Panels that must be produced for the month and the unit profit for each Device Panels. PRODUCT DPI DP2 DP3 DP4 CAPACHY Chours) Drilling 0.40 0.30 0.45 0.33 700 Milling 0.60 0.65 0.52 0.48 890 Lathe 1.20 0.60 0.50 0.70 1200 Unit Profit S16 SI2 S13 SK Minimum 200 250 600 450 needed Determine the optimal production mix for the Device Panels plant to make the best use of its profit potential