please answer all the question. student ID 00337390

Please ready, its on the top

View Activity Transactions by Term: ACF-350 MANAGERIAL ACCOUNTING FINAL COMPUTER PROJECT PROEESSOR Ca DONN CHESS The Bear Corporation will begin business operations on January 1, 2015. Below is the anticipated SALES BUDGET (in units): 0,000 0,000 Feb. 0,000 Mar 0,000 Apr. 0,000 May To complete the unit sales forecast, use the third, fourth, fifth and sixth digits of your student identification number to fill in the blanks. If any of these digits contains a "0", use "3" instead. Example: If student ID number is 00607357. The sales forecast would be: January 60,000 February 30,000 70,000 30,000 April ADDITIONAL INFORMATION a. Ending finished goods inventory should be equal to 10% of next month's sales projection b. Each unit requires 3 pounds of material at a raw material cost of ss per pound. c: Labor cost is $10 per unit produced. d Ending raw material imentory should be equal to 20% of next month's material requirement. e. Factory overhead is S18,000 per month of which S8,000 is for depreciation. f All costs are paid in the month incurred except for purchase which is paid in the following month. g. The selling price per unit is S100 REQUIRED: Using Excel, in good form: Prepare a SALES BUDGET for the first quarter anuary through March Prepare a PRODUCTION BUDGET for the first quarter January through March) Prepare a Raw Materials PURCHASES BUDGET for the first quarter Jan- through Mar.) Prepare a CASH DISBURSEMENTS budget for the first quarter January through March) You are to work independently on this project