need help with yellow cells

Make sure you fill in all Yellow cells. Yellow cells left blank will receive zero credit. Alternate Problem A: CRD Company prepares monthly operating and financial budgets. Fstimates of sales in units are made for each month. Production is scheduled at a level high enough to take care of current neods and to carry into each month 30% of the next month's unit sales. Direct 59 points materials, direct labor, and variable manufacturing overhead are estimated at $10,58, and $3 per unit, respectively. Total fixed manufacturing overhead is budgeted at $520,000 per month. The inventory at January 1 consists of 20,000 units, Sales for April, May, Junc, and July are estimated at 80,000,100,000,95,000, and 110,000 units with a rate of $60 per unit. Variable selling and administrative expenses are $20 per unit. Fixed selling and administrative expenses are $800,000 per month. a) Prepare a sales budget for the scond quarter by month. b) Prepare a schedule showing the budgoted production in units for April, May, and June. c) Prepase a sthedule showing the budgeted cost of goods sold for the same throe months, d) Prepere a budgeled income statement for the first quarter by month. At Problem A: Sales, Production, Cost of Goods Sold Budgets and Budgeted Income Statement At Problem A: Sales, Production, Cost of Goods Sold Budgets and Budgeted Income 5tatement