To help you analyze LGI so that you can make recommendations to reverse the trends, you receive an Excel workbook containing the following: Prices and quantities of LGI’s product After plotting
To help you analyze LGI so that you can make recommendations to reverse the trends, you receive an Excel workbook containing the following:
- Prices and quantities of LGI's product
After plotting a supply/demand graph and calculating elasticity, submit your team's initial findings.
Complete the analysis calculation for the project:
- Download the Project 2 Excel workbook, click the Instructions tab, and read the instructions.
- Draw a supply and demand graph and calculate elasticity.
- If you would like instructor feedback on this step, follow the instructions in the Take Action box below to submit your Excel file to the Assignments folder as a milestone by the end of Week 3. This is optional. If you choose to submit the milestone, you will receive instructor feedback on the milestone submission. To distinguish the milestone submission from the file you will submit at the end of Project 2, label your file as follows: P2_milestone_lastname_Calculation_date.
Instructions
| In Class Currently |
Largo Global Inc. is a fictious firm that is will be used to allow you to understand the market forces of supply and demand as they impact a company as well as the industry in which the company operates. The company produces two types of boxes, a Standard box and a Deluxe box. These boxes are also produced by many other companies. In Project 2, you will learn about how to apply the tenets of microeconomics to improve the company's profitability. In tab 1 after reading the instructions, you will chart the supply and demand curves for the two different boxes. In tab 2 you will focus on the price elasticity of demand for these two products. In tab 3 you will determine at what price the company can maximize the profitability of both boxes. Project 2 is the team assignment in MBA 620. Follow these steps to complete the project: 1. In step 3 the team will complete their Team Agreement and Work Plan and submit it to their faculty member by the due date noted by their faculty member. 1. In step 4, the team will complete this Excel file by answering the questions for all three tabs in the boxes provided. One member of the team will submit this file to the Project 2 Milestone assignment folder by the stated due date to receive feedback from their faculty member. Upon receipt of the feedback, the team will coordinate any necessary corrections. 2. In step 5, each team member must answer all questions for two of the five topics provided in the Word file. These questions constitute the core of your team's report. Each team member will serve as the team’s primary respondent for one of the five topics and coordinate the answers for that topic. Each team member will also serve as the secondary respondent to one of the five topics and submit their answers to the primary respondent. a. The faculty member will create a separate Team Project 2 Discussion forum for each team which includes all five topics. All team members should prepare their answers to the questions for their two chosen topics as separate Word files. They should post their two files in the appropriate topics in the Team Project 2 Discussion forum. b. After coordinating with the other members of the team, the primary respondent for each topic will submit their answers to the editor of the team’s Word file. The editor will then consolidate the answers to the questions for all five topics in a single Word file and submit that file along with the team's revised Excel file to the Project 2 Final assignment folder. c. If the team does not receive a grade of Meets Requirements or Exceeds Requirements, the primary respondents will coordinate any necessary changes to the answers for their topic questions and resubmit them to the editor. The editor will then consolidate all changes to the Word file and resubmit the file along with the team's Excel file to the Project 2 Final assignment folder.
Tab 1 – Supply and Demand Graph
| Table 1 | |||
| Future Supply and Demand for Standard boxes | |||
| Price per box | Daily US demand of Standard boxes (in billions of boxes per day) | Daily US supply of Standard boxes (in billions of boxes per day) | |
| $17.00 | 2 | 0.1 | |
| $17.20 | 1.8 | 0.2 | |
| $17.40 | 1.6 | 0.3 | |
| $17.60 | 1.4 | 0.4 | |
| $17.80 | 1.2 | 0.5 | |
| $18.00 | 1 | 0.6 | |
| $18.20 | 0.8 | 0.7 | |
| $18.40 | 0.6 | 0.8 | |
| $18.60 | 0.4 | 0.9 | |
| $18.80 | 0.2 | 1 | |
| $19.00 | 0.1 | 1.1 | |
| Question 1: | |||
| Create a Supply and Demand Chart for the Standard box below | |||
| Equilibrium: | |||
| Table 2 | |||
| Future Supply and Demand for Deluxe boxes | |||
| Price per box | Daily US demand of Deluxe boxes (in billions of boxes per day) | Daily US supply of Deluxe boxes (in billions of boxes per day) | |
| $25.00 | 2 | 0.3 | |
| $25.50 | 1.8 | 0.4 | |
| $26.00 | 1.6 | 0.5 | |
| $26.50 | 1.4 | 0.6 | |
| $27.00 | 1.2 | 0.7 | |
| $27.50 | 1 | 0.8 | |
| $28.00 | 0.8 | 0.9 | |
| $28.50 | 0.6 | 1 | |
| $29.00 | 0.4 | 1.1 | |
| $29.50 | 0.2 | 1.2 | |
| $30.00 | 0.1 | 1.3 | |
| Question 2: | |||
| Create a Supply and Demand Chart for the deluxe box below | |||
| Equilibrium: | |||
| Equilibrium: | |||
