WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 1) How many units should be produced next year? Record your answer, using excel formulas, here 2) What is the dollar amount budgeted for direct material purchased for next year? Record your answer, using excel formulas, here 3) What is the Budgeted Revenues for next year. Record your answer, using excel formulas, here USE ONLY THE FOLLOWING INFORMATION TO ANSWER THIS QUESTION. DO NOT USE ANY INFORMATION FROM ABOVE. Gamble Company has the following sales budget for the last six months: January 10,000 April 7,500 February 12,000 May 15,000 March 4,000 June 2,500 Historically, the cash collection of sales has been as follows: The % of sales collected in the month of sale is 50% The % of sales collected in the month following the sale is 30% The % of sales collected in the second month following the sale is 15% The % of sales that are uncollectible 5% 1) What are the budgeted Cash collections for the month of May? Record your answer, using excel formulas, here Check the order of your formula calculations For example, if cell al is 15 and cell b1 is 4 and cell c1 is 2. You want to add cells al and b1 and then divide that sum by cell c1 If your excel formula is al+b1/c1 then your calculation result is 16.333 If your excel formula is (al+b1)/c1 then your calculation result is 9.5 The result 9.5 would be the correct answer. Case Part 4 Grading: Possible Points Earned Points 3 points for each correct answer 12 2 points for use of excel formulas to support answers 8