The Bear Corporation will begin business operations on January 1, 2021. Below is the anticipated SALES BUDGET (in units): L Jan. 0,000 Feb. 0,000 Mar. 0,000 Apr. 0,000 May 0,000 To complete the unit sales forecast, use the third, fourth, fifth and sixth digits of your student identification mumber to fill in the blanks. If any of these digits contains a "0", Example: If student ID number is 00607357. The sales forecast would be January $0,000 February 20,000 March 70,000 April 30.000 A ADDITIONAL INFORMATION Ending finished goods inventory should be equal to L of next month's sales projection h Each unit requires 3 pounds of material at a raw material cost of $2 per pound. 6 Labor ont is $10 per unit produced d. Ending raw merial inventory should be equal to 2% of sest mond's material requirement E Factory overhead is $18,000 per month of which $8.000 is for depreciation All cos are paid in the mouth incurred except for purchases which is paid in the following mouth The selling price per $100 REQUIRED Using Excel, in good form: Prepare a SALES BUDGET for the fint quarter (January through March) Prepare a PRODUCTION BUDGET for the first quarter (January through March) Prepare a Raw Materials PURCHASES BUDGET for the first quarter (Jan. theough Mar.) Prepare a CASH DISBURSEMENTS hodge for the first quarter (anuary theouch Machi E