Please show your work in excel with formulas.

P21-2A Prepare sales, production, direct materials, direct labor, and income statement budgets (LO 3,4), AP Deleon Inc. is preparing its annual budgets for the year ending December 31,2014. Accounting assistants furnish the data shown below Product JB 50 Product JB 60 Sales budget: Anticipated volume in units Unit selling price 200,000 $25 400,000 $20 Production budget: Desired ending finished goods units Beginning finished goods units 30,000 25,000 15,000 10,000 Direct materials budget: Direct materials per unit (pounds) Desired ending direct materials pounds Beginning direct materials pounds Cost per pound 30,000 40,000 S3 10,000 15,000 $4 Direct labor budget: 0.4 Direct labor time per unit Direct labor rate per hour 0.6 Budgeted income statement: Total unit cost $13 $20 An accounting assistant has prepared the detailed manufacturing overhead budget and the selling and administrative expense budget. The latter shows selling expenses of $560,000 for product JB 50 and $360,000 for product JB 60, and administrative expenses of $540,000 for product JB 50 and $340,000 for product JB 60, Income taxes are expected to be 30%