Reference no: EM131071267
Financial Analytics for Managerial Decisions Assessment - Case Study
CASE SUMMARY
You have been provided with a case study entitled " Modern Agricultural Farm: Budgeting and Control". The Modern Agricultural Farm (MAF) located in Pakistan produces two main categories of crops:one for human consumption andthe other for animal consumption (fodder). In the first category are crops such as wheat, cotton, sunflower while in the second category are crops such as sarson, maize and barseem.
You are provided with more information about the various crops which include which season they are planted, acreage planted and financial information that allows you to calculate revenue figures, cash receipts, cash payments and contribution margins. Also make reference to figures in Exhibit 1and Exhibit 2.
I have embedded below an Excel file "Modern agriculture student worksheet.xls" which you are required to use to do the necessary calculations. Please note that when you open the file check and access a number of worksheets provided with valuable information.
REQUIREMENTS
1. Using the information in the case and performing analytics in the Excel spreadsheet provided,
(a) Determine cash receipts and payments for the 6 months from November 2010 to April 2011.
(b) Determine the cash balances at the end of eachmonth and,
(c) With the help of a graph and in a maximum of 500 words explain the situation faced by the farm with regards to cash balances and suggest how this can be resolved.
2. Prepare a budget for the period November 2011 to October 2012 (full year) from the data given and in a maximum of 400 words explain how this helps to improve control on farm operations.
Attachment:- Assignment.rar
|
Dean of technology for the university
: In a conversation with the dean of technology for the university, you have discovered that the university does not have a current disaster recovery and business continuity plan. Provide a 1-2-page document for the dean of technology that describes..
|
|
What are green house gases
: What are Green House Gases (GHGs)? What are the most common GHGs in energy production and consumption? Using the definition of Climate Sensitivity, discuss how GHGs impact Climate Sensitivity.
|
|
Problem regarding the cryptographic methods
: You have found an old ciphertext, where you know that the plaintext discusses cryptographic methods. You suspect that a Vigenere cipher has been used and therefore look for repeated strings in the ciphertext.
|
|
Develop a communication plan for quality improvement program
: Analyze the pros and cons of the quality improvement program that you are proposing for the organizational process that you identified. Justify the need for this program, and detail all of the program specifics, including a time line from launch to ..
|
|
Determine cash receipts and payments for the six months
: BUSM 4154/4344 Financial Analytics for Managerial Decisions Assessment - Case Study. Using the information in the case and performing analytics in the Excel spreadsheet provided, Determine cash receipts and payments for the 6 months from November 201..
|
|
A manufacturer of plastic carrier bags supplying
: Asia Paper Bag has since 1990 operated as a manufacturer of plastic carrier bags supplying them on a contract-manufacturing basis to well-known supermarket chains, fast-food outlets, pharmacies and department stores.
|
|
Deposit funds into the account or withdraws accounts
: The Case of an E-Banking Information System Mr. Joshua, Director of the ZION Bank has Customers all over world. A customer may have one or more accounts in the Bank wide spread across one or more branches. Customers open bank accounts with a speci..
|
|
Determine how long it takes the tank to drain if the fluid
: determine how long it takes the tank to drain if the fluid level
|
|
What are some of its challenges
: Analyze and discuss how the Health Insurance Portability and Accountability Act (HIPPA) helps to improve the U.S. healthcare industry. What are some of its challenges?
|