need to complete this case. due in 5 hours. Can anyone help?

COST 1 COMPUTER CASE - Fall 2016 The purpose of this case is 1) to reinforce understanding of budgeting computations, 2) practice Excel particularly linking, and 3) write a conclusion from an analytical perspective using good writing form. Employers are increasingly looking for analytical abilities combined with business writing skills. Also, Excel is the software nearly all financial professionals use. GoTeam Corporation makes college mascot statues. Its popular USF Bulls product has the following budgeted sales for the next six-month period: Month Unit Sales June 90,000 July 120,000 August 210,000 September 150,000 October 180,000 November 120,000 The selling price of each Bulls statue is $100.00. There were 30,000 finished Bulls statues in inventory at the beginning of June. Plans are to have an inventory of finished products that equal 20% of the unit sales for the next month. The Company has no beginning or ending work-in-progress in any month. Five pounds of materials are required for each statue produced. Each pound of material costs $9. Inventory levels for materials are equal to 30% of the needs for the next month. Materials inventory on June 1 was 15,000 pounds. It takes 2 hours of labor to make one statue. The Company pays a labor rate of $15 per hour. The Company allocates overhead based on finished goods produced. The allocation rate is $13.50 per unit. GoTeam's current selling and administration costs are as follows: Selling $10.00 per statue sold Administration $105,000 per month Required: a. Prepare production budgets in units for July, August, and September. b. Prepare a purchases budget in pounds for July, August, and September, and give total purchases in both pounds and dollars for each month. c. Prepare a cost of sales budget for July, August and September. Be sure to label each cost component clearly. d. Prepare a budgeted income statement for July, August and September. e. Prepare a scenario analysis for GoTeam (additional income statements). What inputs are the drivers for the business model? f. Based on your budget and your scenario analysis, prepare a conclusion for the company. From a business perspective, are there any areas that you feel should be examined further? What suggestions do you have for improved profitability? Use good writing technique; make sure proper grammar and spelling are used and that you fully explain your thoughts. This is your CONCLUSION. - Upload your file to the assignments window in Canvas. Please name your file with the last names of your group members. For example, Smith_Jones.xls HINTS 1. Set up your Excel workbook with 7 tabs (worksheets) Input and conclusion Production budget Purchases budget Cost of sales budget Budgeted income statements Scenario analysis You should link (cell reference) your inputs (from input tab) to your various worksheets. You should link key information from all worksheets to other worksheets as needed. Grading: Computations Workpaper setup, linking, easy to follow Conclusion, quality of thoughts and writing Total 10 5 5 20