solve accordingly using data given , i just need 4 answers and their excel formulas

Enter Your Name Here BASE DATA: Foundation Data for Solving questions 1, 2 and 3: Budgeted Direct Materials Cost Per UNIT 15.00 10.00 Budgeted Direct Manufacturing Labor Per UNIT Budgeted Manufacturing Overhead Per UNIT 5.00 IN ADDITION TO ABOVE USE THE FOLLOWING: This is Next Year's Budgeted Data for XYZ Budgeted Sales Price Per UNIT 20.00 Budgeted Sales - UNITS 15,000 Units Target Ending Finished Goods Inventory in UNITS 2,500 Units Target Beginning Finished Goods Inventory in UNITS 1,850 Units Target Ending Direct Materials Inventory in UNITS 8,500 Units Target Beginning Direct Materials Inventory in UNITS 6,500 Units Note: It takes one unit of direct materials to make one production unit. 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 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 I 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 February 12,000 May March 4,000 April 7.500 15,000 2,500 June 50% Historically, the cash collection of sales has been as follows: The % of sales collected in the month of sale is The % of sales collected in the month following the sale is The % of sales collected in the second month following the sale is The % of sales that are uncollectible 30% 15% 5% 4) What are the budgeted Cash collections for the month of May? Record your answer, using excel formulas, here