The quаntity оf items circulаting in the ecоnоmy thаt can be used as money is called
Prоblem 5 [30 pоints]: [Yоu must use Excel]: Johnson Electric produces smаll electric motors for four аppliаnce manufacturers (customers P, Q, R, S) in each of its three plants (A, B, C). The unit production cost varies with the plant location because of differences in the production equipment and labor productivity. The customer orders that must be produced next month are shown in the following table. Customer P Q R S Demand 400 600 500 700 The unit production costs and the monthly capacities (supplies) for the plants are shown in the following table. Plant Unit Production Cost ($) Monthly Production Capacity A 17 700 B 24 800 C 20 700 The cost of transportation to the four customers varies from the three plants. The unit transportation costs (in $) are given in the following table. From Plant To Customer P Q R S A 9 1 5 4 B 3 2 5 7 C 6 4 8 3 Johnson must decide how many units to produce in each plant and how much of each customer's demand to be shipped from each plant. It wishes to minimize the "Total Cost" (cost of production plus cost of transportation). Formulate Johnson's problem as a Linear Programming Problem and solve for the optimal solution. a) Formulate a Linear Programming Problem. Prepare the layout (template) to solve the problem on an Excel Spreadsheet. The layout (template) must have proper formatting, appropriate labels, and identifiers. Wherever relevant, the cells must have Excel formula in them. I need to see you solve the problem in Excel Solver in Honorlock recording to earn these points. [10 points]. b) Set up linear programming model using Excel Solver, and solve the problem to minimize the total production and transportation costs. Typing in the numbers manually is not acceptable. I should be able to solve the problem with your Solver settings when I grade for you to earn these points. [10 points] Based on the solver results obtained, answer the following questions. You MUST explain/state what your answers are for each of the questions c through g, to earn the points indicated. c) How many small electric motors are to be manufactured at each of the three plant locations A, B, and C? [2 points] d) Which Customer location/s would receive how many motors from which plant/s next month? [2 points] e) What will be the total production cost for the next month for Johnson Electric? [2 points] f) What will be the total transportation cost for the next month for Johnson Electric? [2 points] g) What will be the total cost (production cost plus transportation cost) for the next month for Johnson Electric? [2 points] Upload and Submit your Excel for this Question. If you don't upload your Excel file, Exam cannot be graded. So, zero points will be recorded as the grade. NOTE: Do not violate academic integrity. ONLY ONE SYSTEM IS ALLOWED FOR THE EXAM. Any allowed resource on Canvas you use for the exam must be visible in your Honorlock recording. Using a second computer or other gadgets is a violation of Academic Integrity. Honorlock recording must show the entire duration of your exam without any breaks. I must see you working in Excel and answering questions in your Honorlock recording. If I don't see you working using Excel functions and formulas in Excel in your Honorlock recording, that would be an academic integrity violation, and ZERO POINTS will be recorded as your grade. All academic integrity violations will be reported to USF for further disciplinary action, that could be receiving an "F" grade for the course to other severe actions such as dismissal from the program, ... etc. So, please follow instructions and maintain academic integrity.